Photo Gallery Member List Search Calendars FAQ Ticket List Log Out


How to pass server name as parameter to osql from VBS

  		Logged in as: Guest
arrSession:exec spGetSession 2,2,63766
Active Users: There are 0 members and 0 guests.
Users viewing this topic: none
 

 

  
 
  Printable Version
All Forums >> [Scripting] >> WSH & Client Side VBScript >> How to pass server name as parameter to osql from VBS
  Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks! 		Page: [1]
Login
Message << Older Topic   Newer Topic >>
How to pass server name as parameter to osql from VBS - 8/24/2008 8:57:57 AM   
  BikeBoy

 

Posts: 10
Score: 0
Joined: 1/4/2006
Status: offline 		Hello,

I am trying to do something like that from VBScript:

Dim strServer
Dim strDB
strServer = "MyServer"
strDB = "My DB"

Set WshShell = CreateObject("Wscript.Shell")
strCmd = "osql -d strDB -S strServer -E -ic:\sqlfile.sql -oc:\sqllog.log
Wscript.Run strCmd


This is not working since osql is trying to connect to strServer. How do I pass servername as a variable? I would use sqlcmd but it doesn't work with sql 2000 i don't think.

Thanks

 
 
Post #: 1
 
RE: How to pass server name as parameter to osql from VBS - 8/24/2008 12:45:59 PM   
  fosterr_2000

 

Posts: 115
Score: 0
Joined: 12/18/2004
From:
Status: offline 		Try this:

strCmd = "osql -d " & strDB & " -S " & strServer & " -E -ic:\sqlfile.sql -oc:\sqllog.log"



Hope this helps!

(in reply to BikeBoy)
 
 
Post #: 2
 
RE: How to pass server name as parameter to osql from VBS - 8/25/2008 12:25:48 AM   
  BikeBoy

 

Posts: 10
Score: 0
Joined: 1/4/2006
Status: offline 		that worked, thanks a lot!

(in reply to BikeBoy)
 
 
Post #: 3
 
 
 
 

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.
All Forums >> [Scripting] >> WSH & Client Side VBScript >> How to pass server name as parameter to osql from VBS Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts




Forum Software © ASPPlayground.NET Advanced Edition 2.5.5 ANSI