How to Connect SQL database from server2005 over dyndns in php?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kurakar

    How to Connect SQL database from server2005 over dyndns in php?

    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:
    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);
    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
Working...