dsn/dsnless connection string

[gusset]

i have been told to use ODBC instead of a dsnless connection string as it is safer.

is this true? what danger is presented by using a dsnless connection string?

thanks

gusset

 

[SQLRickster]

If you use a DSN less connection string the ODBC drivers for the client or the database you are connecting to can change which will cause an error. It is safe to use DSN less connection as long as the drivers stay compatable.

Rick

 

[gusset]

thanks. rickster. it is an ms sql server database. i can't imagine that there would ever be this type of error in the future as ms is responsible both for vb and ss.

the people who maintain our database suggested that using a dsnless connection could present a danger for the database, not for my app. is this the kind of error that you meant?

thanks

gusset