keyword not supported error

Question

User-763776826 posted

when i connect my asp.net application with the mysql 5.1 then an error occur:---in connection string:-ArgumentException was Unhandled by user code keyword not supported .parameter name :dsn.............plz can anybody tell me the solution of it:

Thanks in advance

manisha walia

Answer 1

User1642208711 posted

Check here for different types of connectionstrings for MySql in .Net. http://www.connectionstrings.com/mysql

The error shows that there shouldn't be a attribute named dns in the connection string. Try to remove the attribute dns from connection string if any. And follow any one of the connection strings provided in above link.

Answer 2

User500621135 posted

Connection string

Local database

Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=myDataBase;User=myUsername;Password=myPassword;Option=3;

 

 

Remote database

Driver={MySQL ODBC 5.1 Driver};Server=myServerAddress;Database=myDataBase;User=myUsername;Password=myPassword;Option=3;

 

 

Specifying TCP/IP port

Driver={MySQL ODBC 5.1 Driver};Server=myServerAddress;Port=3306;Database=myDataBase;User=myUsername;Password=myPassword;Option=3;

The driver defaults to port value 3306, if not specified in the connection string, as 3306 is the default port for MySQL.

 

Specifying character set

Driver={MySQL ODBC 5.1 Driver};Server=myServerAddress;charset=UTF8;Database=myDataBase;User=myUsername;Password=myPassword;Option=3;

 

 

Specifying socket

This one specifies the Unix socket file or Windows named pipe to connect to. Used only for local client connections.

Driver={MySQL ODBC 5.1 Driver};Server=myServerAddress;Database=myDataBase;User=myUsername;Password=myPassword;Socket=MySQL;Option=3;

On Windows, the socket variable is the name of the named pipe that is used for local client connections. The default value is MySQL.

On Unix platforms, the socket variable is the name of the socket file that is used for local client connections. The default is /tmp/mysql.sock.

 

Using SSL

Driver={MySQL ODBC 5.1 Driver};Server=myServerAddress;Database=myDataBase;User=myUsername;Password=myPassword;sslca=c:\cacert.pem;sslcert=c:\client-cert.pem;sslkey=c:\client-key.pem;sslverify=1;Option=3;

SSLCA specifies the path to a file with a list of trust SSL CAs

I hope this help ........... If you face more problem then email me [e-mail]

see also this link

http://www.connectionstrings.com/mysql#p31

Answer 3

User-763776826 posted

not working....another error occur which is:-

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ...plz tell me how to solve it...........

thanks

Answer 4

User500621135 posted

you have to be use

using system.data.odbc;

Answer 5

User-763776826 posted

i have already use it.

Answer 6

User500621135 posted

if there create problem you have to be add as a aweb refrence (data.odbc)

Answer 7

User-763776826 posted

How can i make Dll from a class in c#....plz explain the steps .....

Thanks & regards:-

Manisha Walia

Answer 8

User500621135 posted

Administrative Tools --> Data Sources (ODBC) --> Create a connection

In Visual Studio --> Open your server browser and then create a new connection.

Select the connection type as Microsoft ODBC Data Source (ODBC)

Select the radio button for Using Connection String, Select Machine Data Source and

the select your data source you just created.

You can just copy this string and paste it in to your web/app.config file.

Answer 9

User-763776826 posted

 have done it .... but not working....but i have done it without odbc ...pls tell me how to make dll of my class....Thanks

Answer 10

User500621135 posted

dear

the way that i tell you it's a way

this time you do with odbc

try

if this not worked then u have be show your code

then, i can do someting for u?

Answer 11

User500621135 posted

dear

the way that i tell you it's a way

this time you do with odbc

try

if this not worked then u have be show your code

then, i can do someting for u?

Answer 12

User500621135 posted

see this link i hope this link also helps

Answer 13

User-763776826 posted

pls tell me how i can covert my class into dll.

Answer 14

User500621135 posted

yaaar kyu maze le rahe ho....... iska solution yahi hai......

i think you wanna make my fun 

if not then re-install all software under a perfectionalist

Answer 15

User500621135 posted

see below link

http://forums.asp.net/t/1215601.aspx/1 

http://www.evdenevenakliyatbul.com

new Projects >> class library >> add reference >> add reference >>>>>>>>>>>>> using System.Data.SqlClient; using System.Web; Projects run C:\Documents and Settings\Senol\Belgelerim\Visual Studio 2005\Projects\free\free\bin\Debug\free.dll

Answer 16

User500621135 posted

See tis link then This Helps

Do It now

http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/4ac99b36-c512-45d2-8b30-8a70ce8e5b3e/