Thread: msysconf error

msysconf error

From

David Chapman

Date:

22 January 2006, 01:39:29

I am using Postgresly 8 running on Fedora C3. The clients are Microsoft Access connecting using ODBC.

Recently I rebuilt my development database. Now I am getting an error referring to a missing msysconf, which shows up as an error in the calling statements, although the postresql statements (insert and update) execute correctly. Can some one please advise me on where to find msysconf and how to fix the problem.

The extract from the odbc log is bellow

David

conn=137311856, query='set client_encoding to 'UTF8''

conn=137311856, PGAPI_DriverConnect(out)=''

conn=137311856, query='SELECT Config, nValue FROM MSysConf'

ERROR from backend during send_query: 'ERROR: relation "msysconf" does not exist'

STATEMENT ERROR: func=SC_execute, desc='', errnum=7, errmsg='Error while executing the query'

------------------------------------------------------------

hdbc=137311856, stmt=137340976, result=137340840

manual_result=0, prepare=0, internal=0

bindings=0, bindings_allocated=0

parameters=0, parameters_allocated=0

statement_type=0, statement='SELECT Config, nValue FROM MSysConf'

stmt_with_params='SELECT Config, nValue FROM MSysConf'

data_at_exec=-1, current_exec_param=-1, put_data=0

currTuple=-1, current_col=-1, lobj_fd=-1

maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1

cursor_name='SQL_CUR082FA830'

----------------QResult Info -------------------------------

fields=137346856, manual_tuples=0, backend_tuples=0, tupleField=0, conn=0

fetch_count=0, num_total_rows=0, num_fields=0, cursor='(NULL)'

message='ERROR: relation "msysconf" does not exist', command='(NULL)', notice='(NULL)'

status=7, inTuples=0

CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: relation "msysconf" does not exist'

------------------------------------------------------------
--

David Chapman
David's Backyard Computing

PLEASE RECORD MY NEW EMAIL ADDRESS
david.luckychap@gmail.com

Re: msysconf error

From

"Rolf Østvik"

Date:

30 January 2006, 02:21:50

Please don't use html in e-mails and on news (i read this on news)

david.luckychap@gmail.com (David Chapman) wrote in
news:9c7f5eb30601211839t55b50913sacd7c5219bb36ef2@mail.gmail.com:

> I am using Postgresly 8 running on Fedora C3. The clients are
> Microsoft Access connecting using ODBC.
>
> Recently I rebuilt my development database. Now I am getting an error
> referring to a missing msysconf, which shows up as an error in the
> calling statements, although the postresql statements (insert and
> update) execute correctly. Can some one please advise me on where to
> find msysconf and how to fix the problem.

From the Microsoft Access Help:
: Use the MSysConf table with linked SQL databases

: If you are administering an SQL database that uses Microsoft Access as a
: front end, you can create a table in your SQL database named MSysConf
: to help you control communication between the two applications.

There is more, but look it up in the Microsoft Access help.

I think that it is strange that you get an error message if that file is
missing since the table is optional.

Hope this can be of some help.
--
Rolf