ASP.NET Connection String Error

Question

I used this connection to run my SQL query, but it did not work and sent this error:

Keyword not supported: 'dsn'

This is my connection:

public static string CnnStr = @"Dsn=Server;uid=kity;app=Microsoft® Visual Studio® 2010;wsid=kity;database=Server;trusted_connection=Yes";

This connection works for me in my datalist, but for my behind code it gives me this error. II should say that I used ODBC connection to database.

could you provide us the text that Exception throws – Deeptechtons Oct 15 '11 at 07:22 — Deeptechtons, Oct 15 '11 at 07:22
Which database product you are using? – KV Prajapati Oct 15 '11 at 10:04 — KV Prajapati, Oct 15 '11 at 10:04

score 0 · Answer 1 · answered Oct 15 '11 at 08:06

0

create any .udl file

press enter on it

detect your data source and copy and paste you Connection String in the asp.net code

answered Oct 15 '11 at 08:06

Royi Namir

I do this and this connection string is the exact that copy of string but i dont know why it does not work,it works when i use in sqldatasource but when i use it as a code in code behind it shows me that error – Katy J Oct 15 '11 at 11:05

score 0 · Answer 2 · edited May 23 '17 at 12:27

0

Try adding a value for providerName=System.Data.Odbc into the connection string.

Like this:

@"Dsn=Server;uid=kity;app=Microsoft® Visual Studio® 2010;wsid=kity;database=Server;trusted_connection=Yes;providerName=System.Data.Odbc;"

If that doesn't work, take a look at the same question in different situations:

Note: the "Keyword not supported: ..." error usually comes from an incorrectly formatted connection string.

edited May 23 '17 at 12:27

Community

answered Oct 15 '11 at 21:10

Gibron

I try providerName=System.Data.Odbc but It doesn't work too and gives me same error – Katy J Oct 16 '11 at 06:09

2 Answers2