Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem when I am using Microsoft Jet 4.0 OLE DB Provider in
Message
From
18/06/2003 14:47:04
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Problem when I am using Microsoft Jet 4.0 OLE DB Provider in
Miscellaneous
Thread ID:
00801366
Message ID:
00801366
Views:
52
Problem when I am using Microsoft Jet 4.0 OLE DB Provider in Visual Foxpro

I can’t give a password for the database when I am using Microsoft Jet 4.0 OLE DB Provider. If the database has no password, it is working properly. If the database has a password, system will show an error message – OLE IDispatch exception code 0 from Microsoft JET Database Engine: Cannot start your application. The workgroup information file is missing or opened exclusively by another user. I have used the following code in the application.

recordSet = CreateObject('ADODB.RECORDSET')
recordSet.CursorLocation = 3
recordSet.LockType = 3
recordSet.Open("Select * from [Brand]", ;
“Provider=Microsoft.Jet.OLEDB.4.0;” + ;
"Data Source= data\db1.mdb;user id=admin;password=tmp")

I have some more doubts, how can I connect Oracle and MS SQL databases using OLEDB provider. I know how to connect the same using data source names (ODBC), but it is too slow. How can I make an ODBC connection fast?
Reply
Map
View

Click here to load this message in the networking platform