Search results for query: *

Hi, Is there a way to return the @@ERROR messages in (SQL Server 2000) stored procedures to the ASP page? Essentially, I have a function that allows the user to import data into the SQL Server using BULK INSERT in an ASP Page. Should anything be amiss, (record exists etc.) I'd like to be able...

Hi, Does anyone know how to use ASP to read data from a csv file and do an INSERT into SQL Server 2000 database? Both my csv file and sql db allows null values in their columns. I went to this link: (reads from csv file and writes to HTML page ~ I figured would be similar to writing to SQL...

Hi, I have a pop-up box with this message everytime I connect to the Internet. It pop-ups about 5 minutes into the connection : This shutdown is initiated by NT AUTHORITY\SYSTEM Remote Procedure Call (RPC) service terminiated unexpectedly. Then the system just restarts. The same thing...

Hi, I have page with a table, and a button to add rows to this table dynamically. This is a very basic concept I have of this program. It adds a row at a time: <% Function addrow() %> <tr> <td>value1</td> <td>value2</td> </tr> <% End Function %> <form> <input type=&quot;Submit&quot...

Oops... More details: I'm writing a program to do the conversion of data in my tables into .txt file. Thanks

Hi! I would like to know how to export data fields in an Access database into a .txt file to store in a floppy. I don't want to store the .mdb file directly into the floppy because the file would be hugh. I understand that the tables in my database should be processed individually. Could...

Hi, My SQL query from an ASP page: query = &quot;UPDATE Loan SET DateOut = '&quot;&Date&&quot;', TimeOut = '&quot;&Time&&quot;', CheckedOut = Yes WHERE LID = '&quot;&lid&&quot;'&quot; resulted in a data type mismatch error. My column LID is an auto increment field. I set it to be the...

Hi, I'm running on local web server IIS, and using a remote MS SQL Server 2000 Enterprise Manager which houses my database. I have set my ODBC connection. I'm trying to retrieve data with my ASP pages, but had this errror: (Connection to SQL Server was successful) Error Type: Microsoft...

Hi everyone, I am using MS Access for my database. I am doing some web based programming. I have an auto increment field in one of my tables. I would like to insert a record using SQL INSERT statement into the table. What value do I insert for this auto increment field? I tried ignoring the...

Hi, I'm new to MS SqlServer7. Need some help on this. I installed the standard version of this RDBMS on my office desktop. However I could not open the Enterprise Manager, so essentially, I can't create any databases using this RDBMS at all. The error message I got...

Hi! Am trying to work out how to auto delete a row in my table that's displayed on the webpage upon clicking a [delete] button. The page should refresh automatically without showing the deleted row. I have a [delete] button in each row. Grateful for any kind advice. :)