My SQL in ASP

[Jason Rivers]

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

Thanks

Jason

[dlbjr]

install the ODBC drivers available on the MySQL web side and then create a
DSN.
-dlbjr

Discerning resolutions for the alms

[William Tasso]

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

[dlbjr]

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

[Ray at]

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

[Tony Mak...]

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

[Michel Thiffault]

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

[William Tasso]

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