[Pdns-users] Microsoft SQL ODBC Backend Connection, help please?

[Michel Stol]

Hello,

> 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?

Microsoft SQL probably don't support auto_increment as MySQL does (not sure 
though).
Maybe you could import the example database (Access) into MSSQL trough 
ODBC, but I don't know if this is possible as I've never used MSSQL myself.

>
> I haven't used Microsoft SQL much, I prefer MySQL, but we're working on a 
> Win2k platform here.  :(

MySQL runs perfectly under Win2k, so that might be an option too :)

Greetings,

- Michel Stol