i have received a driver to connect with a legacy database.
after i have installed the driver on the server box, i managed to import some tables using data transformation services (DTS). but when it comes to create a connection to the server linked server then it is a different result, it simply does not work.
as i am not an expert in MS SQL 2k, i am asking you for help!
on DTS (on Enterprise Manager), i do the following:
click on data transformation services -> right click on local packages -> choose 'new package'
on the new windows, i do the following:
i choose other connections ->
a pop-up appears asking for connection details and i enter the following details:
new connection: newConnectionName
data source: MSM-SQL/ODBC 32 bit Driver
user/system dsn: MSM-SQL 32 bit
but when i try to use the details above in the 'linked server' section i receive an error that says:
error 7399: OLE DB provider 'MSDASQL' reported an error. Data source name not found and no default driver specified.
could i please ask for assistance in sorting this issue?
many thanks in advance for your input!