How to create DSN using asp.net?

  • Thread starter Thread starter Shibu
  • Start date Start date
DSNs can be created by using the COM-based ODBC API. These are a bit tough
to use and somewhat erratic. However, in an ASP.NET environment I would not
recommend doing so. Accessing a file-based DSN can also be problematic if
you don't setup correct file permissions. I would recommend a DSN-less
solution where the connection string contains all of the needed connection
information. See Carl Prothman's "Connection Strings" site for examples.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Hi William,
Thanks for your reply... I have a requirement, where I have to create a DSN
Manager for some other application
using a supporting tool created in ASP.NET. Can you please tell me any
article links or any more info regarding
the usage of COM-based ODBC API.

Thanks
Shibu
 
I discussed this years ago in the 4th and (perhaps) 5th edition of my book
"Hitchhiker's Guide to Visual Basic and SQL Server". Another resource is the
ODBC SDK although it's kinda tough to decipher.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Back
Top