I am writing a program and i need to connect to an Azure Database to do inserts. Our db does not allow Entra account logins
the program can be visual cobol or visual cobol .net which ever will work
I am looking for a connection string.
Cybersecurity
DevOps Cloud
IT Operations Cloud
If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more
I am writing a program and i need to connect to an Azure Database to do inserts. Our db does not allow Entra account logins
the program can be visual cobol or visual cobol .net which ever will work
I am looking for a connection string.
I found several examples of connection strings for Azure SQL database here:
If you are planning on using OpenESQL with EXEC SQL embedded SQL support, then you would create a .NET COBOL program and connect to the database using its ADO driver.
I found an example of how to find the ADO connection string to use in the EXEC SQL CONNECT statement here:
For this example, the connect statement would then look something like this where you would replace connString with the connection string for your database.
01 connString string. procedure division. set connString to "Server=tcp:myserver.database.windows.net,1433;Authentication=Active Directory Password;Database=myDataBase;UID=myUser@myDomain;PWD=myPassword;factory=System.Data.SqlClient;" EXEC SQL CONNECT USING :connString END-EXEC
Chris Glazier
Rocket Software - Principal Technical Support Specialist
If you found this post useful, give it a “Like” or click on "Verify Answer" under the "More" button