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 > ODBC Version su...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 5 Topic 2293 of 2382
Post > Topic >>

ODBC Version supporting specif databases?

by bruce.mcalister@[EMAIL PROTECTED] (Bruce McAlister) Feb 22, 2008 at 04:22 PM

Hi All,

I am having connection issues with the 08.03.0100 version of the ODBC 
driver.

What happens is that when I attempt to connect to an 8.2.6 PostgreSQL 
database, using the 08.3.0100 ODBC driver then i get an error connecting 
during authentication as follows:

-------------------------------------------------------------------------
[28000][unixODBC]Communication error during authentication;
Error while reading from the socket.
[ISQL]ERROR: Could not SQLConnect
-------------------------------------------------------------------------

However, if I use the 08.01.0200 version to connect to the same DSN, I 
am able to successfully connect?

Is there a specific version of the ODBC driver that supports a specific 
version of the PostgreSQL database.

The way the above two ODBC drivers were built are as follows:

OS: Solaris 10 Update 3
ODBC Manager : unixODBC v1.2.12

I'm not too sure which version of the libpq library was used, but I know 
for certain that Solaris 10 Update 3 comes with a Sun built version of 
PostgreSQL 8.1, the one on the system I am trying to build on is version 
8.1.10.

Am I doing something wrong or are the versions of the odbc driver just 
not compatible with the versions of libpq that i am using to build with, 
and thus, unable to connect to the database, or, is it something 
completely different.

If you need any additional info, please dont hesitate to ask.

Thanks
Bruce
-- 
+-------------------------------------------------------+
| Bruce McAlister                          Blueface Ltd |
| <bruce.mcalister@[EMAIL PROTECTED]
>  http://www.blueface.ie
|
+-------------------------------------------------------+

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings




 5 Posts in Topic:
ODBC Version supporting specif databases?
bruce.mcalister@[EMAIL PR  2008-02-22 16:22:06 
Re: ODBC Version supporting specif databases?
bruce.mcalister@[EMAIL PR  2008-02-22 17:27:13 
Re: ODBC Version supporting specif databases?
bruce.mcalister@[EMAIL PR  2008-02-28 07:48:33 
Re: ODBC Version supporting specif databases?
luiz@[EMAIL PROTECTED] (  2008-02-28 17:50:03 
Re: ODBC Version supporting specif databases?
bruce.mcalister@[EMAIL PR  2008-02-28 22:59:01 

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:37:10 CDT 2008.