Ejemplo de Tdatarow para crear Base de datos y tablas

Re: Ejemplo de Tdatarow para crear Base de datos y tablas

Postby Compuin » Sat Apr 01, 2017 3:53 pm

Which dll file do I need to connect MSSSQL using ADO?
FWH 20.12
Hbmk2 32/64 Bits (Build 19.29.30133)
Microsoft Visual C 32 Bits
MySql 8.0.24 32/64 Bits
VS Code
Compuin
 
Posts: 1213
Joined: Tue Dec 28, 2010 1:29 pm
Location: Quebec, Canada

Re: Ejemplo de Tdatarow para crear Base de datos y tablas

Postby nageswaragunupudi » Sat Apr 01, 2017 3:56 pm

All recent Windows versions have the drivers installed by default.
You do not have to do anything.
Just use FW_OpenAdoConnection () and provide teh parameters correctly.

Why are you asking? Are you experiencing problems in connecting?
What is the Windows version of your PC?
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10248
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: Ejemplo de Tdatarow para crear Base de datos y tablas

Postby Compuin » Sat Apr 01, 2017 4:06 pm

I have Windows 7...I would like to connect with SQL Server 2014

I'm not sure if decide between FWH ODBC Class or ADO class....I'm not sure if query speed is granted by the drivers itself instead the class.

Please, advise
FWH 20.12
Hbmk2 32/64 Bits (Build 19.29.30133)
Microsoft Visual C 32 Bits
MySql 8.0.24 32/64 Bits
VS Code
Compuin
 
Posts: 1213
Joined: Tue Dec 28, 2010 1:29 pm
Location: Quebec, Canada

Re: Ejemplo de Tdatarow para crear Base de datos y tablas

Postby nageswaragunupudi » Sat Apr 01, 2017 7:34 pm

ODBC is the oldest technology
ADO is based on OLEDB which is a later development.

ADO works the best with MSSQL. There is no better option than ADO for MSSQL.
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10248
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: Ejemplo de Tdatarow para crear Base de datos y tablas

Postby Compuin » Sat Apr 01, 2017 8:05 pm

Thanks

Which is the most complete fwh sample with all ado functions to learn?
FWH 20.12
Hbmk2 32/64 Bits (Build 19.29.30133)
Microsoft Visual C 32 Bits
MySql 8.0.24 32/64 Bits
VS Code
Compuin
 
Posts: 1213
Joined: Tue Dec 28, 2010 1:29 pm
Location: Quebec, Canada

Previous

Return to FiveWin para Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 84 guests