Hi all,

To connect a database which one of the following should I use:

"Driver={SQL Server};DSN=;SERVER=" & SERVER &
";UID=" & UID & ";PWD="
& PWD & ";DATABASE=" & DATABASE & ";"


"Provider=SQLOLEDB.1;Persist Security
Info=False;AutoTranslate=no;User ID=" & UID &
";Password=" & PWD
& ";Initial Catalog=" & DATABASE & ";Data
Source=" & SERVER

Knowing that the application is client/server, that users have W95, W98, W2K and that the database is in SQL Server 7.0 SP3.

Thanks in advance.

God Bless.

use the first one

Why?