Smart Client, Auto Indexing, Progress Database

For those of you who use Smart Client and are on a progress database, how did you set up the auto indexing?


We tried doing an ODBC connection directly to the database, while it worked in the administrator module, when I tried to index a document I got an error saying that that type of connection is not valid.


Then I tried doing a linked server to link the Epicor server to the SQL server, I was able to write an SQL code in the server management studio that returned data from Epicor, however, when I tried that SQL code in the auto-indexing properties nothing happens.


I tried contacting Altech, but they had no idea how help us.... now we cant be the only ones on a progress database trying to use Smart Client.