What could it be ? Plz answer me

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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


Bobby said:
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
Click to expand...
also tried Trusted_Connection =true/false
Earlier I installed in a different XP machine and that machine is working
Click to expand...
fine with the same database so the id and pwd is not the problem, I think.
 
Back
Top