What could it be ? Plz answer me

[Guest]

I have installed MSDE but when ever i try to connect to it from the same computer, it gives me
'Can not open Database requested in Login 'pubs' failed. Login fails
my connection string is as follow

Public Conn As New ADODB.Connectio
conn.Open("Driver={SQL Server};User ID=sa;Password=abcd;Database=pubs;Server=Master\Mycube"

where 'Master' is the computer name and 'Mycube' is the instance name. i also tried Trusted_Connection =true/false

Earlier I installed in a different XP machine and that machine is working fine with the same database so the id and pwd is not the problem, I think

What could it be

Any help and all the help is greatly appreciate

Thank
Bobby

 

[Rob Ford]

Do you have any kind of personal firewall installed on your PC ? If so this
could be blocking the connection.

Try using the osql command-line program to connect to your database and see
if you get the same problem

regards

Rob

I have installed MSDE but when ever i try to connect to it from the same computer, it gives me
'Can not open Database requested in Login 'pubs' failed. Login fails'
my connection string is as follows

Public Conn As New ADODB.Connection
conn.Open("Driver={SQL Server};User ID=sa;Password=abcd;Database=pubs;Server=Master\Mycube")

where 'Master' is the computer name and 'Mycube' is the instance name. i

also tried Trusted_Connection =true/false

Earlier I installed in a different XP machine and that machine is working

fine with the same database so the id and pwd is not the problem, I think.