1. Home >
  2. Apps >
  3. Groups >

Help needed Urgently!! database ODBC SQL Server Driver

Question asked by king99 in #Databases on Aug 16, 2011
king99 · Aug 16, 2011
Rank D2 - MASTER
Hi database experts,

I am running visual basic 2010 application , the program access small database which we create using sql explorer [ ie we install sql server 2005] to store the values.My problem is that I am not able to access database when I run the program it gives me following error " [Microsoft] [ODBC SQL Server Driver][SQL Server] Cannot open database "ABC" requested by the login .The login failed.

I am working on project which needs to be completed sooner and is only stuck due to this error.Request to all databse experts to help me out .Please suggest solution in simple language so that I can understand it as I am new to SQL Server .

Thanks ,

King99 Posted in: #Databases
RajdeepCE · Aug 16, 2011
Rank B3 - LEADER
Do the following thing, it may help you if your connection string is wrong.
In Visual Studio, View -> Server Explorer, than right click on Data Connections & make new connection.
Try connecting & adding your database there in server explorer. Once you have successfully connected the database than you can right click on database(of course in server explorer) & view properties. There you can find the correct "Connection String" for your application.


You must log-in or sign-up to reply to this post.

Click to Log-In or Sign-Up