LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 28th 04, 03:11 PM
Posts: n/a
Default Attempt to register XLODBC32.DLL failed when trying to load SQL-R.

Using Office 2003. Have speadsheet created in Excel 2002 which uses
XLODBC.XLA add-in to gain access to my SQL database.
When tried to run program on another computer running Excel 2003, the add-in
will not load giving message "Attempt to register XLODBC32.DLL failed".
Cells with SQL.REQUEST formula show as #NAME?

Do not have any other instances of Excel installed.
ODBC DNS has been created and tested OK.
Have opened Visual Basic editor and gone to Tools/References and pointed the
path to XLODBC.XLA

Any suggestions v.welcome:-)

  #2   Report Post  
Old October 28th 04, 03:36 PM
Posts: n/a

can you locate XLODBC32.DLL through search function in windows
If you found it, go to the add-ins menu, click on automation, on browse
and browse to the xlodbc32.dll

schuurke28's Profile:
View this thread:

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

All times are GMT +1. The time now is 05:35 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017