asked
SQL connection string works on VB but not on IE(javascript).
I want to make a query to my local sql server databas . This works fine on VB6: Dim cnn As ADODB.Connection Set cnn = New ADODB.Connection cnn.Open "Provider=SQLOLEDB;Initial Catalog=PW8_EMP000_TYC2013;Data Source=ZALMANPC\SQLEXPRESS;integrated security=SSPI; persist security info=True;" And I want to do the same with javascript. var connection = new ActiveXObject("ADODB.Connection") ; var connectionstring="Provider=SQLOLEDB;Initial Catalog=PW8_EMP000_TYC2013;Data Source=ZALMANPC\SQLEXPRESS;integrated security=SSPI; persist security info=True;" But I have the error " [DBNETLIB][ConnectionOpen (Connect()).] Does not exist SQL server or you have dennied access What's happen ????? I'm using IE 8. I have all IE-Activex options enabled. Any help would be appreciated- Thanks
can you try a sql server login instead of sspi just to see if you get a different result?
14 People are following this question.
