|
-
Oct 6th, 2003, 07:14 AM
#1
Thread Starter
Junior Member
ADO.Net opens AccessDB always in exclusive mode ?
Hi,
i'm using vb.net with ado.net and asp.net:
Scenario:
ASP.Net creates an instance to the vb.net project and vb.net establishes the ado.net connection. But the AccessDB is always opened in exclusive mode ?
this is my connection method in vb:
Function dbopenread(ByVal osql As String) As OleDbDataReader
odbpath = "C:\db\1.mdb"
Dim objConn as New New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & odbpath & ";Jet OLEDB atabase Password=xxx")
objConn.Open()
Dim objCmd As New OleDbCommand(osql, objConn)
Dim objDataReader As OleDbDataReader = objCmd.ExecuteReader
objCmd.Dispose()
objCmd = Nothing
dbopenread = objDataReader
End Function
I also tried "Mode=SHARE DENY NONE" in the connection string?
Any idea ?
Thanks
Oliver
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|