SqlDataSource wizard showing SQL with wrong syntax

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Reggie Burnett - 15 Feb 2007 18:29 GMT

I've set the quoted identifier stuff in all the locations I can think of
and yet SqlDataSource wizard still shows the SQL as SELECT [col1], [col2]
from [table]. This syntax doesn't work for us. How does it determine what
syntax to use if it's not using things like DataSourceInformation?

Reggie
MySQL, Inc.

Reply to this Message

Carlos Guzmán Álvarez - 26 Feb 2007 12:37 GMT

Hello:

> I've set the quoted identifier stuff in all the locations I can think
> of and yet SqlDataSource wizard still shows the SQL as SELECT [col1],
> [col2] from [table]. This syntax doesn't work for us. How does it
> determine what syntax to use if it's not using things like
> DataSourceInformation?

In the Firebird .NET provider i was having the same problem, looks like
VS is setting the DataAdapter QuotePreffix and QuoteSuffix two times,
the first one with the correct value ( " in the case of the .NET
provider ) and a second one using brackets ...

The only way i found to solve it wqas doing a hack in those properties
to be always " ( As firebird didn't allow other it can be valid for now.

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...