NotesSQL to SQL2000 issues

[ik646]

Good afternoon, All.

I want to transfer databases from our legacy Domino server to SQL2000. I have configured NotesSQL v2.06 on a WinXP box, set up the ODBC driver, and installed and configured Notes client v4.6. When I configure my SysDSN, I am prompted for a password and am given a list of servers and *.NSF files. If I attempt to use that DSN to create a linked server in SQL Enterprise Manager, the MMC snap-in times out. If I attempt to use a newer version of NotesSQL(3.02f), my linked server gives an error.

Has anyone ever been successful in linking a Domino and SQL server?

 

[yksvaan]

Why do you have to create a linked server definition ? Couldn't you use dts Transform Data Task ?

Cheers


[blue]Backup system is as good as the latest recovery[/blue]