http://forums.asp.net/t/328921.aspx/1?How+to+add+ByteFX+Data+Provider+and+let+it+run+properly+Mon, 03 Nov 2003 20:03:45 -0500328921328921http://forums.asp.net/p/328921/328921.aspx/1?How+to+add+ByteFX+Data+Provider+and+let+it+run+properly+ 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? 2003-09-04T02:31:44-04:00332109http://forums.asp.net/p/328921/332109.aspx/1?Re+How+to+add+ByteFX+Data+Provider+and+let+it+run+properly+ 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. 2003-09-08T00:55:50-04:00373019http://forums.asp.net/p/328921/373019.aspx/1?Re+How+to+add+ByteFX+Data+Provider+and+let+it+run+properly+ 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. 2003-10-22T07:28:03-04:00383838http://forums.asp.net/p/328921/383838.aspx/1?Re+How+to+add+ByteFX+Data+Provider+and+let+it+run+properly+ 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 2003-11-03T20:03:45-05:00