access db via asp.net

[=?Utf-8?B?c2VndWU=?=]

I'd greatly appreciate suggestions on a better method for cursing through
access database tables or why I'm getting the following error at
oleConnection.Open().

Do I need an odbc syntax instead of oledb?
Much thanks.

System.Data.OleDb.OleDbException: The database has been placed in a state on
machine 'IO' that prevents it from being opened or locked.

Dim olestring As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\db\db2000_1_client.mdb"
Dim qstring As String = "SELECT * FROM " & aTable & ""

Try

oleConnection = New OleDbConnection(olestring)
'oleDataAdapter = New oledataadapter
oleConnection.Open()

[=?Utf-8?B?TWFuaXNo?=]

Try to give ASPNET account rights to the folder which contains the mdb
database and make sure that database is not opened/used by some other
Application.

Regards,
Manish
www.ComponentOne.com
"segue" wrote:

>
I'd greatly appreciate suggestions on a better method for cursing through
access database tables or why I'm getting the following error at
oleConnection.Open().

Do I need an odbc syntax instead of oledb?
Much thanks.

System.Data.OleDb.OleDbException: The database has been placed in a state on
machine 'IO' that prevents it from being opened or locked.

Dim olestring As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\db\db2000_1_client.mdb"
Dim qstring As String = "SELECT * FROM " & aTable & ""

Try

oleConnection = New OleDbConnection(olestring)
'oleDataAdapter = New oledataadapter
oleConnection.Open()

[Michael Nemtsev [MVP]]

Hello segue,

Are u sure that u are using the right connection string? U can check it there
http://connectionstrings.com/

I recommend u to use the following OLEDB sample how to work with Access DB
in C# http://msdn2.microsoft.com/en-us/lib...52(VS.71).aspx

---
WBR,
Michael Nemtsev [.NET/C# MVP] :: blog: http://spaces.live.com/laflour

"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo
sI'd greatly appreciate suggestions on a better method for cursing
sthrough access database tables or why I'm getting the following error
sat oleConnection.Open().
s>
sDo I need an odbc syntax instead of oledb?
sMuch thanks.
sSystem.Data.OleDb.OleDbException: The database has been placed in a
sstate on machine 'IO' that prevents it from being opened or locked.
s>
sDim olestring As String =
s"Provider=Microsoft.Jet.OLEDB.4.0;Data
sSource=c:\db\db2000_1_client.mdb"
sDim qstring As String = "SELECT * FROM " & aTable & ""
sTry
s>
soleConnection = New OleDbConnection(olestring)
s'oleDataAdapter = New oledataadapter
soleConnection.Open()

[=?Utf-8?B?c2VndWU=?=]

Thank you for your responses.

I'm now getting the error:
System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot
find the input table or query 'Reports'. Make sure it exists and that its
name is spelled correctly.

From:

Dim olestring As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\db\db2000_1_client.mdb;Persist Security Info=False;"
Dim qstring As String = "SELECT * FROM Reports" ' & pwTable & ""

"Michael Nemtsev [MVP]" wrote:

Hello segue,

Are u sure that u are using the right connection string? U can check it there
http://connectionstrings.com/

I recommend u to use the following OLEDB sample how to work with Access DB
in C# http://msdn2.microsoft.com/en-us/lib...52(VS.71).aspx

---
WBR,
Michael Nemtsev [.NET/C# MVP] :: blog: http://spaces.live.com/laflour

"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo
sI'd greatly appreciate suggestions on a better method for cursing
sthrough access database tables or why I'm getting the following error
sat oleConnection.Open().
s>
sDo I need an odbc syntax instead of oledb?
sMuch thanks.
sSystem.Data.OleDb.OleDbException: The database has been placed in a
sstate on machine 'IO' that prevents it from being opened or locked.
s>
sDim olestring As String =
s"Provider=Microsoft.Jet.OLEDB.4.0;Data
sSource=c:\db\db2000_1_client.mdb"
sDim qstring As String = "SELECT * FROM " & aTable & ""
sTry
s>
soleConnection = New OleDbConnection(olestring)
s'oleDataAdapter = New oledataadapter
soleConnection.Open()

[=?Utf-8?B?c2VndWU=?=]

Please disregard I figured it out by making a database connection with
visual studio and using the wizards to create functional queries.

Thanks.

"segue" wrote:

>
Thank you for your responses.

I'm now getting the error:
System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot
find the input table or query 'Reports'. Make sure it exists and that its
name is spelled correctly.

From:

Dim olestring As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\db\db2000_1_client.mdb;Persist Security Info=False;"
Dim qstring As String = "SELECT * FROM Reports" ' & pwTable & ""

"Michael Nemtsev [MVP]" wrote:

Hello segue,

Are u sure that u are using the right connection string? U can check it there
http://connectionstrings.com/

I recommend u to use the following OLEDB sample how to work with Access DB
in C# http://msdn2.microsoft.com/en-us/lib...52(VS.71).aspx

---
WBR,
Michael Nemtsev [.NET/C# MVP] :: blog: http://spaces.live.com/laflour

"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo
sI'd greatly appreciate suggestions on a better method for cursing
sthrough access database tables or why I'm getting the following error
sat oleConnection.Open().
s>
sDo I need an odbc syntax instead of oledb?
sMuch thanks.
sSystem.Data.OleDb.OleDbException: The database has been placed in a
sstate on machine 'IO' that prevents it from being opened or locked.
s>
sDim olestring As String =
s"Provider=Microsoft.Jet.OLEDB.4.0;Data
sSource=c:\db\db2000_1_client.mdb"
sDim qstring As String = "SELECT * FROM " & aTable & ""
sTry
s>
soleConnection = New OleDbConnection(olestring)
s'oleDataAdapter = New oledataadapter
soleConnection.Open()