Help needed Urgently!! database ODBC SQL Server Driver

king99

king99

@king99-bh2V1z • Oct 26, 2024
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
Like 0 Replies 1

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

Sign up Log in

CrazyEngineers powered by Jatra Community Platform

  • RajdeepCE

    RajdeepCE

    @rajdeepce-7UdrG8 • 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
    0