Re: help debugging segfault

Frediano Ziglio <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <CAHt6W4e0jssL58Fxg2uBLaQqA44x_TUYQnRLq9zHi1d14wJvHg@mail.gmail.com>
2013/3/4 Mark A. Hershberger <[email protected]>:
> 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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.