Here's my situation. I'm using PHP to talk to 2 different MS SQL databases. One of them is setup by IT, the other is my development server. I'm using ADO/ODBC to talk to both, but it only works on the IT server. Granted, I'm only using this in cases of large text fields, otherwise I use the built-in PHP MSSQL library.
My question isn't necessarily about the code, because I know the code is fine. I just need to know how to setup the ODBC driver on the development server so that my code can talk to it:
I've tried playing with the Data Sources (Administrative Tools -> Data Sources), but I'm apparently missing something.Code:$conn = new COM("ADODB.Connection") or die("Cannot start ADO"); $conn->Open("Provider=SQLOLEDB; Data Source=edlsql.hag.bulldog.com;Initial Catalog=TestCellData; User ID=labuser; Password=helab");
Anything would be helpful.




Reply With Quote