I have a very basic question. I have a single column datalist on my webpage which is a hyperlink and takes you to another page when clicked. I want to make this column a hyperlink based on the...
But if the way I process the files is wrong, shouldn't I be getting the same issue on all my machines. It runs fine on all my dev machines and production sites. It has been running fine for about 2...
I have a strange problem. My c$ .net application has a filesystemwatcher that watches a specific folder and whenever there is a new file it processes it.
When I run this app on my test...
In my c++ program I connect to the database and execute some SQL queries. Most of my statements execute fine but once in a while I get errors with my insert statements. I am printing out the error...
That did not make any difference.
Actually I have some print statements in my SP. Can I write those lines to a text file so I can see it after I run the SP from my program to see what was...
I have been doing it like that but the problem is the SP did not seem to execute completely. Basically I have a table called PIN with 23 rows in there.
My SP procedure updates a column in this pin...
I am trying to call a stored procedure within a C# program. I get an
error "The type or namespace name 'CommandType' could not be found (are you missing a using directive or an assembly...
I have a table with a date column which has data in this format 2003-01-31 09:03:05.303. I would like to extract the date from this column and format it to 20030131 format. Can anyone help me...
Here are the version details of both the machines if that helps.
DOES NOT WORK ON
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft...
I have a basic insert statement like this,
INSERT INTO TRANS ( pin , date , time , type , amount , descr , userid ) VALUES ( '111111' , '20070425' , '230904' , '1Œ' , 3100 , '' , 'TEST' )
...
That was helpful. Thanks.
I was wondering if I could specify the output format. For example if my database table has fields like fname, lname, DOB. I would like it to output the data as 15 chars of...
I want to write a script which executes a select statement and outputs the data to file in the format I specify. What would be the easiest way to accomplish this.
There might be around 24 users connected during a stress test and it runs fine for 2-3 hours. Is there any way to check how many connections are being made to the datasource.
Where do we set the...
I have a C++ program that accesses SQL database using ADO.
Everything runs fine on the manual test but when I do a stress test after running for while I get the "out of database connections" in my...
I am trying to write to a binary file and while I am setting the values I have to convert an int to a char using
rec.cStopReason = (char) m_nStopCode; where the defnitions are as follows. ...
I use ADO to execute some SQL statements in my C++ code. Our test machines are windows NT. One of the NT machines is not starting our application and the error I see in the log file is Error =...