ODBC - Works on some but not others - PLEASE HELP !!!!!!
John R. Hamilton
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
jrhla...@hotmail.com