invalid procedure call or argument

[Mike2020]

Hi

I created an application using VB to update access database. Due to the computer that I install the application can't use ODBC. so I use this way to open the database:

Dim oConn As New ADODB.Connection
oConn.Open = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\db\summation.mdb"

I also use Sleep, and DoEvents in my application.
When I use this application in Window XP, it is just run fine. But when it runs in Window NT, the error message pop up:

"invalid procedure call or argument"

Do you have any idea what is going wrong, is there *.dll files missing, or old version *.dll file. if yes, which one?

Many... Thanks

Mike

 

[blueknot]

Don't know the specific .dll, but try installing the Microsoft Data Access Pack (mdac_typ.exe) from Microsoft, that usually solves that error for me on older NT systems.

You should be able to find it either be on your studio disk or in one of the service pack downloads, or from MS's site.

 

[paulbent]

The link to the MS ODBC site is:

http://www.microsoft.com/data/odbc/

There are many flavours of MDAC available, 2.6 SP1 is a safe choice if targeting multiple O/S. You also need to download Jet 4.0 SP3 separately to connect to Access and other ISAM data sources.

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[Mike2020]

Hi Folks:

Thank you so much for your tip!!

Ming