Problem connecting MS SQLServer & Postgresql using psqlODBC driver

------=_Part_21102_10424351.1141625734635
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hello,

I'm unable to connect from DTS designer (MS SQLServer2000/WindowsXP
Professional) to PostgreSQL (RHEL-4) using psqlODBC driver. I setup a DSN
successfully in the Windows machine. (but did not change any of the default
values of advanced options)

While creating a connection in DTS designer, the installed psqlODBC driver
is listed, and it pops up a window, where I typed in the ip address of the
linux box and the postgres username and password.

Would you please help me out? The details are as follows:

1) ODBC driver version - psqlodbc-08_01_0200 (downloaded from
http://www.postgresql.org/ftp/odbc/versions/msi/)

2) PostgreSQL database version - 7.4.6-1 (this is the rpm name - running on
RHEL-4)

3) Error message -

"Package error :
HResult of 0x80004005 (-2147467259) returned
Unexpected error occured. An error result was returned without an error
message."

4-a) Error log file (mylog_1532.log) -

" [3428]globals.extra_systable_prefixes =3D 'dd_;'
[3428]aszKey=3D'DSN', value=3D'PostgreSQL'
[3428]copyAttributes:
DSN=3D'PostgreSQL',server=3D'',dbase=3D'',user=3D'',passwd=3 D'xxxxx',port=
=3D'',onlyread=3D'',protocol=3D'',conn_settings=3D'',disallo w_premature=3D-=
1)

[3428]globals.extra_systable_prefixes =3D 'dd_;' "

4-b) Error log file (psqlodbc_1544.log) -
The following error appears many times in the log file:

" func=3DPGAPI_DriverConnect, desc=3D'Error from CC_Connect', errnum=3D101,
errmsg=3D'Could not connect to the server' "

I guess, each one corresponds to each of my (unsuccessful) connection
attempts?

Thanks in advance.
Ram Mohan

------=_Part_21102_10424351.1141625734635
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Re: Problem connecting MS SQLServer & Postgresql using psqlODBC driver

Ram,

Are the machines on a local LAN together? Or, might there be some sort of f=
irewall between them.

Also, did you modify your pg_hba.conf file (in postgres /data/ directory) t=
o allow access to your server from outside of the localhost.

http://www.postgresql.org/docs/7.4/static/client-authenticat ion.html#AUTH-P=
G-HBA-CONF might prove useful.

Regards,

Daniel Holm

________________________________________
From: pgsql-odbc-owner@postgresql.org [mailto:pgsql-odbc-owner@postgresql.o=
rg] On Behalf Of Ram R.K. Mohan
Sent: Monday, March 06, 2006 12:16 AM
To: pgsql-odbc@postgresql.org
Subject: [ODBC] Problem connecting MS SQLServer & Postgresql using psqlODBC=
driver

Hello,
=A0
I'm unable=A0to connect from=A0DTS=A0designer=A0(MS SQLServer2000/WindowsXP=
Professional) to PostgreSQL (RHEL-4) using psqlODBC driver. I=A0setup a DS=
N successfully in the Windows machine. (but did not change any of the defau=
lt values of advanced options)=20
=A0
While creating a connection in DTS designer, the installed psqlODBC driver =
is listed, and it=A0pops up a window, where I=A0typed in=A0the ip address o=
f the linux box and the postgres username and password.
=A0
Would you please help me out? The details are as follows:
=A0
1) ODBC driver version - psqlodbc-08_01_0200 (downloaded from http://www.po=
stgresql.org/ftp/odbc/versions/msi/ )
=A0
2) PostgreSQL database version - 7.4.6-1 (this is=A0the rpm name - running =
on RHEL-4)
=A0
3) Error message -
=A0
"Package error :
HResult of 0x80004005 (-2147467259) returned
Unexpected error occured. An error result was returned without an error mes=
sage."=20
=A0
4-a) Error log file (mylog_1532.log) -
=A0
" [3428]globals.extra_systable_prefixes =3D 'dd_;'
[3428]aszKey=3D'DSN', value=3D'PostgreSQL'
[3428]copyAttributes: DSN=3D'PostgreSQL',server=3D'',dbase=3D'',user=3D'',p=
asswd=3D'xxxxx',port=3D'',onlyread=3D'',protocol=3D'',conn_s ettings=3D'',di=
sallow_premature=3D-1)=20
[3428]globals.extra_systable_prefixes =3D 'dd_;' "
=A0
4-b) Error log file (psqlodbc_1544.log) -=20
The following error appears many times in the log file:
=A0
" func=3DPGAPI_DriverConnect, desc=3D'Error from CC_Connect', errnum=3D101,=
errmsg=3D'Could not connect to the server' "=20
=A0
I guess, each one corresponds to each of my (unsuccessful) connection attem=
pts?=A0
=A0
Thanks in advance.
Ram Mohan
=A0

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org