Go to http://industry.java.sun.com/products/jdbc/drivers

I can't comment on which is best since I use Sybase.

But one thing is for sure, anyone who is using jdbc-odbc bridge in
production at the moment, stop what you are doing and find a way to replace
it ASAP.

-----Original Message-----
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 16, 2001 3:16 PM
To: JRun-Talk
Subject: RE: Going crazy w/ something the should work, SQL + Java
problem


> - don't use the JDBC-ODBC bridge, it is a piece of junk. It could well be
> the source of your problem.

What would you recommend then?

> - You can also use the bcp command to copy textfiles into tables, or SQL
> Server 7 comes with a nice set of graphical tools to mostly do it for you.

Oh, yea, well, I tried DTS, but I had to fight with it to get it to convert
strings to ints and just got tired. I figured writing it in Java.

By the way, I found my problem. The string had a chr(0) in it. -sigh-

=======================================================================
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email   : [EMAIL PROTECTED]
ICQ UIN : 3679482

"My ally is the Force, and a powerful ally it is." - Yoda
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to