Hi,

I will make this short and to the point. I wrote a program in VB6 that
links to Excel. The data is displayed using MSHFlexGrid. I use the VB6
Data Environment with the following connection source.

dsn=Excel Files; dsq=.\Payroll.xls

I create an executable on the server. It works great from the (2) XP and
(2) Win 98 computers. But the other single XP computer and other (3) Win 98
computers do not connect to the data and the MSHFlexGrid is empty. I have
installed all the latest ODBC drivers and verified the DSN of each.

Why does the program work on some of the computers but not others. I have
ruled out the operating system since it works on both XP and 98. The only
other thing is the ODBC drivers. I have even tried to force ODBC as follows
to even select the appropriate ODBC driver as follows in my connection
source.

ODBC;dsn=Excel Files; dsq=.\Payroll.xls

On the ones that do work, the ODBC dialog box comes alive and requests a
driver. On the ones that do not work, the ODBC dialog box never shows up
and the program continues to display the MSHFlexGrid and it is empty.

Is there a startup service or event that must be in the registry or
something to kickstart the ODBC on the other computers. What is it that I
need to do ???? PLEASE HELP !!!! PLEASE HELP !!!! PLEASE HELP !!!!


Thank you in advance, John
jrhlasvegas@hotmail.com

Are you using On Error Resume Next ? I am curious as to why no error is triggered. I would create a simple vb app that has connection/recordset objects using the excel file and loop through 10 records displaying through a message box - don't use any error trapping, if it is failing we want to see.

I am not using any error trapping mechanism. Again, it works on others but not on others. Please help.

Check the versions of mdac on each machine and I would create a minimal application (maybe 15 lines of code) that just opens the recordset and loops through a couple of records for the excel file (this might yield more information about the problem).

I have done just that.... But the ODBC does not trigger on some of the machines but on others it does. No errors are generated and all the computers have the same MDAC. Any other suggestions ?

PLEASE HELP ME !!!!!!!

Thank you,
John
jrhlasvegas@hotmail.com