Database connection in server without VB


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?
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!