How to create DSN using asp.net ?

[Shibu]

Hi,
Can anyone tell me how to create a DSN from asp.net..

Thanks
Shibu

 

[Guest]

Hi Shibu,

Are you trying to create a DSN to use with an ASP.NET application? If so,
you'll want to use data connection strings instead. Lots of samples here:

http://www.able-consulting.com/dotnet/adonet/Data_Providers.htm#ODBCManagedProvider

 

[Shibu]

Hi Ken,
I have specific requirement to creat DSN in a server from ASP.NET. But
the DSN is going to be used by some other kind of application in a different
technology other than .NET. Is there a way to create DSN using ASP.NET..

Thanks
Shibu

 

[Guest]

It looks like you'll have to poke around with SQLConfigDataSource in
odbccp32.dll

How To Create ODBC Data Sources Using SqlConfigDataSource

http://support.microsoft.com/default.aspx?scid=kb;en-us;142216

http://www.tek-tips.com/faqs.cfm?fid=301

The ASP.NET account or its impersonator is going to need wide security
permissions to do this.

 

[Shibu]

I am going to try using SQLConfigDataSource in odbccp32.dll .. As you
said, it might require extra security privileges.
Can you please tell me the type of security permission it might require? Do
I need to give permission to ASPNET user specific to this odbccp32.dll . If
so how can I do it..

Thanks
Shibu

 

[Ken Cox [Microsoft MVP]]

You'll probably want to create a special Windows NT account for that task
and then use impersonation in the ASP.NET page.

This page has info on how to do that and code samples:

http://support.microsoft.com/default.aspx?scid=kb;en-us;306158#2

 

[Shibu]

Hi Ken
It worked.. Thanks for your help..

Shibu

You'll probably want to create a special Windows NT account for that task
and then use impersonation in the ASP.NET page.

This page has info on how to do that and code samples:

http://support.microsoft.com/default.aspx?scid=kb;en-us;306158#2