Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : Having some QuestionsSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v8 Forum

 New Topic 
 
 Post Reply 
[1]  
 Having some Questions 
 Author   Message 
  HIMAL PATEL 
  
 Group: Members 
 Posts: 1 
 Joined: 2007-10-03 
 Profile
 Posted : 2007-10-04 22:57:08

We are right now evaluating QODBC. and are need your inputs for following queries.

1.  Do we need to set one ODBC conneciton per company or there is any way to change the company of ODBC Connection using programming (I am more interested in C#.NET)

2. Can we call QODBC from the windows service? I think yes. but my problem is when the service is accessing the company file, is it possible to open QB UI for the same company ?

3. When QB is open and QODBC is accessing the company file, we cannot close QB until QODBC finished accessing of the file. is there any workaround for that ? or we just have to wait for QODBC to finish its operation ?

4. Can QODBC work on the machine on which QB or QB SDK is not installed.

Answer to this question would help us a lot to decide our design to use QODBC.

Waiting for your positive reply,

Thanks
Himal Patel
Sr. Software Engineer
Solutions@MBA,
(305)377 9200 x 9903
hpatel@satmba.com
www.satmba.com

 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-10-05 07:19:25

1.  Do we need to set one ODBC conneciton per company or there is any way to change the company of ODBC Connection using programming (I am more interested in C#.NET)

The company file is selected by using the DFQ = Path to company file or . (dot) to indicate currently open company file parameter in the connection string see: How do I build a connection string with all the available QODBC parameters? for more.

2. Can we call QODBC from the windows service? I think yes. but my problem is when the service is accessing the company file, is it possible to open QB UI for the same company ?

Yes, and the QuickBooks UI can be set visable if required by checking the "Launch QuickBooks UI" option.

3. When QB is open and QODBC is accessing the company file, we cannot close QB until QODBC finished accessing of the file. is there any workaround for that ? or we just have to wait for QODBC to finish its operation ?

No, you must close the connection and in the case of Windows Services, wait for the Windows O/S to really close the connection. BTW: QuickBooks can only have one company file open at the one time.

4. Can QODBC work on the machine on which QB or QB SDK is not installed.

QODBC talks directly to QuickBooks and not the companyfile.qbw file, so it needs to find a copy of QuickBooks.

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to