 |  |  |  |  |  |  |  |
can i used MySQL as database server for asp?
Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
hai everyone..i'm still beginner in this ASP..
jus wanna know is it ok if i used MySQL as database? can anyone teach..
really needs ur helps and guides..thanx alot guys..
jus wanna know is it ok if i used MySQL as database? can anyone teach..
really needs ur helps and guides..thanx alot guys..
•
•
Join Date: Sep 2007
Posts: 1,080
Reputation: 
Solved Threads: 68
yes, you can use it. You need to connect to it. Visit www.connectionstrings.com for examples.
Ooooh yes you can
Here's a working connectionstring:
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={MySQL ODBC 5.1 Driver}; SERVER=localhost; DATABASE=<yourdatabasename>; UID=<yourusername>; PWD=<yourpassword>;"
Change SERVER=localhost if your database is placed somewhere else.
You can download all of the drivers from mysql.com. You may have to setup an DSN connector for the drivers.
Here's a working connectionstring:
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={MySQL ODBC 5.1 Driver}; SERVER=localhost; DATABASE=<yourdatabasename>; UID=<yourusername>; PWD=<yourpassword>;"
Change SERVER=localhost if your database is placed somewhere else.
You can download all of the drivers from mysql.com. You may have to setup an DSN connector for the drivers.
Last edited by TobbeK; Feb 16th, 2008 at 7:38 am.
hi bungek84,
You can use MySql with ASP.net easily. There are lots of article's you can learn from there.
But for your help please visit the given link.
http://www.codeproject.com/KB/webforms/MySQLsuite.aspx
http://www.15seconds.com/issue/050210.htm
Hope this will help you.
Thanks & Regards
Dilipv
You can use MySql with ASP.net easily. There are lots of article's you can learn from there.
But for your help please visit the given link.
http://www.codeproject.com/KB/webforms/MySQLsuite.aspx
http://www.15seconds.com/issue/050210.htm
Hope this will help you.
Thanks & Regards
Dilipv
Dilip Kumar Vishwakarma
Programmer
.Net Consulting
If this post is answer for your query then don't forget to mark as an answer.
Programmer
.Net Consulting
If this post is answer for your query then don't forget to mark as an answer.
|
Similar Threads
- can asp work with mySQL (ASP)
- PHP vs ASP... the big ShOwdOwN (IT Professionals' Lounge)
- can i use mysql database with asp (ASP)
- connecting to database error (ASP)
- Copying database from one server to another (MS SQL)
- php mysql help (PHP)
- SQL Server vs MYSQL vs MSQL (i'm stopping now) (MS SQL)
- MySQL - ASP.NET - Issues.... (VB.NET)
- ASP and SQL ? (MS SQL)
Other Threads in the ASP Forum
- Previous Thread: Classic ASP (ASPvb) and IIS7 ??
- Next Thread: Passing a Trimmed Value from a FormField
Views: 1028 | Replies: 3
| Thread Tools | Search this Thread |
Latest ASP Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for ASP
archive asp asp.net aspandmssqlserver2005 aspandmssqlserver2005connection aspconnection calendar changeable connection current database databaseconnection diagnostics dreamweaver excel fso html iis microsoft msmsql mssql2005 mssqlserver2005 mssqlserver2005andasp mssqlserverandasp opentextfile query record searchbox selectoption server single specfic sqlserver sqlserverconnection toolkit update web webserver windows7
