Re: Adp to SQL 2000 Internet connection basics
- From: "Marcus" <marcus@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 29 Apr 2008 19:37:02 +0200
Fantastic!
I've just changed the variable I used to contain the server name with a.b.c.d,5555 (with port mapping enabled on the router and Voilà!!!!
While the connection is immediate, retrieving records isn't that fast, but there may be some techniques like retrieveing small record amounts or maybe compressing data.....
Thanks Silvain!
"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)> wrote in message news:O1pvwGhqIHA.1772@xxxxxxxxxxxxxxxxxxxxxxx
A lot of questions here that would be probably best answered in a newsgroup dedicated to SQL-Server such as microsoft.public.sqlserver.client or mps.connect or mps.security or mps.setup or mps.server.
Second, the traffic is not encrypted by default. To encrypt it, you must install a certificate on the server and use SSL. It's also an all or nothing solution: you cannot a mixed environment with some connection encrypted and others not. See:
http://support.microsoft.com/kb/316898/en-us
For your post mapping, you can create an Alias using the SQL-Server Client Network Utility or use a comma to specify the port number as in a.b.c.d,1433.
For using two different ports (one external, one internal) using port mapping on the firewall, I don't know. You will have to make your own tests. Usually, this is done by using and configuring a proxy (see http://support.microsoft.com/kb/216415 ) but if you can configure your server, then you don't have to do this as you can easily configure the server to listen to another port than 1433 by editing the Server Network Utility, see http://msdn2.microsoft.com/en-us/library/aa197974(SQL.80).aspx for SQL-Server 2000.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Marcus" <marcus@xxxxxxxxxxxxxxxxxx> wrote in message news:KPidnVjmpaEMs4rVnZ2dnUVZ_gWdnZ2d@xxxxxxxxxxxxxxxxHi there I'd wish to test my adp application (Access 2003, working allready on LAN) to access the MS SQL Server 2000 throught the internet.
Questions:
1) If, for security reasons, I'd like to expose a different port on the internet side I would let the firewall do the port mapping somothing like route all traffic from port 5555 to internal IP a.b.c.d:1433.
2) What syntax should I use in my app? (Should I set the "globalServer" variable to "w.x.y.z:5555" where w.x.y.z is the internet ip address of the router?
3) Is the traffic encrypted?
Thanks
This is the current code:
**********************************************************
Public Sub enableDBConnection(dbName As String)
globalDatabase = dbName
strConnect = "PROVIDER=SQLOLEDB.1;" & _
"INITIAL CATALOG=" & globalDatabase & ";" & _
"DATA SOURCE=" & globalServer & ";Persist Security Info=True"
Select Case globalServer
Case "MyMSWindowsServerName"
strConnect = strConnect & ";USER ID=myUser;PASSWORD=myPassword;"
Case Else
strConnect = strConnect & ";INTEGRATED SECURITY=SSPI"
End Select
CurrentProject.OpenConnection (strConnect)
If globalCn.State = adStateOpen Then
globalCn.Close
End If
globalCn.CursorLocation = adUseClient
globalCn.Open strConnect
globalStrConnect = strConnect
End Sub
**********************************************************
.
- Follow-Ups:
- Re: Adp to SQL 2000 Internet connection basics
- From: Sylvain Lafontaine
- Re: Adp to SQL 2000 Internet connection basics
- References:
- Adp to SQL 2000 Internet connection basics
- From: Marcus
- Re: Adp to SQL 2000 Internet connection basics
- From: Sylvain Lafontaine
- Adp to SQL 2000 Internet connection basics
- Prev by Date: Re: Adp to SQL 2000 Internet connection basics
- Next by Date: Re: Adp to SQL 2000 Internet connection basics
- Previous by thread: Re: Adp to SQL 2000 Internet connection basics
- Next by thread: Re: Adp to SQL 2000 Internet connection basics
- Index(es):
Relevant Pages
|
