Re: Database connection problem on VB6.0

Jim Carlock wrote:
"Engada" pondered...
: 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 app 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?'

"Engada" posted...
: I'm using Microsot DAO 3.6 Object Library.
:
: Variable declaration:

Try changing those to:

Private autodrs_work As DAO.Workspace
Private autodrs_db As DAO.Database

I don't have a copy of Postgres installed. Are you limited to
Postgres?

One option might be to try getting an Access .mdb to link to
the Postgres through your ODBC connection. The ODBC
connection should be visible through the Link wizard. Just
right click inside the white window area in an Access file
and then click on Link tables...

If Access can create a link, then we know your ODBC is
configured properly and ready to go. This should provide
a little help here.

--
Jim Carlock
Post replies to the group.


.

Relevant Pages

  • Re: Database connection problem on VB6.0
    ... Private autodrs_work As DAO.Workspace ... I don't have a copy of Postgres installed. ... the Postgres through your ODBC connection. ... connection should be visible through the Link wizard. ...
    (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: ODBC conection
    ... It uses Postgres for it's database. ... I have never done ODBC before. ... that does not seem to have put the correct enires in /etc/odbcinst.ini. ... [SQLite] ...
    (Ubuntu)
  • Re: ODBC conection
    ... On Thursday 01 July 2010 14:53:09 stan wrote: ... It uses Postgres for it's database. ... I have never done ODBC before. ... My deeds are my dearest companions. ...
    (Ubuntu)
  • connect to postgres db via compact framework
    ... i'm using SqlLinkCe ... to connect via ODBC to a postgres db which is loacted on an other pc in ... postgres i'm using the one from postgres.org ... the odbc driver does not send them to the db.... ...
    (microsoft.public.dotnet.framework.compactframework)