FreeTDS Development Group

[Frediano Ziglio <freddy77 AT gmail.com>]

2013/3/4 Mark A. Hershberger <mah AT everybody.org>:
> On 03/04/2013 03:10 AM, Frediano Ziglio wrote:
>> /* allow double quoted indentifiers */
>> DBSETOPT(H->link, DBQUOTEDIDENT, 1);
>>
>> PHP pass a number as a pointer to string!
>
> Thank you!  This fixed it.
>
> Now, the error messages returned from by PHP are useless.  I'll look for
> a way to fix this, but right now I get the following:
>
>   Error: [HY000] General SQL Server error: Check messages from the SQL
>   Server [102] (severity 15) [sql here here with a MySQL create table]
>
> The relevant line in the debug log is:
>
>   (dbutil.c:86):msgno 102: "Incorrect syntax near 'AUTO_INCREMENT'."
>
> I'll try to get this fixed, but if you have any suggestions, I'm open!
>
> Thanks again!
>

Hi,
  you are trying to speak mysql to mssql! The syntax is different,
probably you have something like

create table table_name
(
    id int identity primary key,
    ...
)

Frediano