I need to create an ODBC link from a client to a SQL Server
backend, which is accessed through Terminal Server. I'm
successful in creating an ODBC link once on Terminal
Server, but I don't have any success creating a link from
the client. It seems as if the IP address should go in
the Server Name box, but that doesn't seem right (I get the
message that the data source cannot be found). Has anyone
had any experience with setting up ODBC over TS?

On Wed, 17 Dec 2003 10:41:17 -0800, "Daryl"
<(E-Mail Removed)> wrote:

>
>I need to create an ODBC link from a client to a SQL Server
>backend, which is accessed through Terminal Server. I'm
>successful in creating an ODBC link once on Terminal
>Server, but I don't have any success creating a link from
>the client. It seems as if the IP address should go in
>the Server Name box, but that doesn't seem right (I get the
>message that the data source cannot be found). Has anyone
>had any experience with setting up ODBC over TS?

If I am reading you right, I don't think you can do this. Actually, I
pretty sure you can't do this (somebody correct me if I am wrong). TS
is just a thin client where everything is run on the server and the
only thing exported is your display from your desktop. You cannot do
any port mappings of any kind back from your TS client to your server
while within your TS window. You would need the database client
software running on your client platform to access your ODBC database
via IP and this would negate the whole point of TS. So what you would
want to do is run your database client on your server, create your
link from your client software on your TS server to your database on
the server, and run it remotely via TS exporting only the desktop
display to your client PC. That is what TS is for.

Hal

>-----Original Message-----
>On Wed, 17 Dec 2003 10:41:17 -0800, "Daryl"
><(E-Mail Removed)> wrote:
>
>>
>>I need to create an ODBC link from a client to a SQL
Server
>>backend, which is accessed through Terminal Server. I'm
>>successful in creating an ODBC link once on Terminal
>>Server, but I don't have any success creating a link
from
>>the client. It seems as if the IP address should go in
>>the Server Name box, but that doesn't seem right (I get
the
>>message that the data source cannot be found). Has
anyone
>>had any experience with setting up ODBC over TS?
>
>If I am reading you right, I don't think you can do
this. Actually, I
>pretty sure you can't do this (somebody correct me if I
am wrong). TS
>is just a thin client where everything is run on the
server and the
>only thing exported is your display from your desktop.
You cannot do
>any port mappings of any kind back from your TS client
to your server
>while within your TS window. You would need the
database client
>software running on your client platform to access your
ODBC database
>via IP and this would negate the whole point of TS. So
what you would
>want to do is run your database client on your server,
create your
>link from your client software on your TS server to
your database on
>the server, and run it remotely via TS exporting only
the desktop
>display to your client PC. That is what TS is for.
>
>Hal
>
>
>.
>One thing you have to make sure of and that is that your
client side software is TERMINAL SERVICES FRIENDLY. Some
front end clients don't like multiple users at the same
time.

Just to clarify, my front-end client is an Access 2k
database, which doesn't reside on TS. Access works pretty
well with TS, or so I'm told. It can definitely manage
multiple users. I need to connect to the back-end which is
on TS. Hal, from what I understand from your post, my
front-end would also need to be on TS to successfully have
an ODBC link, is that correct? Unfortunately that would be
impossible for me, so I'd have to find another
solution...is that my fate?

thanks-

Daryl


>>If I am reading you right, I don't think you can do
>this. Actually, I
>>pretty sure you can't do this (somebody correct me if I
>am wrong). TS
>>is just a thin client where everything is run on the
>server and the
>>only thing exported is your display from your desktop.
>You cannot do
>>any port mappings of any kind back from your TS client
>to your server
>>while within your TS window. You would need the
>database client
>>software running on your client platform to access your
>ODBC database
>>via IP and this would negate the whole point of TS. So
>what you would
>>want to do is run your database client on your server,
>create your
>>link from your client software on your TS server to
>your database on
>>the server, and run it remotely via TS exporting only
>the desktop
>>display to your client PC. That is what TS is for.
>>
>>Hal
>>
>>
>>.
>>One thing you have to make sure of and that is that your
>client side software is TERMINAL SERVICES FRIENDLY. Some
>front end clients don't like multiple users at the same
>time.
>.
>

On Wed, 17 Dec 2003 14:15:04 -0800,
<(E-Mail Removed)> wrote:

>
>Just to clarify, my front-end client is an Access 2k
>database, which doesn't reside on TS. Access works pretty
>well with TS, or so I'm told. It can definitely manage
>multiple users. I need to connect to the back-end which is
>on TS. Hal, from what I understand from your post, my
>front-end would also need to be on TS to successfully have
>an ODBC link, is that correct?

That is my understanding, yes.

Hal

><Unfortunately that would be
>impossible for me, so I'd have to find another
>solution...is that my fate?
>
>thanks-
>
>Daryl
>
>
>>>If I am reading you right, I don't think you can do
>>this. Actually, I
>>>pretty sure you can't do this (somebody correct me if I
>>am wrong). TS
>>>is just a thin client where everything is run on the
>>server and the
>>>only thing exported is your display from your desktop.
>>You cannot do
>>>any port mappings of any kind back from your TS client
>>to your server
>>>while within your TS window. You would need the
>>database client
>>>software running on your client platform to access your
>>ODBC database
>>>via IP and this would negate the whole point of TS. So
>>what you would
>>>want to do is run your database client on your server,
>>create your
>>>link from your client software on your TS server to
>>your database on
>>>the server, and run it remotely via TS exporting only
>>the desktop
>>>display to your client PC. That is what TS is for.
>>>
>>>Hal
>>>
>>>
>>>.
>>>One thing you have to make sure of and that is that your
>>client side software is TERMINAL SERVICES FRIENDLY. Some
>>front end clients don't like multiple users at the same
>>time.
>>.
>>