Problem with using odbc connection

[MTarkington]

Good afternoon,

I am using SQL Server 2005 and Cache v5.

I am trying to import tables from Cache into SQL Server. I have worked with this before, but the last version of SQL I used was more friendly.

I cannot find a way for the import wizard to see the Intersystems Cache ODBC connection.

Is there an option that I've missed, or is there something extra I need to do so SQL will see the ODBC connection?

TIA,
Mark

 

[FlashMerlot]

This is only a guess, but, what type of DSN are you creating? User, System, File ... and is the DSN actually resident on the same physical box running the SQL Server?

 

[MTarkington]

I have created a System DSN and it is resident on the physical box...

Thanks,
Mark