How to connect SQL server with clarion5


I’m new to clarion. We are using clarion5 application(Since already application developed through Clarion5). I’m creating a new sample application through Clarion 5. How we can find out the DB server name for the newly created application? and how to map the tables accordingly?

Are you using an existing database or do you need to create one?

Hi jslarve,

I’m using existing database. But I don’t where the DB server name will be available.

You would need to get that information from the db admin and use it in a “connection string” that you assign to OWNER() or PROP:Owner of the file. I don’t know anything about the limitations you might hit when doing this in C5, or the best way to get the tables into a dictionary.
You’ll need to make sure you have a 32-bit version of the ODBC driver.

Here’s a site that can be useful for connection strings.

Thank you for the response. I will check that connection string.


I’m trying to create a new clarion application with MS Sql database. Can you please let me know what is the step by step procedure to connect to MSSQL. I’m using clarion 5 version.