Hello,

I get the following error message from DTS when attempting
to connect to an ODBC datasource:

"A serious error occured when connecting to the provider"

The ODBC driver that I loaded onto the server computer
(same computer that contains Sql Server) works fine when I
connect to the provider through Microsoft Access (on the
same server computer). I created a DSN in
ControlPanner/ODBC... works fine in Access. When I use
DTS I get the error.

In DTS I select the ODBC driver (which shows up in the
datasource window), then I select User/System DSN and pick
the DSN I created for this ODBC driver in Control Pannel,
I add the UserID/Password, when I click on Next, I get the
error message above. I tried creating a new system DSN
from the New button in DTS, but still get the same error
message. I also tried selecting "Other ODBC data source"
from the Data Source window in DTS and then selecting the
DSN I created in Control Pannel. Still get the error
message above. Is this a configuration problem that I
need to fix in Sql Server? or is it possible that Sql
Server just does not support this ODBC driver?