Sql syntax using brackets "[" "]" instead of quotes in Configure Datasource Wizard

Discussion in 'Visual Studio' started by Shawn Mower, May 27, 2009.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Dear ASP.net forum,

    I have been trying to find an answer to this online, but can't seem to find a solution.

    Is there anyway with visual studio to change the way the "Configure Datasource Wizard" generates it's sql statement commands to surround the database tables with quotes instead of brackets for odbc connections to non microsoft databases?

    For example, I have a database that uses a DataDirect odbc driver and visual studio seems to connect to it just fine but the "Configure Datasource Wizard" generates the following code:
    SELECT * FROM [Customers] which breaks my odbc driver instead of using
    SELECT * FROM "Customers" which works fine with my odbc driver.

    I have noticed that you can go back in the code later and change the statement, but it sure would be convenient if I could just tweak something so that Visual Studio would generate it correctly with the wizard....

    Any help on how to do this would be greatly appreciated.

    Thanks!
    Shawn
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page