connecting to mysql using asp.net - c#

[Paradox Synthesist]

hi,
i am a newbie to asp.net and have started learning mainly from
websites. i have a question which IS very silly and trivial.

http://msdn2.microsoft.com/en-us/lib...sn(VS.80).aspx

i looked through this url to see how could i connect to a mysql
database...where does the dsn figure out? why do i need to give it? i
cant see any dsn specified anywhere on the database control panel. i
am a newbie to this thing. all i could figure out was the connection
string part:

http://dev.mysql.com/tech-resources/articles/dotnet/
.....................[
string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" +
"SERVER=localhost;" +
"DATABASE=test;" +
"UID=venu;" +
"PASSWORD=venu;" +
"OPTION=3";

OdbcConnection MyConnection = new OdbcConnection(MyConString);
MyConnection.Open();

The above one uses DSN-less connection, if you have a MyODBC DSN
defined already then you can just use "DSN=dsn_name" as the connection
string i.e.

OdbcConnection MyConnection = new OdbcConnection("DSN=myodbc3-
test");
MyConnection.Open();
]....................

but the dsn part is something that is baffling me. moreover at places
it is said that i need to change my webconfig file. is it necessary to
do so?
Could you tell me the procedure of connecting to a mysql database
using the odbc driver and inserting a row in a table; all the
procedures involved?

[Mark Rae]

"Paradox Synthesist" <ku**********@gmail.comwrote in message
news:11**********************@p77g2000hsh.googlegr oups.com...

Could you tell me the procedure of connecting to a mysql database
using the odbc driver

Firstly, can I just ask you why on earth you are even trying to use ODBC...?

http://www.mysql.com/products/connector/net/
http://www.crlab.com/mysqlnet/download.html
http://sourceforge.net/projects/mysqldrivercs/

[David]

You can use DSN or DSNLess connections.

The DSNless is the one where you define all the parameters to connect to the
database. a DSN is one you have created on the ODBC administrator in control
panel (of windows).

You can put your connection string (either DSN or DSNLess) in your
web.config or in your code.

In .NET 1.1, you need...

using System.Data.Odbc;

In your code, you just add the data like you would any database. There are
loads of examples on the net for this.

--
Best regards,
Dave Colliver.
http://www.AshfieldFOCUS.com
~~
http://www.FOCUSPortals.com - Local franchises available
"Paradox Synthesist" <ku**********@gmail.comwrote in message
news:11**********************@p77g2000hsh.googlegr oups.com...

hi,
i am a newbie to asp.net and have started learning mainly from
websites. i have a question which IS very silly and trivial.

http://msdn2.microsoft.com/en-us/lib...sn(VS.80).aspx

i looked through this url to see how could i connect to a mysql
database...where does the dsn figure out? why do i need to give it? i
cant see any dsn specified anywhere on the database control panel. i
am a newbie to this thing. all i could figure out was the connection
string part:

http://dev.mysql.com/tech-resources/articles/dotnet/
....................[
string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" +
"SERVER=localhost;" +
"DATABASE=test;" +
"UID=venu;" +
"PASSWORD=venu;" +
"OPTION=3";

OdbcConnection MyConnection = new OdbcConnection(MyConString);
MyConnection.Open();

The above one uses DSN-less connection, if you have a MyODBC DSN
defined already then you can just use "DSN=dsn_name" as the connection
string i.e.

OdbcConnection MyConnection = new OdbcConnection("DSN=myodbc3-
test");
MyConnection.Open();
]....................

but the dsn part is something that is baffling me. moreover at places
it is said that i need to change my webconfig file. is it necessary to
do so?
Could you tell me the procedure of connecting to a mysql database
using the odbc driver and inserting a row in a table; all the
procedures involved?

[Rad [Visual C# MVP]]

On Sun, 29 Apr 2007 21:49:25 +0100, David wrote:

You can use DSN or DSNLess connections.

The DSNless is the one where you define all the parameters to connect to the
database. a DSN is one you have created on the ODBC administrator in control
panel (of windows).

You can put your connection string (either DSN or DSNLess) in your
web.config or in your code.

In .NET 1.1, you need...

using System.Data.Odbc;

In your code, you just add the data like you would any database. There are
loads of examples on the net for this.

Where possible, try and use MySQL native .NET provider for better
performance
--
Bits.Bytes
http://bytes.thinkersroom.com