Recent content by jjob

Thanks, I'll look at that, although I've only been looking at code with the Cache with a sample data set, as I have no control over the templates worksheets, connections, sQL and tables etc, other than I read the data for all this into my code via a control worksheet.

First, my apologies for the delay in replying, I was at a seminar last night. Second, thank you for your time and effort on this, and finally, just in case anyone is doing anything similar, here is the history of how I got the thing to work. So, I have solved my problems, although I am...

Thanks, but I am hoping someone knows where there is anything useful, I've searched and searched and can find nothing that helps.

It is , but I am not able to post any code, I work in a secure environment and nothing can come in or go out - I am writing this from home, so I'm afraid I can't post any actual code.

I define a recordset known as the 'virtual table' the documentation calls it that, although it is in fact an ADODB recordset - with no connection, it's definition is based on a SQL Server query defined for a Pivot table. The mechanism is that I open the SQL Server query recordset and add the...

I am required to replace the current data supplied to a pivot table and replace it with a disconnected recordset. The recordset is created from a virtual table to which I have added data from 2 sources, a SQL table and an Access table, I can save the recordset to disk and open it and populate a...

Typically, no sooner had I posted this than I found the answer! My apologies, I was searching on 'remove' all I needed to do was search on 'disable'. Sigh

I have a remote server connected to a DB I'm using and it apears to be an historical artefact, the database that any call would use does not exist there. My problem is that this Server is screwing up my efforts to amend existing DTSs, in that when I attempt to check parameters and build...

Many thanks, a star for that.

I am interested in how 'response.redirect' works in IIS6.0 with a URL of the form shown below. eg response.redirect "http://myrealsite/login.asp" does the server lookup the IP address, or does it send back the URL to the browser and the browser then looks it up and connects? I've never...

Thanks Sheco, We copied back to a temp folder and then deleted via the filesystem object - our security staff wouldn't countenance the change to IIS. regards John

Anyone tried to attach a file using CDO from a NAS? If so how did you get it to work? Our NAS provides a IP address as part of the path for the attached file, and the CDO object hasn't got the required permission to attach it, as far as we can tell. Hence our insterest in seeing if anyone else...

Excellent, you have both identified the problem, I needed the OLEDB connection, not the ODBC one. Stars for both of you, I may make the deadline for this now!

Thanks all, my apologies for the delay in getting back to you, I'm working on 2 projects at once and one requires me to work away, will look at your comments when I get back home tonight. regards john

The 'core' ASP code is shown below, minus the connection, which is set up in an include file This displays the columns OK with response.write, but fails on the append. Thanks John Dim cat Dim tbl Dim con Dim tableExists Dim colExists tableExists=False colExists = False on error...