Thread: Problem with VPN
Hi list,
We have here a system that uses Postgresql via odbc and it works well. The problem is when we try to connect the database via odbc with VPN (virtual privat network).
We are using Delphi and the message is: "Key violation".
Does anybody had the same experience with VPNs ?
Any suggestion is quite important to us.
ps: we are using Postgresql 8.1 and the proper msi odbc driver.
Regards ...
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Atenciosamente (Sincerely)
Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/
Hi, Actually We're working with Delphi 6.0 + openvpn + postgresql 8.1.1 with out any problem.... It works very fine ... We're using a very old psqlODBC version -07.03.0100- but It works ... And Rigth now with a friend we're looking for a connection problem creating CursorAdapters with VisualFoxpro+psqlODBC+Postgres 8.1.1 and if we try to connect with the lastest version of the psqlODBC driver It generates the following error 'unexpected protocol character during authentication; error while reading from the socket' BUT if we use the 07.03.0100 version of the psqlODBC IT WORKS FINE... I hope this coulld be helpfull... regards, Alvaro Arcila PD: Sorry for my poor english >From: "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com> >To: pgsql-odbc@postgresql.org >Subject: [ODBC] Problem with VPN >Date: Fri, 25 Aug 2006 10:06:22 -0300 > >Hi list, > >We have here a system that uses Postgresql via odbc and it works well. The >problem is when we try to connect the database via odbc with VPN (virtual >privat network). > >We are using Delphi and the message is: "Key violation". > >Does anybody had the same experience with VPNs ? > >Any suggestion is quite important to us. > > >ps: we are using Postgresql 8.1 and the proper msi odbc driver. > >Regards ... > >=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > Atenciosamente (Sincerely) > Ezequias Rodrigues da Rocha >=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- >A pior das democracias ainda é melhor do que a melhor das ditaduras >The worst of democracies is still better than the better of dictatorships >http://ezequiasrocha.blogspot.com/
ALVARO ARCILA wrote: > > Hi, > > Actually We're working with Delphi 6.0 + openvpn + postgresql 8.1.1 with > out any problem.... It works very fine ... We're using a very old > psqlODBC version -07.03.0100- but It works ... > > And Rigth now with a friend we're looking for a connection problem > creating CursorAdapters with VisualFoxpro+psqlODBC+Postgres 8.1.1 and if > we try to connect with the lastest version of the psqlODBC driver It Which version of driver are you using ? If you are using 8.2.0002 please try the snapshot at http://www.geocities.jp/inocchichichi/psqlodbc/index.html . You can simply replace the dll psqlodbc35w.dll without un/reregistration if you installed 8.2.0002 version. regards, Hiroshi Inoue > generates the following error > > 'unexpected protocol character during authentication; error while > reading from the socket' > > BUT if we use the 07.03.0100 version of the psqlODBC IT WORKS FINE... > > I hope this coulld be helpfull... > > regards, > > Alvaro Arcila > > PD: Sorry for my poor english > > >> From: "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com> >> To: pgsql-odbc@postgresql.org >> Subject: [ODBC] Problem with VPN >> Date: Fri, 25 Aug 2006 10:06:22 -0300 >> >> Hi list, >> >> We have here a system that uses Postgresql via odbc and it works well. >> The >> problem is when we try to connect the database via odbc with VPN (virtual >> privat network). >> >> We are using Delphi and the message is: "Key violation". >> >> Does anybody had the same experience with VPNs ? >> >> Any suggestion is quite important to us. >> >> >> ps: we are using Postgresql 8.1 and the proper msi odbc driver. >> >> Regards ... >> >> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- >> Atenciosamente (Sincerely) >> Ezequias Rodrigues da Rocha >> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- >> A pior das democracias ainda é melhor do que a melhor das ditaduras >> The worst of democracies is still better than the better of dictatorships >> http://ezequiasrocha.blogspot.com/ > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > >