How to create DSN using asp.net?

[Shibu]

Can anybody tell me, how to create DSN dynamically using ASP.NET

Thanks
Shibu

 

[William \(Bill\) Vaughn]

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.
__________________________________

 

[Shibu]

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

 

[William \(Bill\) Vaughn]

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.
__________________________________

 

[Paul Clement]

¤ Can anybody tell me, how to create DSN dynamically using ASP.NET
¤

See the following:

http://makeashorterlink.com/?D11F52679


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)