We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
I error at Line 9 char 7
Dim conn , rs, sql, ConnString sql = "SELECT * FROM sessiontbl" Set rs = CreateObject("ADODB.Recordset") Set conn = CreateObject("ADODB.Connection") With conn .Provider = "SQLOLEDB" .Mode = adModeReadWrite .ConnectionString ="Data Source=SANDBOX;Trusted_Connection=Yes;InitialCatalog=Inventory;" .Open WScript.Echo "Connection was established." End With rs.Open sql,conn If conn.State = adStateOpen Then WScript.Echo "Connection was established." Else WScript.Echo "No Connection ." End If rs.Close Set rs = Nothing conn.Close Set conn = Nothing
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Force application to connect using sql native client for mirroring||3||18|
|semaphore timeout period has expired||1||29|
|Need help with part of sql query for a condition||12||31|
|Total count in section based report in SSRS||10||6|
Join the community of 500,000 technology professionals and ask your questions.