How to access ConnectionString in VBScript?

[SunnyYu-98]

Hi, how can I access the ConnectionString variable in VBScript?

My app is developed with Classic ASP and hosted on Azure App Services.

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 91979290-94f6-b300-e200-f071129a92b2
• Version Independent ID: 77b80ec5-3559-74e6-e0fa-6384b20052e5
• Content: Configure web apps in Azure App Service
• Content Source: articles/app-service/web-sites-configure.md
• Service: app-service
• GitHub Login: @cephalin
• Microsoft Alias: cephalin

[Grace-MacJones-MSFT]

Hi @UIrving, thanks for the feedback! We are currently investigating and will update you shortly.

[BryanTrach-MSFT]

@UIrving The below snippet allowed me to access my DB. I hope this helps.

We will now proceed to close this thread. If there are further questions regarding this matter, please tag me in your reply. We will gladly continue the discussion and we will reopen the issue.

Dim conn , rs, sql, ConnString sql = "SELECT * FROM tblOutbox" Set rs = CreateObject("ADODB.Recordset") Set conn = CreateObject("ADODB.Connection") With conn .Provider = "SQLNCLI" .Mode = adModeReadWrite .ConnectionString = "SERVER=.\SQLExpress;AttachDbFilename=F:\Test2.mdf;Database=Test2.mdf; Trusted_Connection=Yes;" .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