Обсуждение: msysconf error
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
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