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
|
|
Remote Connection to QODBC using ASP |
Author |
Message |
|
Posted : 2006-09-29 01:25:25 |
Good Morning,
I'm using the Remote Connection to QODBC to access a company file in Quickbooks. I've set everything up and tested it using the qpcust.asp demo page found on this site.
When I run the page, I get no results. The SQL Statement is "Select * from Terms" I chose this table because its small and "Customer" has 14,000 records. When I run the page, everything connects fine, but when it gets to the display loop -nothing displays. In fact, it returns "No Records". I opened the connection in Access and ran the same statement and it returned all the records.
I believe I did something wrong in the installation, but after reviewing it, I can't seem to figure it out. I connect to the DSN just fine, create the recordset just fine, but I do not get any data returned.
Any suggestions would be helpful.
Thanks |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-09-29 09:14:08 |
I'm guessing that you changed just the select statement to use Terms in qbcust.asp. You will need to fix the fields displayed also:
Response.Write oRecordSet.Fields("Name") & " - " Response.Write oRecordSet.Fields("IsActive") & "<BR>" & vbCrLF
|
|
|
|
|