|
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
|
|
| Need Sample code to connect from Visual FoxPro |
| Author |
Message |
|
|
| Posted : 2009-01-05 05:07:23 |
Hi, I have the Quick Books Pro 2007 and I'm trying to access it from Visual FoxPro using a QODBC V7 connection. Is there any sample code to help figure out how it will be done. Actually I am using
myHandle=SQLCONNECT()
to find out if any connection is available. But I do not see any available connection. Whereas when I used VB Demo I can browse QB tables. Thanks. |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2009-01-05 11:31:29 |
|
|
|
|
|
| Posted : 2009-01-05 13:14:34 |
Thanks for replying and guiding me to a sample code. In sample you are pointing to can make connection with QuickBooks and has problem with using SQL statement, whereas, I am unable to connect through Visual FoxPro and do not know why it is not connecting. I will appreciate if you can elaborate on what could be possible reasons of this problem. |
|
|
|
| Tom |
| |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2009-01-05 17:45:26 |
| This isn't a Visual FoxPro support forum. Try doing:
* Connect to an ODBC data source
LOCAL nHnd
nHnd = SQLCONNECT ("QuickBooks Data")
* Retrieve data from the remote server and stores it in
* a local data cursor
nResult = SQLEXEC (nHnd, "select * from Customer", "QCUST")
* Close the connection
SQLDISCONNECT(nHnd)
and then look for examples of using MS SQL Server from Visual FoxPro on the FoxPro forums. |
|
|
|
|