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/
