Angelo
Thanks for this - I have now loaded a new ODBC driver. In SQL 2005 you
need to build the connection string (I am using the .net framework Data
Provider for ODBC). Here is what I have at the moment:
Driver={IBM UniData ODBC Driver};provider=Ardent.UniOLEDB;data
source=servername;location=databasename;user id=odbc;password=password
Does anyone have a successful connection string which works with SQL
2005 SSIS?
Thanks
graham
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Angelo Collazo
Sent: Wednesday, June 21, 2006 4:40 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Unidata 6 into SQL 2005
Graham,
If you are running your U2 database under Windows, You can download the
CLIENT(s) and use the native U2 ODBC drivers. See this link:
http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=u2trial
s&S_
TACT=105AGX11&S_CMP=DNLD
If your are running under UNIX you to purchase one. Two I know of.
1- http://www.easysoft.com/
2- http://www.datadirect.com/index.ssp
3- Open source (http://www.mysql.com/) and search for ODBC. Two versions
UNIX(AIX/HP/Others) and Linux unixODBC)
May the force be with you.
Cheers,
Angelo Collazo
System Administrator
Silver Line Building Products Corporation
One Silver Line Drive
North Brunswick NJ, 08902
[EMAIL PROTECTED]
Ph: 732.435.1000 X4495
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, June 21, 2006 9:22 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] Unidata 6 into SQL 2005
Does anyone have any advice for which odbc drivers are best for
importing Unidata data into a SQL 2005 database?
Thanks
Graham
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall
Sent: Tuesday, June 20, 2006 2:25 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] .net - universe 10.1.14
Redback and .Net work perfectly together. I've used it in a variety of
applications using both C# and VB.Net. Full power of .Net is available
as
Redback simply makes U2 available. You can build a Data Access Layer
where
U2 looks like any other database to .Net.
If you are from the .Net/SQL world, you can access your Universe data
via
ADO same as other databases. If you are not an ADO guru, Redback
provides
its' own more U2 friendly commands to also access the Universe data and
programs.
You have total freedom in deciding how much or how little of your
business
logic to be in U2 or .Net.
Unlike like some of the other offerings, Redback is not a 'do something
on
the web for the U2 programmer' type of application. It is a true
enabler
to allow you to use U2 with the web and do whatever you can do in your
web
technology of choice.
Mike.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney
Sent: Tuesday, June 20, 2006 3:30 AM
To: U2-Users (E-mail)
Subject: [U2] .net - universe 10.1.14
Apologies I asked this before then went on tour for 3 weeks and my
wonderfull staff cleared by emails
So
I am looking to tie Universe 10.1.14 to a .net development
I am looking at biztalk and redback and one other piece of software to
facilitate this
Any experiences/opinions will be gratefully received (and read this
time)
Bob Witney
IT Senior
EXPLORE!
Nelson House
55 Victoria Road
Farnborough
Hampshire
GU14 7PA, UK
Tel: 01252 379489
Mob: 07973 451156
www.explore.co.uk
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
