Database connection problem on VB6.0

I have an application written in VB6.0 which has previously been interfacing with MS SQL server 2000, which I have moved to Postgres 8.2.3.

When attempting to create an ODBC workspace, the application now errors on the following line of code:

Set autodrs_work = CreateWorkspace("autodrs", g_strUserName, g_strPWD, dbUseODBC)

Where g_str* variables are globals holding the username and password for connecting to the db.

The following is the resulting error:
3633 Cannot load DLL: '?????L?'

In all documentation I can find, error 3633 is an error loading MS Jet files, which I don't understand since I am using ODBC which should be bypassing the Jet engine (at least according to the VB documentation it does) and secondly neither this line of code nor any around it has changed since I moved the db from sql server to Postgres. As a side note, MS Jet 4.0 is installed on the machine, and both msjet35.dll and msjet40.dll are registered on the server.

Can anyone offer some pointers on what the problem might be?

Thanks in advance,
Paul.

--
Paul Lambert
Database Administrator
AutoLedgers

--
Posted via a free Usenet account from http://www.teranews.com

.

Relevant Pages

  • Re: OT Re: Databases - DAO and ADO
    ... Around the Ado recordset is still pretty much documentation, ... Have a look at this one to and use SQL Server Express like the Jet ... database file ...
    (microsoft.public.vb.general.discussion)
  • OT Re: Databases - DAO and ADO
    ... the documentation on Internet is poor. ... Have a look at this one to and use SQL Server Express like the Jet ... database file ... VB6 cannot only be used with plain text files or Jet, SQL fits very well to it, something I wrote already in this thread. ...
    (microsoft.public.vb.general.discussion)
  • Re: Database connection problem on VB6.0
    ... I have nothing major against SQL Server, this was purely a financial decision. ... Postgres appears to me to be the most functional, stable, robust etc rdbms out there - right up there with oracle and sql server in those areas. ... the Postgres through your ODBC connection. ... connection should be visible through the Link wizard. ...
    (microsoft.public.vb.general.discussion)
  • Re: clobs and blobs
    ... In my experience (SQL Server, mysql, postgres) you build a string ...
    (comp.lang.java.databases)
  • Re: Reading million records
    ... There is really no comparison between foxpro and a SQL server. ... Execute a SELECT statement on both platforms and your results will be much different (Postgres will kill foxpro). ... Most SQL servers consume a great deal of memory to obtain optimal performance, that is where you should start. ...
    (borland.public.delphi.non-technical)
Loading