PDA

View Full Version : connecting to a database thro' VB


netharam
08-14-2002, 04:31 PM
Hi, I tried connecting to an Access databse thro' VB.It is fine until I set the password fo that database. After this when I executed the program I got an error msg. that the workgroup information file is not available. Then when I tried using the datasource name to connect to a databse I received errors.

The Code is:

con = new ADODB.Connection
con.provider ="Microsoft Jet OLEDB.4.0"
con.open(App.path &"\ov.dsn",usrnme,usrid)

where ov resides in the same directory.

I receive an error message that "The dsn does not exist, error in loading"

Expecting the best results.