Recent content by hughesai

jsteph, You were right on the money. I had three fields with a SQL Server "real" data type mapping to Access "double" data types. When these were in the recordset I had write conflicts - when I removed them I didn't. ! ! The difference between this situation and the other 3,500 records in the...

Hi all, I have an A97 application which uses MS SQL Server 2000 as the back end database. This has been running sucessfully for a number of years. I'm having a problem with one record in one table. Every time I edit it in the application I get the "Write Conflict - ... another user has changed...

I've also been looking for a replacement for the Access IIf statement in SQL Server. I understand the case statement and it's usage, but it is not supported by the Query Designer in Enterprise Manager (SQL-2000) so for me it's usage is limited to relatively simple queries. Is there any way of...

cLFlaVA - I tried your suggestion, but it was not sucessful. The validation still does not fire. Dan - The calendar is generic and is used in other places. Some of these need validation, some don't, and the event handlers are different in any case. I, therefore, can't call specific handlers...

Hi all, I have a input text box used for dates. If a date is typed I have some Javascript validation on it. I also have a button which opens a Javascript calendar in order to pick a date and populate my text box. However, by definition onChange does not recognise this as a change (it only picks...

thanks lupin46. Yes I think I was aware of that before, but discounted it because it was all working fine on other PCs which all use A97 (including my own dev PC). However, always test every hypothesis! Yes - the path + file name was 72 characters, so I shortened it. The path as far as the...

Hi all. This is a recurring porblem on this forum and the MS Access Modules forum, but I have not found a solution in any threads yet. I have an A97 db which exports a table to an Excel file on the user's desktop. The program checks whether the file exists, deletes it if so, and then saves a...

>>>>>>>Tomcat will only load jar files from common/lib on startup - this is expected/normal behaviour. I didn't know this for sure, but had guessed it probably was the case. I discussed with Tech Support - they rebooted the server for good measure as well as restarting Tomcat. My application...

sedj Good thinking - OK I've done that and now I have the same problem on my dev machine, so I have the right files and the app is reading them from the location I thought it was. I put the files back and the problem didn't go away immediately - I had to re-start Tomcat. Now Tech Support have...

Thanks Sedj, Yes - your suggestions seem reasonable. The driver files I have put in common/lib are: msbase.jar mssqlserver.jar msutil.jar I have these on my development PC also and I got them from the driver's lib folder after I installed/unpacked it. I have checked all three locations...

Yes the error is: Cannot load JDBC driver class 'com.microsoft.jdbc.sqlserver.SQLServerDriver' hughesai

Thanks sedj. No - I've already done that and it has not helped ! ? ! hughesai

Hi, I am developing an application which access an MS SQL Server 2000 databse through the MS JDBC driver. My web app is in Tomcat V5.028 on my development PC and 5.025 on the production server. All is working fine on my development PC so I'm relatively confident that my coding is working, but...

Thanks Dian. row is a a recordset which I am accessing through a <sql:...> tag. p1 is a field in that reecordset. I have already tried concatenating with + but this has not helped.

Apologies in advance - I'm new to JSPs and struggling with some basic issues. My present problem is that I need to build a url. This will be of the format: /somepage?param1=p1&param2=p2. p1 and p2 are stored in a database rowset, lets call them ${row.p1} and ${row.p2}. I need to create a...