Clarion Community

Search Sort Posts:  Oldest to newest Newest to oldest

04-23-2008, 9:11 AM EdwardB Joined on 04-23-2008 Posts 2 Clarion 5B / 5.5H and MS SQL 2005 Hi We're running native Clarion 5B and 5.5H apps in-house with MS SQL 2000. Its likely that we will need to install a new MS SQL 2005 database server so I would like to know if (a) SQL 2005 works with 5B/5.5H and (b) if there is anything I need to watch out for. There is the option of porting the apps to a later version of Clarion at some point but I'm worried about whether the 3rd party extensions we use in the apps will be happy with the move! I'm hoping it will just be a case of pointing the dictionaries to the new server and off we go... :-)    Report

04-23-2008, 10:53 PM Shankar Joined on 10-24-2005 Dubai, UAE Posts 219 Re: Clarion 5B / 5.5H and MS SQL 2005 Hi! The latest version of Clarion v6.3 supports SQL 2005 including MARS. I am not sure is the native driver will work properly in prior versions but using the ODBC driver along with the SQL Native Client should definitely work. Regards Shankar    Report

04-24-2008, 7:06 AM EdwardB Joined on 04-23-2008 Posts 2 Re: Clarion 5B / 5.5H and MS SQL 2005 Thanks Shankar. We use the native MS SQL driver in both cases and make good use of the PROP:SQL statement to issues commands direct. I'd definitely prefer to sticking with the native SQL driver, if possible, but I do appreciate you replying with your advice! In one of our main apps, as well as lots of PROP:SQL, we use classic 'Clarion' templates and still access records using NEXTs, SETs. If we buy 6.3 or 7 and attempt to port the code to ensure we can continue using the native SQL driver, am I looking at a wholesale rewrite?    Report

04-24-2008, 9:18 AM Shankar Joined on 10-24-2005 Dubai, UAE Posts 219 Re: Clarion 5B / 5.5H and MS SQL 2005 Hi Edward, C6.3 has a lot of important changes and supports the "Clarion" template chain which means that the changes might me minimal unless you plan to change it into an ABC application. But since you have waited so long without purchasing C6.x, the best option would be to copy you APP & DCT to a temporary folder, change the driver from MSSQL to ODBC in the dictionary, change the Owner / Driver String accordingly in the Application, change Driver/Owner/Driver String for any table structure in hand code,compile and test. The Owner string should be :: Standard security Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword; Trusted Connection Driver={SQL Native Client};Server=myServerAddress;Database=myDataBase;Trusted_Connection=yes; Equivalent key-value pair: "Integrated Security=SSPI" equals "Trusted_Connection=yes" Check www.connectionstrings.com for more info. Regards Shankar    Report

Clarion Communi... » Clarion » Databases and D... » Re: Clarion 5B / 5.5H and MS SQL 2005

(please select) Forums Home |- Search Forums |- Active Topics |- Unanswered Posts User Options |- Sign In |- Join this community |- Forgot Password Clarion |- Clarion Language and Runtime Library |- Databases and Drivers |- Clarion 6 - General Clarion.Net |- General