Click here to Skip to main content
15,907,687 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionPDF parser Pin
εїзεїзεїз23-May-11 9:44
εїзεїзεїз23-May-11 9:44 
AnswerRe: PDF parser Pin
Dalek Dave23-May-11 13:20
professionalDalek Dave23-May-11 13:20 
GeneralA quick question for you - preparing it Pin
TONY_R23-May-11 0:49
TONY_R23-May-11 0:49 
GeneralRe: A quick question for you - preparing it Pin
Dave Kreskowiak23-May-11 1:35
mveDave Kreskowiak23-May-11 1:35 
GeneralRe: A quick question for you - preparing it Pin
Luc Pattyn23-May-11 1:53
sitebuilderLuc Pattyn23-May-11 1:53 
QuestionMulti-threading a windows service in VB [modified] Pin
rguerett20-May-11 8:19
rguerett20-May-11 8:19 
AnswerRe: Multi-threading a windows service in VB Pin
Luc Pattyn20-May-11 8:33
sitebuilderLuc Pattyn20-May-11 8:33 
AnswerRe: Multi-threading a windows service in VB Pin
David Mujica20-May-11 8:36
David Mujica20-May-11 8:36 
Do I understand that your service has one connection string and it is connected to Server B ?

When you are accessing data you get the results from a table that is stored on a linked server.

You issue an update to some table on server B with the results obtain from the linked table.

Is the above correct ?

I'm unclear as to where the problem is ... is this a database issue or a multi-thread problem ?

Suggestion:
Is it possible to have 2 connection strings one for each server and not rely on the "linked data" ?

I'm not sure how you are processing your updates, but maybe you could get all your data from the linked server, copy it to a Temp table, then use an update from that Temp table to the table on server B. This would reduce the number of SQL calls.

sounds like a complex problem, but I don't know where to begin to offer advice.

Post some more info and everyone here will try to help you.

Good luck. Thumbs Up | :thumbsup:
QuestionOnly FW4 possible After new install Pin
JR21219-May-11 19:29
JR21219-May-11 19:29 
AnswerRe: Only FW4 possible After new install Pin
Dalek Dave19-May-11 21:17
professionalDalek Dave19-May-11 21:17 
GeneralRe: Only FW4 possible After new install Pin
AspDotNetDev21-May-11 12:43
protectorAspDotNetDev21-May-11 12:43 
AnswerRe: Only FW4 possible After new install Pin
AspDotNetDev21-May-11 12:40
protectorAspDotNetDev21-May-11 12:40 
QuestionAlign Long String in DataGridView Cell to Show String End Pin
Andraw Tang19-May-11 8:35
Andraw Tang19-May-11 8:35 
AnswerRe: Align Long String in DataGridView Cell to Show String End Pin
Dave Kreskowiak19-May-11 9:02
mveDave Kreskowiak19-May-11 9:02 
GeneralRe: Align Long String in DataGridView Cell to Show String End Pin
Andraw Tang19-May-11 10:15
Andraw Tang19-May-11 10:15 
AnswerRe: Align Long String in DataGridView Cell to Show String End Pin
Luc Pattyn19-May-11 9:12
sitebuilderLuc Pattyn19-May-11 9:12 
GeneralRe: Align Long String in DataGridView Cell to Show String End Pin
Andraw Tang19-May-11 10:35
Andraw Tang19-May-11 10:35 
Questionparsing .frm file for control names and nested level Pin
john john mackey17-May-11 9:27
john john mackey17-May-11 9:27 
AnswerRe: parsing .frm file for control names and nested level Pin
Dave Kreskowiak17-May-11 10:11
mveDave Kreskowiak17-May-11 10:11 
GeneralRe: parsing .frm file for control names and nested level Pin
john john mackey17-May-11 10:32
john john mackey17-May-11 10:32 
GeneralRe: parsing .frm file for control names and nested level Pin
Dave Kreskowiak18-May-11 2:52
mveDave Kreskowiak18-May-11 2:52 
Questionlogin into website Pin
DanYELL17-May-11 5:12
DanYELL17-May-11 5:12 
AnswerRe: login into website Pin
Dave Kreskowiak17-May-11 6:54
mveDave Kreskowiak17-May-11 6:54 
GeneralRe: login into website Pin
DanYELL17-May-11 11:18
DanYELL17-May-11 11:18 
GeneralRe: login into website Pin
Dave Kreskowiak18-May-11 2:49
mveDave Kreskowiak18-May-11 2:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.