Re: Database connection problem on VB6.0

Jim Carlock wrote:
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'll give that a shot when I get into work this morning, thanks - will let you know how it goes.


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

Technically no, but upon evaluating our customers needs vs what they want to spend on additional licensing on top of paying for our software, I decided to move to a free rdbms. 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.


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...

I've done this and it does work fine.


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.



Thanks,
Paul.

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

.

Relevant Pages

  • Re: Strange Problems with ODBC connection to SQL Server
    ... When accessing Jet data, use DAO. ... This way you are not exposing connection information in clear ... >accesses an SQL Server 2000 repository via ODBC data source. ...
    (microsoft.public.data.odbc)
  • Re: Access and processor usage
    ... and you are using an ODBC connection, that would be your bottle neck. ... bottleneck - need to step up to Sql Server. ...
    (comp.databases.ms-access)
  • RE: [ODBC SQL Server Driver][Shared Memory]ConnectionWrite (send()) er
    ... I understand that you encountered the ODBC error message on your ecommerce ... TCP/IP protocol to your SQL Server instance by calling conn.Open, ... SQL Server instance and see if there is a connection reset when this issue ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.connect)
  • RE: [ODBC SQL Server Driver][Shared Memory]ConnectionWrite (send()
    ... remote connection. ... should I just check named pipes only or both TCP/IP and ... I understand that you encountered the ODBC error message on your ecommerce ... TCP/IP protocol to your SQL Server instance by calling conn.Open, ...
    (microsoft.public.sqlserver.connect)
  • Re: Using SQL Server Express on Shared PC
    ... you don't need to install SSMS or VS on the client system. ... using ODBC you're making the job of getting connected more difficult. ... ODBC requires either a REGISTERED DSN, a file-based DSN or a "DSN-less" connection. ... You also need to configure the Network-shared SQL Server service to permit access by whatever credentials you have chosen. ...
    (microsoft.public.sqlserver.connect)