D
Duppypog
I've searched through several forums without finding a definitive answer to
this question:
What is the proper syntax for a connection string that is connecting to an
Access 97 db with workgroup security applied?
I tried the following. I don't get an error, but it also displays NO
results:
Public Shared ReadOnly OleDbConnectionString As String =
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DBQ=c:\CORmandOTweb\NewSecure
CORMandatoryOTList.mdb
SystemDB=c:\inetpub\wwwroot\aspdotnet\cormandot\db\corrections.mdw;UID=usern
ame;PWD=anything"
Also tried:
Dim cnn As OleDbConnection = New
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Persist Security
Info=false;Data Source=" &
System.Web.HttpContext.Current.Server.MapPath("/CORmandOTweb/NewSecure
CORMandtoryOTList.mdb") & "; Jet OLEDB:System
Database=c:\inetpub\wwwroot\aspdotnet\cormandot\db\corrections.mdw;UserID=us
ername;Password=anything")
All help will be greatly appreciated!
Lynnette
this question:
What is the proper syntax for a connection string that is connecting to an
Access 97 db with workgroup security applied?
I tried the following. I don't get an error, but it also displays NO
results:
Public Shared ReadOnly OleDbConnectionString As String =
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DBQ=c:\CORmandOTweb\NewSecure
CORMandatoryOTList.mdb
SystemDB=c:\inetpub\wwwroot\aspdotnet\cormandot\db\corrections.mdw;UID=usern
ame;PWD=anything"
Also tried:
Dim cnn As OleDbConnection = New
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Persist Security
Info=false;Data Source=" &
System.Web.HttpContext.Current.Server.MapPath("/CORmandOTweb/NewSecure
CORMandtoryOTList.mdb") & "; Jet OLEDB:System
Database=c:\inetpub\wwwroot\aspdotnet\cormandot\db\corrections.mdw;UserID=us
ername;Password=anything")
All help will be greatly appreciated!
Lynnette