Answer 1

Hi Joel,

Did you ever figure this out?  I'm having a similar issue, a UniData db that I need to get into either Access or SQL.  I've been unable to locate an ODBC driver for Unidata.

Thanks for any insight you can provide!

Jeremy

Answer 2

You will always needs a ODBC driver in the machine you are running SSIS, so your desktop and probably the server later on as well.

If you can see teh driver in the Data Sources (DSN) stuff from Control Panel,l then you should be fine.

You then need to choose the correct connection manager type in SISS, that allows you to select DSN or eneter a ODBC connection string. You can use the ODBC connection type or the ADO.NET connection, where you can choose the .Net ODBC Data Provider.

Answer 3

Answer 4

Sorry, I assumed you where asking in a SSIS related manner. If you do not have the driver, have you tried IBM or an IBM forum?

If possible I'd recommend using an OLE-DB provider over ODBC, the support in the MS world is better. According to the IBM site, both are available. Is there not a client install or driver install available as part of the main software media?

Answer 5

Answer 6

I don't have a unidata dba...I have a client company with a unidata database that I'm trying to convert into my firm's SQL database.  They don't have their client CD's, and I don't have a relationship with IBM that would allow me to get a copy.

I'm aware of the Google results; that's how I found this thread to begin with.  None of the results pointing to 3rd party drivers went to viable companies that still offer the driver.  Honestly, I wasn't posting here because I thought I had an SSIS issue, I was posting in response the the original poster who seemed to have an ODBC driver.  If you know of someone that offers a usable driver, that's really all I'm looking for.

Thanks!

Answer 7

Darren, yes, I've tried IBM as much as I'm able since I'm not an IBM customer (see my other post) but can't find a driver I can access.  I'll happily take OLE-DB or ODBC...not picky, just need to get into the data! :-)  My client doesn't have their media and say they can't get copies since the originally contracted their install from yet another company.  What I'm ultimately needing is probably a 3rd party driver or a legitimate path to an IBM one...I've just been unable to locate one.

Thanks!

Answer 8

Answer 9

Answer 10

Answer 11

Answer 12

FWIW, I've been working w/ unidata myself from an older SQL 2000 machine.  All I can really tell you about are the configuration settings that I've had to work with to connect to an existing unidata server.

On my SQL server (which already had the unidata drivers installed, can't help you with that, although I'm now looking for newer OLE DB / .Net drivers), I've got a linked server of the type Microsoft OLE DB Provider for ODBC drivers.  When I script that, it looks like the following:

EXEC master.dbo.sp_addlinkedserver @server =N'UNIDATALINK', @provider=N'MSDASQL', @datasrc=N'EXEODBC', @catalog=N'EXCUNIODBC'

master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'UNIDATALINK',@useself=N'False',@locallogin=NULL,@rmtuser=N'<DOMAIN>\<USERNAME>',@rmtpassword='<domain password>'

On my server, in C:\Informix\UniClient\Config folder, I've had to modify the uci.config file when we migrated the unidata server to a new machine.  I think there's a UniAdmin tool or something which effectively modifies this file.  Inside that file, I have the following entry:

[ODBC DATA SOURCES]

<EXEUNIODBC>
DBMSTYPE = UNIDATA
NETWORK = TCP/IP
SERVICE = udserver
HOST = <unidata server name>

And within the server's ODBC settings, I have a System DSN named EXEODBC  (the "EXE" is part of the name of the database used in my scenario, it has no other significance) of type Informix UniData ODBC who's server name is, again, EXEUNIODBC, has a database name specified as "EXCUniODBC" that I guess matches with the actual unidata server.  It has a user(name) specified, but I don't think the one here is relevant.  In the ODBC Drivers tab, on this old sever, the driver version shows 3.01.01.00, UDTODBC.DLL dated 9/6/2001.

The linked server specified above once used a unidata-specific login of some sort, but I recently changed it to use a windows account.  Using the SQL "use existing credentials" option never worked, but entering the login manually did. 

I've been able to run queries against this linked server as follows (connecting to the SQL server, which specific local database you're connected to doesn't matter until you want to start moving the data over).

exec master..sp_tables_exN'UNIDATALINK',null,null,null,'''VIEW'''
exec master..sp_tables_exN'UNIDATALINK',null,null,null,'''TABLE'''

or

select

*
into SomeNewSQLTable
fromOPENQUERY( UNIDATALINK ,'select * from SOMETABLE where NAME = ''fred''')

Answer 13

hi mtbnumber7

did you ever find a solution to this. I am currently trying to set up a linked server in sql server 2008 r2 to Unidata database. Trying various drivers without much luck.

thanks

G