Problems connecting to MS SQL via Access2000 adp

[Paul]

For the past several projects, I have been using an Access 2000 .adp file to
create and manage the database on the remote SQL Server. It has worked very
well for me and is a very fast, simple way to take care of minor updates.

A new project is not going so well, though. No matter what I try, I can not
get a connection established. This project is on a server I do not control,
so I am having to work only with the information provided to me by the
admin.

Using an online admin tool provided by the server administrator, I am able
to log in and view the database and make edits via manually written SQL
statements. However, using the server name provided and the same login info,
I am unable to establish a connection through Access.

The admin also told me to use a file-based DSN connection in my ASP pages; I
have always used DSN-less in the past, and can not figure out why a DSN
would be required. Could there be any connection between this and not being
able to connect via Access?

Any suggestions or ideas would be appreciated.

Thank you.
Paul

[Tom B]

I would guess that the sql server is hidden behind a firewall.

Odds are it's only accessible through the interface they gave you.

I'd stick with the DSNLess connection you're used to.

TomB
"Paul" <no****@mydomain.com> wrote in message
news:e5**************@TK2MSFTNGP14.phx.gbl...

For the past several projects, I have been using an Access 2000 .adp file
to create and manage the database on the remote SQL Server. It has worked
very well for me and is a very fast, simple way to take care of minor
updates.

A new project is not going so well, though. No matter what I try, I can
not get a connection established. This project is on a server I do not
control, so I am having to work only with the information provided to me
by the admin.

Using an online admin tool provided by the server administrator, I am able
to log in and view the database and make edits via manually written SQL
statements. However, using the server name provided and the same login
info, I am unable to establish a connection through Access.

The admin also told me to use a file-based DSN connection in my ASP pages;
I have always used DSN-less in the past, and can not figure out why a DSN
would be required. Could there be any connection between this and not
being able to connect via Access?

Any suggestions or ideas would be appreciated.

Thank you.
Paul

[Paul]

Tom,

Thanks for the reply. That confirms my thoughts. I find it interesting they
would hide it while the provider I usually use, a major hosting provider,
allows connections via 1433 directly to their SQL Server.

Paul

"Tom B" <sh*****@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...

I would guess that the sql server is hidden behind a firewall.

Odds are it's only accessible through the interface they gave you.

I'd stick with the DSNLess connection you're used to.

TomB

[Bob Barrows [MVP]]

If that's the problem, then you can specify the port you want to use in your
connection string. Ask the host what port is open in their firewall. See
http://www.carlprothman.net/Default.aspx?tabid=81 for an example of a
connection string in which the port is specified.

Bob Barrows

Paul wrote:

Tom,

Thanks for the reply. That confirms my thoughts. I find it
interesting they would hide it while the provider I usually use, a
major hosting provider, allows connections via 1433 directly to their
SQL Server.

Paul

"Tom B" <sh*****@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...

I would guess that the sql server is hidden behind a firewall.

Odds are it's only accessible through the interface they gave you.

I'd stick with the DSNLess connection you're used to.

TomB

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.