CrazyEngineers
CrazyEngineers
  • 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
    Replies
Howdy guest!
Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a member of our community. Consider creating an account or login.
Replies

  • RajdeepCE

    Member • 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
    Are you sure? This action cannot be undone.
    Cancel
Home Channels Search Login Register