java.sun.com provides a tool to find drivers for a specific database at http://industry.java.sun.com/products/jdbc/drivers
Also www.freetds.org is an open source implementation of the tabular data stream and provides a type 4 driver. However, the last time I reviewed the product character strings were getting truncated at 255 chars (a problem with several jdbc drivers, including the jdbc-odbc bridge). I also noticed that microsoft has finally started to offer a JDBC driver itself. Looks like it is still in beta, but might be worth a shot - http://www.microsoft.com/sql/downloads/2000/jdbc.asp I hope this helps! Patrick Clark --- Chris Davis <[EMAIL PROTECTED]> wrote: > At this point, the server is not in production, and > has only one user. I figured a non production > quality driver would > suffice. Also, I can't seem to find as well a > priced alternative. > > Does anyone know a cheap alternative to JDBCODBC > bridge? > > -----Original Message----- > From: Danny Angus [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 13, 2002 4:59 PM > To: James Users List; [EMAIL PROTECTED] > Subject: RE: Problem with User Repository in MS SQL > Server Database > > > elsewhere at jakarta the jdbc:odbc bridge is frowned > upon because it is not > production quality, and not thread safe, I wonder if > either of these issues > are affecting you? > You should try to use dedicated JDBC drivers for > SQLServer (or anything > else). > d. > > > -----Original Message----- > > From: Chris Davis [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, February 13, 2002 9:30 PM > > To: [EMAIL PROTECTED] > > Subject: Problem with User Repository in MS SQL > Server Database > > > > > > Hello, > > > > I have configured James to use JDBCODBC bridge to > connect to a SQL server > > fir the user repository. The connection functions > successfully, and I am > > able to add users to the database by telneting to > port 4555. My first > > problem comes when I attempt to connect with POP3 > and authenticate with an > > earlier created account. I always get > authentication failed (I have also > > telneted to port 110 and not been able to > authenticate, though I do get > > connected). My second problem is this; if I > attempt to remove an account > > through telnet, I get a "successfully removed" > message, but when > > I check the > > database tables the account is still there. If I > "verifyuser", I am told > > the account does not exist, if I "listuser" the > account appears > > on the list, > > if I try to re-add the user I get an error. > > > > It appears to me that some of the commands are > successfully accessing the > > database, while others are not. Checking the log > files seems to show that > > everything is functioning properly (no glaring > errors). The only > > non-standard thing I have changes in the > config.xml, is the table > > names for > > the user and list tables within the DB. > > > > Any help is appreciated. > > > > Thanks, > > > > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > __________________________________________________ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
