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
|
|
Can't connect to QuickBooks using VS 2008 |
Author |
Message |
|
Posted : 2008-07-15 06:41:07 |
Hello,
I am building a class for my application that will handle all communication with QuickBooks. I'm using the trial version of QODBC to get a feel for things before purchasing. After going through the setup, I can get the VBDemo32 app to connection using this connection string:
DSN=Quickbooks Data;OLE DB Services=-2;
but I cannot get my application to connect using that same string. I am at a loss as to how my connection string should be formatted and I have tried all of them listed here: http://www.qodbc.com/qodbcvisualbasic.htm without success.
Also, QODBC is not showing up in the ODBC Data Source Administrator panel, not under User, System, or File DSN. It is also not listed under the drivers tab. It does show up in the VB Demo 32's Machine Data Source tab when selecting a data source. Also, I am using XP 64-bit Edition as my development environment and have tried multiple reinstalls of QODBC.
Here is the error I usually recieve with my code and following is the code I'm using to test the connection.
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Public Class quickBooks
Dim connectionString As String = "DSN=Quickbooks Data;OLE DB Services=-2;"
Dim connection As New Odbc.OdbcConnection(connectionString)
Dim cmd As New Odbc.OdbcCommand
Public Function testConnection() As DataTable
Dim dt As New DataTable
cmd.CommandText = "select * from customer"
cmd.Connection = connection
connection.Open()
dt.Load(cmd.ExecuteReader())
connection.Close()
Return dt
End Function
End Class
Note that I have also tried using the OleDb classes in place of the Odbc classes with the same results.
Thank you for your time,
Steve
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-07-15 08:36:56 |
|
|
|
Sal |
|
Group | : Members |
Posts | : 6 |
Joined | : 2007-06-29 |
|
Profile |
|
Posted : 2009-01-30 05:40:20 |
Do you still not support development in Vista x64? I have 2 issues:
1. Visual Studio 2008 crashes when I try to run a query on any table in the QODBC connection from the Server Explorer.
2. If I click Retreive Data from a table (in this case Account) in the Server Explorer window, I get: "You might not have permission to perform this operation, or the object Account may no longer exist in the database". I'm logging in to QuickBooks as Admin. I've set Run 2.1 ODBC compatability off and Use Iterators off. I'm using VS2008 SP1.
Any suggestions? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2009-01-30 09:31:23 |
|
|
|
|