Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Interfaces Odbc > Driver 8.1 : fa...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 2282 of 2382
Post > Topic >>

Driver 8.1 : fails contacting the server with routable address

by guillaume.gautreau@[EMAIL PROTECTED] (Guillaume Gautreau) Jan 21, 2008 at 10:29 AM

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enig33B59D5899DBC964322AE0D6
Content-Type: multipart/alternative;
 boundary="------------080309090705040107040704"

This is a multi-part message in MIME format.
--------------080309090705040107040704
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,

I'd like to use the postgresql driver in Access, in order to query a
postgresql server in my company. I'm linking tables inside Access with
the driver, and all the setup works fine.
But there is a very strange issue when closing the file and re-opening it=
=2E
When I do all this stuff on my client and a test server *all works
great*. My server have the address *192.168.*.**. I don't want Access to
remember the password. When I open the file and click on a table, the
driver window pops up and I have to type it.
When I try to do the same with the production server (with *a routable
address*) I get an issue. The driver pop up does not appear and it seems
to try to contact the server with the good login, but the password can't
be the good one. And then, it sends an error.
Then, I do the exact same thing from another client, but querying my
testing server. The IP address used is then routable (my test server is
a virtual one, using NAT). I query the exact same server from another
location. And I experienced the exact same error.
No problem for linking the tables, but when I close then reopen Access,
it seems to try to directly contact the server without asking me the
password. And then, it fails.

I tried the previous driver version (7.*), all works fine. But I just
can not use it because i need the SSL support (and this version seems
not to support it).

Did you experienced the same issue ? Could you give me more precisions ?
Could you help me ?

Thanks

--=20
Guillaume Gautreau
Responsable projets SI
        Bureau P-417
        Tel : +33 (0)1.64.15.33.22
        Ecole des ponts
        6 et 8 avenue Blaise Pascal - Cit=E9 Descartes
        Champs-sur-Marne - 77455 Marne la Vall=E9e cedex 2

Ce message a =E9t=E9 sign=E9 num=E9riquement avec GnuPG.


--------------080309090705040107040704
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor=3D"#ffffff" text=3D"#000000">
Hi,<br>
<br>
I'd like to use the postgresql driver in Access, in order to query a
postgresql server in my company. I'm linking tables inside Access with
the driver, and all the setup works fine.<br>
But there is a very strange issue when closing the file and re-opening
it.<br>
When I do all this stuff on my client and a test server <b>all works
great</b>. My server have the address <b>192.168.*.*</b>. I don't want
Access to remember the password. When I open the file and click on a
table, the driver window pops up and I have to type it.<br>
When I try to do the same with the production server (with <b>a
routable address</b>) I get an issue. The driver pop up does not appear
and it seems to try to contact the server with the good login, but the
password can't be the good one. And then, it sends an error.<br>
Then, I do the exact same thing from another client, but querying my
testing server. The IP address used is then routable (my test server is
a virtual one, using NAT). I query the exact same server from another
location. And I experienced the exact same error.<br>
No problem for linking the tables, but when I close then reopen Access,
it seems to try to directly contact the server without asking me the
password. And then, it fails.<br>
<br>
I tried the previous driver version (7.*), all works fine. But I just
can not use it because i need the SSL support (and this version seems
not to support it).<br>
<br>
Did you experienced the same issue ? Could you give me more precisions ?<=
br>
Could you help me ?<br>
<br>
Thanks<br>
<pre class=3D"moz-signature" cols=3D"72">--=20
Guillaume Gautreau
Responsable projets SI
        Bureau P-417
        Tel : +33 (0)1.64.15.33.22
        Ecole des ponts
        6 et 8 avenue Blaise Pascal - Cit&eacute; Descartes
        Champs-sur-Marne - 77455 Marne la Vall&eacute;e cedex 2

Ce message a &eacute;t&eacute; sign&eacute; num&eacute;riquement avec Gnu=
PG.</pre>
</body>
</html>

--------------080309090705040107040704--

--------------enig33B59D5899DBC964322AE0D6
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFHlGYVIlsZTXEg2iwRAv2oAJ9uPWAt25eWAGgQHScppfpSLa+MlQCfXQ3y
dmmumBtf9p1llfWZgU4bzZM=
=Giwg
-----END PGP SIGNATURE-----

--------------enig33B59D5899DBC964322AE0D6--




 4 Posts in Topic:
Driver 8.1 : fails contacting the server with routable address
guillaume.gautreau@[EMAIL  2008-01-21 10:29:55 
Re: Driver 8.1 : fails contacting the server with routable
guillaume.gautreau@[EMAIL  2008-01-21 14:33:53 
Re: Driver 8.1 : fails contacting the server with routable addre
usenet@[EMAIL PROTECTED]   2008-01-21 15:01:14 
Re: Driver 8.1 : fails contacting the server with routable
guillaume.gautreau@[EMAIL  2008-01-22 10:43:08 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Fri Jul 4 9:29:54 CDT 2008.