In the application that I built, my first connection was to a MySQL database on the same server as the IIS.
Later I added a connection to read data from a SQL Server database on another server.
When I use .CustomQuery in C#, it uses the MySQL driver by default probably because it was my first connection.
In my application, it errors out, telling me that the MySQL driver cant understand the SQL server SQL statement, even though my SQL server SQL is correct.
I take it there is a hard relationship between tDAL and the first connection?
Is there a way to use CustomQuery with my second connection?
Thnx
Harold G