Good news. I found a solution/work around to getting CF to work with UV/ODBC in Windows.
It requires additional software. I'm running both UVpe and CFMX7 on XP while in development. But it should also work on Windows 200X. I downloaded the eval copy of OpenLink UDA (Universal Data Access) drivers from http://www.openlinksw.com/download. This is a single-tier ODBC driver which acts as an ODBC-ODBC bridge between CF's ODBC sockets and the UV/ODBC driver. Sort of middleware's middleware but shouldn't slow things down much. Easysoft, a UK company, has another bridge. Both products have been mentioned in this email list. At least for OpenLink, configure a UV/OCBC datasource under the System DSN tab just as you would to use in MS-Query, etc. Test it! Then configure another System DSN using the OpenLink Lite for ODBC database (32 bit) driver. Don't use the Unicode driver. This driver should point to the UV/ODBC System DSN that you just created and tested. For this second DSN, I was able to test the connection successfully in ODBC admin but was not able to get a list of table columns using MS-Query so MS-Query failed. Maybe a config parameter or just not able to??? Don't matter to me at the moment. I'll just use the direct UV driver for non-CF client applications. Then I configured a CF Datasource to use this second ODBC DSN I had just created. Note: Don't check Trusted Connection. I was able to SELECT with column names as well as with *. I also was able to INSERT records. I have not tested UPDATE and DELETE but have high hopes. I'll post some images of the config parameters on my website http://www.noteworthyis.com/uv_openlink.html in a few days. Allen Highnote [EMAIL PROTECTED] (requires a challenge and response) --- [EMAIL PROTECTED] wrote: > 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: [email protected] > > 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 > > > > [email protected] > > > > 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 > > > [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/
