How to connect SQL server with clarion5

questions
1

Hi,

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?

2

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

3

Hi jslarve,

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

4

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. https://www.connectionstrings.com/

5

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

6

Hello,

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.