We are using CF with Universe. It took awhile to get it working. One of the problems was an issue in the /etc/inetd.conf file there were two lines referencing the rexec service. The line with the -c at the end is the line you want and there maybe an empty line after the good line in the file, that needs to be deleted. This was on AIX 4.3 and UV 9.6
> -----Original Message----- > From: Allen Highnote [SMTP:[EMAIL PROTECTED] > Sent: Sunday, August 14, 2005 1:37 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Anyone here using Cold Fusion to access UniVerse? > > Peter, > > I'm having problems with CFMX7 and UV/ODBC also and > not having much luck. (UVpe 10.1) > > I was able to get UV/ODBC to work with MS-Query and > was able to get the CF datasource config to test the > UV/ODBC connection as OK but when I ran a CF query > against it, I received an "Invalid Argument or > mismatch" message (or something like that). Is that > what you are experiencing? > > I've tried this with CF and UVpe on XP using CF's > internal web server as well as moving UVpe to W2K > server with IIS and got the same results. > > I was able to work around the issue by using UVSH to > go directly into UV from the <cfexecute> tag. It > works really well but then you are no longer using > ODBC/SQL and is highly proprietary. One of the best > things about it, is that it releases your UV login > once the query finishes and returns to CF. I was very > surprised at just how fast this was but did not like > the non-standard approach. Don't know how it would > work on a large scale application however. My guess > is very fast and very flexible. > > I wrote a couple of CF components as well as a couple > of small UV server applications that help handle the > UV to CF connectivity including UV reads and writes. > Also wrote a rudimentary prototype of the MV REPLACE > statement in CF. > > I finally tabled the task and moved on to testing > UniData which is working well so far. I'm developing > a CF website that works with either MS-Access, > UniData, Universe (maybe), mySQL, and possibly SQL > Server. (Kind of a throw everything in the pot and > call it vegetable soup project!) > > Another possible solution is to use FusionWare's > eTools ODBC driver. I think this is the old > Liberty/ODBC driver and server. I really like the > product when I used it, but am looking for the NO cost > solution at least while prototyping. > > If you could share your CF connectivity parameters for > UV/JDBC, I would appreciate it. I've not played with > that yet. (Just another tasty ingredient in the > soup!) > > The webservices idea is a great way to go, but > requires significant development. Once I get this > site up and running, webservices will be next. > > Allen Highnote > [EMAIL PROTECTED] (requires a challenge > response) > Phone: three 66-3313 in the 5 six 2 area code > > > --- Peter Ivanick <[EMAIL PROTECTED]> wrote: > > > Thanks Tony, and indeed several people have > > suggested that we bypass the > > odbc/jdbc issue altogether & we'll likely be looking > > to do that, > > although we aren't currently exposing any web > > services (just got > > upgraded to 10.1.4 last month); in this case we've > > got a rather severe > > time/resource constraint but do need to upgarde CF > > from 5.1 to CFMX 7, > > which doesn't handle ODBC with UniVerse at all, and > > no help from > > Macromedia in the offing, so JDBC is our best bet > > for the timeframe. > > > > Many thanks for the help. > > > > Tony Gravagno wrote: > > > I'm not sure about your architecture, but just to > > open some > > > possibilities... I used CF years ago connect into > > a back end application > > > using CFHTTP queries rather than ODBC. If you're > > already exposing U2 > > > business rules as a Web Service then using CF to > > generate the UI becomes a > > > no brainer. If not, well, that's one of the > > benefits of modularization and > > > exposing code as UI-independent rules, which is > > after all what Stored > > > Procedures are all about. > > > > > > HTH > > > T > > > ------- > > > u2-users mailing list > > > u2-users@listserver.u2ug.org > > > To unsubscribe please visit > > http://listserver.u2ug.org/ > > > > -- > > Peter Ivanick > > Sr. Programmer/Analyst > > School of Veterinary Medicine, University of > > Pennsylvania > > Email: [EMAIL PROTECTED] > > Phone: 215.573.2306 Fax: 215.573.8777 > > http://www.vet.upenn.edu/ > > ------- > > 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/
