Problems using ODBCDirect with Excel 95 VBA!!! 
Author Message
 Problems using ODBCDirect with Excel 95 VBA!!!

We have an Excel 95 add-in that uses DAO. In particular it uses ODBCDirect.
When developing this code, we had VB 5 etc installed on the machines so
everything worked fine. Now when we are installing all these exes on client
machines and running the Excel add-in, we are getting a page fault in
OLEAUT32.DLL when we are executing the following line of code
DBEngine.SystemDB = ".....\system.mdw".

Now these machines have Excel 95 installed ( which installs DAO 3.0) and
have DAO 3.5 installed which we need for our other VB exes. Upon reading
some article in VBPJ on ODBcDircet, I came across the following line which
says that "ODBC Direct cannot be used inside OLE Automation CLients like
Excel 95 etc unless VB 4.0 Enterprise edition is installed or licensed on
that machine" which is weird because our problem does go away if we install
and uninstall VB 5 enterprise edition on that machine!!!!!!!!!!!!!!

In the Tools , References menu Item in Excel  , I have tried checking "DAO
3.5 Object Library"  and "DAO 3.0 Object Library" on their own. With the
latter, it complains about types like Connections etc because ODBCDirect
was available from DAO 3.1 onwards.

Infact if I try to do Msgbox DBEngine.Version I get an error "Object
required" with the References pointing to "Dao 3.5"....If i try to create a
DbEng object using CreateObject("DAO.DbEngine.35"), i get some other error
"User defined type not known" or something like that....

Has anyone come across this...Is there any way around....

Any help will be greatly appreciated...btw we are doing all this on win
95/nt 4.0


Rajesh H

Fri, 16 Jun 2000 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Problems using ODBCDirect in Excel 95 VBA!!!

2. Access 95 and (Excel 97 and Excel 95)

3. Compatibility Problem Using MS Excel 97 VBA on Excel 2000/XP - Causes crashes

4. VBA for Excel and other Office '95 apps

5. VBA Excel 7.0 (Office 95) Sources.

6. Question on old version of VBA for Excel 95

7. Creating Class in VBA of Excel 95

8. Error-Handling in VBA Excel 95 (V7)

9. Creating Class in VBA of Excel 95

10. Stack Size and VBA (Excel 95)

11. VBA In MS Excel from Office 95.

12. VBA Excel 95 - dynamic memory management ?


Powered by phpBB® Forum Software