Angelo One of my friends at VMARK UK has unearthed a couple of IBM articles on setting up ODBC with UniData on UNIX: one for Merant and one for EasySoft.
I'll forward these to you off-list. Brian > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Angelo Collazo > Sent: 07 June 2006 16:37 > To: [email protected] > Cc: Matt Varghese; Angelo Collazo; [EMAIL PROTECTED]; > Ron Schile > Subject: RE: [U2] IBM U2 UniData ODBC sample working program > > Hello fellow groupies, > > > After downloading the document called "Accessing SQL Data > through BCI", the example is from U2 under Windows. It talks > about U2 under UNIX but it requires additional steps on how > setup up ODBC because it is not native to UNIX. I have found > a .pdf file on the IBM website called Basic SQL client > Interface Guide for UniVerse. This one shows how from UNIX > and UniVerse but I need UNIX and Unidata. > > My Enviroment on UniData versus UniVerse. > > 1- I 'm trying to follow the UNIX/UniVerse part of it and I > will translate all uv....(uvhome vs udhome, uvlibs vs udlibs, > ext...) I wanted to now the > following: > a- Needs UniRpc and I have UniRpc running in AIX/UniData. > root:/:# psgrep rpc > > Search for "rpc"... > UID PID PPID C STIME TTY TIME CMD > daemon 98438 86376 0 Apr 22 - 0:00 /usr/sbin/rpc.statd > root 1622126 1 0 Jun 04 - 0:01 > /ud/unishared/unirpc/unirpcd > root 102792 86376 0 Apr 22 - 0:00 /usr/sbin/rpc.lockd > > b- Needs to run relink.uvlibs and I I have relink.udlibs? It > shows that it requires for UniVerse to be re-started? > > Question: > 1- Not sure if I should execute the relink.udlibs If UniRpc > is already running?, See My Enviroment #1. > > c- Needs a file called UVodbc.config configured but I do NOT > have a file called UDodbc.config? > > Question: > 2- 2- I found ALL of this files under $UDTHOME: > root:/:# find ./ -name '*odbc*' -print|more > ./ud/bin/lib.d/uddlls/libodbc.a ./ud/bin/lib.d/uddlls/odbc.so > ./ud/bin/lib/uddlls/libodbc.a ./ud/bin/lib/uddlls/odbc.so > ./ud/lib/uddlls/libodbc.a ./ud/lib/uddlls/odbc.so > > ./.odbc.ini ?? INVALID IP Address, > could have been by predecessor trying > to setup UniData ODBC at one point? > root:/:# cat ./.odbc.ini > [MySQL-test] > Description = MySQL test database > Trace = Off > TraceFile = stderr > Driver = MySQL > SERVER = 192.168.1.26 > USER = pharvey > PASSWORD = > PORT = 3306 > DATABASE = test > > [PostgreSQL] > Description = PostgreSQL driver for Linux & Win32 > Driver = /usr/local/lib/libodbcpsql.so > Setup = /usr/local/lib/libodbcpsqlS.s > 3- Talks about using UniAdmin or the UV account for data > source creation but the UniAdmin for the ud/sys for UniData > does not have this feature? > Question: > 4- What is the equivalent setup of the data source for UniData? > > TIA and Cheers fellow groupies. > Angelo, > [EMAIL PROTECTED] > > > Angelo > > Do you mean ODBC from UniData (BCI) or into UniData (UniODBC?) > > For BCI, check the (new) knowledge base at: > www.mvopen.org/kb/ > > There is an article on there "Accessing SQL Data through BCI". > This takes you through the steps and there is demo > data/programs available. > > For ODBC, I have a similar article - but I can't post it yet! > (I'm still waiting for the official publication before I'm > allowed to do that). But if you email me offlist I can send > you a copy. > > Brian > > >After searching the archive and to no avail, I would like to know if > >anyone has a sample working program or (BCI.DEMO) working that could > >share a copy of it. > > > >Cheers, > > > >Angelo > >------- > >u2-users mailing list > >[email protected] > >To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
