I've setup QODBC to connect to my Online Edition of Quickbooks to test its functionality.
I've found any script I've written to run incredibly slow and seem to just hang indefinately.
Even the DisplaySQL.asp test script does not display but also does not display an error message.
Example script:
Set Conn = Server.CreateObject("ADODB.Connection") Conn.CommandTimeout = 120 Conn.ConnectionString=("Data Source=QuickBooks Data;OLE DB Services=-2;") Conn.open
Conn.Execute("INSERT INTO CUSTOMER (Name) VALUES ('Chicago Public Schools - 655')") response.write(Timer & "<br>") Conn.Execute("INSERT INTO CUSTOMER (Name) VALUES ('Chicago Public Schools - 656')") response.write(Timer & "<br>") Conn.Execute("INSERT INTO CUSTOMER (Name) VALUES ('Chicago Public Schools - 657')") response.write(Timer & "<br>") response.write("executed")
Conn.close set Conn = nothing
I've tried this setup on 2 different servers with the same result.
While the page never actually loads for me to display anything, it does eventually execute the first INSERT into my Online Edition file so I know the connection was made to the Quickbooks server.
What is the standard time it takes to execute an INSERT command a connection to the Online Edition? Or a simple SELECT query with only a few results?
I'm using the Trial Version of QODBC...are there any restrictions with that, that could be creating this lag?
This product seems ideal for what I'm trying to do. I'd like it to post these transactions realtime but I at least need to get it working fast enough that I can have a script run overnight that would execute all the transactions I need to record.
Any help would be appreciated.
Thanks
-AlexV |