I have a system DSN.How to connect to the database in asp.net using DSN.I wanted the Connection String
-
2Did you try connectionstrings.com ?Fredrik Mörk– Fredrik Mörk2011-02-28 10:42:54 +00:00Commented Feb 28, 2011 at 10:42
-
Ya but i am not getting the exact oneuser628347– user6283472011-02-28 10:44:19 +00:00Commented Feb 28, 2011 at 10:44
-
use connectionstring to obtain the connectionstring and put them in web.config. intialize them in code and open the connection. were are you got problem. ASP.NET website have many video on them. you can watch any for learn.user605334– user6053342011-02-28 11:04:55 +00:00Commented Feb 28, 2011 at 11:04
Add a comment
|
2 Answers
Check out the link , has both DSN and DSN less ODBC connectivity using ADO.Net http://www.easysoft.com/developer/languages/csharp/ado-net-odbc.html
Comments
One way of finding out the connection string is to create a connection in Server Explorer in Visual Studio, then check the properties of the connection and you will see a Connection String property that will give you what you need.
4 Comments
user628347
but when i use that it says dsn is not a keyword.whats wrong with it?
Mantorok
Is this when you try to connect via code? Could you post it on here in that case?
user628347
string consql = "Dsn=databse;uid=sa;pwd=wtl@123!;" The error which i get is below Keyword not supported: 'dsn'
Mantorok
Can you post the rest of it? Particularly the connection class you are using.