Please help with SQL Connection

Ask general questions here.
MMardon
Posts: 1
Joined: Wed Jun 29, 2022 7:27 am

Please help with SQL Connection

Post by MMardon » Wed Jul 06, 2022 7:34 pm

Hello,
Please help me to connect Ranorex with SQL to run existing query.
I used Data source to connect SQL Connector. Used connection string to connect and copy paste the existing query in Query textbox. However, the result is displaying as Row:0.
I execute the query in SSM and its working fine. Please help me what should i update or change. Why ranorex is not displaying the query result?

Thank you.
You do not have the required permissions to view the files attached to this post.

testerad
Posts: 2
Joined: Wed Feb 01, 2023 10:52 am

Re: Please help with SQL Connection

Post by testerad » Wed Feb 22, 2023 9:33 am

Hi, is there a way to create data source with relative path instead of using full physical path?

It is about data source for:
Microsoft Access Database File (OLEDB)

and Database file name:

e.g. full physical path:
C:\Users\dolberal\Documents\Ranorex\myConnector\mdbFiles\SNWX-Produkte.mdb

and relative path:
mdbFiles\SNWX-Produkte.mdb

Thanks very much.