Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] ODBC - MSysConf

From: Karsten Kaus <kk(at)kdschmid(dot)de>
To: David Hartwig <daveh(at)insightdist(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [INTERFACES] ODBC - MSysConf
Date: 1999-02-12 19:44:40
Message-ID: 36C484A8.1675@kdschmid.de (view raw or flat)
Thread:
Lists: pgsql-interfaces
David Hartwig wrote:
> 
> Karsten Kaus wrote:
> 
> > ok, in general it seems to be possible to connect Access97 ( not Access
> > 2.0! ?right?  ) to postgres.
> 
> I recall someone doing this successfully.  The key here is that it needs to
> be running on Win95, Win98, or NT.
> 
as far as I understood, the PostgreSQL driver is a 32-Bit program, so it
does
not show up when I'm using Access 2.0 to link tables, pity, but I can
live with that,
even it will cost money again.
> >
> > It works on ONE of my Computers in the office (486). On that computer
> > I cannot start the 32Bit-ODBC in the systemconfiguration, but I can
...
> > error 4307, that there is a Table called MSysConf on my server but
> > it does not have the expected format.
> 
> You do not need this table on the server.  The driver will report it as an
> error in the log file, but it should not be a problem to the application.
> 
I read that before, but the case is slightly different. The table does
not exist.
I created the table at home, not here in the office. I just veryfied
dropping the table and got the message it woldn't exist.
Now access should notice that the table is missing, but it states the
table would
be there having a wrong format.

> Activate the CommLog in the driver settings and send a copy of the errant
> session.  Its located in C:\psqlodbc*.log.
I did that in the driversetup. but it didn't log to C:\psqlodbc*.log
(I've seen and read them before, but now they are not created any more).
The log is in c:\sql.log. This file is also mentioned in the driver
setup.
So I think it's ok. The info contained looks a little different than in
the
psql*-files, but as fas as I see - the same info is contained:
--------------Here comes c:\sql.log ---------------------

MSACCESS        fff27265:fff26281	ENTER SQLAllocConnect 
		HENV                0x00b30204
		HDBC *              0x0062c910

MSACCESS        fff27265:fff26281	EXIT  SQLAllocConnect  with return
code 0 (SQL_SUCCESS)
		HENV                0x00b30204
		HDBC *              0x0062c910 ( 0x00b31668)

MSACCESS        fff27265:fff26281	ENTER SQLSetConnectOption 
		HDBC                0x00b31668
		UWORD                      103 
		UDWORD                    20

MSACCESS        fff27265:fff26281	EXIT  SQLSetConnectOption  with return
code 0 (SQL_SUCCESS)
		HDBC                0x00b31668
		UWORD                      103 
		UDWORD                    20

MSACCESS        fff27265:fff26281	ENTER SQLDriverConnectW 
		HDBC                0x00b31668
		HWND                0x000002b8
		WCHAR *             0x00b30560 [      -3] ""
		SWORD                       -3 
		WCHAR *             0x00b31734 
		SWORD                      510 
		SWORD *             0x0062c966
		UWORD                        1 <SQL_DRIVER_COMPLETE>

MSACCESS        fff27265:fff26281	EXIT  SQLDriverConnectW  with return
code 0 (SQL_SUCCESS)
		HDBC                0x00b31668
		HWND                0x000002b8
		WCHAR *             0x00b30560 [      -3] ""
		SWORD                       -3 
		WCHAR *             0x00b31734 [     362]
"DSN=PostgreSQL;DATABASE=faxlog;SERVER=192.168.0.3;PORT=5432;UID=kk;PWD=<censored>;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS="
		SWORD                      510 
		SWORD *             0x0062c966 (362)
		UWORD                        1 <SQL_DRIVER_COMPLETE>

MSACCESS        fff27265:fff26281	ENTER SQLGetInfo 
		HDBC                0x00b31668
		UWORD                        9 <SQL_ODBC_API_CONFORMANCE>
		PTR                      51478 
		SWORD                        2 
		SWORD *             0x0062c90e

MSACCESS        fff27265:fff26281	ENTER SQLGetInfoW 
		HDBC                0x00b31668
		UWORD                        9 <SQL_ODBC_API_CONFORMANCE>
		PTR                      51478 
		SWORD                        2 
		SWORD *             0x0062c90e

MSACCESS        fff27265:fff26281	EXIT  SQLGetInfoW  with return code 0
(SQL_SUCCESS)
		HDBC                0x00b31668
		UWORD                        9 <SQL_ODBC_API_CONFORMANCE>
		PTR                      51478 
		SWORD                        2 
		SWORD *             0x0062c90e (2)

MSACCESS        fff27265:fff26281	EXIT  SQLGetInfo  with return code 0
(SQL_SUCCESS)
		HDBC                0x00b31668
		UWORD                        9 <SQL_ODBC_API_CONFORMANCE>
		PTR                      51478 
		SWORD                        2 
		SWORD *             0x0062c90e (2)

MSACCESS        fff27265:fff26281	ENTER SQLGetInfo 
		HDBC                0x00b31668
		UWORD                        6 <SQL_DRIVER_NAME>
		PTR                 0x0062c8ac 
		SWORD                      100 
		SWORD *             0x0062c916

MSACCESS        fff27265:fff26281	ENTER SQLGetInfoW 
		HDBC                0x00b31668
		UWORD                        6 <SQL_DRIVER_NAME>
		PTR                 0x00b31838 
		SWORD                      200 
		SWORD *             0x0062c916

MSACCESS        fff27265:fff26281	EXIT  SQLGetInfoW  with return code 0
(SQL_SUCCESS)
		HDBC                0x00b31668
		UWORD                        6 <SQL_DRIVER_NAME>
		PTR                 0x00b31838 [      24] "PSQLODBC.DLL"
		SWORD                      200 
		SWORD *             0x0062c916 (24)

MSACCESS        fff27265:fff26281	EXIT  SQLGetInfo  with return code 0
(SQL_SUCCESS)
		HDBC                0x00b31668
		UWORD                        6 <SQL_DRIVER_NAME>
		PTR                 0x0062c8ac [      12] "PSQLODBC.DLL"
		SWORD                      100 
		SWORD *             0x0062c916 (12)

MSACCESS        fff27265:fff26281	ENTER SQLGetInfo 
		HDBC                0x00b31668
		UWORD                       46 <SQL_TXN_CAPABLE>
		PTR                      51328 
		SWORD                        2 
		SWORD *             0x0062c742

MSACCESS        fff27265:fff26281	ENTER SQLGetInfoW 
		HDBC                0x00b31668
		UWORD                       46 <SQL_TXN_CAPABLE>
		PTR                      51328 
		SWORD                        2 
		SWORD *             0x0062c742

MSACCESS        fff27265:fff26281	EXIT  SQLGetInfoW  with return code 0
(SQL_SUCCESS)
		HDBC                0x00b31668
		UWORD                       46 <SQL_TXN_CAPABLE>
		PTR                      51328 
		SWORD                        2 
		SWORD *             0x0062c742 (2)

MSACCESS        fff27265:fff26281	EXIT  SQLGetInfo  with return code 0
(SQL_SUCCESS)
		HDBC                0x00b31668
		UWORD                       46 <SQL_TXN_CAPABLE>
		PTR                      51328 
		SWORD                        2 
		SWORD *             0x0062c742 (2)

MSACCESS        fff27265:fff26281	ENTER SQLGetInfo 
		HDBC                0x00b31668
		UWORD                       23 <SQL_CURSOR_COMMIT_BEHAVIOR>
		PTR                      27128 
		SWORD                        2 
		SWORD *             0x0062c742

MSACCESS        fff27265:fff26281	ENTER SQLGetInfoW 
		HDBC                0x00b31668
		UWORD                       23 <SQL_CURSOR_COMMIT_BEHAVIOR>
		PTR                      27128 
		SWORD                        2 
		SWORD *             0x0062c742

MSACCESS        fff27265:fff26281	EXIT  SQLGetInfoW  with return code 0
(SQL_SUCCESS)
		HDBC                0x00b31668
		UWORD                       23 <SQL_CURSOR_COMMIT_BEHAVIOR>
		PTR                      27128 
		SWORD                        2 
		SWORD *             0x0062c742 (2)

MSACCESS        fff27265:fff26281	EXIT  SQLGetInfo  with return code 0
(SQL_SUCCESS)
		HDBC                0x00b31668
		UWORD                       23 <SQL_CURSOR_COMMIT_BEHAVIOR>
		PTR                      27128 
		SWORD                        2 
		SWORD *             0x0062c742 (2)

MSACCESS        fff27265:fff26281	ENTER SQLGetInfo 
		HDBC                0x00b31668
		UWORD                       24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
		PTR                      27130 
		SWORD                        2 
		SWORD *             0x0062c742

MSACCESS        fff27265:fff26281	ENTER SQLGetInfoW 
		HDBC                0x00b31668
		UWORD                       24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
		PTR                      27130 
		SWORD                        2 
		SWORD *             0x0062c742

MSACCESS        fff27265:fff26281	EXIT  SQLGetInfoW  with return code 0
(SQL_SUCCESS)
		HDBC                0x00b31668
		UWORD                       24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
		PTR                      27130 
		SWORD                        2 
		SWORD *             0x0062c742 (2)

MSACCESS        fff27265:fff26281	EXIT  SQLGetInfo  with return code 0
(SQL_SUCCESS)
		HDBC                0x00b31668
		UWORD                       24 <SQL_CURSOR_ROLLBACK_BEHAVIOR>
		PTR                      27130 
		SWORD                        2 
		SWORD *             0x0062c742 (2)

MSACCESS        fff27265:fff26281	ENTER SQLGetInfo 
		HDBC                0x00b31668
		UWORD                        1 <SQL_ACTIVE_STATEMENTS>
		PTR                      51332 
		SWORD                        2 
		SWORD *             0x0062c87e

MSACCESS        fff27265:fff26281	ENTER SQLGetInfoW 
		HDBC                0x00b31668
		UWORD                        1 <SQL_ACTIVE_STATEMENTS>
		PTR                      51332 
		SWORD                        2 
		SWORD *             0x0062c87e

MSACCESS        fff27265:fff26281	EXIT  SQLGetInfoW  with return code 0
(SQL_SUCCESS)
		HDBC                0x00b31668
		UWORD                        1 <SQL_ACTIVE_STATEMENTS>
		PTR                      51332 
		SWORD                        2 
		SWORD *             0x0062c87e (2)

MSACCESS        fff27265:fff26281	EXIT  SQLGetInfo  with return code 0
(SQL_SUCCESS)
		HDBC                0x00b31668
		UWORD                        1 <SQL_ACTIVE_STATEMENTS>
		PTR                      51332 
		SWORD                        2 
		SWORD *             0x0062c87e (2)

MSACCESS        fff27265:fff26281	ENTER SQLSetConnectOption 
		HDBC                0x00b31668
		UWORD                      101 
		UDWORD                     0

MSACCESS        fff27265:fff26281	EXIT  SQLSetConnectOption  with return
code 0 (SQL_SUCCESS)
		HDBC                0x00b31668
		UWORD                      101 
		UDWORD                     0

MSACCESS        fff27265:fff26281	ENTER SQLAllocStmt 
		HDBC                0x00b31668
		HSTMT *             0x0062c744

MSACCESS        fff27265:fff26281	EXIT  SQLAllocStmt  with return code 0
(SQL_SUCCESS)
		HDBC                0x00b31668
		HSTMT *             0x0062c744 ( 0x00b31870)

MSACCESS        fff27265:fff26281	ENTER SQLGetStmtOption 
		HSTMT               0x00b31870
		UWORD                        0 
		PTR                0x0062c6e8

MSACCESS        fff27265:fff26281	EXIT  SQLGetStmtOption  with return
code 0 (SQL_SUCCESS)
		HSTMT               0x00b31870
		UWORD                        0 
		PTR                0x0062c6e8

MSACCESS        fff27265:fff26281	ENTER SQLSetStmtOption 
		HSTMT               0x00b31870
		UWORD                        0 
		UDWORD                    60

MSACCESS        fff27265:fff26281	EXIT  SQLSetStmtOption  with return
code 0 (SQL_SUCCESS)
		HSTMT               0x00b31870
		UWORD                        0 
		UDWORD                    60

MSACCESS        fff27265:fff26281	ENTER SQLExecDirect 
		HSTMT               0x00b31870
		UCHAR *             0x040ce9a0 [      -3] "SELECT Config, nValue FROM
MSysConf"
		SDWORD                    -3

MSACCESS        fff27265:fff26281	EXIT  SQLExecDirect  with return code
0 (SQL_SUCCESS)
		HSTMT               0x00b31870
		UCHAR *             0x040ce9a0 [      -3] "SELECT Config, nValue FROM
MSysConf"
		SDWORD                    -3

MSACCESS        fff27265:fff26281	ENTER SQLFetch 
		HSTMT               0x00b31870

MSACCESS        fff27265:fff26281	EXIT  SQLFetch  with return code -1
(SQL_ERROR)
		HSTMT               0x00b31870

MSACCESS        fff27265:fff26281	ENTER SQLError 
		HENV                0x00b30204
		HDBC                0x00b31668
		HSTMT               0x00b31870
		UCHAR *             0x0062c6ac (NYI) 
 		SDWORD *            0x0062c6c8
		UCHAR *             0x0089a9cc 
		SWORD                     8192 
		SWORD *             0x0062c6de

MSACCESS        fff27265:fff26281	ENTER SQLErrorW 
		HENV                0x00b30204
		HDBC                0x00b31668
		HSTMT               0x00b31870
		WCHAR *             0x0062c25c (NYI) 
 		SDWORD *            0x0062c6c8
		WCHAR *             0x0062c268 
		SWORD                     1024 
		SWORD *             0x0062c6de

MSACCESS        fff27265:fff26281	EXIT  SQLErrorW  with return code 0
(SQL_SUCCESS)
		HENV                0x00b30204
		HDBC                0x00b31668
		HSTMT               0x00b31870
		WCHAR *             0x0062c25c (NYI) 
 		SDWORD *            0x0062c6c8 (3)
		WCHAR *             0x0062c268 [      74] "Bindings were not allocated
properly."
		SWORD                     1024 
		SWORD *             0x0062c6de (74)

MSACCESS        fff27265:fff26281	EXIT  SQLError  with return code 0
(SQL_SUCCESS)
		HENV                0x00b30204
		HDBC                0x00b31668
		HSTMT               0x00b31870
		UCHAR *             0x0062c6ac (NYI) 
 		SDWORD *            0x0062c6c8 (3)
		UCHAR *             0x0089a9cc [      37] "Bindings were not allocated
properly."
		SWORD                     8192 
		SWORD *             0x0062c6de (37)

MSACCESS        fff27265:fff26281	ENTER SQLError 
		HENV                0x00b30204
		HDBC                0x00b31668
		HSTMT               0x00b31870
		UCHAR *             0x0062c6ac (NYI) 
 		SDWORD *            0x0062c6c8
		UCHAR *             0x0089a9fa 
		SWORD                     8146 
		SWORD *             0x0062c6de

MSACCESS        fff27265:fff26281	ENTER SQLErrorW 
		HENV                0x00b30204
		HDBC                0x00b31668
		HSTMT               0x00b31870
		WCHAR *             0x0062c25c (NYI) 
 		SDWORD *            0x0062c6c8
		WCHAR *             0x0062c268 
		SWORD                     1024 
		SWORD *             0x0062c6de

MSACCESS        fff27265:fff26281	EXIT  SQLErrorW  with return code 100
(SQL_NO_DATA_FOUND)
		HENV                0x00b30204
		HDBC                0x00b31668
		HSTMT               0x00b31870
		WCHAR *             0x0062c25c (NYI) 
 		SDWORD *            0x0062c6c8
		WCHAR *             0x0062c268 
		SWORD                     1024 
		SWORD *             0x0062c6de

MSACCESS        fff27265:fff26281	EXIT  SQLError  with return code 100
(SQL_NO_DATA_FOUND)
		HENV                0x00b30204
		HDBC                0x00b31668
		HSTMT               0x00b31870
		UCHAR *             0x0062c6ac (NYI) 
 		SDWORD *            0x0062c6c8
		UCHAR *             0x0089a9fa 
		SWORD                     8146 
		SWORD *             0x0062c6de

MSACCESS        fff27265:fff26281	ENTER SQLFreeStmt 
		HSTMT               0x00b31870
		UWORD                        0 <SQL_CLOSE>

MSACCESS        fff27265:fff26281	EXIT  SQLFreeStmt  with return code 0
(SQL_SUCCESS)
		HSTMT               0x00b31870
		UWORD                        0 <SQL_CLOSE>

MSACCESS        fff27265:fff26281	ENTER SQLFreeStmt 
		HSTMT               0x00b31870
		UWORD                        1 <SQL_DROP>

MSACCESS        fff27265:fff26281	EXIT  SQLFreeStmt  with return code 0
(SQL_SUCCESS)
		HSTMT               0x00b31870
		UWORD                        1 <SQL_DROP>

MSACCESS        fff27265:fff26281	ENTER SQLDisconnect 
		HDBC                0x00b31668

MSACCESS        fff27265:fff26281	EXIT  SQLDisconnect  with return code
0 (SQL_SUCCESS)
		HDBC                0x00b31668

MSACCESS        fff27265:fff26281	ENTER SQLFreeConnect 
		HDBC                0x00b31668

MSACCESS        fff27265:fff26281	EXIT  SQLFreeConnect  with return code
0 (SQL_SUCCESS)
		HDBC                0x00b31668

MSACCESS        fff27265:fff26281	ENTER SQLFreeEnv 
		HENV                0x00b30204

MSACCESS        fff27265:fff26281	EXIT  SQLFreeEnv  with return code 0
(SQL_SUCCESS)
		HENV                0x00b30204
--------------------eof-----------------------------------

I verified again using pg_dumpall, that there is no table MSysConf.
And - even better: postmasters log says in that moment:
ERROR: msysconf: Table does not exist.
So I think I can be shure of that.

has anyone seen that before?

KK

In response to

Responses

pgsql-interfaces by date

Next:From: Thomas G. LockhartDate: 1999-02-13 02:46:59
Subject: Re: [INTERFACES] facing problem with ecpg
Previous:From: Michael MeskesDate: 1999-02-12 16:19:25
Subject: Re: [INTERFACES] facing problem with ecpg

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group