DSN Connection for Microsoft Access in ASP.NET

Hi,

I want to use a DSN connection to connect to MS Access Database. The
ODBC DSN has been configured as MIT.
I use the following connection string to connect (using VB.NET):

Dim cn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;
DSN=MIT")

This throws up an error: Could not find installable ISAM
[OleDbException (0x80004005): Could not find installable ISAM.]
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvider() +57
System.Data.OleDb.OleDbConnection.Open() +203

Can some one please let me know how to make a DSN connection to
Microsoft Access 2000 database in ASP.NET 1.1?

Thanks in advance,
Sandeep Gupta

Paul
Fri May 18 09:27:17 CDT 2007

On 17 May 2007 21:45:54 -0700, Sandeep Gupta <sandy.pec@gmail.com> wrote:

¤ Hi,
¤
¤ I want to use a DSN connection to connect to MS Access Database. The
¤ ODBC DSN has been configured as MIT.
¤ I use the following connection string to connect (using VB.NET):
¤
¤ Dim cn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;
¤ DSN=MIT")
¤
¤ This throws up an error: Could not find installable ISAM
¤ [OleDbException (0x80004005): Could not find installable ISAM.]
¤ System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20
¤ System.Data.OleDb.OleDbConnection.InitializeProvider() +57
¤ System.Data.OleDb.OleDbConnection.Open() +203
¤
¤ Can some one please let me know how to make a DSN connection to
¤ Microsoft Access 2000 database in ASP.NET 1.1?

First, ODBC is not the recommend method for connecting to an Access database. This method is not as
stable and doesn't provide the level of functionality supported by Jet OLEDB.

Second, It looks like you're trying to use the DSN with the Jet OLEDB provider. This is not
supported. If you use a DSN then you will probably need to use the ODBC library instead of OLEDB.

Dim ODBCConnection As Microsoft.Data.Odbc.OdbcConnection

Dim ConnectionString As String = "DSN=MIT;"

ODBCConnection = New Microsoft.Data.Odbc.OdbcConnection(ConnectionString)
ODBCConnection.Open()


Paul
~~~~
Microsoft MVP (Visual Basic)

Sandeep
Fri May 18 10:07:21 CDT 2007

Thanks a lot Paul, I was able to connect to the database using your
suggestions.

One more query,

When I am using the Jet OLEDB provider and specifying the physical
path using the Server.MapPath(".")+"/Data/MIT.db", I get the error
saying the file "d:\host\mit\www\data\mit.db" could not be found. But
the location of the uploaded file is www\data\mit.db.

Is there any workaround to get access using the Jet driver?

- Sandeep


On May 18, 7:27 pm, Paul Clement
<UseAdddressAtEndofMess...@swspectrum.com> wrote:
> On 17 May 2007 21:45:54 -0700, Sandeep Gupta <sandy....@gmail.com> wrote:
>
> =A4 Hi,
> =A4
> =A4 I want to use aDSNconnectionto connect to MSAccessDatabase. The
> =A4 ODBCDSNhas been configured as MIT.
> =A4 I use the followingconnectionstring to connect (using VB.NET):
> =A4
> =A4 Dim cn As New OleDbConnection("Provider=3DMicrosoft.Jet.OLEDB.4.0;
> =A4DSN=3DMIT")
> =A4
> =A4 This throws up an error: Could not find installable ISAM
> =A4 [OleDbException (0x80004005): Could not find installable ISAM.]
> =A4 System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20
> =A4 System.Data.OleDb.OleDbConnection.InitializeProvider() +57
> =A4 System.Data.OleDb.OleDbConnection.Open() +203
> =A4
> =A4 Can some one please let me know how to make aDSNconnectionto
> =A4MicrosoftAccess2000 database in ASP.NET 1.1?
>
> First, ODBC is not the recommend method for connecting to anAccessdatabas=
e=2E This method is not as
> stable and doesn't provide the level of functionality supported by Jet OL=
EDB.
>
> Second, It looks like you're trying to use theDSNwith the Jet OLEDB provi=
der. This is not
> supported. If you use aDSNthen you will probably need to use the ODBC lib=
rary instead of OLEDB.
>
> Dim ODBCConnection AsMicrosoft.Data.Odbc.OdbcConnection
>
> Dim ConnectionString As String =3D "DSN=3DMIT;"
>
> ODBCConnection =3D NewMicrosoft.Data.Odbc.OdbcConnection(Connecti=
onString)
> ODBCConnection.Open()
>
> Paul
> ~~~~MicrosoftMVP (Visual Basic)

Paul
Tue May 22 11:41:27 CDT 2007

On 18 May 2007 08:07:21 -0700, Sandeep Gupta <sandy.pec@gmail.com> wrote:

¤ Thanks a lot Paul, I was able to connect to the database using your
¤ suggestions.
¤
¤ One more query,
¤
¤ When I am using the Jet OLEDB provider and specifying the physical
¤ path using the Server.MapPath(".")+"/Data/MIT.db", I get the error
¤ saying the file "d:\host\mit\www\data\mit.db" could not be found. But
¤ the location of the uploaded file is www\data\mit.db.
¤
¤ Is there any workaround to get access using the Jet driver?

Could you post your code?

I can't tell where your Data folder is relative to your application path.


Paul
~~~~
Microsoft MVP (Visual Basic)

Sandeep
Tue May 22 23:56:16 CDT 2007

Hi Paul,

I am using the following code:

Dim conn as String =3D ""Provider=3DMicrosoft.Jet.OLEDB.4.0; DataSource=3D"
+ Server.MapPath(".") + "\Data\MIT.db"
Dim cn As New OleDbConnection(conn)

Now the Server.MapPath(".") returns d:\host\mit\www, but while
connecting it says the path cannot be found.

Thanks,
Sandeep


On May 22, 9:41 pm, Paul Clement
<UseAdddressAtEndofMess...@swspectrum.com> wrote:
> On 18 May 2007 08:07:21 -0700, Sandeep Gupta <sandy....@gmail.com> wrote:
>
> =A4 Thanks a lot Paul, I was able to connect to the database using your
> =A4 suggestions.
> =A4
> =A4 One more query,
> =A4
> =A4 When I am using the Jet OLEDB provider and specifying the physical
> =A4 path using the Server.MapPath(".")+"/Data/MIT.db", I get the error
> =A4 saying the file "d:\host\mit\www\data\mit.db" could not be found. But
> =A4 the location of the uploaded file is www\data\mit.db.
> =A4
> =A4 Is there any workaround to get access using the Jet driver?
>
> Could you post your code?
>
> I can't tell where your Data folder is relative to your application path.
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)

Paul
Fri May 25 11:15:17 CDT 2007

On 22 May 2007 21:56:16 -0700, Sandeep Gupta <sandy.pec@gmail.com> wrote:

¤ Hi Paul,
¤
¤ I am using the following code:
¤
¤ Dim conn as String = ""Provider=Microsoft.Jet.OLEDB.4.0; DataSource="
¤ + Server.MapPath(".") + "\Data\MIT.db"
¤ Dim cn As New OleDbConnection(conn)
¤
¤ Now the Server.MapPath(".") returns d:\host\mit\www, but while
¤ connecting it says the path cannot be found.
¤

If the path is valid could this be a permissions issue? What type of authentication is your web
application configured for? Anonymous? Basic? Integrated Windows?


Paul
~~~~
Microsoft MVP (Visual Basic)