Recent content by ALWilliams

I wrote a desktop app that mines our SQL DB and passes the results to a Crystal Report for viewing. I've attempted to convert this to ASP for ease of deployment / use but when I run the 'same' code I get differing results. When I run the SQL thru SQL manager I get ~ 200 rows yet when via the...

I am yes as i was kinda using a common sub to commit to the db. Copied this code into the routine and only closed it at the end and not only is it quicker (which you'd expect) it works. Cheers.

Thanks for the alternative suggestions but I'd still like to understand why the method Im using is failing after this many iterations. One of the reasons I dont just dump it straight in is due to me needing to perform some work upon it (not much albeit) prior to sending to SQL. I'm just...

Ive some code which reads a CSV file and line by line inserts it into an SQL server. However, the file has ~ 12,000 entries yet when the code gets to ~ 3933 it raises the following error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The...

Thanks for the response jason...I've tried to provide some feedback to the points 1. Permissions are fine, the user has full access to the data. 2. Server specs should make this 'ok' 3. Yes all disposed of cleanly 4. Not too sure what you mean here (newbie alert!) - the database is on our...

I have a simple ASP page that uses a timer to populate some MI figures every 30 seconds or so. There are 4 entries, 3 of these being mined from SQL server and the other from an Access Database. The app works perfectly from my laptop but when I publish to the webserver the Access one fails with...

Thats pretty much exactly what I have but when it postsback the focus is on the URL line and not the second textbox for some reason. I've amended it to exactly your code and its now working!!! Damn computers!!! Thanks.

Firstly I am new to ASP so apologies if i have missed the obvious here!!! I have a page with two text boxes on it. The idea is for upon initial load the focus is on box1. I am after scanning a barcode into this box which I want it to navigate away upon finding the CRLF from the barcode...

Upon installing and running the service it appears it isnt doing anything. I have also tried another persons sample service code (write an entry into the event log for each timer execution) and this appears to be totally intermittent. The only thing I get regularly is the service start and...

nice one - i solved it also myself by installing sdk 2.0 and applying full trust from there - cant believe the option wasnt in 3.5.

I have installed this but I still no not have an option for framework 3.5!!

I'm downloading the SDK now so will feed back if I cant get it to work - thanks so far!

It is installed on both. The issue here is when the code is stored on a network location and loaded onto my laptop and run from my laptop I get this error.

I've done what the document says using 1.1 and still get the same error.

I only have version 1.1 on my machine yet am developing in 3.5. Should there be a 3.5 framework configuration option or is it all the same?