Clarion and access to MS SQL

[Dirk]

Hi,

I just want to find out if it is possible to access a MS SQL database
directly from Clarion 5.5 or do I have to go thru the ODBC driver. If
it is possible to connect directly would it be possible to let me know
how.

Thanks.

[Dirk]

Thanks for the information but this is where I am stuck at the moment.
My first step is to create the dictionary and I would like to import
my SQL2000 tables that I want to use because I have all my keys and
relationships setup already. If I define an ODBC connection and then
do the import things work and I guess I am not sure if this is the
right / best way to do it or could I do the import directly from
SQL2000.

Thanks,
Dirk

[John Hamilton]

Use the MSSQL Accelorator Driver. It eliminates the need to setup a DNS and
screw with ODBC management.

It still uses ODBC communications under the hood.
--
Thanks,
John Hamilton
POSitive Software Company
http://www.gopositive.com

Post by Dirk
Hi,
I just want to find out if it is possible to access a MS SQL database
directly from Clarion 5.5 or do I have to go thru the ODBC driver. If
it is possible to connect directly would it be possible to let me know
how.
Thanks.

[Jason Berkan]

On Fri, 25 Jul 2003 20:33:00 -0600, "Benjamin Krajmalnik"

Post by John Hamilton
Use the MSSQL Accelorator Driver. It eliminates the need to setup a DNS

and

Post by John Hamilton
screw with ODBC management.

You are incorrect. I use ODBC with a DSN-less connection. That way, I can
access any ODBC conmpliant backend.
I assume that Dirk is using C55PE (since he mentioned he does not have the
"native" MSSQL accelerator).

C55PE (at least my copy) came with the MSSQL driver. You just have to
register it, as it is not registered by default.

Jason

[John Hamilton]

However this person is asking about easy MSSQL integration. The MS SQL
Accelerator is one of the easiest SQL setups I've ever used in any language.
No headaches. Easy to walk a customer through. I use DNSLess ODBC as well
and it's still not as simple.

Just a lowly opinion.
--
Thanks,
John Hamilton
POSitive Software Company
http://www.gopositive.com

Post by John Hamilton
Use the MSSQL Accelorator Driver. It eliminates the need to setup a DNS

and

Post by John Hamilton
screw with ODBC management.

You are incorrect. I use ODBC with a DSN-less connection. That way, I

can

access any ODBC conmpliant backend.
I assume that Dirk is using C55PE (since he mentioned he does not have the
"native" MSSQL accelerator).
If he has C55EE, then Synchronizer is a better option to importing the
tables one by one.