| Sue Hoegemeier 2006-03-28, 3:23 am |
| You can't program one that will store a user name and
password.
Other approaches are to use windows authentication instead
of SQL logins, use DSN-less connections, connection strings
instead of DSNs.
-Sue
On 22 Mar 2006 09:16:19 -0800, shubtech@gmail.com wrote:
>I am trying to use Delphi to create a DSN programatically using the
>SQLConfigDatasource function and that seems to work fine.
>
>However when I try to create a DSN using a specific user name and
>password it does not work.
>
>Is there a way to create a DSN with a user name and Password?
>
>What I am trying to achieve is to connect to a database using a
>particular user name and password that has rights to update data and
>since this application can be run by many different client computers I
>want to avoid setting up the ODBC manually for all the client
>computers. I am using TADOConnection if there is any other way to
>achive this task without having to mess around with all the client
>computers that is welcome.
>
>
>Any help in this regard will be greatly appreciated.
>Thanks
|