I've writen an VB project that retreives data from database with SQL. The Connection to the database is created with this kind of statement:
Set zSample = DBEngine.Workspaces(0).OpenDatabase("", False, False, "ODBC;dsn=DB01")
This works perfectly when I run the project in my local workstation with VB. However when I create an exe about the project and run it in the database server, I get error message "Run-time error 429. ActiveX component can't creta object" or "Run-time error 3447. The Jet VBA file (VBAJET32.dll) filed to initialize when called.." (The dsn-string is correct.)
How should I define the database connection, write the sql and handle the data retreived that I can run the exe in my database server. Could anyone help me?