sql server odbc: I'm trying to import to SqlServer(2000) from a Sybase ODBC(12) connection. I
can use the Sybase connection with appps like MSAcess, and Crystal reports,
but I can't get SqlServer to use that same ODBC connection to Sybase. I get
"no provider exits for this connection on this computer".

Thank you for helping in advance.

Mike,
Are you sure that your data source is System DSN, not a User DSN ?
And I think account you using for run MS SQL must have corresponding rights
to access this DSN.

M> I'm trying to import to SqlServer(2000) from a Sybase ODBC(12)
M> connection. I can use the Sybase connection with appps like MSAcess,
M> and Crystal reports, but I can't get SqlServer to use that same ODBC
M> connection to Sybase. I get "no provider exits for this connection
M> on this computer".

Igor Shekalev, http://www.sqledit.com, SQL editor with ODBC support