|
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
|
|
| QODBC + Jitterbit + QB2008UK |
| Author |
Message |
|
|
| Posted : 2008-06-23 20:46:21 |
Hi all,
I can successfully connect the VB script to my QB's database (using the sample files QBW) and run queries problem free, but I now want to be able to connect using Jitterbit so I can start some internal integration with other databases. I am only interested in reading for the time being. Currently I have Jitterbit server, QODBC and QB all installed on one machine. My problem occurs in the database source creation in jitterbit, I am using the QODBC driver I have set the server to localhost and the database name as the DSN's name with no username or password.
Failed to test the connection.
Error on the server: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
Details:
Unable to connect to database using DSN SERVER=localhost;DRIVER=QODBC Driver for QuickBooks;DATABASE=QuickBooks Data;UID=;PWD=<REMOVED>
Cheers |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
|