Connection String to SQL Server 2005 database via VBScript

• Double-B

  SSC Enthusiast

  Points: 120

  More actions

  May 22, 2007 at 2:23 pm

  #174358

  I am trying to connect to a database on a SQL Server 2005 server.  The connection string below works on a SQL2000 server, but I get the following condition after the rsobj.open statement ...

  Connection string = "Provider=sqloledb;Data Source=servername;Initial Catalog=db_name;Integrated Security=SSPI;"

  Error condition for a given expected return field (objRecordset("ProjID")) = "Item cannot be found in the collection corresponding to the requested name or ordinal"

  A given property on the recordset object states that the "operation is not allowed when the object is closed" ... which indicates to me that although I processed an open statement, the object never opened because of an incorrect/invalid connection connection string.

  Any assistance would be greatly appreciated.

  Double-B

• Epifano San Jose

  Grasshopper

  Points: 15

  More actions

  May 1, 2008 at 7:53 pm

  #809888

  Hi,

  You might need to install Microsoft SQL Server Native Client in your PC and

  use appropriate connection string. The correct connection string could be

  in http://www.connectionstrings.com/?carrier=sqlserver2005