ODBC Connection to FAS 100?

SUGGESTED

Hi,

I can see an ODBC connection available (default name WINFAS32) but can't connect to it. I'd like to automate some spreadsheets that can verify VIN#s on our insurance policies. I've tried integrated security and specified user names, but neither seems to work. I get an ODBC error that the name and password are invalid. It does seem to be seeing the file okay, because if I have it open it gives me an error that it in use (single user version). 

Has anyone else been able to communicate with the ODBC connector? 

Thanks,

Warren