Highlighted
Absent Member.. Absent Member..
Absent Member..
142 views

Syntax Error - lr_db_connect

Jump to solution

Why would I be getting a syntax error on the following?

 

	lr_db_connect("StepName=TestConnect",
		"ConnectionName=VSQLDB",
		"ConnectionString=Data Source="VSQLB\\LVSQLDB01,1435";Initial Catalog=Cache;Integrated Security=True",
		"ConnectionType=SQL",
		LAST);

It follows the example given for lr_db_connect.

 

Thanks,

Cody

0 Likes
1 Solution

Accepted Solutions
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: Syntax Error - lr_db_connect

Jump to solution

Hello Cody,

 

There are extra quotes on your function.

 

Must be like this:

 

lr_db_connect("StepName=TestConnect",
        "ConnectionName=VSQLDB",
        "ConnectionString=Data Source=VSQLB\\LVSQLDB01,1435;Initial Catalog=Cache;Integrated Security=True",
        "ConnectionType=SQL",
        LAST);

 

The extra qoutes were on your Source path.

 

 

Regards,

Daniela Gómez Alvarado
Customer Support Engineer

If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a KUDOS by clicking on the STAR at the bottom left of the post and show your appreciation.

View solution in original post

2 Replies
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: Syntax Error - lr_db_connect

Jump to solution

Hello Cody,

 

There are extra quotes on your function.

 

Must be like this:

 

lr_db_connect("StepName=TestConnect",
        "ConnectionName=VSQLDB",
        "ConnectionString=Data Source=VSQLB\\LVSQLDB01,1435;Initial Catalog=Cache;Integrated Security=True",
        "ConnectionType=SQL",
        LAST);

 

The extra qoutes were on your Source path.

 

 

Regards,

Daniela Gómez Alvarado
Customer Support Engineer

If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a KUDOS by clicking on the STAR at the bottom left of the post and show your appreciation.

View solution in original post

Highlighted
Absent Member.. Absent Member..
Absent Member..

Re: Syntax Error - lr_db_connect

Jump to solution

Dang quotes get me everytime, thanks!

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.