db connection error

[keith]

hi all... Im coding in VB.net
i get an error on this code.
i created the dsn using the tool
but i keep getting "Couldn't find installable ISAM"
the DB is an Access 2002 version File

odbConn = New System.Data.OleDb.OleDbConnection()
cnStr = "DSN=mysiteName_DSN;"
odbConn.ConnectionString = cnStr
odbConn.Open()
odbConn.Close()

any help would be appreciated ;)

thx Keith

[bruce]

This won't work.

ASP.net do not work with ODBC (unless odbc.net is installed) We are debating whether we should offer ODBC.net because MSFT is phasing out ODBC in favor of OLE & .net native db provider (that's why odbc.net is not bundled with the framework)

See a code sample at http://forum.discountasp.net/topic.asp?TOPIC_ID=21

Hope this helps.

[b]quote:Originally posted by keith

hi all... Im coding in VB.net
i get an error on this code.
i created the dsn using the tool
but i keep getting "Couldn't find installable ISAM"
the DB is an Access 2002 version File

odbConn = New System.Data.OleDb.OleDbConnection()
cnStr = "DSN=mysiteName_DSN;"
odbConn.ConnectionString = cnStr
odbConn.Open()
odbConn.Close()

any help would be appreciated ;)

thx Keith
</blockquote id="quote"></font id="quote">