Accessing MySQL database

[John Beschler]

I assume you have downloaded the MYSQL ODBC Driver?

Once you have done that and installed it, it should work
the same as any ODBC driver. You might want to look at
[url]www.connectionstrings.com[/url]. They have hundreds of
connection strings listed and MySQL may be there.

>-----Original Message-----
>Can anyone point me to a resource for accessing MySQL

databases from

>ASP?
>
>Thanks!
>
>--Dave
>.
>

[Dave Navarro]

Thanks. MySQL is listed, but their sample didn't work:

Driver={mySQL};Server=localhost;Option=16834;Datab ase=webdata;

I get the error:

[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified

I also tried changing the server name to the name of my server instead
of localhost, but I get the same error.

--Dave

In article <033a01c35789$82807aa0$a101280a@phx.gbl>, [email]giles@geewhiz.com[/email]
says...

> I assume you have downloaded the MYSQL ODBC Driver?
>
> Once you have done that and installed it, it should work
> the same as any ODBC driver. You might want to look at
> [url]www.connectionstrings.com[/url]. They have hundreds of
> connection strings listed and MySQL may be there.
>
>
>
>
>

> >-----Original Message-----
> >Can anyone point me to a resource for accessing MySQL

> databases from

> >ASP?
> >
> >Thanks!
> >
> >--Dave
> >.
> >

>

[John Beschler]

Please post relevant code and let us take a look at it.

>-----Original Message-----
>Thanks. MySQL is listed, but their sample didn't work:
>
>Driver=

{mySQL};Server=localhost;Option=16834;Database=web data;

>
>I get the error:
>
>[Microsoft][ODBC Driver Manager] Data source name not

found and no

>default driver specified
>
>I also tried changing the server name to the name of my

server instead

>of localhost, but I get the same error.
>
>--Dave
>
>In article <033a01c35789$82807aa0$a101280a@phx.gbl>,

[email]giles@geewhiz.com[/email]

>says...

>> I assume you have downloaded the MYSQL ODBC Driver?
>>
>> Once you have done that and installed it, it should

work

>> the same as any ODBC driver. You might want to look at
>> [url]www.connectionstrings.com[/url]. They have hundreds of
>> connection strings listed and MySQL may be there.
>>
>>
>>
>>
>>

>> >-----Original Message-----
>> >Can anyone point me to a resource for accessing MySQL

>> databases from

>> >ASP?
>> >
>> >Thanks!
>> >
>> >--Dave
>> >.
>> >

>>

>.
>

[Dave Navarro]

<%@ Language=VBScript %>
<%
set conn = Server.CreateObject("ADODB.Connection")

conn.Open "Driver={mySQL};Server=localhost;Option=
16834;Database=webdata;uid=user;pwd=password"

set rs = conn.execute("SELECT * FROM clients")

response.write rs("clientname")

conn.Close

set conn = Nothing

%>

--Dave

In article <037201c357a9$635c78c0$a501280a@phx.gbl>, [email]giles@geewhiz.com[/email]
says...

> Please post relevant code and let us take a look at it.
>

> >-----Original Message-----
> >Thanks. MySQL is listed, but their sample didn't work:
> >
> >Driver=

> {mySQL};Server=localhost;Option=16834;Database=web data;

> >
> >I get the error:
> >
> >[Microsoft][ODBC Driver Manager] Data source name not

> found and no

> >default driver specified
> >
> >I also tried changing the server name to the name of my

> server instead

> >of localhost, but I get the same error.
> >
> >In article <033a01c35789$82807aa0$a101280a@phx.gbl>,

> [email]giles@geewhiz.com[/email]

> >says...

> >> I assume you have downloaded the MYSQL ODBC Driver?
> >>
> >> Once you have done that and installed it, it should

> work

> >> the same as any ODBC driver. You might want to look at
> >> [url]www.connectionstrings.com[/url]. They have hundreds of
> >> connection strings listed and MySQL may be there.
> >>
> >> >-----Original Message-----
> >> >Can anyone point me to a resource for accessing MySQL
> >> databases from
> >> >ASP?
> >> >
> >> >Thanks!

[John Beschler]

Well, I'm at the limits of my experience. We had MySQL
installed for evaluation purposes a while back and I did
some testing. When I was done, we pulled it back off and I
don't have any of my examples left. You might check
[url]www.mysql.com[/url] for more help.

Sorry :(
John

>-----Original Message-----
><%@ Language=VBScript %>
><%
>set conn = Server.CreateObject("ADODB.Connection")
>
>conn.Open "Driver={mySQL};Server=localhost;Option=
>16834;Database=webdata;uid=user;pwd=password"
>
>set rs = conn.execute("SELECT * FROM clients")
>
>response.write rs("clientname")
>
>conn.Close
>
>set conn = Nothing
>
>%>
>
>--Dave
>
>In article <037201c357a9$635c78c0$a501280a@phx.gbl>,

[email]giles@geewhiz.com[/email]

>says...

>> Please post relevant code and let us take a look at it.
>>

>> >-----Original Message-----
>> >Thanks. MySQL is listed, but their sample didn't work:
>> >
>> >Driver=

>> {mySQL};Server=localhost;Option=16834;Database=web data;

>> >
>> >I get the error:
>> >
>> >[Microsoft][ODBC Driver Manager] Data source name not

>> found and no

>> >default driver specified
>> >
>> >I also tried changing the server name to the name of

my

>> server instead

>> >of localhost, but I get the same error.
>> >
>> >In article <033a01c35789$82807aa0$a101280a@phx.gbl>,

>> [email]giles@geewhiz.com[/email]

>> >says...
>> >> I assume you have downloaded the MYSQL ODBC Driver?
>> >>
>> >> Once you have done that and installed it, it should

>> work

>> >> the same as any ODBC driver. You might want to look

at

>> >> [url]www.connectionstrings.com[/url]. They have hundreds of
>> >> connection strings listed and MySQL may be there.
>> >>
>> >> >-----Original Message-----
>> >> >Can anyone point me to a resource for accessing

MySQL

>> >> databases from
>> >> >ASP?
>> >> >
>> >> >Thanks!

>.
>

[Joel]

John,

I find it much simpler to create a odbc dsn to the mysql db and access it
with asp as follows:

******************************
Set connect = Server.CreateObject("ADODB.Connection")
Set objFS = Server.CreateObject("Scripting.FileSystemObject")
connect.Open "<odbc dsn name>", "<mysql db user>", "<mysql db password>"
******************************

Query against the database as follows:

******************************
strQ = "<mysql query>"
Set r1 = connect.Execute(strQ)
<variable name> = r1.fields(<field number>)
******************************

Then use the following code to close the connection when you're finished:

******************************
connect.Close
Set objFS = Nothing
Set connect = Nothing
******************************

[Dave Navarro]

Thanks!

--Dave

In article <3_tWa.7648$Ly2.1226200@cletus.bright.net>,
[email]joelseph@watchtv.net[/email] says...

> John,
>
> I find it much simpler to create a odbc dsn to the mysql db and access it
> with asp as follows:
>
> ******************************
> Set connect = Server.CreateObject("ADODB.Connection")
> Set objFS = Server.CreateObject("Scripting.FileSystemObject")
> connect.Open "<odbc dsn name>", "<mysql db user>", "<mysql db password>"
> ******************************
>
> Query against the database as follows:
>
> ******************************
> strQ = "<mysql query>"
> Set r1 = connect.Execute(strQ)
> <variable name> = r1.fields(<field number>)
> ******************************
>
> Then use the following code to close the connection when you're finished:
>
> ******************************
> connect.Close
> Set objFS = Nothing
> Set connect = Nothing
> ******************************

[John Beschler]

Dave,

If you are still having problems let me know. I installed
MySQL and the OLEDB and ODBC drivers this AM and was able
to connect to it useing OLEDB from a VB Script.

John

>-----Original Message-----
>Thanks!
>
>--Dave
>
>In article <3_tWa.7648$Ly2.1226200@cletus.bright.net>,
>joelseph@watchtv.net says...

>> John,
>>
>> I find it much simpler to create a odbc dsn to the

mysql db and access it

>> with asp as follows:
>>
>> ******************************
>> Set connect = Server.CreateObject("ADODB.Connection")
>> Set objFS = Server.CreateObject

("Scripting.FileSystemObject")

>> connect.Open "<odbc dsn name>", "<mysql db

user>", "<mysql db password>"

>> ******************************
>>
>> Query against the database as follows:
>>
>> ******************************
>> strQ = "<mysql query>"
>> Set r1 = connect.Execute(strQ)
>> <variable name> = r1.fields(<field number>)
>> ******************************
>>
>> Then use the following code to close the connection

when you're finished:

>>
>> ******************************
>> connect.Close
>> Set objFS = Nothing
>> Set connect = Nothing
>> ******************************

>.
>

[Dave Navarro]

In article <697701c35841$47120e30$a001280a@phx.gbl>, [email]giles@geewhiz.com[/email]
says...

> If you are still having problems let me know. I installed
> MySQL and the OLEDB and ODBC drivers this AM and was able
> to connect to it useing OLEDB from a VB Script.

I was able to find and install MyODBC drivers, but I couldn't find the
OLEDB drivers.

I tried following the instructions at:

[url]http://www.coveryourasp.com/Snippet.asp?snip=16[/url]

But I couldn't find the "MySQLProv.2.5" file mentioned.

I have MySQL properly installed (it's being used by a couple of sample
PhP scripts). But I just can't connect to it from ASP.

--Dave

[John Beschler]

go here: [url]http://www.mysql.com/downloads/os-win32.html[/url]

There at least 5 different OLEDB drivers available for
download. I used MyOLEDB3.EXE

>-----Original Message-----
>In article <697701c35841$47120e30$a001280a@phx.gbl>,

[email]giles@geewhiz.com[/email]

>says...

>> If you are still having problems let me know. I

installed

>> MySQL and the OLEDB and ODBC drivers this AM and was

able

>> to connect to it useing OLEDB from a VB Script.

>
>I was able to find and install MyODBC drivers, but I

couldn't find the

>OLEDB drivers.
>
>I tried following the instructions at:
>
>[url]http://www.coveryourasp.com/Snippet.asp?snip=16[/url]
>
>But I couldn't find the "MySQLProv.2.5" file mentioned.
>
>I have MySQL properly installed (it's being used by a

couple of sample

>PhP scripts). But I just can't connect to it from ASP.
>
>--Dave
>.
>