ODBC Connection Reset

[Sue]

We recently had to change our server and my ODBC connections are incorrect.
I have found the following command

ActiveSheet.querytables(1).connection = "ODBC;DRIVER=DEBUG KISAM 32 bit
driver;UID=username;;SERVER=xxxxxxxx;DBNAME=ODBC;LUID=username;"

This corrects the problem but on one sheet at a time. I may have 5 sheets
in one file running queries, is there a command instead of active sheet, that
will update all sheets in the workbook?

 

[Jan Karel Pieterse]

Hi Sue,

This corrects the problem but on one sheet at a time. I may have 5 sheets
in one file running queries, is there a command instead of active sheet, that
will update all sheets in the workbook?

Try my Flexfind tool, it should be able to do a global search and replace for
you. Make sure you check the "Objects" box when you use it.
www.jkp-ads.com/officemarketplaceff-en.asp

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com