Recent content by aldovalerio

I'm a VB6 developer, and I'm trying to learn VB.NET (perhaps not the best way) by converting some code from VB6. I'm having trouble finding the equivalent for the VB6 Array() command. This is my VB6 code: function call: Set rst = ADO_RunSPReturnRSParm ( _ strDBConnect, "sel_facts"...

Thanks to Tonykblen for the great script. It works like a charm on 2 Win2K Pro workstations, but on my 3rd Win2K Pro machine, it hangs. I added some code to write to a log to see where it's hanging and its on this code (below). It just loops, meaning it hasn't detected that the app. is...

(Oracle 8.1.7) Is there any performance difference between the following two code examples? Are they both actually binding the my_sal variable? Apart from performance, is there any reason to choose one method over the other? -- Option #1 DECLARE TYPE EmpCurTyp IS REF CURSOR; -- define...

I've just finished writing a routine to search for a row in my listview based on the character that the user types over the given column. I identify the column the mouse is over (MouseMove) and trap the character typed in (KeyPress) and then search the subitem (corresponding to the column the...

My solution: don't read the column headers with ADO; process them as data, reading them into an array. To avoid reading the first row as headers, change the Excel connection object to HDR=No, as follows. objConnectXLS.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" &...

The client is Windows 2000, so the equivalent command is secedit /refreshpolicy {machine_policy | user_policy}[/enforce]. I ran both the machine_policy and user_policy and I see that there are errors in the Event Viewer. Event: 1000, Source: Userenv, Description: Windows cannot establish a...

Windows 2000 Workstation client, Windows 2000 Advanced Server. SP4 on both. I'm trying to get a logoff script to work, but in certain cases it's not being executed when I log off. It's a simple 1 line IF EXIST C:\XYZ DEL /Q C:\XYZ\*.* and it works when executed manually, but not when I create...

I found a solution thanks to Barbara Boehmer at www.orafaq.com : removing the OPTIONALLY ENCLOSED BY '"' did the trick. Fortunately I didn't have any double-quotes around my data.

Windows 2000/ Oracle 8.1.6 I'm trying to load a tab-delimited file into a table, but when it encounters a record with an empty column, it seems to ignore it and errors out on "Record 19: Rejected - Error on table SRADB.SAP_EXTRACT, column REVISION_CODE. Field in data file exceeds maximum...

Maybe I wasn't very clear with my explanation. I'm reading from Excel, not writing to it. The above code is how I do the read. Also, the [ and ] are embedded in the first row, which is the column headers, meaning that those are the ADO recordset field names. Were you able to retrieve field...

I tried inserting a leading single quote into the header row's cells on the spreadsheets, but my script still transforms the [ and ] into ( and ). I think it's SQL Server and ADO that are converting them. I say this because I know that SQL Server uses [ and ] as object (e.g., columns, table...

I'm not sure this is the right forum for this, since it's more of an ADO question. I have an ActiveX Script Task that reads an Excel workbook and processes its worksheets with an ADO recordset. I process the worksheet column names (first row of worksheet) as recordset fields, but some field...

CF v5, Excel 2000. I'm generating Excel output using the Internet Explorer Excel add-in. I create an HTML table and use the <CFCONTENT TYPE=&quot;application/vnd.ms-excel&quot;> tag. My output is mainly text, retrieved from SQL Server, with embedded carriage returns+line feeds (ascii 13+10)...

Did you ever find a solution to this? I get the same thing, but only with certain cfm templates, even though the cfcontent and cfheader are identical on the ones that work and the ones that don't work.

I am running Back Up Exec 8.6 rev. 3808 on a Windows 2000 Server with SP3, dual 400Mhz processors and 512Mb RAM. Occasionally when I reboot the machine, the Backup Exec 8.x Job Engine service hangs and will not allow the program to connect to the server. Rebooting again seems to solve the...