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.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

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


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!