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

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

[Tom Shelton]

On Fri, 25 Jun 2004 23:56:56 -0700, Bob Achgill wrote:

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?

--
Tom Shelton [MVP]

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

-----Original Message-----
On Fri, 25 Jun 2004 23:56:56 -0700, Bob Achgill wrote:

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?
--
Tom Shelton [MVP]
.

[Herfried K. Wagner [MVP]]

* "Bob Achgill" <an*******@discussions.microsoft.com> scripsit:

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.

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>

[Tom Shelton]

On Sat, 26 Jun 2004 02:37:54 -0700, Bob Achgill wrote:

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.

--
Tom Shelton [MVP]

[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

-----Original Message-----
On Sat, 26 Jun 2004 02:37:54 -0700, Bob Achgill wrote:

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 thesame directory with the ByteFX.Data.MySqlClient.dll. You can also look atthe object browser to see the names of the actual classes.
--
Tom Shelton [MVP]
.