Finally, I created a new project in a new solution, copied form and module
files into its folder, Show All Files, Included files.
The new project did not get the error. Done!!!
MLarsB
Last Activity: Feb 13 '14, 01:01 AM
Joined: Mar 13 '12
Location:
-
Program opens DOS/command window - but it should not
.Net Framework 4.0.30319 SP1Rel
vb.net 2010 10.0.40219.1 SP1Rel
Windows 7
I have searched on the web for this, but all I can find is how
to USE a command window from VB.net, nothing on how to NOT
get the window. I need to not have the window come up.
This problem is both when running debug in the IDE and after installing
with the .MSI.
When one of the command windows... -
How would I read a whole record set at one time? The way I know of doing that in a stored procedure. I am reading records from a different database on a different server and writing them into my database. I have the stored procedure written, but without a linked server I cannot use it, and security does not want to create the linked server. The stored procedures for the inserts are because that is the IT standard here.
The more...Leave a comment:
-
After the select, use drPRptg to read one record at a time.
Use GRGRcmd to insert records into a table using a stored procedure. Conditionally use TERMcmd to write to a second table with another stored procedure.
Stored procedures:
...Code:SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER OFF GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spSampGroupGRGRI]')
Leave a comment:
-
Is there a way to speed up this use of SQL Server 2000?
With the dates in the WHERE clause here, 5,100 records are selected. It takes the function
below 3 minutes to process them.
With the actual date range desired, 119,000 records are selected.
Does anyone see a way to make this run significantly faster?
...Code:SELECT HIST_ROW_ID, HIST_CREATE_DTM, HIST_LOG_ACT_CD, HIST_IMAGE_CD, HIST_TERM_ID, GRGR_CK, GRGR_ID, GRGR_STS, GRGR_TERM_DT, HIST_ROW_ID, GRGR_RENEW_MMDD
-
Return value from stored procedure is "nothing"
I have a stored procedure running in SQL Server 2000 which returns a value
when I run it in SQL Server Management Studio 2008 (SMS). I have also tested
it in SQL Server 2000 Query Analyzer with the same result. However, when I
run it with VB.Net 2010 I get "nothing" as the value of the return parameter:
cmd.Parameters( "@ReturnCount") .Value.
How do I get a value back? The parameter I am testing... -
Mystery solved:
As suggested in a reply to my question, I set cmd.CommandTime out = 600, where cmd is Dim'd as a SQLCommand.
I would have found this before if VB itellisense had offered that property. The next time I typed in cmd., in another part of the program, this property and others were listed by intellisense which had not been listed before.
Thanks to everyone who responded.Leave a comment:
-
Thanks, but the first thing is does is select across the linked server. The rest is selects on the records it had brought over.
I have asked the DBA's to do as suggested on another site:
You can set the time out on a specific linked server if you use the sp_serveroption system procedure with the query timeout option.
I have not heard back from them yet.Leave a comment:
-
Thanks.
The same stored procedure which runs in 2 minutes in SMS will not complete in 30 seconds through VB, with the same parameter values. It would seem the server hops would be the same for the two cases.
If I could set the timeout to 3 minutes the call in VB would most likely work.Leave a comment:
-
Set timeout for a stored procedure across a link to another server
SQL Server 2000, VB.Net 2010
I am executing a stored procedure from VB.Net in a database on one server, linking
to a database on another server. There are about 380 million rows in the table on
the other server. I select on the primary key, an int, to start with a value just
before the most recent three months. I also select on a datetime index for a date
range of one month.
When I run the stored...
No activity results to display
Leave a comment: