I was able to get the Database to be seen by VS2005, but have now run into
another road block. Can someone help me?!!
Here is the situtaion.
I am trying to write a small application that accesses data within an Access
2007 database file with an extention .ACCDB file. I am running Vista on my
computer and using Visual Studio 2005. I am having major difficulty
connecting to the database and actually reading data from it.
The default setting in the app.config file for the connectionstring created
by VS2005 is connectionstring="DSN=MS Access Database” and
providerName="System.Data.Odbc". This value does not work. It generates the
error: {"ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed"}.
I did some investigation and then tried connectionString="driver={Microsoft
Access Driver (*.accdb)};DBQ=GrammarData.ACCDB". This string generated the
error: “ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified”
Both errors occur when the following code is run when the form is loading:
“this.conceptsTableAdapter.Fill(this.grammarData Set.Concepts”.
Does anyone have an example of how to load and read an Access database with
an extension of .ACCDB correctly?
--
-----------
Thanks,
Steve
"SteveT" wrote:
I am trying to write an application using VS 2005 that accesses an Access
database. Unfortunately, VS 2005 doesn't seem to understand the new Access
2007 file extention. Can VS 2005 use the new Access 2007 file format?
--
-----------
Thanks,
Steve