mysql problem

[Dirk Reske]

Hello,

I'm using the bytefx.data library to connect to a mysql server:

string ConnectionString = "Server=localhost;Database=test;User
Id=Freak;password=freak;";
IDbConnection dbConn;
dbConn = new ByteFX.Data.MySqlClient.MySqlConnection(ConnectionString);
dbConn.Open();

I get an NullReference exception when I call the Open() member?
does anyone know why?

thx

 

[Alvin Bruney]

It should be

UID=userid;PWD=pwd";

instead of User

 

[Sunny]

Hello,

I'm using the bytefx.data library to connect to a mysql server:

string ConnectionString = "Server=localhost;Database=test;User
Id=Freak;password=freak;";
IDbConnection dbConn;
dbConn = new ByteFX.Data.MySqlClient.MySqlConnection(ConnectionString);
dbConn.Open();

I get an NullReference exception when I call the Open() member?
does anyone know why?

thx

What kind of exception? If that solution is based on MyODBC, there are
some problems with older versions of MySQL.
Or you may try the native .net classes, provided by MySQL:
http://www.mysql.com/articles/dotnet/index.html

Sunny