connecting from .Net

--0-1595840483-1116951513=:30943
Content-Type: text/plain; charset=us-ascii

Hi,
i have been trying to connect to mySQL from .Net application with on result. i have downloaded mysql-connector-net and have install it, but unable to you it. the help system talks about how to use it in an application, when the components have already been registered with Visual studio.Net and failed to explain the most important subject, how do you register the components with Visual studio.net?
However, i also downloaded myODBC, install it,setup DNS and tried to connecting to it, but couldn't.I tried creating a connection string to connect it, this is was also impossible.
I will greatful if i can get help.

Benjamin Osahon
GTS-Infotel


---------------------------------
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
--0-1595840483-1116951513=:30943--

RE: connecting from .Net

Here is some code that will connect to MySQL in .NET.


Imports System.Data
Imports System.Data.Odbc
Imports System.Data.Odbc.OdbcDataReader
Imports System.Data.Odbc.OdbcDataAdapter
Imports System.Data.Odbc.OdbcConnection

Dim conn As New OdbcConnection("DRIVER={MySQL ODBC 3.51 Driver};" & _
"SERVER=yourserverName or Localhost;" & _
"DATABASE=yourDatabaseName;" & _
"USER=yourUsername;" & _
"PASSWORD=yourpassword;")

I hope this helps.

Ron

-----Original Message-----
From: Engr. Benjamin Osahon [mailto:osahoben@yahoo.com]
Sent: Tuesday, May 24, 2005 12:19 PM
To: myodbc@lists.mysql.com
Subject: connecting from .Net


Hi,
i have been trying to connect to mySQL from .Net application with on result.
i have downloaded mysql-connector-net and have install it, but unable to you
it. the help system talks about how to use it in an application, when the
components have already been registered with Visual studio.Net and failed to
explain the most important subject, how do you register the components with
Visual studio.net?
However, i also downloaded myODBC, install it,setup DNS and tried to
connecting to it, but couldn't.I tried creating a connection string to
connect it, this is was also impossible.
I will greatful if i can get help.

Benjamin Osahon
GTS-Infotel


---------------------------------
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

AW: connecting from .Net

Ron,

Why on earth use ODBC from .NET when the .NEt connector is available ?

make a referrence to the connector in your project and use :

Imports MySql.Data.MySqlClient

Dim conn As New MySqlConnection("Data Source=3D[IP-Address];" & _
"Database=3D[Database name];" & _
"User ID=3D[User];" & _
"Password=3D[Password};")

Freddie

> -----Ursprüngliche Nachricht-----
> Von: Ron Alexander [mailto:ralexander@csmresearch.com]=20
> Gesendet: Mittwoch, 25. Mai 2005 14:32
> An: 'Engr. Benjamin Osahon'; myodbc@lists.mysql.com
> Betreff: RE: connecting from .Net
>=20
> Here is some code that will connect to MySQL in .NET.
>=20
>=20
> Imports System.Data
> Imports System.Data.Odbc
> Imports System.Data.Odbc.OdbcDataReader
> Imports System.Data.Odbc.OdbcDataAdapter Imports=20
> System.Data.Odbc.OdbcConnection
>=20
> Dim conn As New OdbcConnection("DRIVER=3D{MySQL ODBC 3.51 Driver};" & =
_
> "SERVER=3DyourserverName or Localhost;" & _
> "DATABASE=3DyourDatabaseName;" & _
> "USER=3DyourUsername;" & _
> "PASSWORD=3Dyourpassword;")
>=20
> I hope this helps.
>=20
> Ron
>=20
> -----Original Message-----
> From: Engr. Benjamin Osahon [mailto:osahoben@yahoo.com]
> Sent: Tuesday, May 24, 2005 12:19 PM
> To: myodbc@lists.mysql.com
> Subject: connecting from .Net
>=20
>=20
> Hi,
> i have been trying to connect to mySQL from .Net application=20
> with on result.
> i have downloaded mysql-connector-net and have install it,=20
> but unable to you it. the help system talks about how to use=20
> it in an application, when the components have already been=20
> registered with Visual studio.Net and failed to explain the=20
> most important subject, how do you register the components=20
> with Visual studio.net?
> However, i also downloaded myODBC, install it,setup DNS and=20
> tried to connecting to it, but couldn't.I tried creating a=20
> connection string to connect it, this is was also impossible.
> I will greatful if i can get help.
> =20
> Benjamin Osahon
> GTS-Infotel
>=20
> =09
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail - Helps protect you from nasty viruses.
>=20
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe: =20
> http://lists.mysql.com/myodbc?unsub=3Dfreddie@parawebic.com
>=20
>=20



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg

RE: connecting from .Net

I see there have been some other answers to this already but, in case
you need more details, here is what you do.

In the project where you wish to use the connector, right click on
References and choose Add Reference. Navigate to MySQl.Data.dll in the
connector files you installed (mine is in
bin\net-1.1\release\MySql.Data.dll where I unzipped the files) and
select it.

Then include=20

using MySql.Data.MySqlClient;

in the code modules where you want to use it.

John Bonnett

-----Original Message-----
From: Engr. Benjamin Osahon [mailto:osahoben@yahoo.com]=20
Sent: Wednesday, 25 May 2005 1:49 AM
To: myodbc@lists.mysql.com
Subject: connecting from .Net

Hi,
i have been trying to connect to mySQL from .Net application with on
result. i have downloaded mysql-connector-net and have install it, but
unable to you it. the help system talks about how to use it in an
application, when the components have already been registered with
Visual studio.Net and failed to explain the most important subject, how
do you register the components with Visual studio.net?
However, i also downloaded myODBC, install it,setup DNS and tried to
connecting to it, but couldn't.I tried creating a connection string to
connect it, this is was also impossible.
I will greatful if i can get help.
=20
Benjamin Osahon
GTS-Infotel

=09
---------------------------------
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg

Re: AW: connecting from .Net

Hello Freddie,

Wednesday, May 25, 2005, 9:48:44 PM, you wrote:

> Ron,

> Why on earth use ODBC from .NET when the .NEt connector is available ?


Because .Net is slow


--
Best regards,
artem mailto:artem@w510.com.ua


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: connecting from .Net

We are trying register the MySQL connector with Micosoft Visual Web =
Developer Express. The goal is to have the MySQL connector appear in the =
data source list box when configuring a data source. Does anyone know =
how to do this?

-----Original Message-----
From: jbonnett@sola.com.au [mailto:jbonnett@sola.com.au]
Sent: Thursday, May 26, 2005 5:12 PM
To: osahoben@yahoo.com; myodbc@lists.mysql.com
Subject: RE: connecting from .Net


I see there have been some other answers to this already but, in case
you need more details, here is what you do.

In the project where you wish to use the connector, right click on
References and choose Add Reference. Navigate to MySQl.Data.dll in the
connector files you installed (mine is in
bin\net-1.1\release\MySql.Data.dll where I unzipped the files) and
select it.

Then include=20

using MySql.Data.MySqlClient;

in the code modules where you want to use it.

John Bonnett

-----Original Message-----
From: Engr. Benjamin Osahon [mailto:osahoben@yahoo.com]=20
Sent: Wednesday, 25 May 2005 1:49 AM
To: myodbc@lists.mysql.com
Subject: connecting from .Net

Hi,
i have been trying to connect to mySQL from .Net application with on
result. i have downloaded mysql-connector-net and have install it, but
unable to you it. the help system talks about how to use it in an
application, when the components have already been registered with
Visual studio.Net and failed to explain the most important subject, how
do you register the components with Visual studio.net?
However, i also downloaded myODBC, install it,setup DNS and tried to
connecting to it, but couldn't.I tried creating a connection string to
connect it, this is was also impossible.
I will greatful if i can get help.
=20
Benjamin Osahon
GTS-Infotel

=09
---------------------------------
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.

--=20
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: =
http://lists.mysql.com/myodbc?unsub=3Djfrankman@idfbins.com


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg

AW: AW: connecting from .Net

LOL - you are kidding, right ?=20

> -----Ursprüngliche Nachricht-----
> Von: artem@w510.com.ua [mailto:artem@w510.com.ua]=20
> Gesendet: Freitag, 27. Mai 2005 11:08
> An: myodbc@lists.mysql.com
> Betreff: Re: AW: connecting from .Net
>=20
> Hello Freddie,
>=20
> Wednesday, May 25, 2005, 9:48:44 PM, you wrote:
>=20
> > Ron,
>=20
> > Why on earth use ODBC from .NET when the .NEt connector is=20
> available ?
>=20
>=20
> Because .Net is slow
>=20
>=20
> --
> Best regards,
> artem mailto:artem@w510.com.ua
>=20
>=20
> --=20
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe: =20
> http://lists.mysql.com/myodbc?unsub=3Dfreddie@parawebic.com
>=20
>=20



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg