Search results for query: *

I am having problems taking a binary file such as an image and inserting it into a SQL Table. I have used a statement to convert the image into an array of bytes like this: Dim buffer(objStream.Length) As Byte objStream.Read(buffer, 0, objStream.Length) This works fine and...

I know this should be an easy one but I cant find it anywhere. I need to get my network machine name in my VB program. Thanks, ctau

Is it possible to execute a stored procedure in the declaration of a view? Thanks, Ctau

I am trying to merge based on a value found in the registry. I am using sql server 7. I am able to get my desired results through query analyzer with a statement like this declare @build varchar(3) exec master..xp_regread 'HKEY_CURRENT_USER', 'SOFTWARE\VB AND VBA PROGRAM...

I am getting an error message when I try to connect my asp to SQL Server. I am connecting to the same database fine with visaul basic but I get the following error when I try to do it from an ASP. [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'. I am using the...

I am trying to write a trigger between an inventory table and a returns table. When a return comes in I want it to check the condition field to see if the return is to be destroyed or returned to stock. If it is to be returned to stock it should add the value to Qty_on_hand and to Qty_returned...

I am pulling one line from a text file that is delimited by |. After I pull it in I want to divide it up into variables. I am using the split function but I can only refrence the first element in the array. Input #ITEM_FILE, strLINE STRING_ARRAY = Split(strLINE, "|") if I say...

I am using a string field to allow the user to type in a description of their problem, but if they try to include a single quote in this field they receive an error. Is there anyway to fix this problem without removing the ' from the field?

I need help with the syntax to join to tables together using a Select statement. Here is what I have been trying so far SQL_Statement = "SELECT * FROM return_header Inner JOIN return_line ON return_header.return_number = return_line.return_number"

I am having problems connecting to an ODBC database. I am using the following code Set MyConnection = Server.CreateObject("ADODB.Connection") MyConnection.Open SQL, "dsn = wacs" I get the following error when I run this. Line 31 is the DSN line...

I am having problems changing my code from Access 97 to Access 2000. I am unable to connect to the database when I switch from one database to the other. Any help would be greatly appreciated. I am new to ASP and can't seem to get over this small hump. The code that I have been using for the...

My computer has recently started frequently rebooting and freezing. It seems to happen at least once an hour if not more. I am on the internet when it happens, but I am not using the computer for much of anything else. I have changed ISPs due to the problem but I am still experiencing it with...

Is their an easy way to FTP files inside of a Visual Basic Program? I basically just need to be able to login and put a file in a specific directory. Any ideas?

This is probably a simple task but I just can't figure it out. I have created a procedure that opens an excel file makes some changes and then saves it. But when I try to save it tells me that it already exist and asks me if I would like to continue. Is there a way to avoid this dialog box...

I recently purchased an AMD 950 and an Abit KA7 motherboard.  After installing them I was unable to get any display.  I get power to my hard drive and cdroms but not my floppy.  I am sure that everything else in the computer is working properly and have tried the...

Does anyone know the command used to retrieve previous commands that you have used?  Also could this be put in a .profile?

I have a computer where a previous employee has set the content advisor password on Internet Explorer so that no unrated pages can be displayed.  Of course almost all pages on the internet are unrated.  I have tried uninstalling IE but upon reinstallation the password is...

Upon booting up one of our computers this morning I noticed that one of its two harddrives was missing in Windows. It appears in Bios and in Fdisk it says that it is a non Dos partition. Does anyone have an idea of how to fix this corruption?

My computer was originally running two hardrives in fat16. Recently it went into compatibility mode on the harddrive buses. It now says that the primary drive is running in Fat32. I did not change it but someone else may have. I went ahead and converted the second harddrive to it hoping to...

My computer has entered into compatibility mode. When I checked the reason I found out that I had warnings on both my primary and secondary hard drive controllers. Earlier in the week I did a drive image from this computer and upon restarting my computer with its original drive I got an error...