Re: Multilevel inserts issue with ODBC
От | George Weaver |
---|---|
Тема | Re: Multilevel inserts issue with ODBC |
Дата | |
Msg-id | bc64ba97-3ce5-e7cc-1800-4cecd47f83b1@cleartagsoftware.com обсуждение исходный текст |
Ответ на | Multilevel inserts issue with ODBC (<krishnanand.pandey@accenture.com>) |
Список | pgsql-odbc |
I have done multi-level inserts (up to several thousand rows) from a VB.NET application using the psqlODBC driver - various versions - on XP, Win 7, and Win 10.
Hope this helps,
George
Hi Adrian
Same thing I am trying in a Windows XP 64bit machine from VB application it fails with the error (3137Missing semicolon (;) at end of SQL statement.).
And if the same multi-level insert statement from code executed from psql/pgadmin it works.
Could you please check the below statement from Windows odbc?
Thanks
Krishnanand Pandey
Newcastle Delivery CentreUK Delivery Centre (Newcastle)
15A | 1 Quick Silver Way | Cobalt Business Park |Tyne and Wear| NE27 0QQ
* krishnanand.pandey@accenture.com
Confidential
This message is for the designated recipient only and may contain confidential, privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this email by you is prohibited.
Communications with Accenture or any of its group companies (“Accenture Group”) including telephone calls and emails (including content), may be monitored by us for the purposes of security and the assessment of internal compliance with company policy. Accenture Group does not accept service by e-mail of court proceedings, other processes or formal notices of any kind.
Accenture means Accenture (UK) Limited (registered number 4757301), Accenture Services Limited (registered number 2633864), or Accenture HR Services Limited (registered number 3957974), all registered in England and Wales with registered addresses at 30 Fenchurch Street, London EC3M 3BD, as the case may be.
-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@aklaver.com]
Sent: 21 June 2016 21:57
To: Pandey, Krishnanand <krishnanand.pandey@accenture.com>; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] Multilevel inserts issue with ODBC
On 06/21/2016 01:37 AM, krishnanand.pandey@accenture.com wrote:
> Hi Adrian
>
>
>
> We are seeing this error in the VB application logs where we have
> captured the error with the Err.Number and Err.Description in the code.
>
> Are there any limitations in the ODBC driver that it cannot handle
> multi-level inserts?
Not that I can see. Just got a chance to compile 09.05.0300 on my Linux machine. Going through the isql utility of unixODBC:
SQL> INSERT INTO odbc_test(id, fld_1) VALUES (1, 'one'), (2, 'two'), (3,
'three')
SQLRowCount returns 3
postgres@production=# select * from odbc_test ;
id | fld_1
----+-------
1 | one
2 | two
3 | three
(3 rows)
>
>
>
> Thanks
>
>
>
>
>
>
>
> /Krishnanand Pandey/
>
--
Adrian Klaver
This message is for the designated recipient only and may contain privileged, proprietary, or otherwise confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the e-mail by you is prohibited. Where allowed by local law, electronic communications with Accenture and its affiliates, including e-mail and instant messaging (including content), may be scanned by our systems for the purposes of information security and assessment of internal compliance with Accenture policy.
______________________________________________________________________________________
www.accenture.com
Вложения
В списке pgsql-odbc по дате отправления: