Hi,

When I run "DisplaySQL.php" it seems to be hanging on this statement:

$oConnect = odbc_connect("QuickBooks Data", "", "");

But I can't figure out why it's doing this.

VBDEMO32.EXE runs with no problems so I know the DNS and Remote Connector are working.

When I put Echo and die statements in the PHP file they display so I know the PHP is working.

BTW, I don't really know that much about PHP so it could be a PHP configuration issue.

Gary

Hi,

Ok, now I'm confused. The article you list doesn't mention PHP at all.

If the DSN was not setup correctly why does the VB program that uses the DSN, work?

What needs to be different about the DSN for PHP to work?

Gary

Hi,
Ok, I went through both articles and found a couple things that needed changing.

Now the VB Demo works and the qbcust.asp works.

But the DisplaySQL.asp doesn't and DisplaySQL.php doesn't. It doesn't even write the ibizqbcon.txt log file for these.
I even modified the DisplaySQL.asp to use the same connection string as qbcust.asp and added the same debug statements. It's hanging on:

oConnection.Open "QuickBooks Data"

I don't understand why one asp file works and the other doesn't, especially when using the same connection string.

Gary

Maybe I didn't make myself clear.

Aren't DisplaySQL.asp and DisplaySQL.php basically the same page in different languages?

I put:

<% Response.buffer = true %>

and

oConnection.Open "QuickBooks Data"
response.write "QODBC DSN QuickBooks Data Open<BR>" & vbCrLf
response.flush

In DisplaySQL.asp,. but I never got the response write.

So where does that leave me?

That didn't seem to make any difference. I can't get qbcust.asp to work now no matter what I do.

We've given up on the web server approach. Really what they need is to run some PHP programs to manipulate the QB data, they don't need a web interface.

How do I go about setting it up so they can use PHP in CLI mode (Already installed) on the same machine as Quick Books 6.0 Enterprise.

QODBC Version 7.0.0.194 is of course installed on that machine and currently setup with the remote connector.

The VB Demo currently runs on that machine and retrieves data.

What I'd like is for them to work on a Terminal Services session. Can QB run there or does it have to run on the console? I'm sort of confused on that point as the documentation seems be ambiguous on that unless using DCom servers. I don't know if I need the DCom option now or not.

I appreciate your help with this. It seems like a good product, just we've had trouble getting it going.

Gary

The current setup is:

Windows 2000, SP4 with terminal services
Quick Books Enterprise Solutins 6.0
QODBC Version 7.0.0.194 with the remote connector still configured
PHP 5.1.6 (cli) (built: Aug 23 2006 16:35:53)