|
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
|
|
| ASP page hangs when trying to open connection (ADO and classic ASP) |
| Author |
Message |
| Ken |
| |
| Group | : Members |
| Posts | : 1 |
| Joined | : 2008-03-20 |
|
| Profile |
|
| Posted : 2008-03-20 05:45:07 |
Hi folks,
I'm currently evaluating QODBC to enable integration with a website shopping cart database.
I have the drivers installed on an XP Pro machine, fully patched and running IIS.
Via DCOMCNFG, I modified the qbXMLRP2eQODBCInteractive and qbXMLRPeQODBCInteractive DCOM components for Launch and Activate and Access, adding IUSR, INTERACTIVE and ASPNET accounts, with full permissions.
I created a test QB file, called C:\QB_test\Test.QBW, renamed the default QODBC System DNS to QBData, pointed it to the QBW file, configured the QuickBooks file (as admin) to allow the QODBC application to read and modify, and login automatically.
I added a single invoice, then ran the connection test. The test works, and the sample VB application returns the invoice record.
Next I created a test virtual directory with a single ASP page with the following script block. The page hangs on the ADO connection.open call, no matter how I modify the connection string. I've tried dozens of different connection strings, without success.
Does the file need to be open in quickbooks in order to connect? Can another QB file be open while I'm connecting to another?
I'd appreciate any assistance you could provide.
<%
dim cnn
Dim rs
dim sSQL
set cnn = Server.CreateObject("ADODB.connection")
Response.Write "cnn created"
set rs = Server.CreateObject("ADODB.Recordset")
Response.Write "rs created"
cnn.ConnectionString = "Driver={QODBC Driver for QuickBooks};DFQ=C:\QB_test\Test.QBW;OpenMode=M;OLE DB Services=-2;"
Response.Write "CONNECTION STRING SET"
cnn.Open
stSQL = "SELECT * from Employee"
Set rs = cnn.Execute(stSQL)
Do While (not rs.EOF)
For i = 0 to 5
Response.Write "Field " & i & ": " & rs.Fields(i).Value & "<BR>"
rs.MoveNext
Next
Loop
rs.Close
Set rs = Nothing
cnn.Close
Set cnn = Nothing
cnn.Open
%>
Thanks in advance.
Ken Prock
IT Manager
Virtual Graffiti, Inc.
9979 Muirlands Blvd.
Irvine, CA 92618 |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-03-26 12:22:49 |
|
|
|
|