Connection Speed

Is there any known connection speed level where a low connection speed will
cause an application to not connect to sql server? I periodically have
problems with applications connecting to the sql server and the only thing I
have noticed is that when this is occuring the speed on the network is very
slow. It is about 3200 kbs.It is not an issue of speed, but how much bandwidth is available to your
application.
Connecting to SQL server on a 16kbit modem is possible, not if you are
trying this whilst mail is downloading and you are surfing 5 sites.
I would not try anything slower than 9.6kbit. It might bet irritating.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"John" <noEmail@.yahoo.com> wrote in message
news:eIZH#1UDFHA.3596@.TK2MSFTNGP12.phx.gbl...
> Is there any known connection speed level where a low connection speed
will
> cause an application to not connect to sql server? I periodically have
> problems with applications connecting to the sql server and the only thing
I
> have noticed is that when this is occuring the speed on the network is
very
> slow. It is about 3200 kbs.
>|||Does anyone have an article where microsoft talks about the amount of
bandwidth required for connecting? I would like some documentation to show
the higher ups.
Thanks

Connection Problem with Remote Server

If I do this:
select * from tblAmcareDetail
I get my records back but as soon as try to specify column names I get:
Server: Msg 207, Level 16, State 3, Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
'apexorderid'.
I think it must be a connection problem because I don't have this problem on
local servers. The server is registered by it's ip address and I'm running
the query under the servers sa account.
Can anyone help?Doesn't sound like a connection problem.
Are you sure the table on the server.database you're connecting to has
this column?
Is the server/db/table you're connecting to perhaps setup with a
case-sensitive collation? If so, you'll need to query using the case of
column names as in the table definition.
Spike wrote:
> If I do this:
> select * from tblAmcareDetail
> I get my records back but as soon as try to specify column names I get:
> Server: Msg 207, Level 16, State 3, Line 1
> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
> 'apexorderid'.
> I think it must be a connection problem because I don't have this problem
on
> local servers. The server is registered by it's ip address and I'm runnin
g
> the query under the servers sa account.
> Can anyone help?
>