<div>
suni's code might/should work - when the user was logged on as a system administrator.<br />
<br />
Alternatively,<br />
a) run a VB DLL under an administrator's account, using MTS<br />
b) use a DSN-less connection.
</div>


suni's code might/should work - when the user was logged on as a system administrator.

Alternatively,
a) run a VB DLL under an administrator's account, using MTS
b) use a DSN-less connection.

<div>
or simply just use a free asp component to create DSN on the fly. &nbsp;Checkout this site: <a href="http://www.alphasierrapapa.com" rel="ugc">www.alphasierrapapa.com</a>, look for asp component list.
</div>


or simply just use a free asp component to create DSN on the fly.  Checkout this site: www.alphasierrapapa.com [http://www.alphasierrapapa.com], look for asp component list.

<div>
It is using RDO, can you give me a sample in ASP ? Thank you for your answer.
</div>


It is using RDO, can you give me a sample in ASP ? Thank you for your answer.

<div>
<div class="content wysiwyg-content">
I'm wondering how to create a DSN over a browser ? I've seen a web hosting company gives a service to his client to create a DSN connecting to SQL Server. The client can create the DSN himself from a browser. Any ideas would be great.
</div>
</div>


I'm wondering how to create a DSN over a browser ? I've seen a web hosting company gives a service to his client to create a DSN connecting to SQL Server. The client can create the DSN himself from a browser. Any ideas would be great.

Create DSN using ASP

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.