Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
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?
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement