Another Instance of SQL Server

20 Jul 2006 4:56 PM

Rafael Chemtob

hi,
i created another instance of MS SQL Server on server BESQL01. this new
instance is called BESQL01A. i'm trying to connect to it from a web page
and it's giving me an error saying the server doesn't exist.
any ideas what the missing link is.
here is the connection string:
oDBCOnn.open "driver={SQL Server};server=BESQL01\BESQL01A;uid=
xxxx;pwd=xxxxxxx;database=DATABASENAME"

thanks

20 Jul 2006 5:26 PM

Arnie Rowland

Messages in the group "server doesn't exist" tend to fall into either the
server name is incorrect, security info (UserID/PWD) is incorrect, or
firewall issues.

Please post the complete error message.

Is there such a database as "DATABASENAME"? ;-)

--
Arnie Rowland
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

Show quote

"Rafael Chemtob" <rchemtobb@nospam.yahoo.com> wrote in message
news:uRoonzBrGHA.3908@TK2MSFTNGP05.phx.gbl...
> hi,
> i created another instance of MS SQL Server on server BESQL01. this new
> instance is called BESQL01A. i'm trying to connect to it from a web page
> and it's giving me an error saying the server doesn't exist.
> any ideas what the missing link is.
> here is the connection string:
> oDBCOnn.open "driver={SQL Server};server=BESQL01\BESQL01A;uid=
> xxxx;pwd=xxxxxxx;database=DATABASENAME"
>
> thanks
>
>