Thread: migrating MSAccess to pgsql7.0 on RH 6.2 through odbc
Hej
I have succesfully migrated 28 tables in MSaccess to Pgsql 7.0 on RH6.2 through ODBC.
I have to migrate 2 more tables, but get the message "Query string is to long".
I have tried to raise the values in the OBDC configuration, but it does't
seem to work.
What else can I do?
TIA
Poul
You can try to use PgAdmin to upsize instead: http://www.greatbridge.org/project/pgadmin/download/download.php But maybe the error comes if you try to insert a record that is larger than 8kb, which is the upper limit in 7.0. 7.1 doesn't have this limit. Hilsen Poul L. Christiansen > Poul Kristensen wrote: > > Hej > > I have succesfully migrated 28 tables in MSaccess to Pgsql 7.0 on > RH6.2 through ODBC. > > I have to migrate 2 more tables, but get the message "Query string is > to long". > > I have tried to raise the values in the OBDC configuration, but it > does't > seem to work. > > What else can I do? > > TIA > > Poul >
"Poul L. Christiansen" <poulc@cs.auc.dk> writes: >> I have succesfully migrated 28 tables in MSaccess to Pgsql 7.0 on >> RH6.2 through ODBC. >> >> I have to migrate 2 more tables, but get the message "Query string is >> to long". > But maybe the error comes if you try to insert a record that is larger > than 8kb, which is the upper limit in 7.0. There is no such error message in the 7.0 backend. I think the ODBC driver still believes that there is an 8K limit on query strings, and it is helpfully preventing you from issuing the query :-(. There isn't anyone actively maintaining the ODBC driver right now, AFAIK, so I don't know when that silliness will be fixed. regards, tom lane