470,594 Members | 1,444 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,594 developers. It's quick & easy.

My SQL in ASP

How do i connect to a MySQL sever in ASP, Not MS SQL Server.

Thanks

Jason
Jul 19 '05 #1
7 1522
install the ODBC drivers available on the MySQL web side and then create a
DSN.
-dlbjr

Discerning resolutions for the alms
Jul 19 '05 #2
dlbjr wrote:
install the ODBC drivers available on the MySQL web side and then
create a DSN.


is ODBC the only supported method?

--
William Tasso - http://WilliamTasso.com
Jul 19 '05 #3
It's the only one I'm knowledgeable of.
I have used it mainly to hit MySQL on a Linux box.
I have installed MySQL on the local Microsoft box and connected through ODBC
locally

-dlbjr

Discerning resolutions for the alms
Jul 19 '05 #4
I've never used MySQL or anything, so I don't know, but
connectionstrings.com does have an oledb string for MySQL. So, that would
lead me to believe there's an OLEDB driver available. Nice.

Ray at home

"dlbjr" <do******@do.u> wrote in message
news:s90nb.155$Qy4.12411@typhoon01...
It's the only one I'm knowledgeable of.
I have used it mainly to hit MySQL on a Linux box.
I have installed MySQL on the local Microsoft box and connected through ODBC locally

-dlbjr

Discerning resolutions for the alms

Jul 19 '05 #5
Try this:
strConn =
"driver={MySQL};server=xxx.xxx.xxx.xxx;uid=databas eusername;pwd=databasepass
word;database=databasename;option=NUM"

Set dbc = Server.CreateObject("ADODB.Connection")
dbc.open strConn

Tony Mak...

"Jason Rivers" <ja**********@sevenstreams.tk> wrote in message
news:O1**************@TK2MSFTNGP12.phx.gbl...
How do i connect to a MySQL sever in ASP, Not MS SQL Server.

Thanks

Jason

Jul 19 '05 #6
http://www.connectionstrings.com

"Jason Rivers" <ja**********@sevenstreams.tk> wrote in message
news:O1**************@TK2MSFTNGP12.phx.gbl...
How do i connect to a MySQL sever in ASP, Not MS SQL Server.

Thanks

Jason

Jul 19 '05 #7
Ray at <%=sLocation%> wrote:
I've never used MySQL or anything, so I don't know, but
connectionstrings.com does have an oledb string for MySQL. So, that
would lead me to believe there's an OLEDB driver available. Nice.


That's better. Now we may be cooking ;o)

--
William Tasso - http://WilliamTasso.com
Jul 19 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by William C. White | last post: by
2 posts views Thread by Albert Ahtenberg | last post: by
3 posts views Thread by James | last post: by
reply views Thread by Ollivier Robert | last post: by
1 post views Thread by Richard Galli | last post: by
4 posts views Thread by Albert Ahtenberg | last post: by
1 post views Thread by inderjit S Gabrie | last post: by
2 posts views Thread by Jack | last post: by
3 posts views Thread by Sandwick | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.