FiveTech Support Forums

FiveWin / Harbour / xBase community
Board indexAll discussionsLogin (GitHub)
Board index FiveWin for Harbour/xHarbour Accessing SQL Server via Internet
byron.hopp
Posts: 408
Joined: Sun Nov 06, 2005 03:55 PM
Accessing SQL Server via Internet
Posted: Tue Mar 17, 2015 07:56 PM

Is there an ado driver for Microsoft SqlServer which allows the user to access SQL through the internet. So you could create a FiveWin application which access the SQL data through the internet.

Thanks,

Byron ...

Thanks,

Byron Hopp

Matrix Computer Services
devtuxtla
Posts: 392
Joined: Tue Jul 29, 2008 01:55 PM
Re: Accessing SQL Server via Internet
Posted: Tue Mar 17, 2015 08:00 PM

Hi Bayron

I use SQLRDD for xHarbour

regards.

Visite Chiapas, el paraiso de México.
byron.hopp
Posts: 408
Joined: Sun Nov 06, 2005 03:55 PM
Re: Accessing SQL Server via Internet
Posted: Tue Mar 17, 2015 08:31 PM

I thought SQLRDD allowed the user to use the dBase DML to traverse through the data, how do you set it up for access through the internet?

Byron ...

Thanks,

Byron Hopp

Matrix Computer Services
nageswaragunupudi
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: Accessing SQL Server via Internet
Posted: Tue Mar 17, 2015 09:22 PM

https://www.youtube.com/watch?v=VOUDdUJ5BLY

Regards



G. N. Rao.

Hyderabad, India
Marc Vanzegbroeck
Posts: 1195
Joined: Mon Oct 17, 2005 05:41 AM
Re: Accessing SQL Server via Internet
Posted: Wed Mar 18, 2015 11:33 AM

You don't need a special driver for accesing ADO via internet.
You only have to use the correct IP-adress (or noip) and forward the correct PORT to access the SQL-server if the SQL-server is behind a router

Regards,

Marc



FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
nageswaragunupudi
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: Accessing SQL Server via Internet
Posted: Wed Mar 18, 2015 01:24 PM
Marc Vanzegbroeck wrote:You don't need a special driver for accesing ADO via internet.
You only have to use the correct IP-adress (or noip) and forward the correct PORT to access the SQL-server if the SQL-server is behind a router

True.
But a client can connect like this, if server-side is configured correctly. If we are managing the server-side, we need to know how to configure the server and the router for accessing the server over internet.
Regards



G. N. Rao.

Hyderabad, India

Continue the discussion

Static archive · New replies & topics via GitHub Discussions