Hi, I have copied the .dll file which download from sourceforge web site for the new release data provider. I put it in my project folder, and then add a reference to it. But when i run the project, the ByteFX can not be found (error). But later i change the
location to put in the bin folder then the ByteFX problem solved but another problem arise -assembly system can not be found. I am successfully put the namespace "Imports ByteFX.Data.MySqlClient". If i not add the command "dim mycon as new MySqlClient(myconstring)",
the project run perfectly alright, but when i add this command, then the problem above occur. Why?
I think you probably got that wrong. what you should do is: ' Creates a connection to the MySQL database, assuming myconstring ' is the connection string. Dim mycon As New MySqlConnection(myconstring) ' SQL Statement Dim SQLString As String = "SELECT * FROM
table" ' Creates the ADO.NET command object Dim mycmd As New MySqlCommand(SQLString, mycon) ' Creates a dataset object to hold the query Dim ds As New System.Data.Dataset() ' Creates the ADO.NET data adapter Dim myadp As New MySqlDataAdapter(mycmd) ' Fill
the dataset with the values from query myadp.Fill(ds) Alternatively, if you SQL statement does not return a result, you can skip the dataset and data adapter part and call the mycmd.ExecuteNonQuery() command. Hope it helps and it's not too confusing.
I got the same problem ,when i used the ByteFX Data Provider.The Problem is that,you must have downloaded latest Bytefx Version(0.70,0.72),which was developed by using .NET 1.1.i have used ByteFX version .68 it is working fine.you can use ildasm tool to verify
which version of system namespace your Bytefx is using.
Hmmmmm....I followed the above instructions verbatim.... So, what is wrong with this ? I keep on getting an "Object Reference not set to an instance of an object" error...but it is set !! Dim MyConnection As New MySqlConnection("data source=myDSN") Dim MyCommand
As New MySqlCommand("SELECT * FROM users", MyConnection) Dim ds As New System.Data.Dataset() Dim MyAdapter As New MySqlDataAdapter(MyCommand) MyAdapter.Fill(ds) And it fails here... Any ideas ? TIA, FP
florencelee
Member
215 Points
45 Posts
How to add ByteFX Data Provider and let it run properly?
Sep 04, 2003 02:31 AM|LINK
best regards,
florence
g33k
Member
95 Points
19 Posts
Re: How to add ByteFX Data Provider and let it run properly?
Sep 08, 2003 12:55 AM|LINK
protegesolut...
Member
30 Points
6 Posts
Re: How to add ByteFX Data Provider and let it run properly?
Oct 22, 2003 07:28 AM|LINK
Flatpass
Member
10 Points
2 Posts
Re: How to add ByteFX Data Provider and let it run properly?
Nov 03, 2003 08:03 PM|LINK