Hi, everyone!
Tell me please, who is familiar with the subject SQL Server + Clarion IP Driver and Data Server how to work with TURBOSQL driver string?
Whether there are examples “SQL Query for SQL Server Database + Clarion IP Driver and Data Server”?
The example on the basis of IP Drivers Examples Client People is desirable
I have access to the SQL server is through Clarion IP Driver, but it is impossible to receive result a request on TurboSQLTable {PROP:SQL} = 'SELECT * FROM People '.
Need working Clarion code for creation of IP_people.dll and people.exe for receiving reply to the request of TurboSQLTable {PROP:SQL} = 'SELECT * FROM People ’ through Clarion IP Driver Data Server
will give you some ideas.
Basic idea is to issues the prop:sql then immediately do an error check (that will catch errors in the prop:sql statement itself)
Assuming no errors then you can do a loop and next on the file to retrieve the result set a row at a time.
NB It’s not actually necessary to have the columns in the ‘dummy’ turbosql table exactly match the datatypes you want to retrieve.
You can just use CSTRINGs with a length equal to the largest expected result.
So for example my dummy turbosql table has twenty CSTRING(261) in it.
Clarion will auto convert the datatypes for you when you assign from the dummy table to the destination variable or function.
Graham
Graham I thank for an quick response!
But a problem in operation through Clarion IP Driver Data Server.
If i have direct access to MSSQL the server, then does not have problems.
Need the example in the Clarion code with MSSQL server on the basis of an example of People from delivery of Clarion IP Driver Data Server
Greetings 
This topic seems to fit my question.
Moving to MS SQL 2019 from TPS. All is well.
One app in the solution makes use of the IP Driver. Worked well with TPS files.
But since moving to SQL the ip-app won’t open the files.
True, there is a GLO:CONNECTOWNER string which is set containing the server name and password… File name DBO.INVOICE .
In the CLW FILE, of the ip_dll that is DEPLOYED, the source code show that the GLO:CONNECTOWNER variable is FILLED, right after all the TABLES are declared.
Still, the app opens, then trying to open a file. Hourglass 
and after a few seconds, file cannot be opened 
.
Any tips?
I did some research into this issue a few years ago.
Maybe these documents might help
1 Like
Thank you “JobCard”
That worked. Yippee!! 
Studying the PDFs it became clear that the DriverOwner variable - ServerVariable -of the TABLE must be defined in the GLOBAL DATA pad of the IP_Data app. NOT in the DICTIONARY GLOBAL.
Then in the IP_Data APP, GLOBAL EMBEDS → Program Setup, Under [Extended options Init]
ServerVariable = 'MySQLServer1,Test_Database,sa,P@assword1'
Appreciate you sharing the PDFs.
Have a lovely day!
Fouché
Happy that they helped and you got it working.
cheers
Rohan