VB6 exe help!!!?

Question

Hi everyone need some help please...
Okay so here goes, i made this really simple program, that suppose to compare two tables from database and display the results. So i have two Ado and two datagrid. The program works fine in my computer, even when its already an exe it works okay. The problem is when i run it in another computer (that has no vb6 installed) the program runs but the items doesnt display in the datagrid. I have some sql in the code and it works fine but the Ado connection doesnt. There's no error, the database just doesnt populate the datagrid.
Im such a beginner at this can anyone help me out please?!!!

ahhmm... im using msaccess for database. and i copied it at the same place i did at the comp im working on so the path should be alright. all the ocx are there.
and... also... the sql code works fine its just the ado connection thats messing up, at least that's what i suspect. im pretty sure im missing something but since this is my first time compiling my project into .exe, i really have no clue what it is. (",)

Answer 1

let me try.

If connectionError there may be following condition of Error.
1- Database may be absent in another computer. Just copy and past database with same path of last computer.

2- Database base path may not mach as programming. Please check the path and make the same path as previous.

3- I think you have used "One Error Resume Next" or "On error goto errCheck" or any error validation so error is not showing. There must be some dll missing.

4- When ever you try to run .exe developed in VB6 it requires Visual Basic Setup invironment. it is small file comes with VB6.

5- Most important when ever used any Component(.ocx,.dll). Please copy these and past it into your program forlder where .exe exist. Practice it always.

6- Always make Setup Package of your product that includes all required files (.ocx,.dll,Font,exe,,,,,etc). And install it when ever you need. No problem will exist on new computer. It will work as were working in your computer


I think my short knoweldge could help you.

thanks

Answer 2

Compare the ODBC on the two computers for differences. I'd suspect you have one configured and one is missing.

It is usually found beneath the Control Panel - Administrative Tools area.

Answer 3

What kind of database are you using? - MySQL, Oracle, MS Access???
If not MS Access, the i think you may have to setup the ODBC just as you would have done in your computer.

Answer 4

Drag the batch file over the program,file that you want it to open up in. BATCH FILES CAN BE VERY DANGEROUS! notice you musent open that file ever again... example: hack.bat [drags] to internet explorer [releases the bat file onto the shorcut] now when somone opens that it will start the batch file.