Terminal server breaks connect string.

[billybobk]

I'm accessing a .dbf database over the network and using ADO to do so. The ADO application works fine. Now when I open the database using Terminal Server, then try to run the app, I get this error: 80004005 [ODBC driver manager] data source name not found and no defauld driver specified. I tried both a UNC and mapped drive to no avail (Though they both word fine without using terminal server. Here's my connection string:
"Provider=MSDASQL.1;Password=access;Persist Security Info=True;User ID=MASTER;Mode=Read;Extended Properties=DSN=GoldMine;DBQ=" & App.Path & "\COMMON;DefaultDir=" & App.Path & "\COMMON;DriverId=533;FIL=dBase 5.0;MaxBufferSize=2048;PageTimeout=600;"
Thank you in advance


--Bill
One may not reach the dawn save by the path of the night
--Kahlil Gibran

 

[billybobk]

Here I am answering my own thread again. But I got the problem wrong -- it isn't terminal server, but just that a DSN has to be created in the control panel on each machine. Can this be done with the PDW installer? Or maybe ZEMP's new thread is my answer. Or, how about, instead of the above connectionstring, is there a string that will work (DSN-less connection string) I think I've heard of this type of thing somewhere. Thanks again.

--Bill
One may not reach the dawn save by the path of the night
--Kahlil Gibran