"SQL Server does not exist" Error

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

"SQL Server does not exist" Error

Author

Topic

Plotin
Starting Member

21 Posts

Posted - 2005-12-06 : 09:32:36

Hi

The following JScript code returns [DBNETLIB][ConnectionOpen (Connect().)SQL Server does not exist or access denied error.

function GETRECORDS(){
var adoCon;
adoCon = new ActiveXObject("ADODB.Connection.2.8");
adoRst = new ActiveXObject("ADODB.Recordset.2.8")

adoCon.Provider = "SQLOLEDB";
adoCon.CursorLocation = 3;
adoCon.IsolationLevel = 256;
adoCon.Mode = 2;
adoCon.ConnectionString = "Data Source = GFSSVR1015\Mike_Test;Initial Catalog = WorkDummy;Integrated Security = SSPI"

adoCon.Open;
adoRst.Open("Select * From OfferCondition,adoCon,3,1);
window.alert(adoRst.RecordCount);
adoRst.Close;
adoCon.Close;
}

Enabled SQL Server Network Protocols are Named Pipes and TCP/IP.

Named Pipes property is
Default Pipe: \\.\pipe\MSSQL$MIKE_TEST\sql\query
and TCP/IP property is
Default Port:1433

Any assistance is highly appreciated.

Thanks

Plotin

my_aro
Yak Posting Veteran

50 Posts

Posted - 2005-12-06 : 23:48:25

try to look closely at your connection type, at the sql server name and the port including the password maybe you just missed out something.. it could be so impossible for your machine not to locate your sql server if its installed properly

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources