Search results for query: *

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

I have an ADOX script that was tested in Access, then converted from VBA to VBS and run in ASP. In Access it happily appends a column to an existing table using the Columns.Append method, in ASP it fails with the message 438 Object doesn't support this property or method It can append columns...

Thanks Chris, I was afraid of that. I've given you a star even though it is bad news 8-) regards John

I am dynamically including a VBScript function along with an XML reader class into ASP. I use the Filesystem object and Execute string method to produce the dynamic inclusion. I do a similar thing in a vbs script, except I don't have to dynamically load the function. In the vbs script that XML...

***************** Apologies **************** I seem to have fixed it now, I'm afraid to say I think it was simply a case of not stopping the web server during edits - being new to .NET I thought the web server could be left running as I do with IIS, but a couple of pages on in the tour it says...

I am new to .NET and am following the MS guided tour at http://www.asp.net/GuidedTour/default.aspx I've followed the notes, writing code and adding web forms, and got to the form that is displayed by the url below http://localhost:2353/AUTHORS/DependencyCaching.aspx which works if I press F5...