Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO Connection
Message
From
11/12/2001 15:54:28
Jason Dalio
Northern Interior Regional Health Board
Prince George, British Columbia, Canada
 
 
To
10/12/2001 19:44:38
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Title:
Miscellaneous
Thread ID:
00592465
Message ID:
00592936
Views:
17
The way you are specifying the provider string is incorrect if you are trying to use a password. It should be (double-quotes replaced by []):

oConn.Open []Provider=Microsoft.Jet.OLEDB.4.0;Data Source=[] & filePath & [];User ID=Admin;Password=blargaria[]

Also, if you want to track down the problem if this doesn't work, remove the database password and try connecting with no password or user id set. Then at least you know if it is a problem with the security.
Previous
Reply
Map
View

Click here to load this message in the networking platform