Connect Harbour to MS Sql Server

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

Post Reply
jparada
Posts: 433
Joined: Fri Jan 23, 2009 5:18 pm

Connect Harbour to MS Sql Server

Post by jparada »

Hi,

I'm posting here a question I asked in the harbor users groups...
jparada wrote:To connect to MS SQL Server, which is available .. ADO, ODBC, ADORDD and RDDSQL, there is another option ...?.

Of course I dismissed ODBC, and RDDSQL and ADORDD because my intention is not emulate dbf syntax.

So the only thing I have available is ADO...?, I have no choice...? or better something native ...?.

PS. Talking to a friend of mine that connects to MS SQL Server via ADO with VB, I commented to him that harbour and ADO was faster than VB and ADO, and he asked me why if ADO layer is the same, no matter the programming language used, it's that true ...?, I did not give an answer to him because in fact I do not know.
I'm not interested in options like ADORDD or RDDSQL, much less ODBC, so the question is if ADO is the only option for me...?.

What about my question Harbour + ADO vs VB6 + ADO, it is true that it is the same ...?.

I appreciate any help.

Regards,
Javier
jayadevu
Posts: 240
Joined: Tue May 19, 2009 7:10 am

Re: Connect Harbour to MS Sql Server

Post by jayadevu »

Dear Javier,

You can use Mediator from OTC available free at http://www.otc.pl, very little change in the program, use regular statements like append, lock , use and manipulate the sql database.

HTH,

Warm regards,

Jayadev
Post Reply