sql server odbc: SQLConfigDatasource with user name and Password -- sql server odbc

SQLConfigDatasource with user name and Password

shubtech NO[at]SPAM gmail.com
3/22/2006 9:16:19 AM

sql server odbc:

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

Re: SQLConfigDatasource with user name and Password

Sue Hoegemeier
3/27/2006 8:32:34 PM

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

[quoted text, click to view]

Re: SQLConfigDatasource with user name and Password

shubtech NO[at]SPAM gmail.com
4/7/2006 10:59:21 AM

Thanks for your response, I am not sure what you mean by DSN-less
connections. Also, do you have an example of connection string? I am
not sure if I completely understand.
Thanks

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server odbc group.