can asp work with mySQL
maggie 0 Newbie Poster
Recommended Answers
Jump to Postcannot i think so, but i am not so sure.
PHP With MY SQL
ASP With Access or Sql Server.
Jump to PostYou can connect to a MySQL Database server without a problem. MyODBC makes it easy. Take a look at http://www.devarticles.com/c/a/ASP/Using-MyODBC-To-Access-Your-MySQL-Database-Via-ASP/ for a good tutorial. Let me know if you need help setting it …
Jump to PostI deleted WebHostalk's duplicate post. :)
Jump to PostSscripting language is pretty independent from database platform. Most languages work with most database in most cases.
All 14 Replies
Vinoth 0 Junior Poster
cannot i think so, but i am not so sure.
PHP With MY SQL
ASP With Access or Sql Server.
samaru 145 a.k.a inscissor Team Colleague
You can connect to a MySQL Database server without a problem. MyODBC makes it easy. Take a look at http://www.devarticles.com/c/a/ASP/Using-MyODBC-To-Access-Your-MySQL-Database-Via-ASP/ for a good tutorial. Let me know if you need help setting it up or with code.
WebHoststalk, don't double post.
Dani 4,653 The Queen of DaniWeb Administrator Featured Poster Premium Member
I deleted WebHostalk's duplicate post. :)
Arizona Web 5 Junior Poster
Sscripting language is pretty independent from database platform. Most languages work with most database in most cases.
Drew 14 Junior Poster
MySQL will work with ASP, but it was not designed for asp. Your better off using MSSQL.
RobUK 0 Light Poster
MySQL will happily work with ASP, which is why microsoft bundles the driver by default.
For a list of connection strings including one for mySql, see this thread:-
http://www.webforumz.com/topic.asp?TOPIC_ID=8
AwSDesigns 0 Newbie Poster
MySQL will happily work with ASP, which is why microsoft bundles the driver by default.
For a list of connection strings including one for mySql, see this thread:-
http://www.webforumz.com/topic.asp?TOPIC_ID=8
What MICROSOFT does NOT bundle the driver!! well not on XP home / Pro, 2003 server, or 2000 which version You use???? I needed to download the driver from MySQL website!
RobUK 0 Light Poster
You are right AwS ... How silly of me.... I have just always had it available to me... I take back my comment which was founded on nothing but my own prejudgement.
bhangyi 0 Newbie Poster
bhangyi 0 Newbie Poster
Download this add it to your data directorey and add reference to it.
it has mysqlconnection objects, commands objects, data adaptors, transactions etc.
please unzip the library file to your data directory. Email me on any progress. VB.NET programmers please use the same library. Visit this site on how to use the stuffffffffffffffffffffffffffffffffffffffff.
bhangyi 0 Newbie Poster
please make sure you unzip the library file.
smart_saru 0 Newbie Poster
asp will work with almost all databases
smart_saru 0 Newbie Poster
it does work with mysql and mssql too..
SheSaidImaPregy 28 Veteran Poster
It works with it just fine, just like all others. I've only ever used MySQL with asp, and have never had a problem.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.