Openlink Universal Data Access

From: José Carlos Faial <faial(at)intelectum(dot)com(dot)br>
To: pgsql-interfaces(at)hub(dot)org
Subject: Openlink Universal Data Access
Date: 1999-09-03 14:41:22
Message-ID: 513C757322FBD11185A400C0DF46C270237F81@BOSS
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all,
Somebody is using Openlik Universal Data Access (multi-tier version) for
access a PostgreSQL database? I installed the Request broker, pgr95_sv
agent on my Linux Server and Generic Odbc driver in a machine running
windows 95.
So, here is the problem: when a test my connection the odbc driver (in
windows) results this error:
Connection Failled
SQLSTATE = "08004", NativeError = 0, ErrorMsg = "[OpenLink][ODBC]invalid
username/password"
SQLSTATE = "08004", NativeError = 0, ErrorMsg =
"[OpenLink][ODBC]Connection reject by data source"

In Request Broker Log:
05:48:11 10.0.0.34 called (10.0.0.34.1072)
05:48:11 request: domain=PostgreSQL database=faial serveropts=
05:48:11 connectopts=10.0.0.1 user=faial opsys=win32 readonly=0
05:48:11 application=ODBCCP32 processid=4294512091
05:48:11 solve mapping: pgr95:faial:faial:msdos:10.0.0.34:ODBCCP32:rw
05:48:11 using mapping: pgr95:*:*:*:*:*:*
05:48:11 using [generic_pgr95] ServerProgram=pgr95_sv
05:48:11 unsuccessful login attempt for faial
05:48:11 rejected faial(at)10(dot)0(dot)0(dot)34(dot)ODBCCP32 (invalid username/password)

The database name is faial, the username is faial (I can connect using
pgsql or by postODBC driver) and the password is testdb.

Somebody can help me??

In time: I configure the oplrqb.ini with a enviroment for this database,
like this:
[generic_pgr95]
Description = Default settings for Postgress 95 agent
Program = pgr95_sv
OpSysLogin = yes
ReUse = never
;CommandLine = -T
;ConnectOptions =
;Directory = /tmp
Database = faial
Userid = faial
Password = testdb
ReadOnly = No

Thanks.

________________________________________
Jose Carlos Faial - Network Manager
Registered Linux User #133319
E-mail: faial(at)intelectum(dot)com(dot)br

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.0.2 for non-commercial use <http://www.pgp.com>

iQA/AwUBN8/c8IuTSrQ9LukdEQJPgwCcDALMxX6FxszbeE79O7h9fAGhNJkAoITM
VTuy4jT+aQR9yURyUWEVeiKw
=vxzm
-----END PGP SIGNATURE-----

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Moray McConnachie 1999-09-03 15:12:05 Re: [INTERFACES] Openlink Universal Data Access
Previous Message Tom Lane 1999-09-03 14:40:51 Re: [INTERFACES] Win32 interface