[thelist] Q about connecting to a DB with VBScript

[Ken Schaefer]

Hi there,

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adosql/adoprg04_97g9.asp
-and-
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataSqlClientSqlConnectionClassConnectionStringTopic.asp

Cheers
Ken

PS Use the OLEDB Provider, not the ODBC driver:

strConn = _
    "Provider=Microsoft.Jet.OLEDB.4.0;" & _
    "Data Source=" & Server.Mappath("sitedbs\CustInfo.mdb") & ";" & _
    "Persist Security Info=False"

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <burgan at iprimus.com.auSubject: [thelist] Q about connecting to a DB with VBScript


Hi,

I've seen the following line of code which directs to an Access DB.

What does 'Persist Security Info=False" mean? I've never seen this before?

----
adoCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath("sitedbs\CustInfo.mdb") & ";Persist Security Info=False"
----

Thanks
Tim

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~