Stanley Lai

<div>
Thanks RobSampson for your quick and direct solution. &nbsp;Really appreciated ^^
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Since our company still have an old client server application which still in use today by many users. &nbsp;Yet, the problem is that, this client server application need to setup quite a number of user ODBC DSN before it can be used. &nbsp;I'm wonder whether I can write a script or batch and make it to run once when user login. &nbsp;If those user ODBC DSN are missed, it will create automatically.<br />
<br />
Can this can be automated?<br />
<br />
Kindly please help<br />
<br />
Stanley
</div>
</div>


Hi,

Since our company still have an old client server application which still in use today by many users.  Yet, the problem is that, this client server application need to setup quite a number of user ODBC DSN before it can be used.  I'm wonder whether I can write a script or batch and make it to run once when user login.  If those user ODBC DSN are missed, it will create automatically.

Can this can be automated?

Kindly please help

Stanley

How to use VB script or batch file to create User ODBC DSN?

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.