Search results for query: *

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

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

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

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

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

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

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

Below is a simple PL/SQL proc, it is limited, in that the argument is fixed as a row type of Processed_Data_Cursor, ideally adding a new parameter for a table name then having the rowtype as dynamic would provide a general proc, I have seen possible ways of producing dynamic SQL, but they seem...

Hi, I'm returning a field and its value from a weak cursor, but I want to process the data based on the data type. Is there any way I can determine the data type of a field returned from a weak cursor? The cursor should only return a field called 'theField' and its data. TIA John

Hi, My job is to get a DTS package on my SQL Server machine to load a text file from a folder on another machine. I have no control over either machine, both are hosted by an ISP, one is a SQL Server machine holding 2 SQL 2000 databases of mine, as well as other users databases. The second...

Here is a small sample (i've edited stuff using find and replace to preserve confidentiality) of a log when running a web site using IE and Firefox. The reason for the log was because IE kept refusing entry to the admin scripts after a login, but firefox did not, and testing showed that vital...

I have a table that has no key fields, it contains sets of data identified by a company, a code (the rows also contain a date) so it could be that all 3 fields could form a composite key, but as the sets are deleted and inserted as blocks, (always in that order, DELETE old set of data, then...

I've been asked by a colleague to discover if the DoCmd.TransferText will return information on the state of a load IF DoCmd.SetWarnings is False. Basically he wants to be able to inform the his non-technical users that a file load has been successful, partly successful or failed. TIA John

I have an Oracle stored procedure that has 4 parameters, 2 are input, 2 output. It was written for use in an ASP script. I am about to use it in a different situation, and call it from within another stored procedure, and I do not want the second of the 2 output variables. My question is, is...

Can anyone confirm that ADO will not allow a call to a user defined PL/SQL function? If it is possible, I'd be very grateful for some advice on the syntax of calling this from VBScript/ASP. TIA John

I'm looking at a script that is supposed to 'logout' a user if the user 'closes' the browser or navigates away from the site. The relevant code is show below (IP and site details edited to protect the innocent!!) There is also an error handler shown in the second code block, which calls the...

I have the following Access SQL, from a Query UPDATE User INNER JOIN TempUser ON User.Comp_ID = TempUser.CompID SET User.FirstName = [TempUser]![FirstName], User.SecondName = [TempUser]![SecondName]; I am required to convert this into an Oracle stored procedure, and wanted to maintain a...

We have a DLL to handle password input for an Oracle / ASP application. The DLL also writes the session id to a cookie if the password is validated. There are 4 developers, each of whom has their own development site on the web server, but all of whom use the same DLL - it being stored once...

I get the message shown below in the notes section (3197 although in my log it is appearing as a negative error number, but same text) When it appears,it is logged at the same place in the same code each time, BUT it is infrequent, and I've checked the back and front end databases for...

Rep 0499 Column '' selected by query in incompatible with report definition. Is an error I'm getting on a previously working report. I know that fields in the database have changed, at least in their roles, but not necessarily in their types. My problem is that I can't find the '' column that...