Search results for query: *

Hello, I have a DTS that exports an SQL table to a text file. One of the values of the table is a remarks column. I have set the column up as a varchar/1000. When I view the data in the table, all the data is there. When I export the data using the Microsoft text driver ODBC, the data gets...

Hello, I have a secure site using nt authentication. In one instance I would like to open a new window from a link. I have this worked out, but the user authentication session carries over to the new window. I would like to force a new login request when the window is opened. I am using the...

Hello, I am running MSDE for SQL2000 on a windows2000 server. I am trying to connect to this server from a client using the Enterprise Manager or through ODBC. When I try to register the server in the client/remote EM using the server name, I get an error message "specified sql server...

Hello, I have an nt4 server this is losing passwords on system reboot. Specifically it is loosing the sa password for the sql2000 server and the odbc password for pervasive. It appears that these settings are in the registy and for some reason on a system restart, the passwords get lost. To...

Hello, Wondering if anyone knows why our IIS services keep stopping, you reboot the box or start the service again and all is well until 5 or 10 even 900 minutes later and it happens again. I am running nt4 with iis4. I also recently installed an email package called mailmaxweb from...

Hello, Can someone help me with this problem. I have a SQL statement that looks like this; strSQL = "SELECT * FROM Transaction, "Unit-Participator" WHERE Transaction.T_TRAN_NUMBER = "Unit-Participator".U_TRAN_NUMBER AND ((Transaction.T_MLS_NUMBER='990616'))" The...

I am trying to create a comma delimited array from an sql query result. I use a count query to create the ubound on my array, but the actual query is a select group by. The results are returned as one long number. If I loop through the record set using Response.write, I can concantinate the...

I screwed up. I created a SQL table with char fields. Now when I try to post the data from the SQL table to an access table, it has null characters padding the data. I tried to trim the records, but the characters are not actually spaces. I tried to figure out how to use the replace function...

I am trying to validate a form using javascript. The form has two submit buttons. If the first button is clicked, the form should run a brief verification, then change the form action to an asp page. If the second button is clicked, the for will run the verification, then change the form...

Is there an easy way that to perform a multi-record update using a single submit in ASP? Basically I have a form that is created using a query. It is built by bringing back multiple records as text boxes. I then what to change the information on a few of the text boxes and click submit to...