Imports problem with ByteFX

[Bob Achgill]

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."

Hmmm??

Thanks,

Bob Achgill

 

[Bob Achgill]

This is the line of code that did not work...

Imports ByteFX.Data.MySqlClient

 

[Tom Shelton]

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."

Hmmm??

Thanks,

Bob Achgill

Did you add a reference to the ByteFX.MySqlClient.dll to your project?

 

[Bob Achgill]

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...

 

[Herfried K. Wagner [MVP]]

This is the line of code that did not work...

Imports ByteFX.Data.MySqlClient

After adding the reference, you can check the classes contained in the
library using the object browser.

 

[Tom Shelton]

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...

Thats because it's MySqlConnection, MySqlCommand, MySqlDataAdpater, etc...

There is a help file installed with the dataprovider. It should be in the
same directory with the ByteFX.Data.MySqlClient.dll. You can also look at
the object browser to see the names of the actual classes.

 

[Bob Achgill]

Thanks!

I was missing a "My" on the front of each object.

For example
ByteFX.Data.MySqlClient.SqlCommand

Should be
ByteFX.Data.MySqlClient.MySqlCommand


Bob