Database Connectivity using DSN

[Arun K]

Hi,
I need to connect to SQL server Database using a System DSN. Can anyone
tell me how to connect to SQL Server using DSN in ASP.NET (VB.Net).
Using a Try Catch block.

Does anyone know how to create a "filename.DSN" file. I know how to
create a system DSN, but my N/W admin has asked me to create a DSN file
to send him. which would be a file name with ".DSN" extension.

thanks in advance.

 

[Natty Gur]

Hi,

The following link explained how to do it. but I cant see why to use
oledb/odbc when you can use SQLclient namespace to access SQL server
natively.

http://www.devasp.com/samples/dsn_sql.asp

Natty Gur[MVP]

blog : http://weblogs.asp.net/ngur
Mobile: +972-(0)58-888377