Photo Gallery Member List Search Calendars FAQ Ticket List Log Out


DSN less connection to SQL Named Instance

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

 

  
 
  Printable Version
All Forums >> [Scripting] >> WSH & Client Side VBScript >> DSN less connection to SQL Named Instance
  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 >>
DSN less connection to SQL Named Instance - 2/9/2004 8:39:55 PM   
  sreilly

 

Posts: 1
Score: 0
Joined: 2/9/2004
From:
Status: offline 		I'm trying to connect to a sql database (a named instance of SQL Server 2000). But tweaking the old connection string i was using
to an access database isn't working. It says it can find the
server - is there some knack to using a named instance?

'set objDC = server.createobject("ADODB.Connection")'
'objDC.ConnectionString = "Driver={SQL Server};SERVER=\\W2K9999\SQL1;UID=sa;DATABASE=Master"'
'objDC.open'
 
 
Post #: 1
 
Re: DSN less connection to SQL Named Instance - 2/11/2004 5:19:44 AM   
  rhrogers

 

Posts: 5
Score: 0
Joined: 2/6/2004
From: Canada
Status: offline 		Your params for the connection string look a bit off. I refer you to this website on OLEDB Connection string construction with SQL Server. Hope it can be of some help.
http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForSQLServer

(in reply to sreilly)
 
 
Post #: 2
 
 
 
 

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 >> DSN less connection to SQL Named Instance 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