Dephi 5 and MS SQL Server 2000

[mike]

What do I need to get my Delphi 5 Enterprise talking to MS SQL Server 2000
over the internet?

[Kevin Frevert]

Mike,

Configure your connection method (BDE/ADO) server name to the IP address
of your MSSQL server. Make sure you configure your MSSQL clients
(Start->Programs->Microsoft SQL Server->Client Network Utilty. Then
check/add Alias info) for TCP/IP.

Good luck,
krf

"mike" <mi...@allredonline.com> wrote in message
news:3dde...@newsgroups.borland.com...

[Brian Slack]

No Pro can do it. Either buy the ADO add-on or connect by yourself. Just set
the server name to it's ip address.

--

Brian Slack
http://www.depicus.com
"Wake On Lan" and "Remote Shutdown" Software

"mike" <mi...@allredonline.com> wrote in message
news:3dde...@newsgroups.borland.com...

[Edwin Walker]

Mike,

As Kevin pointed out, it is easy to connect to a SQL over the net once
you have it configured correctly. However, I would recommend using a Middle
tier product such as Asta. Performance will be much better.

Edwin

"mike" <mi...@allredonline.com> wrote in message
news:3dde...@newsgroups.borland.com...

[Reid Roman]

I also recommend using ADO for the connection. I found out that you can
avoid installing or configuring any client side layers by appending the
protocol to the end of the connection string:

ADODB.ConnectionString :=
'Provider=SQLOLEDB.1;Password=YOUR_PASSWORD;Persist Security Info=True;' +
'User ID=YOUR_USER_LOGIN;Initial
Catalog=YOUR_DATABASE_NAME;' +
'Data Source=YOUR_SQLSERVER_IP_OR_ALIAS;Network
Library=dbnetlib';

The "Network Library" parameter sets the protocol to TCP/IP

-hth

--
Reid Roman
Future Generation Software
http://www.fgsoft.com