Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ADO.NET: Connecting to MySQL Server

0 views
Skip to first unread message

TP-Software

unread,
Nov 30, 2001, 6:50:14 PM11/30/01
to
Hey,

I have a MySQL server running at 192.168.0.1:3306
I know how to connect to access databases using .Net, but I don't know how
to connect to MySQL.
Can somebody show me the connectionstring and a small example of opening a
connection in ASP.NET ?

Thnx

Sebastien Le Calvez

unread,
Dec 1, 2001, 2:42:18 PM12/1/01
to
I'm actually usign MySQL with .Net and you have tow options... either you
download MYOLEDB driver... and try the connection string whiche you can find
here:
http://www.able-consulting.com/ADO_Conn.htm#OLEDBProviderForMicrosoftJet
(that way didn't work for me) or you either download MyODBC (from
www.mysql.com) and download from microsoft ODBC.NET driver. It's still a
Beta but it works..... .Net doesn't support ODBC as a default anymore... so
that's why you hace to download it... If you need more help write me.


TP-Software

unread,
Dec 1, 2001, 3:24:40 PM12/1/01
to
Thnx I'll try that :-)

"Sebastien Le Calvez" <k...@al.com> schreef in bericht
news:e6ujaBqeBHA.2120@tkmsftngp07...

TP-Software

unread,
Dec 1, 2001, 4:33:42 PM12/1/01
to
Hey,

I was able to connect to the database
but when I do a Select * from mysql.user (or user or mydb.member) all I get
is the name of the fields and this error

Error: 30023
Unable to access data. DataSource settings may be incorrect or the
DataSource functionality may be limited. See Help for more information.

So I don't get any values, any idea ?

"Sebastien Le Calvez" <k...@al.com> schreef in bericht
news:e6ujaBqeBHA.2120@tkmsftngp07...

Sebastien Le Calvez

unread,
Dec 3, 2001, 2:15:56 AM12/3/01
to
sorry, I can's help you anymore... That's all I was able to do!


"TP-Software" <tp-so...@cyberia.be> wrote in message
news:OEPZP#qeBHA.828@tkmsftngp04...

0 new messages