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 : New Setup AdviceSearch Forum

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

 New Topic 
 
 Post Reply 
[1]  
 New Setup Advice 
 Author   Message 
  jdroger2 
  
 Group: Members 
 Posts: 5 
 Joined: 2008-11-13 
 Profile
 Posted : 2008-11-13 01:09:22
We have purchased the server version of QODBC and have 2 servers, A is a terminal server / fileserver and B is our SQL server / Web server.  Quickbooks Enterprise 9 is installed on server A and we want to create a web application on Server B that can access the quickbooks data.  I have seen in the forums bits and pieces and it seems like there are several ways I could go, RDS vs installing qb on server b... I was wondering if someone could outline for me the broad steps of good deployment plan for my situation.

Thanks!

PS: Has anyone had success using SQL Server Integration Services with QODBC? 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-11-13 08:04:06

You will need to use RDS (see: Accessing QuickBooks data remotely via QODBC using RDS ) or install a QuickBooks Enterprise 9 client on your SQL server / Web server.

There are a number of posts on SSIS, see: click here.

 

  Top 
  jdroger2 
  
 Group: Members 
 Posts: 5 
 Joined: 2008-11-13 
 Profile
 Posted : 2008-11-13 08:07:57
Thanks for your reply.  I am also noticing that the license I bought is for 2008 server read write.  Is this a free upgrade to 2009 or do i need to upgrade it before i start this?

Thanks! 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-11-13 22:38:27
See: QODBC v9 Released!  

  Top 
  jdroger2 
  
 Group: Members 
 Posts: 5 
 Joined: 2008-11-13 
 Profile
 Posted : 2008-11-13 23:31:53
Are there any advantages / disadvantages to my using RDS vs installing QB client on that server (ie whats the best way)?  

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-11-14 16:25:43
Installing a QB client on that server ensures that QuickBooks and the company file is available for use all the time by the Web Application.  Also to reset you only need to reboot one server, not two. 

  Top 
  jdroger2 
  
 Group: Members 
 Posts: 5 
 Joined: 2008-11-13 
 Profile
 Posted : 2008-11-29 01:38:26
Thanks for your reply.  I have six or seven company files that I am trying to report on with the qodbc driver.  Does this necessitate my using RDS or can I create multiple connections to different files on the same computer?

Thanks 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-11-29 20:08:38
The rule is QuickBooks can only have ONE COMPANY file open at the one time. So the connection must be closed before opening another company file or you can have multiple computers each running their only company file that you can connect to using RDS all at once through multiple connections. 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to