ODBC Problem needs help

johnzhou529

New member
Joined
Jul 20, 2004
Messages
1
Programming Experience
Beginner
Hi i am a newbie to vb.net
currently developing an web application and trying to connect it to a MS Acess
DB, i use the OdbcConnection to connect to the DB and then assign it to a ODBC command. Every thing went well and it debug ok but when i input data in the web page (meant to be written into the database) it's not happy with the line: OdbcConnection1.Open()
it throws the exception: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified


How do i point to the data source and default driver???

Thanks if u can help me
 

Paszt

Staff member
Joined
Jun 3, 2004
Messages
1,500
Location
Raleigh, NC - USA
Programming Experience
Beginner
For MS Access, use the System.Data.OleDb namespace.

There are many examples in this forums.

Happy programming :).
 
Top Bottom