Обсуждение: Migration from MSAccess

1. Are there dynasets in PG (like in Access)?


2. I tried to export tables from Access95 to PG7.0.3-2 using ODBC Driver on
the Win machine (PG is on a RH7.0).  It worked fine with a simple table I
created myself. Once I tried something real (many columns), I got errors -
see log below:

conn=58261624, SQLDriverConnect( in)='DRIVER={PostgreSQL};',
fDriverCompletion=1
Global Options: Version='06.50.0000', fetch=100, socket=4096,
unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
                disable_optimizer=1, ksqo=1, unique_index=1,
use_declarefetch=1
                text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=0
                extra_systable_prefixes='dd_;pg_', conn_settings=''
conn=58261624, query=' '
conn=58261624, query='set DateStyle to 'ISO''
conn=58261624, query='set geqo to 'OFF''
conn=58261624, query='set ksqo to 'ON''
conn=58261624, query='BEGIN'
conn=58261624, query='declare SQL_CUR03793938 cursor for select oid from
pg_type where typname='lo''
conn=58261624, query='fetch 100 in SQL_CUR03793938'
    [ fetched 0 rows ]
conn=58261624, query='close SQL_CUR03793938'
conn=58261624, query='END'
conn=58261624,
SQLDriverConnect(out)='DRIVER={PostgreSQL};DATABASE=test;SERVER=100.100.100.
100;PORT=5432;UID=postgres;PWD=postgres;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX
=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
conn=58261624, query='BEGIN'
conn=58261624, query='declare SQL_CUR03793938 cursor for SELECT Config,
nValue FROM MSysConf'
ERROR from backend during send_query: 'ERROR:  Relation 'msysconf' does not
exist'
conn=58261624, query='ABORT'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while
executing the query'

The message on screen appears later: "Unable to locate type name 'lo' in
catalog".

Thanks everybody,

Mihai Gheorghiu

> The message on screen appears later: "Unable to locate type name 'lo' in
> catalog".

Don't know about the rest, but take a look at:

http://www.postgresql.org/ftpsite/odbc/psqlodbc_faq.html

under "Can I use large objects or OLE?" - it has the definition for
type 'lo'.

Cheers,

Patrick