obdc_connect()

[brownfox]

This works fine while trying to connect to sql server on localhost:

$dsn="sqlserver";
$username="sa";
$password="";
$sqlconnect=odbc_connect($dsn,$username,$password);

I have created a new sql server dns configuration on "COMPUTER1" (networked computer) with the same name "sqlserver" and I want to connect to that computer. So my question is how do I change the above code to connect to a dns name "sqlserver" on COMPUTER1? I've tried this:

$dsn="COMPUTER1/sqlserver";
$username="sa";
$password="";
$sqlconnect=odbc_connect($dsn,$username,$password);

But no luck, I get this error msg:
"Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:\

http://www\webroot\SampleASP\inc\db.php

on line 5"
P.S i'm using Apache2 and PHP by the way...
T.I.A!

 

[seema165]

Try this website:

http://www.connectionstrings.com/

or

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=6442&lngWId=4

It gives you the connect strings and examples of how to do them for different databases.

Hope this helps

 

[brownfox]

Unfortunately none of those helped as I'm using PHP not asp, but thanks anyway!

 

[brownfox]

Got it! From the php manual

http://uk.php.net/manual/en/function.odbc-connect.php

way down in the comments bit...

$connection_string = 'DRIVER={SQL Server};SERVER=COMPUTER1;DATABASE=SampleASP';
$user = 'sa';
$pass = '';
$connection = odbc_connect( $connection_string, $user, $pass );