View Feed
group-icon
Coffee Room
Discuss anything here - everything that you wish to discuss with fellow engineers.
12933 Members
Join this group to post and comment.
king99
king99 • Aug 16, 2011

Help needed Urgently!! database ODBC SQL Server Driver

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
RajdeepCE
RajdeepCE • Aug 16, 2011
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.

-Regards,
RajdeepCE

Share this content on your social channels -