6 messages in com.mysql.lists.win32Re: Imports ByteFX.Data.MySqlClient
FromSent OnAttachments
Bob Achgill25 Jun 2004 23:52 
Freddie Sorensen26 Jun 2004 00:45 
Bob Achgill26 Jun 2004 02:35 
Freddie Sorensen26 Jun 2004 02:46 
Bob Achgill26 Jun 2004 15:06 
Freddie Sorensen26 Jun 2004 23:52 
Subject:Re: Imports ByteFX.Data.MySqlClient
From:Bob Achgill (BobA@hotmail.com)
Date:06/26/2004 03:06:23 PM
List:com.mysql.lists.win32

Thanks Freddie!

Adding the "My" was what I needed.

You read my mind on what my next question would be...

About connection string!

If my stats are like this (see below) how would my connection string look like?

hostname: mysql.mydatabase.org database name : MyDataBaseName username: MyUserName password: MyPassword

Thank you,

Bob Achgill

----- Original Message ----- From: "Freddie Sorensen" <fred@parawebic.com> To: "'Bob Achgill'" <BobA@hotmail.com>; <win@lists.mysql.com> Sent: Saturday, June 26, 2004 1:47 PM Subject: AW: Imports ByteFX.Data.MySqlClient

Bob,

You just have to add 'My' in front of the objec t names, following will work :

ByteFX.Data.MySqlClient.MySqlCommand ByteFX.Data.MySqlClient.MySqlConnection Etc.

Assuming you have Imports ByteFX.Data.MySQLClient at the top of your page, use something like this :

Dim strSQL As String Dim objConn As New MySQLConnection(ConfigurationSettings.AppSettings("strConn")) Dim objCommand As New MySQLCommand() Dim objDR As MySQLDataReader

objConn.Open() objCommand.Connection = objConn

strSQL = "SELECT blah blah etc" objCommand.CommandText = strSQL objDR = objCommand.ExecuteReader

Do stuff with your DataReader (or another obejct)

objDR.Close() objConn.Close() objDR.Dispose() objConn.Dispose() objCommand.Dispose() objDR = Nothing objCommand = Nothing objConn = Nothing

-----Ursprüngliche Nachricht----- Von: Bob Achgill [mailto:BobA@hotmail.com] Gesendet: Samstag, 26. Juni 2004 11:36 An: win@lists.mysql.com Betreff: Re: Imports ByteFX.Data.MySqlClient

Thanks!

OK... I added a reference to both: ByteFX.MySqlClient ByteFX.MySqlClient.Design

That solved the error "ByteFX.Data.MySqlClient cannot be found."

But I still have some more syntax errors

Type "ByteFX.Data.MySqlClient.SqlCommand" is not defined. Type "ByteFX.Data.MySqlClient.SqlCommand" is not defined. Type "ByteFX.Data.MySqlClient.SqlConnection" is not defined. Type "ByteFX.Data.MySqlClient.SqlConnection" is not defined.

And so on...

----- Original Message ----- From: "Freddie Sorensen" <fred@parawebic.com> To: "'Bob Achgill'" <BobA@hotmail.com>; <win@lists.mysql.com> Sent: Saturday, June 26, 2004 11:45 AM Subject: AW: Imports ByteFX.Data.MySqlClient

Bob,

Did you add a reference to the component in your project ?

Freddie

-----Ursprüngliche Nachricht----- Von: Bob Achgill [mailto:BobA@hotmail.com] Gesendet: Samstag, 26. Juni 2004 08:53 An: win@lists.mysql.com Betreff: Imports ByteFX.Data.MySqlClient

I am trying to use ByteFX with VB.Net for accessing data in MYSQL. I am using Visual Studio 2003 on a WinProXP platform.

After running the install for ByteFX and putting the subject line of code at the top of my progrom ... I get the syntax error:

"ByteFX.Data.MySqlClient cannot be found."

Thanks,

Bob Achgill

-- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/win32?unsub=BobA@hotmail.com

-- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/win32?unsub=fred@parawebic.com