Search results for query: *

Hi, I'm trying to read from xml files, and put values into variables to load to a database. I have been trying to work with the XML Dom, but have not had much luck. I have the following xml: <readin> <doc> <object id="1"/> <object id="2"/> <object id="3"/> <object id="11"/> <object id="12"/>...

I have the folling stored procedure: CREATE PROCEDURE gouplevels (@current char(20)) as SET NOCOUNT ON DECLARE @level int, @line char(20),@foldname varchar(255) CREATE TABLE #stack (item char(20), level int,foldname varchar(255)) INSERT INTO #stack VALUES (@current, 1,@foldname) SELECT @level =...

Hi, I have some binary files that I want to run through vb.net, and have it identify how many instances of a string is located in the file. This is done easily in unix by just using the grep command. Is there a way to do this in vb.net? I have never processed/opened files in binary mode in...

Hi, I have a project where I need to remove the first 1998 bytes from a set number of files. I am guessing I need to open the file in binary mode, but I am not sure how to write to a new file, skipping the first 1998 bytes. These are not text files, they are binary jpg files, and the first...

I have created a window service, and it runs to open a database and update values. The database resides on another server, and the local service has a system dsn setup. The account used to run the service is a domain user account that does have access to the database. Below is the error...

I have some files where I need to always remove the first 192 bytes. Is there a way to do this in vb6. I know how to open the file in binary mode, but it is not text data or records, so there is no consistency, I just need to remove the bytes.

I have a webform where a user enters data in some field and a datagrid is populated with the results of the query. The datagrid contains 6 bound columns with values from a database. There is one button column which contains a view link. When the user clicks the view link I am running a...

Hi, I have gotten a file from a customer that contains the date time in VMS format, and a separate file that contains the date time format in DD-MMM-YYYY HH:MM:SS.MS I need to convert the date format(DD-MMM-YYYY HH:MM:SS.MS) in the one file to link to the date format in the other, to create a...

Hi, I received an Oracle 7.0 exported .dmp file from a customer. The customer does not know the user, or schema info for the .dmp file. How do I go about importing the file into my oracle 10g server. I have tried using the imp command with various switches, all which appear to start running...

Hi, I have created an app where the user enters a project number, and a stored procedure on a sql server 2000 box is called, and results are returned. If I just run the stored procedure through Server explorer, and enter some parameters results are displayed in the output window. I cant...

Hi, I have a customer who is sending me numeric values from 1-234. They then want me to convert those values to alpha & numeric. 1 = 1A 2 = 1B 27 = 2A The number goes from 1-26 and has A-Z, then when it gets to 27 it goes to 2A - 2Z, and so on. I can't seem to figure out the conversion...

Hi, I have a customer who is providing me files that are name from 1-999. They are asking that the files be renamed. Files are sent to me daily, so I am looking to write a program to do the renaming. The files would be renamed 1-99, but when it gets to 100 they want to name the file A0, and...

Hi, I am using tar on a windows box to extract some DLT tapes created using ustar. The command I use is tar xvf /dev/mt0. I am able to use tar tvf /dev/mt0 to get the list of files on tape, and the list looks like below: mr0010:d0243845.30_r136.p003@1954115, 64677 bytes, 127 tape blocks...

Hi, A customer has provided me a visual basic 2.0 bas module written by their previous programmer. I don't have access to VB 2.0, and am trying to import the 2.0 bas module which looks to be in some type of binary format into VB 6.0, but it doesnt recognize the file. Any idea of a tool that...

Hi, I have a large number of files, and I always want to trim the first 32 bytes from the file. What is the easiest method do this. I am thinking to open the file in binary mode, but don't know what to do next. Any help would be appreciated. Thanks

Hi, I have a form with a single command button, and a label. When the user clicks the command button, a loop is run against a directory of files, renaming the files. Within the loop I have change the label caption to match the filename, and perform label.refresh. This is working as each file...

Hi, I currently have a Windows 2000 server setup as the primary domain controller with ADS, and DNS installed. I have two NIC cards in the server, and DHCP is also running. I have connected the DSL modem to one of the NIC's and tried sharing the connection, and it is not working. In order to...

Hi, I plan to import a text file daily into a Microsoft Access 2000 database. The access table has fields: ID, Name, SSN, Date of Birth The text file has fields: Name, SSN, Date of Birth When I import the text file, the name is put into the id field. The id field is an autonumber field...

Hi, I have imported a text file into SQL Server 2000 Enterprise that contains 5,000,000 records. During the import I create a new table. The table contains 3 fields Fieldname Datatype Length Docid integer 10 SeqNo integer 3 Fname varchar 125 I have created...

Hi, I have a programming running that is outputting excel spreadsheets. I want to create a new directory every Friday, and put only the spreadsheets that are created from Friday - Thursday. I know how to create the directory and put Friday's files into it, but if there are Monday files I...