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 (by searching for that record), now however, on the other pc's when it checks for this it doens't find the record that already exists (it comes up with recordset.EOF on the search) 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.

 

[fenris]

Trying loading the latest MDAC onto the target computer. I had similar problems and that resolved them.... Troy Williams B.Eng.
fenris@hotmail.com

 

[Painkiller]

That did it! Thanx man, the app is up and running.

 

[fenris]

That is one of the problems that I found with visual basic, so many darn support files before your app will run. What I do is have a couple of virgin machines to test my apps out on. I have a w2k machine and a win98 machine. They usually get the gamit of problems. Usually they are api problems or database problems.......

Troy Williams B.Eng.
fenris@hotmail.com

 

[chiph]

fenris -

I've done that in the past -- you can use a program like Ghost or Drive Image to make as many configurations as you want onto a removeable drive like a 2gb JAZ. You then boot from a floppy, run the restore program, and presto! your machine is fresh again.

Chip H.

 

[elziko]

Mmm, we are trying to do the same sort of thing here with ghost. On our test computer I have two partitions and I want to install Win2K & Oracle, then copy an image 0of this onto the other partition and then maybe use a floppy to recretae the original system.

Can you give me any advice on using ghost to do this 'cos I get completley lost when trying!

Or, will Drive Image be easier to use for this?

Cheers,

elziko

 

[chiph]

Elziko -

Haven't used Ghost myself, but have used Drive Image.

What part are you having trouble with? Your first partition (primary, bootable) would have to contain your OS and everything you want to replicate. The 2nd (logical on extended) partition would be storage for the image files. The trick is recognizing which is which when the program prompts you for a source and destination partition. Oh, you'll need to make sure the 2nd partition is plain old FAT16. This will limit you to 2gb, but you could divide it up into several FAT16 partitions.

The reason you need a DOS bootable floppy is if you want to restore an NT/2000 partition that's using NTFS. NT/2000 locks the boot drive during use, so you can't use a copy of the program located on the boot drive. Thus, you boot from a floppy. And... since poor old DOS only knows FAT16, that's why you made the storage partitions FAT16, so DOS can see them.

Chip H.