[Pdns-users] Microsoft SQL ODBC Backend Connection, help please?
DaveHowe at gmx.co.uk
Mon Oct 13 09:57:16 UTC 2003
I didn't get the original of this, btw....
Patricio Valdes wrote:
> From: "Taylor Dondich" <tdondich at majiknetworks.com>
>> Hi there, I was looking through the documentation and found the SQL
>> CREATE statement to create the table for powerdns to use; however,
>> Microsoft SQL says I have illegal syntax near 'auto_increment'. Does
>> anyone have a solution for this or a proper CREATE SQL statement that
>> will create my tables?
MS SQL uses a non-standard syntax for its autoinc - the base syntax is
<columnname> <columntype> IDENTITY (<seed>, <increment>) NOT NULL
where seed is the base value for autoinc
More information about the Pdns-users