Remove Double quotes in datawindow sql for migration to sql server

[#1]

We have just srarted an effort to move one of our app to sql server from sql anywhere. All my datawindows are failing because the sql for all datawindows has table and column names in double quotes but these double quotes will not work with SQL Sever, SQL server throws an error via odbc as soon as these datawindows are hit, I have hundered of datawindows that I will go in and remove these quotes one at a time, is there some way of searching and replacing these quotes massively? any help will be much appreciated.

Javed

[Breck_Carter]

You should not have to do that... SQL Server is perfectly capable of handling "delimited" identifiers; see http://msdn.microsoft.com/en-us/library/ms174393.aspx

Check the ODBC DSN and make sure "Use ANSI quoted identifiers" is checked.

Good luck with all the other problems you're going to have with Transact SQL!

[Former Member]

Breck: thanks for your reply but the above option in odbc dsn configuration is checked.