ASP.NET & MySQL

[David Whitehouse]

Ok, I have a MySQL database on my server, and i want to test my ASP.NET
pages on my localhost. How do i do a DNS-less connection to it and pull data
from the database? I've tried some stuff from asp.net but nothings working.
-David

[Ken Cox [Microsoft MVP]]

My colleague Carl Prothman has a great collection of connection strings
(including MySQL.NET) here:

[url]http://www.able-consulting.com/dotnet/adonet/Data_Providers.htm#MySQLNETNativeProvider[/url]

Ken

"David Whitehouse" <david@whitehouse.liqx.net> wrote in message
news:3f1937a8@dnews.tpgi.com.au...
Ok, I have a MySQL database on my server, and i want to test my ASP.NET
pages on my localhost. How do i do a DNS-less connection to it and pull data
from the database? I've tried some stuff from asp.net but nothings working.
-David

[Marc Hoeppner]

Hi,

here are two good links:

"David Whitehouse" <david@whitehouse.liqx.net> wrote in message
news:3f1937a8@dnews.tpgi.com.au...

> Ok, I have a MySQL database on my server, and i want to test my ASP.NET
> pages on my localhost. How do i do a DNS-less connection to it and pull

data

> from the database? I've tried some stuff from asp.net but nothings

working.

> -David
>
>

[Marc Hoeppner]

Hi,

here are two good links about this:

[url]http://www.mysql.com/articles/dotnet/#ODBC.NET[/url]

[url]http://www.mysql.com/products/myodbc/faq_3.html#Without_DSN[/url]

Best regards,

Marc Höppner
NeoGeo

"David Whitehouse" <david@whitehouse.liqx.net> wrote in message
news:3f1937a8@dnews.tpgi.com.au...

> Ok, I have a MySQL database on my server, and i want to test my ASP.NET
> pages on my localhost. How do i do a DNS-less connection to it and pull

data

> from the database? I've tried some stuff from asp.net but nothings

working.

> -David
>
>

[David Whitehouse]

Sadly I've already read them and dont understand too well. I've tried to
give them a go but still get the same errors. What i really need is a
dummies guide to set it up, step by step.

"Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
news:OBZxThgTDHA.1288@tk2msftngp13.phx.gbl...

> Hi,
>
> here are two good links about this:
>
> [url]http://www.mysql.com/articles/dotnet/#ODBC.NET[/url]
>
> [url]http://www.mysql.com/products/myodbc/faq_3.html#Without_DSN[/url]
>
> Best regards,
>
> Marc Höppner
> NeoGeo
>
> "David Whitehouse" <david@whitehouse.liqx.net> wrote in message
> news:3f1937a8@dnews.tpgi.com.au...

> > Ok, I have a MySQL database on my server, and i want to test my ASP.NET
> > pages on my localhost. How do i do a DNS-less connection to it and pull

> data

> > from the database? I've tried some stuff from asp.net but nothings

> working.

> > -David
> >
> >

>
>

[Marc Hoeppner]

Hi,

have you tried something like:

MySqlConn.ConnectionString = "Data Source=localhost;Database=<DB>;User
ID=<user>;Password=<password>";

I assume MySQL is on the same box.

Best regards,

Marc Höppner
NeoGeo

"David Whitehouse" <david@whitehouse.liqx.net> wrote in message
news:3f197309@dnews.tpgi.com.au...

> Sadly I've already read them and dont understand too well. I've tried to
> give them a go but still get the same errors. What i really need is a
> dummies guide to set it up, step by step.
>
> "Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
> news:OBZxThgTDHA.1288@tk2msftngp13.phx.gbl...

> > Hi,
> >
> > here are two good links about this:
> >
> > [url]http://www.mysql.com/articles/dotnet/#ODBC.NET[/url]
> >
> > [url]http://www.mysql.com/products/myodbc/faq_3.html#Without_DSN[/url]
> >
> > Best regards,
> >
> > Marc Höppner
> > NeoGeo
> >
> > "David Whitehouse" <david@whitehouse.liqx.net> wrote in message
> > news:3f1937a8@dnews.tpgi.com.au...

> > > Ok, I have a MySQL database on my server, and i want to test my

ASP.NET

> > > pages on my localhost. How do i do a DNS-less connection to it and

pull

> > data

> > > from the database? I've tried some stuff from asp.net but nothings

> > working.

> > > -David
> > >
> > >

> >
> >

>
>

[Alvin Bruney]

are you still having problems with this?

"Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
news:eErf5uhTDHA.2480@tk2msftngp13.phx.gbl...

> Hi,
>
> have you tried something like:
>
> MySqlConn.ConnectionString = "Data Source=localhost;Database=<DB>;User
> ID=<user>;Password=<password>";
>
> I assume MySQL is on the same box.
>
> Best regards,
>
> Marc Höppner
> NeoGeo
>
> "David Whitehouse" <david@whitehouse.liqx.net> wrote in message
> news:3f197309@dnews.tpgi.com.au...

> > Sadly I've already read them and dont understand too well. I've tried to
> > give them a go but still get the same errors. What i really need is a
> > dummies guide to set it up, step by step.
> >
> > "Marc Hoeppner" <marchoeppner@hotmail.com> wrote in message
> > news:OBZxThgTDHA.1288@tk2msftngp13.phx.gbl...

> > > Hi,
> > >
> > > here are two good links about this:
> > >
> > > [url]http://www.mysql.com/articles/dotnet/#ODBC.NET[/url]
> > >
> > > [url]http://www.mysql.com/products/myodbc/faq_3.html#Without_DSN[/url]
> > >
> > > Best regards,
> > >
> > > Marc Höppner
> > > NeoGeo
> > >
> > > "David Whitehouse" <david@whitehouse.liqx.net> wrote in message
> > > news:3f1937a8@dnews.tpgi.com.au...
> > > > Ok, I have a MySQL database on my server, and i want to test my

> ASP.NET

> > > > pages on my localhost. How do i do a DNS-less connection to it and

> pull

> > > data
> > > > from the database? I've tried some stuff from asp.net but nothings
> > > working.
> > > > -David
> > > >
> > > >
> > >
> > >

> >
> >

>
>