General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Problem when I am using Microsoft Jet 4.0 OLE DB Provider in
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only