Re: Extended inserts not working with ODBC C program

[Bogdan Degtyariov]

Hi Ted,

I am not sure I understand what exactly you wanted to say when mentioning "extended inserts".
My guess would be several insert statements like this:

INSERT INTO my_table ..... ; INSERT INTO my_table ..... ; INSERT INTO my_table ..... ;

if that is the case you need to enable executing of multiple statements. This can be done either through the connection string by specifying MULTI_STATEMENTS=1 or through the GUI dialog in ODBC administrator:

Details >> Connection >> [x] Allow Multiple statements