|
|
Clarion 6 - General
Started by Aces at 08-13-2008 7:57 PM. Topic has 14 replies.
  
|
|
Sort Posts:
|
|
|
|
 08-13-2008, 7:57 PM
|
Aces
 
Joined on 08-14-2008
Philippines
Posts 4
|
Clarion 6.3 and MS SQL 2005
|
|
|
|
|
Hello everyone! I'm new to Clarion software and I want to use MS SQL 2005 as my database. How do I get start? what do I need first?
|
|
|
|
|
Report
|
|
|
|
|
08-14-2008, 2:33 AM
|
Wolfgang Orth
Joined on 10-25-2005
Rastede, NW-Germany
Posts 49
|
Re: Clarion 6.3 and MS SQL 2005
|
|
|
|
|
|
Hello Aces,
how "new" are you to Clarion?
What about looking at the examples and work through the "Getting Started", using TPS as your datafiles.
Once you get used to Clarion and see how easy programming is with this tool, you can switch to any other data-file-driver.
Just my 2 cent
Wolfgang
Regards
Wolfgang Orth
|
|
|
|
|
Report
|
|
|
|
|
08-14-2008, 2:15 PM
|
samir
Joined on 05-21-2008
Posts 28
|
Re: Clarion 6.3 and MS SQL 2005
|
|
|
|
|
|
Hello Aces,
If you want to enjoy, get the SQL online training course. You will be productive in MS SQL 2005 in short time.
Best wishes.
Samir
|
|
|
|
|
Report
|
|
|
|
|
08-14-2008, 6:20 PM
|
Aces
Joined on 08-14-2008
Philippines
Posts 4
|
Re: Clarion 6.3 and MS SQL 2005
|
|
|
|
|
|
Thank you very much for reply.. ^__^
What I mean is that I can only use its native database (TPS). I enjoyed using Clarion, so I want more out of it. I'm thinking of integrating Clarion and MS SQL but don't know how to get started..
|
|
|
|
|
Report
|
|
|
|
|
08-14-2008, 6:26 PM
|
samir
Joined on 05-21-2008
Posts 28
|
Re: Clarion 6.3 and MS SQL 2005
|
|
|
|
|
|
Hello Aces,
Try Google the following:-
" clarion Better SQL and OOP "
Best wishes,
Samir
|
|
|
|
|
Report
|
|
|
|
|
08-15-2008, 7:16 PM
|
Aces
Joined on 08-14-2008
Philippines
Posts 4
|
Re: Clarion 6.3 and MS SQL 2005
|
|
|
|
|
|
Thanks Samir,
I've got the DCT2SQL templates and also registered it to Clarion. How will I use these templates?
|
|
|
|
|
Report
|
|
|
|
|
08-16-2008, 9:45 AM
|
samir
Joined on 05-21-2008
Posts 28
|
Re: Clarion 6.3 and MS SQL 2005
|
|
|
|
|
|
Hello Aces,
These templates are application utilities. They come into place when an application is open. Simply press CTRL-U to access them. They will read the application dictionary and create SQL scripts for the common back end databases. A million thanks to Roberto who made this stuff available to this community.
Regards.
Samir
|
|
|
|
|
Report
|
|
|
|
|
08-18-2008, 8:00 AM
|
PBlais
Joined on 01-10-2007
Hayes, VA
Posts 2
|
Re: Clarion 6.3 and MS SQL 2005
|
|
|
|
|
|
Do you have the Clarion Enterprise version? The professional version does not support the SQL drivers.
Paul Blais
Hayes, Virginia
|
|
|
|
|
Report
|
|
|
|
|
08-19-2008, 5:21 PM
|
samir
Joined on 05-21-2008
Posts 28
|
Re: Clarion 6.3 and MS SQL 2005
|
|
|
|
|
|
Hello Paul,
Check your Database Driver Registry. IF you can see ODBC, you can connect to any SQL back end. You will need to get the ODBC setup for the specified database. e.g. You can connect to PostGreSQL after you download PostGres ODBC.
Regards.
Samir
|
|
|
|
|
Report
|
|
|
|
|
09-08-2008, 8:53 AM
|
Mahdi
Joined on 09-08-2008
Posts 1
|
Re: Clarion 6.3 and MS SQL 2005
|
|
|
|
|
|
Hello Guys,
I am working with Clarion 6.0. I got the DCT2SQL templates but I cann't register it. Clarion couldn't open include files (.TPW).
What should I do?
Thanks,
|
|
|
|
|
Report
|
|
|
|
|
09-12-2008, 12:41 AM
|
samir
Joined on 05-21-2008
Posts 28
|
Re: Clarion 6.3 and MS SQL 2005
|
|
|
|
|
|
Hello ayeimee,
If you know English, can you kindly post in a language we can understand, definitely not in your mother-tongue language (Tagalo). I have many Philipino friends but it would be more appropriate if you ask somebody of yours to translate...
Regards.
|
|
|
|
|
Report
|
|
|
|
|
09-14-2008, 5:31 PM
|
ayeimee
Joined on 09-11-2008
Ofreci
Posts 7
|
Re: Clarion 6.3 and MS SQL 2005
|
|
|
|
|
|
|
Hi Samir!
Sorry about that, there is no bad intention with it, I'm just a bit excited when I found out that Clarion users are growing here in our country, peace ....
|
|
|
|
|
Report
|
|
|
|
|
09-21-2008, 5:52 PM
|
Jock
Joined on 09-22-2008
Posts 1
|
Re: Clarion 6.3 and MS SQL 2005
|
|
|
|
|
|
I'm rather surprised at Paul's comment since I've been using PE with SQL backends for some years now, originally connecting to MSDE via ODBC.
I also have an app which uses SQL 2005 Express via the SQL drivers. It's been live for just about one year now.
|
|
|
|
|
Report
|
|
|
|
|
09-21-2008, 6:17 PM
|
Aces
Joined on 08-14-2008
Philippines
Posts 4
|
Re: Clarion 6.3 and MS SQL 2005
|
|
|
|
|
|
Hello Ayeimee,
Very nice! If possible can you share a copy of your SQL Training?
Thanks in advance!
|
|
|
|
|
Report
|
|
|
|
|
|