ADO connection string with variables

[impulse24]

Hello,

I am creating a program to loop through db's in a directory. I have a variable for the database name. How do I use this variable in the following connection string:

connectstring = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=C:\Programming Tests\ & strDbName;" _
& "Persist Security Info=False"

strDbName contains the database name. I know I have to surround the variable with quotes or something, but can't get it to work. Can someone please show me the syntax. Thanks

 

[sunaj]

Hi,

You need to have the variable outside the "
like this:
connectstring = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=C:\Programming Tests\" & strDbName & _
& "Persist Security Info=False"

Sunaj

 

[woyler]

Sunaj is correct, except you will need the semi colon after the variable


connectstring = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=C:\Programming Tests\" & strDbName & _
& ";Persist Security Info=False"

 

[sunaj]

yes, thanks woyler.