Dinna work Tracy.
Sent from my T-Mobile 4G LTE Device -------- Original message -------- From: Tracy Pearson <[email protected]> Date:10/21/2015 14:38 (GMT-07:00) To: [email protected] Subject: RE: Quickbooks ODBC Jeff Johnson wrote on 2015-10-21: > Below is a test program to connect to a Quickbooks database. The > SQLSTRINGCONNECT returns a 1 indicating I am connecting to the database. > Any SQLEXEC returns -1 and I am using samples from the driver help manual. > Any idea why it won't work? Can the SQALSTRINGCONNECT return a 1 even > though we are not fully connected? > > sConnectString = "Driver={CData ODBC Driver for QuickBooks > 2015};DFQ=C:\mydatabase.qbw;OpenMode=M;OLE DB Services=-2;" > > lnHandle = SQLSTRINGCONNECT(sConnectString) > > MESSAGEBOX(TRANSFORM(lnHandle)) > > lnsuccess = SQLEXEC(lnHandle, "SELECT * FROM accounts") > > MESSAGEBOX(TRANSFORM(lnsuccess)) > > =SQLDISCONNECT(lnHandle) > > SELECT sqlresult > brow Jeff, You may need to format the select string as: "SELECT * FROM [accounts]" You might also look up SQLTABLES to be sure of the table name spellings. Tracy Pearson PowerChurch Software _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious. Report [OT] Abuse: http://leafe.com/reportAbuse/[email protected] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
