Dear all,
How to connect SQL Database from Server 2005 through dyndns in php,
My dyndns address - xxx-xxx.dyndns.org
Port - 3389(default)
This is the code i am using:
And the error like this
Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection., SQL state 08001 in SQLConnect in C:\wamp\www\qam aruae\component s\com_amc1234\v iews\amc1234\tm pl\statement.ph p on line 3
ODBC Error:: 08001 :: [Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection. :: DRIVER={SQL Server};SERVER= xxxx-xxxxx.dyndns.or g:3389\SQLEXPRE SS;DATABASE=xxx xxxxxxxx
Please helpme
How to connect SQL Database from Server 2005 through dyndns in php,
My dyndns address - xxx-xxx.dyndns.org
Port - 3389(default)
This is the code i am using:
Code:
$dsn = 'DRIVER={SQL Server};SERVER=xxxx-xxxx.dyndns.org:3389\SQLEXPRESS;DATABASE=CXXXXXXC';
$connection = odbc_connect($dsn,'sa','xxxxxx') or die('ODBC Error:: '.odbc_error().' :: '.odbc_errormsg().' :: '.$dsn);
Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection., SQL state 08001 in SQLConnect in C:\wamp\www\qam aruae\component s\com_amc1234\v iews\amc1234\tm pl\statement.ph p on line 3
ODBC Error:: 08001 :: [Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection. :: DRIVER={SQL Server};SERVER= xxxx-xxxxx.dyndns.or g:3389\SQLEXPRE SS;DATABASE=xxx xxxxxxxx
Please helpme