This is a Long shot (IBM/Rocket U2 and SQL connection)

• Vertigo44

  SSCarpal Tunnel

  Points: 4055

  More actions

  March 24, 2011 at 1:35 pm

  #235589

  I am mainly a DBA not a developer however a situation has come up where we could like to be able to import data from this U2 UniVerse Database system to SQL Server or atleast look at the data using BIDS. I can't seem to be able to find the ODBC / OLEDB driver to make this work and actually don't even know how to set up the connection or whats involved. Any help would be greatly appreciated!

• stevefromOZ

  SSC-Forever

  Points: 43646

  More actions

  March 24, 2011 at 2:26 pm

  #1303233

  Haven't used it but the following link is an (old-ish) ODBC handbook for it, so you may find some pointers there. The whole multivalue may be problematic if the SQL tools aren't set up to handle it.

  Steve.