ADO using Terminal Server

[IrelandsOwn]

I have a VB app that I have installed on a terminal server using the P&D wizard. When it tries to select data from a VFP table I get the following RTE (-2147467259) Data Source Name not found and no default driver specified. I have MDAC 2.8 installed on this Windows 2000 server. It works fine on any other PC. Can someone shed any light on this?

[RobDog888]

First, when you installed your program were you in "Install Mode" on the Terminal server?
Second, can you post you connection code and the code in question?

[IrelandsOwn]

Set Cnn1 = New ADODB.Connection
Cnn1.ConnectionString = "DSN=Visual FoxPro Tables;UID=;PWD=;SourceDB=r:\time;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;"
Cnn1.Open
Set rstEmployee = New ADODB.Recordset
rstEmployee.Open "select * from employee where mainmenu order by lastname;", Cnn1, adOpenStatic, adLockReadOnly

Yes it was in install mode.

[RobDog888]

I think it has to do with the DSN on the system. Is "DSN=Visual
FoxPro Tables" a File, Machine Specific, or User DSN?
Does your TServer have the FoxPro runtime files? You can tell if
there is an entry in the ODBC for "Visual FoxPro Driver"?

[reginaldm]

Check control panel/administrative tools/data sources. I would bet that the "Visual FoxPro Tables" DSN is a user dsn and not a system DSN. Copy the settings over and it should work.