Connecting to SQL Server 2005 with PHP 64 bit

[TinMan486]

I am using PHP 64 bit on windows server 2003 64 bit edition.

I am trying to connect to a SQL Server, via the odbtp extension. So far the PHP page I am attempting to connect with returns nothing but also does not error.

Essentially I am asking for a template or some dummy code for connection to SQL Server 2005 and the returning of data just to be sure I can actually connect and that data can be retrieved. Any help is greatly appreciated.

Also if you have any questions for clarity please don't hesiate to ask.

 

[ingresman]

while someome magics this up can you try switching on the ODBC tracing facility ? and see what is happening.
also do you have error notification switch on in php.ini ?
lust run odbcad32 to get o the utility. I don't know the 64 version so it might have a different call e.g. odbcad64

 

[TinMan486]

odbc tracing is turned on i should be able to see that using phpinfo() right

if not how do i turn on odbc tracing...

I am also editing the ini right now. as far as functionality goes any commands etc that work in 32 bit should work in 64. The only issue i've found is no MS SQL connection support because mircosoft doesn't support a 64 bit dll for the extension. Thats why im using odbtp to "manually" work around it.

 

[ingresman]

You need to start a cmd session on the box where the web server is and type odbcad32.
Click the Tracing tab.
Put a file name in the Log file Path box.
Click start tracing now.
.
Do you web site stuff
.
Go back to the odbcad32 command and click the stop tracing button on the trace tab.
.
Look at the file you specified in the log file path box.
Does it tell you anything ?