Well, our backend is INFORMIX...so yeah, we had some problems, but most of them originated from bugs in the JDBC drivers we received from IBM. You may not have the same issues with SQL Server....but a couple of the issues I recall:
- Date functionality. The returned date objects in JDBC were different than ODBC. JDBC was returning a native Java date object, whereas ODBC would return a less strongly typed object. I don't recall exactly the issues we had with this, but it's something to keep in mind. - JDBC returned "decimal" type fields differently than ODBC. If we had a decimal field declared as "decimal(5,0)", ODBC returned 99999, whereas JDBC would return 99999.0 Just another thing to consider. There were some other issues, but I think most of them involved bugs in the early drivers we received from IBM. I don't think you'll have the same issues with SQL Server. On 8/4/06, William Bowen <[EMAIL PROTECTED]> wrote: > > > We've since moved all of our connections over to JDBC (dunno if > > that's an option in your case?), and have not had the problem since. > > I don't know if that is an option in my case (I haven't had a reason > to look into it). But I will look into it, any gotchas I should watch > out for? (WinServer2003/CFMX6.1/SQLServer2k.) > > > (Also, > > when things do get out of wack, you can write a little script to reset > the > > connection without a reboot). > > That's a good idea. > > Thanks! > -- > will > > "If my life weren't funny, it would just be true; > and that would just be unacceptable." > - Carrie Fisher > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:212529 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
