Knowledgebase
how we can setup a system DSN to access our MySQL database through ASP
| #Setting up a system DSN :
>>click on the start menu -> Settings -> Control Panel -> Administrative Tools -> Data Sources (ODBC) menu option.(This will load the ODBC data source administrator tab).
>>System DSN tap -> ADD -> Select the MySQL driver from the bottom of the list and click the finish button.
The MySQL driver configuration dialog appears. It contains seven text boxes and a variety of check boxes.
*Windows DSN name field="mysql_dsn".
(This is simply the name that we will use to refer to our DSN from within ASP)
*MySQLhost field= I.P. address of your MySQL server
* database name field=enter the db name
*Username and password=Enter your MySQL username and password details into the user and password fields.
Note:If you aren't sure what they are and you're running MySQL on Windows, then run c:\mysql\bin\winmysql.exe and click on the "my.ini Setup" tab. Under the "[WinMySQLAdmin]" section, you'll find your default MySQL username and password.
* Leave both the port and sql command on connect fields empty.
* Lastly, make sure that the "Return matching rows" checkbox is ticked.Click on the OK button to create your new MySQL system DSN.
#Now you are ready to connect MYSQL DATABASE using DSN connection string in ASP code.
|
Also Read
Powered by WHMCompleteSolution
Quick Navigation
Search
