ODBC connection help needed

[DanBrill]

Hey all,

I'm trying to import data from Excel via ODBC on Win XP. As soon as I select Excel as the ODBC source, FM asks me for the user name and password. (This also happens if I choose Access or any other of my ODBC sources.) I've never set up a password for any of my ODBC sources, and I don't see a place to do so in the ODBC manager. I'm transfering data via these driver in other applications, and passwords are never required. What's going on?

Thanks for any help,

Dan

[DanBrill]

OK,

Kinda-sorta figured this out. If I use the ODBC manager to create a new data source and use the excel driver and point it to a specific file, then it works. It asks me for a password, but doesn't complain when there isn't one.

So is this how it is supposed to work? Is there any way to use a driver that doesn't have a specific file associated with it, that lets the user pick it herself?

Thanks,

Dan

[Gupangam]

I want to link ArcView mapping application to my FileMaker Pro soil survey database via ODBC. However, I can't see FileMaker Pro ODBC drivers as an option in the Windows ODBC dialogs. I am attaching some pics to explain the problem This is despite the fact that FMP has Local Data Access Companion and sharing enabled.

FMP6_ODBC.zip