Connecting By ODBC - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Connecting By ODBC

Author

Topic

sparrow
Starting Member

20 Posts

Posted - 2008-06-08 : 22:29:11

I'm using the import/export wizard and are trying to connect to another systems database Views and getting the following error

Cannot get the supported data types from the database connection “Dsn = TMS Live:Driver ={JADE ODBC Driver 6.1}

Additional information:
Unknown SQL type – 128.(system.Data)

I think the problem is that the system i'm trying to connect to is an object based system rather than relational based, hence having to import the views rather than tables

I am able to connect using the same DSN/driver in DTS SQL2000 which we currently use, but want to be able to move to 2005.

Any ideas on how i can connect?

Cheers

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-08 : 22:34:06

Then you should check with vendor to get new driver for sql2k5.

sparrow
Starting Member

20 Posts

Posted - 2008-06-08 : 22:45:20

Makes sense

I'll go back to them as have been getting little help from them, so wasn't really sure where the issue lay

Cheers

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources