Openlink Universal Data Access - Mailing list pgsql-interfaces

From José Carlos Faial
Subject Openlink Universal Data Access
Date
Msg-id 513C757322FBD11185A400C0DF46C270237F81@BOSS
Whole thread Raw
List 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@10.0.0.34.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@intelectum.com.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-----


pgsql-interfaces by date:

Previous
From: Stephen Wright
Date:
Subject: UNSUBSCRIBE sjw@sun.ac.za
Next
From: Tom Lane
Date:
Subject: Re: [INTERFACES] Win32 interface