Обсуждение: ODBC /w 7.0.2
Has anyone got odbc on windows ODBC driver to connect to their database running on freeBSD or linux? I keep getting an error Invalid password even though I know I'm putting the correct password in the System DNS resourse and in pgadmin. When I look at the ODBC driver it says it can only connect using 6.5/6.4 protocal. Does that meen I cann't connect to my 7.0.2 db? Chad Skeeters
On Sun, 12 Nov 2000, Chad Skeeters wrote: > Has anyone got odbc on windows ODBC driver to connect to their database > running on freeBSD or linux? I keep getting an error Invalid password even > though I know I'm putting the correct password in the System DNS resourse > and in pgadmin. When I look at the ODBC driver it says it can only connect > using 6.5/6.4 protocal. Does that meen I cann't connect to my 7.0.2 db? The protocol did not change significantly or at all in 7.0.x. The ODBC drive works fine. However, you must configure the database to all remote connections from your client. > Chad Skeeters Tom
That´s true. In Linux MAndrake or Redhat check the pg_hba.conf file to allow connections outside the localhost. it is located at /var/lib/pgsql/data ----- Original Message ----- From: Tom Samplonius <tom@sdf.com> To: Chad Skeeters <goobsoft@goobsoft.com> Cc: <pgsql-interfaces@postgresql.org> Sent: Sunday, November 12, 2000 7:01 PM Subject: Re: [INTERFACES] ODBC /w 7.0.2 > > On Sun, 12 Nov 2000, Chad Skeeters wrote: > > > Has anyone got odbc on windows ODBC driver to connect to their database > > running on freeBSD or linux? I keep getting an error Invalid password even > > though I know I'm putting the correct password in the System DNS resourse > > and in pgadmin. When I look at the ODBC driver it says it can only connect > > using 6.5/6.4 protocal. Does that meen I cann't connect to my 7.0.2 db? > > The protocol did not change significantly or at all in 7.0.x. The ODBC > drive works fine. However, you must configure the database to all remote > connections from your client. > > > Chad Skeeters > > Tom >