Anyone had use AC with SQL Server 2005???

[rhmorales]

I cant copy structure from ACDEMO50 to a new DB in SQL Server 2005 but it is easy in SQL Server 2000.
Somebody have any successful case with AC and SQL Server 2005?
Thank in advance!

[tomislavqs]

Yes,
all you have to do is to set database to be SQL2000 compliant when you create it...

[rhmorales]

Yes,
all you have to do is to set database to be SQL2000 compliant when you create it...

I will review this option in a new install of SQL Server, thank you

[deantm@inbox.com]

I cant copy structure from ACDEMO50 to a new DB in SQL Server 2005 but it is easy in SQL Server 2000.
Somebody have any successful case with AC and SQL Server 2005?
Thank in advance!

Hi ,

I had the same problem. In SQL 2005: Right click on "Databases" click on "New Database", give it a name, click on "Options" (in the left-hand pane) and change the compatibility level to SQL 2000, click on OK, ODBC to it via AC and it should successfully connect to it and import AC's table structure into the Database that you created!

Regards,
Dean