Database Connection ,,,?

1. Anonymous Says

   go through these steps.
   1) Go to Visual Studio 2010
   2) Open Server Explorer if not visible than Go to View than click on Server Explorer. Now You will find it on the right side of your Visual Studio.
   3) In server explorer there will be Data Connection. Right click on it and than new connection.
   Data Connection >> Right Click >> Add Connection >> click on change >> select Microsoft Access Database >> click on ok >> Browse the database file and test the connection.
   if its working than you will receive message saying connection successful or else.
   regards
   Prashant

2. Juliet Russel Says

   Sorry if this is a duplicate post but there are so many I can’t figure out what applies to me.
   I had a .NET 2003 application that connected to an Access 2000 database using ODBC.
   I upgraded this to .NET 2008 and Access 2010 in a Windows 7 environment.
   My connection string used to be
   “PageTimeout=5;DSN=MS Access Database;DefaultDir=” & dbpath & “;DriverId=25;DBQ=”C:MGSDATA_VBAccess_… 10.mdb;FIL=MS”
   That gave me a data architecture error when I tried to connect.
   I downloaded the Access 2010 database engine and changed the connection string to:
   “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:MGSDATA_VBAccess_MGSDA… b”
   Now I get this message when I try to connect:
   [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
   What is the problem? I’m certain that the path on my C: drive is correct since it worked on the old version.

Leave a Reply

You must be logged in to post a comment.