Share this page

# Example: lr_db_connect

In the following example, lr_db_connect connects to an Inventory SQL database using Oracle.

    lr_db_connect("StepName=Connect", "ConnectionString=Provider=OraOLEDB.Oracle.1,
    	Data Source=<Paste the Net service name from the clipboard here>; Persist Security Info=True;
           User ID=myUser;Password=myPassword", "ConnectionName=db1", "ConnectionType=OLEDB", LAST );

In the following example, lr_db_connect connects to an Inventory SQL database using SQL authentication.

    lr_db_connect("StepName=DatabaseConnection",
            "ConnectionString=Data Source=myServer.myLab.ad;Initial Catalog=InvDatabase;Persist Security Info=True;User ID=myUser;Password=myPassword",
            "ConnectionName=InvDatabaseConnection",
            "ConnectionType=SQL",
            LAST );

In the following example, lr_db_connect connects to an Inventory SQL database using Windows authentication. Note the additional Integrated Security argument that must be specified.

    lr_db_connect("StepName=Connect",
            "ConnectionString=Data Source=myServer\\mySoa;Integrated Security=SSPI;Password=password;User ID=DOMAIN\\UserName;Initial Catalog=soa;",
            "ConnectionName=db1",
            "ConnectionType=SQL",
            LAST );

Tips to improve your search results... VuGen Function Reference Version 25.1-25.3 Function Reference 25.1-25.3 All View Local Help Center View Online Help Center Version: