Click here to Skip to main content
15,898,723 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Print file VB.Net Pin
Dave Kreskowiak2-Nov-04 8:04
mveDave Kreskowiak2-Nov-04 8:04 
GeneralRe: Print file VB.Net Pin
Mekong River2-Nov-04 13:48
Mekong River2-Nov-04 13:48 
GeneralRe: Print file VB.Net Pin
Mekong River2-Nov-04 17:24
Mekong River2-Nov-04 17:24 
GeneralVisio ActiveX Drawing Control Pin
pantera728-Oct-04 5:31
pantera728-Oct-04 5:31 
GeneralData Grid Paging Pin
rjcarney28-Oct-04 2:38
rjcarney28-Oct-04 2:38 
GeneralRe: Data Grid Paging Pin
Mekong River31-Oct-04 22:15
Mekong River31-Oct-04 22:15 
Generalclient server app in VB+SQL Pin
shaf_sar27-Oct-04 16:58
shaf_sar27-Oct-04 16:58 
GeneralRe: client server app in VB+SQL Pin
Mekong River27-Oct-04 18:59
Mekong River27-Oct-04 18:59 
In my opinion, The Initial Catalog won't change but the Data Source might change base on the server name for each machine. As far as I know (local) variable is use to represent for each server name.

shaf_sar wrote:
"Provider=SQLOLEDB.1Persist Security Info=False;User ID=sa;Initial Catalog=dbDesa;Data Source=MSSYA"

So your code should become to:

"Provider=SQLOLEDB.Persist Security Info=False;User ID=sa;Initial Catalog=dbDesa;Data Source=(local)" or "Provider=SQLOLEDB.Persist Security Info=False;User ID=sa;Initial Catalog=dbDesa;Data Source=local"

Try to check at http://www.connectionstrings.com/[^] for more information. For your database in sql server try use sp_detach_db and sp_attach_db store procedure to deploy it to the other machine. If you have SQL server book online then you can choose have a look at it for reference.



A thousand mile of journey, begin with the first step.

APO-CEDC
Save Children Norway-Cambodia Office

GeneralRe: client server app in VB+SQL Pin
RichardGrimmer29-Oct-04 4:09
RichardGrimmer29-Oct-04 4:09 
GeneralRe: client server app in VB+SQL Pin
Mekong River31-Oct-04 22:11
Mekong River31-Oct-04 22:11 
GeneralImport excel using VBA Pin
Rip V. Winkle27-Oct-04 15:44
Rip V. Winkle27-Oct-04 15:44 
GeneralDragDrop Pin
PaleyX27-Oct-04 11:55
PaleyX27-Oct-04 11:55 
GeneralRe: DragDrop Pin
Tom John29-Oct-04 4:59
Tom John29-Oct-04 4:59 
QuestionHow to receive mail using sockets or anything without using third party utility (control) in vb.net Pin
Member 138681227-Oct-04 11:26
Member 138681227-Oct-04 11:26 
GeneralAccess like Report Pin
MohammadAmiry27-Oct-04 6:48
MohammadAmiry27-Oct-04 6:48 
GeneralRe: Access like Report Pin
larryjf27-Oct-04 9:42
larryjf27-Oct-04 9:42 
GeneralRe: Access like Report Pin
MohammadAmiry28-Oct-04 8:17
MohammadAmiry28-Oct-04 8:17 
GeneralCoding Pin
Member 116832427-Oct-04 6:09
Member 116832427-Oct-04 6:09 
GeneralRe: Coding Pin
MohammadAmiry27-Oct-04 6:42
MohammadAmiry27-Oct-04 6:42 
GeneralManipulating a String Pin
Brad Fackrell27-Oct-04 5:18
Brad Fackrell27-Oct-04 5:18 
GeneralRe: Manipulating a String Pin
cwayman27-Oct-04 5:46
cwayman27-Oct-04 5:46 
GeneralRe: Manipulating a String Pin
Brad Fackrell28-Oct-04 2:14
Brad Fackrell28-Oct-04 2:14 
GeneralNot sure where to start Pin
dahlst27-Oct-04 4:32
dahlst27-Oct-04 4:32 
GeneralSqlCEDataAdapter problem. How can I update ? Dataset has the changes. Pin
vasper27-Oct-04 3:25
professionalvasper27-Oct-04 3:25 
GeneralMouse Scroll button in Flexgrid not working Pin
parthi197727-Oct-04 2:51
parthi197727-Oct-04 2:51 

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.