What is wrong with my connection.

[GAVO-UK]

Experts

I'm experimenting with ADP and MSDE and I'm trying to connect a remote
front end through the internet.

I have already enabled TCP/IP connection on port 1433 on the MSDE host
computer and at the remote client computer on the File>Connection>Data
link properties I'm using an IP address for the server name which I got
from the LOG file of MSDE (192.168.xxx.xx,1433) but then I realised
that that IP could not be used to connect from a remote computer, but
then only that IP and a 127.xxx.xxx were listed as "listening" on the
LOG file, so I went to www.whatismyip.com and used that IP,1433 (not
static) instead and still nothing. I have already tried setting my
firewall to accept connection from the remote computer by specifying
its IP address but no luck either.

Can someone please tell me what is the right procedure to distribute
ADP, ADE applications to remote computer and connect them to a back end
database (MSDE) through the internet?

GAVO.

[lylefair]

Let's look at a typical (for me) connection string to an Internet
Enabled MS-SQL db.

Sub a()
Dim c As ADODB.Connection
Set c = New ADODB.Connection
With c
.Open "PROVIDER=SQLOLEDB.1" _
& ";INITIAL CATALOG=DatabaseName" _
& ";DATA SOURCE=server.ipaddress" _
& ";USER ID=USERID" _
& ";PASSWORD=Password"

Debug.Print .State = adStateOpen
' shows True
End With
End Sub

What might be wrong?

Did you specify the correct server name and ip address in the Data
Source?

You've specified Port 1433. Port 1433 is sometimes blocked by ISP
providers. Have you tried using another port for both the in and the
out? (It may be bad practice to use 1433 anyway, as it is likely to be
the first port tested by SQL hackers).

You stated previously that you are trying to connect via Dial Up. Maybe
this is OK. Maybe it isn't. I would never have thought that a Dial Up
would be sufficient to do an MS-SQL connection and so I have never
tried.

You are using MSDE. I've never tried MSDE via the Internet. If you're
using an ADP, you should be aware that one ADP can (yes, I have seen
this after hearing some new swear words from an SA) make multiple
(multiple -> more than two) connections to the db. Perhaps, over the
internet MSDE recognizes each connection as a user and balks?

If you are desperate and trusting send me your connection info and let
me try connecting.Maybe your workstation TC etc is not set up properly
for this.

[GAVO-UK]

Have you got msn messenger? if yes this is mine: ga******@hotmail.com

It would be greate if you could help me test the connection.
GAVO.

lylefair wrote:

Let's look at a typical (for me) connection string to an Internet
Enabled MS-SQL db.

Sub a()
Dim c As ADODB.Connection
Set c = New ADODB.Connection
With c
.Open "PROVIDER=SQLOLEDB.1" _
& ";INITIAL CATALOG=DatabaseName" _
& ";DATA SOURCE=server.ipaddress" _
& ";USER ID=USERID" _
& ";PASSWORD=Password"

Debug.Print .State = adStateOpen
' shows True
End With
End Sub

What might be wrong?

Did you specify the correct server name and ip address in the Data
Source?

You've specified Port 1433. Port 1433 is sometimes blocked by ISP
providers. Have you tried using another port for both the in and the
out? (It may be bad practice to use 1433 anyway, as it is likely to be
the first port tested by SQL hackers).

You stated previously that you are trying to connect via Dial Up. Maybe
this is OK. Maybe it isn't. I would never have thought that a Dial Up
would be sufficient to do an MS-SQL connection and so I have never
tried.

You are using MSDE. I've never tried MSDE via the Internet. If you're
using an ADP, you should be aware that one ADP can (yes, I have seen
this after hearing some new swear words from an SA) make multiple
(multiple -> more than two) connections to the db. Perhaps, over the
internet MSDE recognizes each connection as a user and balks?

If you are desperate and trusting send me your connection info and let
me try connecting.Maybe your workstation TC etc is not set up properly
for this.

[Lyle Fairfield]

"GAVO-UK" <an****@peopleex.com> wrote in news:1132322373.440270.152270
@o13g2000cwo.googlegroups.com:

Have you got msn messenger? if yes this is mine: ga******@hotmail.com

It would be greate if you could help me test the connection.
GAVO.

I'm sorry that I don't have time to address this interactively, but if you
send me your connection information

ly***********@aim.com

I will try to see if I can effect a connection and let you know my results.
This will rule out some peculiarity of machine.

--
Lyle Fairfield