Very Computer

I am using VB 5 to connect to a Sybase SQL Server data source....

Does anyone know of a way to login to a Sybase SQL Server (system 10
on Netware) without entering a UID or PWD in to the connection string
when using DAO or RDO. The ODBC driver setup for this SYBASE data
source allows us to store a User ID and Password in the DSN. So, we
wanted to create our logins without using this in the code. We want to
be able to change the DSN UserID and Password and not have to go back
and recompile our VB app. Any suggestions would be helpful.

Please email to me directly as well as post to the group. Sometimes I
can't get access to my news server, but email seems reliable.

Kevin Simmers

Quote:>I am using VB 5 to connect to a Sybase SQL Server data source....

>Does anyone know of a way to login to a Sybase SQL Server (system 10
>on Netware) without entering a UID or PWD in to the connection string
>when using DAO or RDO.

If your question is whether or not there is a way to retrieve the user
ID from Novell, yes, there is. With password you are going to have
major difficulties, though.

Quote:>The ODBC driver setup for this SYBASE data
>source allows us to store a User ID and Password in the DSN. So, we
>wanted to create our logins without using this in the code. We want to
>be able to change the DSN UserID and Password and not have to go back
>and recompile our VB app. Any suggestions would be helpful.