Connection Problem with Remote Server

2 Dec 2005 4:58 PM

Spike

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?

2 Dec 2005 7:39 PM

Trey Walpole

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:
Show quote

> 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?
>
>