executable doens't work properly on other pc's 1

[Painkiller]

Hi all,

I facing the following problem. I've made a vb application that reads in data files and stores the data in a SQL server database on a remote server using ADO. The program works fine on my pc (WIN NT). I've compiled the program using the package and deployment tool and distributed it to other pc's (both with win 98 and win nt). However, when run , the program doesn't work properly. When it is storing data, the program checks if the key it is about to store already exists in the DB, now however, on the other pc's when it checks for this it doens't find the record that already exists and when it gets tot the update command it crashes. The program is able to make a connection to the server and the database so the problem is not there...

Anyone know how to solve this one?

Thx in advance.

 

[RAtkison]

In the directory where the setup files are stored should be a file called mdac_typ.exe. For ADO to work properly on the users machine, this file must be installed.
Hope it works!
RKA

 

[Painkiller]

Thanx man. installed version 2.6 of MDAC (instead of the 2.0 that VB ships with the setup files)and the app is happily running again.