phpLens
 home • products examples manual • faq support forum • contact news • login store

Forums: phplens   adodb
Forums:   PHPLens Technical Support:   Replies 
New ReplySearch
Topic: can't connect to a named instance of SQL Server 2005
author: norman   created: 08-07-2010 05:11:20 AM
if i try to connect to a name instance of MSSQL like this:



$db = ADONewConnection("mssql");

$db->debug = true;

$db->Connect('Server1\\MYINSTANCE', "myUser", "password", "MyDB");

i get the error:

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: Server1\MYINSTANCE in c:\program files\apache group\Apache\htdocs\xxx\classes\db\adodb\drivers\adodb-mssql.inc.php on line 493
Server1\MYINSTANCE: Connection error to server 'Server1\MYINSTANCE' with user 'myUser'

how can i connect to this instance?
Page 1
New ReplySearch

View Source
email: contact#phplens.com (change # to @)     telephone (malaysia): 60-3-7947 2888     fax (malaysia): 60-3-7947 2800