From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "SweetBeet(dot)com Webmaster" <webmaster(at)agterra(dot)com> |
Cc: | <pgsql-odbc(at)postgresql(dot)org>, "Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp> |
Subject: | Re: continuing problems with sqlsetpos & syncing postgresql to a mobile database |
Date: | 2003-04-08 20:07:22 |
Message-ID: | 03AF4E498C591348A42FC93DEA9661B88619@mail.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi Julie,
The obvious error is that your application is not correctly quoting the
tablename in the query:
select * from SYWARE_SyncInfo where Tablename = 'contract_test'
It should probably be:
select * from "SYWARE_SyncInfo" where Tablename = 'contract_test'
I'm not sure about the SetPos error though. Any ideas Hiroshi?
Regards, Dave.
-----Original Message-----
From: SweetBeet.com Webmaster [mailto:webmaster(at)agterra(dot)com]
Sent: 08 April 2003 20:46
To: Dave Page
Cc: pgsql-odbc(at)postgresql(dot)org; Hiroshi Inoue
Subject: continuing problems with sqlsetpos & syncing postgresql
to a mobile database
Dave,
We tried both the snapshot of the psqlodbc driver and the
snapshot of the psqlodbc30 driver. We were not able to get either to
work. I looked through the logs and when I searched for "error" I did
find new error messages but I am not sure what they mean. I have
attached all the logs for both drivers. I truncated the mylogs to reduce
their size, let me know if you need to see the full log
Julie
----- Original Message -----
From: Dave Page <mailto:dpage(at)vale-housing(dot)co(dot)uk>
To: Julie May <mailto:julie(at)ccorb(dot)com>
Sent: Saturday, April 05, 2003 1:21 PM
Subject: RE: [pgadmin-support] PgMigration error when
migrating Dbase tables
Hi Julie,
Please try the updated DLLs from
http://www.geocities.jp/inocchichichi/psqlodbc/
<http://www.geocities.jp/inocchichichi/psqlodbc/>
I haven't tested it myself but I'm told that:
You can use SQLSetPos(SQL_UPDATE) if you compiled the
driver with DRIVER_CURSOR_IMPLEMENT #defined(the current makefile s in
cvs already #define it) and turn on the *Updatable cursors* DSN option.
Hiroshi's snapshots are only a week and a bit old, so
should include the relevant mods. If not, let me know and I'll compile a
fresh one for you.
Regards, Dave.
From | Date | Subject | |
---|---|---|---|
Next Message | Y.V.Shreenivas Rao | 2003-04-09 05:01:14 | Fw: RE: [webmaster] Image storing in postgresql. |
Previous Message | Dave Page | 2003-04-05 19:06:41 | Re: SQLSetPos |