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 - [url]http://WilliamTasso.com[/url]

[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" <dontknow@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" <jason.rivers@sevenstreams.tk> wrote in message
news:O1Yavr$mDHA.2312@TK2MSFTNGP12.phx.gbl...

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

[Michel Thiffault]

[url]http://www.connectionstrings.com[/url]

"Jason Rivers" <jason.rivers@sevenstreams.tk> wrote in message
news:O1Yavr$mDHA.2312@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 - [url]http://WilliamTasso.com[/url]