Re: Database connection problem on VB6.0
- From: "Jim Carlock" <anonymous@localhost>
- Date: Mon, 26 Feb 2007 09:10:44 -0500
Jim Carlock wrote:
: 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, _
: 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?'
: 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
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.
Post replies to the group.
- Prev by Date: Re: VB6 program runs with Win Vista ?
- Next by Date: Re: Shell on Vista
- Previous by thread: Re: Database connection problem on VB6.0
- Next by thread: Re: Database connection problem on VB6.0