Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2003
    Posts
    4

    Unanswered: ODBC - Works here and there ? PLEASE HELP !!!!

    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

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    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.

  3. #3
    Join Date
    Jan 2003
    Posts
    4
    Originally posted by rnealejr
    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.

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    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).

  5. #5
    Join Date
    Jan 2003
    Posts
    4

    Unhappy

    Originally posted by rnealejr
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •