Hiya - not blanking you - but went home after my last post yesterday (UK time) - CF runs fine on *nix - we've got a few installs running on Solaris and Redhat (CF 4.0, 4.5 and 5) - as far as Compac True 64 Unix - it no worky as CF can only go on NT,2000,Linux,Solaris 2.6,7,8 and HP-UX 11.0 as far as I know...
Key things to watch for are ODBC native drivers not working for v5.x as they did for v4.x on professional version, CF logging into Oracle with the right credentials and NOT trying to run JRUN on the same server... got to look out for the usual *nix file naming conventions, but apart from that v. stable and happy. J -----Original Message----- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: 29 November 2001 18:17 To: CF-Talk Subject: Re: Oracle and CF LOL - sorry if I seemed "intense" - I like to think of myself as "passoniate" - LOL (yea, right) BTW - how does cf run on *nix. I've yet to venture that direction, but I have to soon. Does CF run on True64? What should I watch for? Dave ----- Original Message ----- From: "James Maltby" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 29, 2001 1:00 PM Subject: RE: Oracle and CF Talking to someone "new" to CF - so talking in S-L-O-W voice - lighten up! :) J -----Original Message----- From: Dave Hannum [mailto:[EMAIL PROTECTED]] Sent: 29 November 2001 17:34 To: CF-Talk Subject: Re: Oracle and CF You don't have to add the schema to the tables if you are the owner of the tables. Besides, schema dot, as you call it, is common and proper SQL for higher level RDBMS. You can't call it a problem. Perhaps you're comparing Oracle to Access or something - as for autonumbering, you simply create a sequencing table and reference it in your SQL INSERT statement. Very simple. Dave ----- Original Message ----- From: "James Maltby" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 29, 2001 12:16 PM Subject: RE: Oracle and CF There are some probs with SQL syntax and autonumbering, but these should be easy for you (if you are used to ANSI SQL then you have to re-learn some syntax - such as adding "schema" dot notation before all table calls and creating server-side auto numbering formats and calling them from the code. Oracle seems a little more robust than SQL, there are however some problems when loading native and odbc drivers in CF 5.0 on *nix platforms, but if you are not using CF on *nix then I won't bore you with them.... HTH J -----Original Message----- From: Alex [mailto:[EMAIL PROTECTED]] Sent: 29 November 2001 16:14 To: CF-Talk Subject: Re: Oracle and CF What are the "some small issues"? On Thu, 29 Nov 2001, Dave Hannum wrote: > We use Oracle here both with Native drivers and with ODBC. Works great! > (mostly - some small issues) > > Dave > > > ----- Original Message ----- > From: "Jason Dowdell" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, November 29, 2001 10:39 AM > Subject: Oracle and CF > > > Hi all, > > Being a former Oracle employee I'm fairly familiar > with Oracle but I've yet to use it with CF. What > are some of the limitations versus SQL Server? > I've heard that the Oracle drivers only return > one record in a query result set at a time. Is > this true. What are some of the other drawbacks > and or advantages? > > Thanks in advance, > Jason > > > -- > --------------------------------- > Jason Dowdell > CF_Developer > e-mail: [EMAIL PROTECTED] > --------------------------------- > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
