Recommended Answers
Jump to PostWhat version of VB are you using? And, what is DBEngine declared as?
Jump to Postdont know much about VB @ all but let me ask u a coupla ???...
what db are u trying to access the Access DB from?
does it support ODBC via VB directly, or do you need connection services, managers &/or drivers?
is it necessary to establish …
Jump to PostJust wanna check up on something ...
Personally, I've never connected to a database via ODBC. However, just wanna check:
You say you used the command
Set db = DBEngine.Workspaces(0).OpenDatabase("dbsourcename", ,"DSN=dbsourcename;UID=MyUID;PWD=Mypassw")
to connect to the database. You *DID* replace the items in bold with your own variables, right? …
Jump to PostDani -
Thats wrong :-P. When you use a DSN, you do not need to fill in any other information. The DSN stores everything for you.Also you seperate connnectionstring items with a ;
Jump to PostIf your using VB.NET or C#.NET the following link is your end-all resource!
http://www.connectionstrings.com/
The following is if you're using VB.NET:
Access
ODBCStandard Security:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=\somepath\mydb.mdb;Uid=Admin;Pwd=asdasd;"
Workgroup:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=\somepath\mydb.mdb;SystemDB=\somepath\mydb.mdw;"
OLEDB, …
All 28 Replies
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.