Creating ODBC link over Terminal Server

[Daryl]

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?

 

[hal]

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

 

[Ron]

-----Original Message-----


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.

 

[Guest]

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

 

[hal]

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