How to specify that option depends entirely on how you are forming your
connection with the MySQL server. Which connection library are you using
and how are you opening your connection?
The application is an ASP .NET web app hosted on Mono on an Apache web
server running Linux. My data access class uses the MySQLConnector .NET
library (1.0.7) to issue SELECT statements to populate DataSets. The
connection string is as follows:
"Uid=myUsername;Pwd=myPassword;Server=192.168.0.12;Database=myDatabase;"
The function which returns the results of the query boils down to the
following:
mySqlConnection = new MySqlConnection(stringDatabaseConnection);
mySqlDataAdapter = new MySqlDataAdapter(stringSelect, mySqlConnection);
dataSetSQL = new DataSet();
mySqlDataAdapter.Fill(dataSetSQL);
return dataSetSQL;
Regards,
David P. Donahue
[EMAIL PROTECTED]
http://www.cyber0ne.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
