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]>
