db connection error

Discussion in 'ASP.NET / ASP.NET Core' started by keith, Feb 27, 2003.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. 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
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    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.

    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">
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page