Password with DataControl [vb6]

bellportal
01-14-2004, 05:04 AM
Using a data control, I set the database name property to the location, but how do I tell the control what the database password is?

jezzerdilla
01-14-2004, 05:27 AM
Using a data control, I set the database name property to the location, but how do I tell the control what the database password is?

In the connection string property.

bellportal
01-14-2004, 07:18 AM
Using a data control, I set the database name property to the location, but how do I tell the control what the database password is?

In the connection string property.

Thanks,

So do I just add pwd=pass to the connection string, and keep the database location in the databaselocation property?

an5w3r
01-14-2004, 07:22 AM
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\mydb.mdb;" & _
"Jet OLEDB:Database Password=MyDbPassword", _
"myUsername", "myPassword"

an5w3r
01-14-2004, 07:24 AM
sorry for the :D i didn't realise it at that time... it means : D

try this

Provider=Microsoft.Jet.OLEDB.4.0; Data Source = db.mdb; Jet OLEDB:Database Password=yourpass

bellportal
01-14-2004, 07:58 AM
Thanks a lot, I will try it when I get home.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum