search

jorkin / aspjson

Automatically exported from code.google.com/p/aspjson
0 stars 0 forks source link

Connection String for SQL Server?? #10

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Please give me an example.

Thanks
Art.

Original issue reported on code.google.com by siamdayt...@gmail.com on 13 May 2009 at 7:46

GoogleCodeExporter commented 9 years ago 

I already known.
This code is OK!..

<%       
Dim dbstr, dbconn   
dbstr = "Provider=SQLOLEDB; Data Source = (local); Initial Catalog = 
[databasename]; 
User Id = [user]; Password=[pwd]"   
Set dbconn = CreateObject("ADODB.Connection")
dbconn.Provider = dbstr
dbconn.Open dbstr      
QueryToJSON(dbconn, "SELECT top 10 companyname FROM company").Flush
%>

Art.

Original comment by siamdayt...@gmail.com on 13 May 2009 at 9:01

GoogleCodeExporter commented 9 years ago

Original comment by tugrulto...@gmail.com on 8 Nov 2009 at 7:23