Postgres Pro
Downloads
Home   >   mailing lists

ODBC not connecting. - Mailing list pgsql-general

From Peter Cordone
Subject ODBC not connecting.
Date
Msg-id 35BF5E96.694C5AC9@ee.net
Whole thread Raw
List pgsql-general
Tree view 
I am running windows NT version 4.0 (I believe there are no service paks
applied, at least I didn't apply any).  I have installed the Postgres
ODBC driver.  I have Linux from Redhat ver 5.1 installed running
Postgres.  I edited the pg_hba.conf file and added my machine to the
host list.  When I set the database to all with no identification, I am
able to connect through the ODBC driver fine.  I changed the database to
test (there is a test database in postgres that I can connect to fine on
the Linux local machine) and change the authentication to ident
sameuser.  And then I can't connect.  I keep getting some vague error on
the win NT side about user authentication or database nonexistent.  What
am I doing wrong here?  I have attached the output from the ODBC log on
the windows NT side.  I haven't found where the postgres log is on the
Linux side (I am new to unix and postgres).

Your help is appreciated.

Attached ODBC log from windows NT side.  Look at the bottom of the log.
I think the top is some successfull connections before I changed the
ident.


bdeadmin        5e:41 ENTER SQLAllocEnv
  HENV *              0x00dcf8d0

bdeadmin        5e:41 EXIT  SQLAllocEnv  with return code 0
(SQL_SUCCESS)
  HENV *              0x00dcf8d0 ( 0x02872d68)

bdeadmin        5e:41 ENTER SQLDataSources
  HENV                0x02872d68
  UWORD                        2 <SQL_FETCH_FIRST>
  UCHAR *             0x0012f3d4
  SWORD                       33
  SWORD *             0x0012f3fa
  UCHAR *             0x0012f2d0
  SWORD                      257
  SWORD *             0x0012f3f8

bdeadmin        5e:41 ENTER SQLDataSourcesW
  HENV                0x02872d68
  UWORD                        2 <SQL_FETCH_FIRST>
  WCHAR *             0x02872df0
  SWORD                       66
  SWORD *             0x0012f3fa
  WCHAR *             0x02872e40
  SWORD                      514
  SWORD *             0x0012f3f8

bdeadmin        5e:41 EXIT  SQLDataSourcesW  with return code 0
(SQL_SUCCESS)
  HENV                0x02872d68
  UWORD                        2 <SQL_FETCH_FIRST>
  WCHAR *             0x02872df0 [      42] "MS Access 97 Database"
  SWORD                       66
  SWORD *             0x0012f3fa (42)
  WCHAR *             0x02872e40 [      62] "Microsoft Access Driver
(*.mdb)"
  SWORD                      514
  SWORD *             0x0012f3f8 (62)

bdeadmin        5e:41 EXIT  SQLDataSources  with return code 0
(SQL_SUCCESS)
  HENV                0x02872d68
  UWORD                        2 <SQL_FETCH_FIRST>
  UCHAR *             0x0012f3d4 [      21] "MS Access 97 Database"
  SWORD                       33
  SWORD *             0x0012f3fa (21)
  UCHAR *             0x0012f2d0 [      31] "Microsoft Access Driver
(*.mdb)"
  SWORD                      257
  SWORD *             0x0012f3f8 (31)

bdeadmin        5e:41 ENTER SQLDataSources
  HENV                0x02872d68
  UWORD                        1 <SQL_FETCH_NEXT>
  UCHAR *             0x0012f3d4
  SWORD                       33
  SWORD *             0x0012f3fa
  UCHAR *             0x0012f2d0
  SWORD                      257
  SWORD *             0x0012f3f8

bdeadmin        5e:41 ENTER SQLDataSourcesW
  HENV                0x02872d68
  UWORD                        1 <SQL_FETCH_NEXT>
  WCHAR *             0x02872df0
  SWORD                       66
  SWORD *             0x0012f3fa
  WCHAR *             0x02872e40
  SWORD                      514
  SWORD *             0x0012f3f8

bdeadmin        5e:41 EXIT  SQLDataSourcesW  with return code 0
(SQL_SUCCESS)
  HENV                0x02872d68
  UWORD                        1 <SQL_FETCH_NEXT>
  WCHAR *             0x02872df0 [      22] "dBASE Files"
  SWORD                       66
  SWORD *             0x0012f3fa (22)
  WCHAR *             0x02872e40 [      60] "Microsoft dBase Driver
(*.dbf)"
  SWORD                      514
  SWORD *             0x0012f3f8 (60)

bdeadmin        5e:41 EXIT  SQLDataSources  with return code 0
(SQL_SUCCESS)
  HENV                0x02872d68
  UWORD                        1 <SQL_FETCH_NEXT>
  UCHAR *             0x0012f3d4 [      11] "dBASE Files"
  SWORD                       33
  SWORD *             0x0012f3fa (11)
  UCHAR *             0x0012f2d0 [      30] "Microsoft dBase Driver
(*.dbf)"
  SWORD                      257
  SWORD *             0x0012f3f8 (30)

bdeadmin        5e:41 ENTER SQLDataSources
  HENV                0x02872d68
  UWORD                        1 <SQL_FETCH_NEXT>
  UCHAR *             0x0012f3d4
  SWORD                       33
  SWORD *             0x0012f3fa
  UCHAR *             0x0012f2d0
  SWORD                      257
  SWORD *             0x0012f3f8

bdeadmin        5e:41 ENTER SQLDataSourcesW
  HENV                0x02872d68
  UWORD                        1 <SQL_FETCH_NEXT>
  WCHAR *             0x02872df0
  SWORD                       66
  SWORD *             0x0012f3fa
  WCHAR *             0x02872e40
  SWORD                      514
  SWORD *             0x0012f3f8

bdeadmin        5e:41 EXIT  SQLDataSourcesW  with return code 0
(SQL_SUCCESS)
  HENV                0x02872d68
  UWORD                        1 <SQL_FETCH_NEXT>
  WCHAR *             0x02872df0 [      22] "Excel Files"
  SWORD                       66
  SWORD *             0x0012f3fa (22)
  WCHAR *             0x02872e40 [      60] "Microsoft Excel Driver
(*.xls)"
  SWORD                      514
  SWORD *             0x0012f3f8 (60)

bdeadmin        5e:41 EXIT  SQLDataSources  with return code 0
(SQL_SUCCESS)
  HENV                0x02872d68
  UWORD                        1 <SQL_FETCH_NEXT>
  UCHAR *             0x0012f3d4 [      11] "Excel Files"
  SWORD                       33
  SWORD *             0x0012f3fa (11)
  UCHAR *             0x0012f2d0 [      30] "Microsoft Excel Driver
(*.xls)"
  SWORD                      257
  SWORD *             0x0012f3f8 (30)

bdeadmin        5e:41 ENTER SQLDataSources
  HENV                0x02872d68
  UWORD                        1 <SQL_FETCH_NEXT>
  UCHAR *             0x0012f3d4
  SWORD                       33
  SWORD *             0x0012f3fa
  UCHAR *             0x0012f2d0
  SWORD                      257
  SWORD *             0x0012f3f8

bdeadmin        5e:41 ENTER SQLDataSourcesW
  HENV                0x02872d68
  UWORD                        1 <SQL_FETCH_NEXT>
  WCHAR *             0x02872df0
  SWORD                       66
  SWORD *             0x0012f3fa
  WCHAR *             0x02872e40
  SWORD                      514
  SWORD *             0x0012f3f8

bdeadmin        5e:41 EXIT  SQLDataSourcesW  with return code 0
(SQL_SUCCESS)
  HENV                0x02872d68
  UWORD                        1 <SQL_FETCH_NEXT>
  WCHAR *             0x02872df0 [      24] "FoxPro Files"
  SWORD                       66
  SWORD *             0x0012f3fa (24)
  WCHAR *             0x02872e40 [      62] "Microsoft FoxPro Driver
(*.dbf)"
  SWORD                      514
  SWORD *             0x0012f3f8 (62)

bdeadmin        5e:41 EXIT  SQLDataSources  with return code 0
(SQL_SUCCESS)
  HENV                0x02872d68
  UWORD                        1 <SQL_FETCH_NEXT>
  UCHAR *             0x0012f3d4 [      12] "FoxPro Files"
  SWORD                       33
  SWORD *             0x0012f3fa (12)
  UCHAR *             0x0012f2d0 [      31] "Microsoft FoxPro Driver
(*.dbf)"
  SWORD                      257
  SWORD *             0x0012f3f8 (31)

bdeadmin        5e:41 ENTER SQLDataSources
  HENV                0x02872d68
  UWORD                        1 <SQL_FETCH_NEXT>
  UCHAR *             0x0012f3d4
  SWORD                       33
  SWORD *             0x0012f3fa
  UCHAR *             0x0012f2d0
  SWORD                      257
  SWORD *             0x0012f3f8

bdeadmin        5e:41 ENTER SQLDataSourcesW
  HENV                0x02872d68
  UWORD                        1 <SQL_FETCH_NEXT>
  WCHAR *             0x02872df0
  SWORD                       66
  SWORD *             0x0012f3fa
  WCHAR *             0x02872e40
  SWORD                      514
  SWORD *             0x0012f3f8

bdeadmin        5e:41 EXIT  SQLDataSourcesW  with return code 0
(SQL_SUCCESS)
  HENV                0x02872d68
  UWORD                        1 <SQL_FETCH_NEXT>
  WCHAR *             0x02872df0 [      20] "Text Files"
  SWORD                       66
  SWORD *             0x0012f3fa (20)
  WCHAR *             0x02872e40 [      72] "Microsoft Text Driver
(*.txt; *.csv)"
  SWORD                      514
  SWORD *             0x0012f3f8 (72)

bdeadmin        5e:41 EXIT  SQLDataSources  with return code 0
(SQL_SUCCESS)
  HENV                0x02872d68
  UWORD                        1 <SQL_FETCH_NEXT>
  UCHAR *             0x0012f3d4 [      10] "Text Files"
  SWORD                       33
  SWORD *             0x0012f3fa (10)
  UCHAR *             0x0012f2d0 [      36] "Microsoft Text Driver
(*.txt; *.csv)"
  SWORD                      257
  SWORD *             0x0012f3f8 (36)

bdeadmin        5e:41 ENTER SQLDataSources
  HENV                0x02872d68
  UWORD                        1 <SQL_FETCH_NEXT>
  UCHAR *             0x0012f3d4
  SWORD                       33
  SWORD *             0x0012f3fa
  UCHAR *             0x0012f2d0
  SWORD                      257
  SWORD *             0x0012f3f8

bdeadmin        5e:41 ENTER SQLDataSourcesW
  HENV                0x02872d68
  UWORD                        1 <SQL_FETCH_NEXT>
  WCHAR *             0x02872df0
  SWORD                       66
  SWORD *             0x0012f3fa
  WCHAR *             0x02872e40
  SWORD                      514
  SWORD *             0x0012f3f8

bdeadmin        5e:41 EXIT  SQLDataSourcesW  with return code 0
(SQL_SUCCESS)
  HENV                0x02872d68
  UWORD                        1 <SQL_FETCH_NEXT>
  WCHAR *             0x02872df0 [       8] "Test"
  SWORD                       66
  SWORD *             0x0012f3fa (8)
  WCHAR *             0x02872e40 [      20] "PostgreSQL"
  SWORD                      514
  SWORD *             0x0012f3f8 (20)

bdeadmin        5e:41 EXIT  SQLDataSources  with return code 0
(SQL_SUCCESS)
  HENV                0x02872d68
  UWORD                        1 <SQL_FETCH_NEXT>
  UCHAR *             0x0012f3d4 [       4] "Test"
  SWORD                       33
  SWORD *             0x0012f3fa (4)
  UCHAR *             0x0012f2d0 [      10] "PostgreSQL"
  SWORD                      257
  SWORD *             0x0012f3f8 (10)

bdeadmin        5e:41 ENTER SQLAllocConnect
  HENV                0x02872d68
  HDBC *              0x00dcf81c

bdeadmin        5e:41 EXIT  SQLAllocConnect  with return code 0
(SQL_SUCCESS)
  HENV                0x02872d68
  HDBC *              0x00dcf81c ( 0x02872df0)

bdeadmin        5e:41 ENTER SQLDriverConnectW
  HDBC                0x02872df0
  HWND                0x00000000
  WCHAR *             0x02871c58 [      92]
"DATABASE=test;DSN=Test;UID=pcordone;PWD=peanut"
  SWORD                       92
  WCHAR *             0x02873260
  SWORD                     1000
  SWORD *             0x0012f1ce
  UWORD                        0 <SQL_DRIVER_NOPROMPT>

bdeadmin        5e:41 EXIT  SQLDriverConnectW  with return code -1
(SQL_ERROR)
  HDBC                0x02872df0
  HWND                0x00000000
  WCHAR *             0x02871c58 [      92]
"DATABASE=test;DSN=Test;UID=pcordone;PWD=peanut"
  SWORD                       92
  WCHAR *             0x02873260
  SWORD                     1000
  SWORD *             0x0012f1ce
  UWORD                        0 <SQL_DRIVER_NOPROMPT>

bdeadmin        5e:41 ENTER SQLError
  HENV                0x00000000
  HDBC                0x02872df0
  HSTMT               0x00000000
  UCHAR *             0x0012f3f4 (NYI)
   SDWORD *            0x0012f194
  UCHAR *             0x0012f1f0
  SWORD                      511
  SWORD *             0x0012f192

bdeadmin        5e:41 ENTER SQLErrorW
  HENV                0x00000000
  HDBC                0x02872df0
  HSTMT               0x00000000
  WCHAR *             0x0012ecf4 (NYI)
   SDWORD *            0x0012f194
  WCHAR *             0x0012ed00
  SWORD                     1022
  SWORD *             0x0012f192

bdeadmin        5e:41 EXIT  SQLErrorW  with return code 0 (SQL_SUCCESS)
  HENV                0x00000000
  HDBC                0x02872df0
  HSTMT               0x00000000
  WCHAR *             0x0012ecf4 (NYI)
   SDWORD *            0x0012f194 (5)
  WCHAR *             0x0012ed00 [     144] "The database does not exist
on the serveror user authentication failed."
  SWORD                     1022
  SWORD *             0x0012f192 (144)

bdeadmin        5e:41 EXIT  SQLError  with return code 0 (SQL_SUCCESS)
  HENV                0x00000000
  HDBC                0x02872df0
  HSTMT               0x00000000
  UCHAR *             0x0012f3f4 (NYI)
   SDWORD *            0x0012f194 (5)
  UCHAR *             0x0012f1f0 [      72] "The database does not exist
on the serveror user authentication failed."
  SWORD                      511
  SWORD *             0x0012f192 (72)

bdeadmin        5e:41 ENTER SQLError
  HENV                0x00000000
  HDBC                0x02872df0
  HSTMT               0x00000000
  UCHAR *             0x0012f3f4 (NYI)
   SDWORD *            0x0012f194
  UCHAR *             0x0012f1f0
  SWORD                      511
  SWORD *             0x0012f192

bdeadmin        5e:41 ENTER SQLErrorW
  HENV                0x00000000
  HDBC                0x02872df0
  HSTMT               0x00000000
  WCHAR *             0x0012ecf4 (NYI)
   SDWORD *            0x0012f194
  WCHAR *             0x0012ed00
  SWORD                     1022
  SWORD *             0x0012f192

bdeadmin        5e:41 EXIT  SQLErrorW  with return code 100
(SQL_NO_DATA_FOUND)
  HENV                0x00000000
  HDBC                0x02872df0
  HSTMT               0x00000000
  WCHAR *             0x0012ecf4 (NYI)
   SDWORD *            0x0012f194
  WCHAR *             0x0012ed00
  SWORD                     1022
  SWORD *             0x0012f192

bdeadmin        5e:41 EXIT  SQLError  with return code 100
(SQL_NO_DATA_FOUND)
  HENV                0x00000000
  HDBC                0x02872df0
  HSTMT               0x00000000
  UCHAR *             0x0012f3f4 (NYI)
   SDWORD *            0x0012f194
  UCHAR *             0x0012f1f0
  SWORD                      511
  SWORD *             0x0012f192

bdeadmin        5e:41 ENTER SQLFreeConnect
  HDBC                0x02872df0

bdeadmin        5e:41 EXIT  SQLFreeConnect  with return code 0
(SQL_SUCCESS)
  HDBC                0x02872df0

bdeadmin        5e:41 ENTER SQLFreeEnv
  HENV                0x02872d68

bdeadmin        5e:41 EXIT  SQLFreeEnv  with return code 0 (SQL_SUCCESS)

  HENV                0x02872d68

pgsql-general by date:

Previous
From: JohnDz
Date:
Subject: Re: [GENERAL] Mac Connectivity
Next
From: dave madden
Date:
Subject: Re: [GENERAL] Postgres vs commercial products