Excellent! thank you! On 8/4/06, G Money <[EMAIL PROTECTED]> wrote: > 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:212532 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
