Re: Where is Connector/NET Documentation
Posted by: David
Date: January 03, 2005 08:34AM

Your connection string should read as follows:

myCommand.ConnectionString = "Database=dbName;Data Source=serverName;User Id=userId;Password=pwd;"

The syntax of that string is very important.

Don't change the order of your connection commands. Best practices dictate that your connection should be open for as little time as possible. You should declare and instantiate all of your objects first, then open the connection, run the query, and close your connection. This will keep your application running much more smoothly than opening your connection and leaving it open while your code does a bunch of other stuff.

There is documentation included with the .NET connector that shows the syntax of all the commands available. If you installed the connector to its default location on a Windows box, you can access the documentation by going to: Start>Programs>MySQL Connector Net 1.0.3>Documentation.


Options: ReplyQuote

Written By
Re: Where is Connector/NET Documentation
January 03, 2005 08:34AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.