kamiseq <hok...@o2.pl> wrote on 02/06/2006 07:30:07 AM:
ok, i just changed "OPTION" to "PORT" and it is working:]
string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" +
"SERVER=localhost;" +
"DATABASE=test;" +
"UID=root;" +
"PASSWORD=dbhaslo;" +
"PORT=3309";
siemka
If you still want to use OPTION= in your connection string, add it. A
connection string is a sequence of "name=value" pairs separated by
semicolons. There is nothing special about the order you put them in. You
were using "OPTION=3" before the change so you can still use it now:
string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" +
"SERVER=localhost;" +
"DATABASE=test;" +
"UID=root;" +
"PASSWORD=dbhaslo;" +
"OPTION=3;"
"PORT=3309";
make sense?
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
3 messages in com.mysql.lists.dotnetRe: connection to mysql via .Net port...