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 : sql server 2000 QODBC installationSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC Installation Support Forum

 New Topic 
 
 Post Reply 
[1]  
 sql server 2000 QODBC installation 
 Author   Message 
  william 
  
 Group: Members 
 Posts: 2 
 Joined: 2007-09-11 
 Profile
 Posted : 2007-09-11 08:35:37

We are running Sql Server 2000 on Sql_Server_1 and Quick Books Enterpirse 7 on QB_Server_2.  Both servers exist inside the same LAN. 

We need detailed step-by-step instructions on exactly how to download/install the QODBC driver Evaluation Version so that we can pull QB data from QB_Server_2 into Sql_Server_1 tables. I am familiar with sp_linkedservers.

We would prefer that the QODBC connection is Read-Only, if that is possible.

Thanks for your help ...

Bill

 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-09-11 10:20:27

QuickBooks Enterprise 7and the company file can stay on QB_Server_2, but you will also need to install a copy of QuickBooks Enterprise 7on Sql_Server_1 first. Then follow:

a) How do I install QODBC? 
b) How do I connect to QuickBooks for the first time? 
c) Does QODBC work with MS SQL Server Linked Tables? 

 

  Top 
  william 
  
 Group: Members 
 Posts: 2 
 Joined: 2007-09-11 
 Profile
 Posted : 2007-09-12 01:09:11

Thank you, Tom. 

A few questions based on the links you posted below:

1) We want to use the 'Remote QODBC' - please confrim we need to install the QODBC Driver on both the QB box (server hosting QB) and also on the sql server box (server where sql server is running,  where QB data will be uploaded to);

2) Please confirm that only a user with QB Admin Permissions can download/install the QODBC Driver

3) Is there any way to limit the sql server version of the QODBC driver to 'Read-Only?  It is important to us that the sql server connection is limited to Read-Only. Or will it apply the user's permissions automatically?  For example, I have Admin rights to sql server, but only Read-Only rights to QB.  If I access the QB data through sql server, will I automatically be limited to Read-Only permissions?

Thanks ... 

 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-09-12 08:30:38

You will need to install the QODBC Driver on both the QB box (server hosting QB) and also on the sql server box (server where sql server is running. This will require the purchase of two QODBC licenses and your overall performance will be unstable.

To establish the first connection to QuickBooks, QuickBooks must be running and the company file open by the QuickBooks Admin user.

The QODBC Desktop edition is avaliable in either Read Only or a Read Write version.

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to