ODBC Error - Need help connecting to access

  • Thread starter Thread starter George
  • Start date Start date
G

George

I get the following connectivity error. im trying to
conncet to MSAccess 2000

any suggestions ?

Server Error in '/EBtest' Application.
-----------------------------------------------------------
---------------------

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source
name not found and no default driver specified
Description: An unhandled exception occurred during the
execution of the current web request. Please review the
stack trace for more information about the error and where
it originated in the code.

Exception Details: System.Data.Odbc.OdbcException: ERROR
[IM002] [Microsoft][ODBC Driver Manager] Data source name
not found and no default driver specified
 
Looks like either a typo for the name (orlocation) of the data source name or a permissions issue
Try testing the DSN using outside of your application
Here's a KB article which discusses further: http://support.microsoft.com/default.aspx?scid=kb;en-us;14089

This posting is provided "AS IS" with no warranties, and confers no rights

----- George wrote: ----


I get the following connectivity error. im trying to
conncet to MSAccess 200

any suggestions

Server Error in '/EBtest' Application
----------------------------------------------------------
--------------------

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source
name not found and no default driver specified
Description: An unhandled exception occurred during the
execution of the current web request. Please review the
stack trace for more information about the error and where
it originated in the code.

Exception Details: System.Data.Odbc.OdbcException: ERROR
[IM002] [Microsoft][ODBC Driver Manager] Data source name
not found and no default driver specifie
 
¤
¤ I get the following connectivity error. im trying to
¤ conncet to MSAccess 2000
¤
¤ any suggestions ?
¤
¤ Server Error in '/EBtest' Application.
¤ -----------------------------------------------------------
¤ ---------------------
¤
¤ ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source
¤ name not found and no default driver specified
¤ Description: An unhandled exception occurred during the
¤ execution of the current web request. Please review the
¤ stack trace for more information about the error and where
¤ it originated in the code.
¤
¤ Exception Details: System.Data.Odbc.OdbcException: ERROR
¤ [IM002] [Microsoft][ODBC Driver Manager] Data source name
¤ not found and no default driver specified

Use the Jet OLEDB driver instead of the Microsoft Access ODBC driver:

Dim AccessConnection As System.Data.OleDb.OleDbConnection

AccessConnection = New
System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=E:\My Documents\db1.mdb")

AccessConnection.Open()


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top