OLE DB for access

[charonlee]

hi,

1.)I really can't solve the problem, that is why i'm here. When i'm trying to use OLEDB provider for access ((objDC.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DataPath & ";uid=;pwd=1234") ), below problem occur:

Error Type:
Microsoft JET Database Engine (0x80004005)
Could not find installable ISAM.

I have alreday tried to re register again the dll (Regsvr32 c:\winnt\system32\msexcl40.dll)file, but still face the same problem

2.) In order to create store procedure, do I must use OLEDC instead of ODBC, i failed to create SP with ODBC

3.) In order to save the database records into CRV file (rs.save "file), I need to use OLEDB right? I failed in ODBC

Please advice.

[Dreamquick]

Not 100% sure but I don't think it's possible to create a stored procedure within access - normally they are associated with full-on rdbms systems such as SQL Server or Oracle.

ODBC / OLE DB is merely an abstraction layer and so can only leverage the functions the underlying database engine exposes.

If you havent done so already you'll want to get a copy of the latest MDAC which will fix any bugs in your data access drivers as well as install the standard drivers if you dont already have them...

www.microsoft.com/data

- Tony

[charonlee]

Access can, please read:

[aspemporium.com...]

[macrost]

How are you connecting to your database? Are you using DSN or DSN-less connection?
Mac

[charonlee]

I'm using DNS-Less:

objDC.Open "DBQ=" & DataPath & ";Driver={Microsoft Access Driver (*.mdb)};DriverId=25;MaxBufferSize=8192;Threads=20;uid=;pwd="

I went to Microsoft data site, but don't have MDAC which suit my requirement, i'm using win2\k profesional service pack 2.

[macrost]

I'm running win2k with sp3. You should update to service pack 3 and see if that corrects your problem. If not then we start somewhere else ;)
Mac

[charonlee]

1.)I have already installed, and my pc now has three msrd3x40.dll files. Still cannot.

2.) But when i 'm trying to use data link, it seems like can, but I have some problems:
a)Microsoft OLE DB Service Components (0x80030005)Access Denied. I try all the access permission, all failed

3.) When i upload my files to my site (located at web hosting com), same problem occur...
Pls advice!

[charonlee]

DEAR ALL,

after a long discussion, and spent so much time,my problem only because of this:

objDC.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DataPath & ";uid=;pwd=1234" -->In correct

objDC.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DataPath & ";Jet OLEDB:Database Password=1234" -> Correct

But, I found that the SQL statement which can be executed with ODBC, can't be executed in OLEDB

For instance:
"SELECT * FROM control"
I have error :
Microsoft JET Database Engine (0x80040E14)
Syntax error in FROM clause.

"INSERT INTO Names (Name) VALUES ('Rose')"

Microsoft JET Database Engine (0x80040E14)
Syntax error in INSERT INTO statement.