I work for a company who have a large amount of data stored in a FileMaker database.
I'd like to access that data from VWDexpress and do wonderful things with it.
My problem is when i try to add an SqlDataSource in VWD
(That's Visual Web Developer express edition)
Here's what i did...
I set up a very simple database in FileMaker with just a few fields which i populated with test data.
I set the database to be able to share the data...
I created a user datasource in the ODBC Data Sources bit of the admin tools.
I checked that it worked with Excel by using the menu item: Data/Get External Data ... etc etc. and it works, excel can suck the data in.
But with Visual Web Designer, i can get to the point where i can see the fields available and choose which ones i want but when i get to the 'Test Query' bit i get a nasty error message which consists of two lines and says:
ERROR [ 42502 ] [FileMaker] [ODBC FileMaker Pro driver] [FileMaker Pro] Database not open.
ERROR [ 42502 ] [FileMaker] [ODBC FileMaker Pro driver] [FileMaker Pro] Cannot open table: [IANTEST]
The database IS open, filemaker is sitting there with it running (which is must do).
It is true, that VWD cannot open the table 'IANTEST' although it can see the table and it can see which fields are in the table,,, it just can't open the table....
Unfortunately ODBC looks like the only way i'm going to be able to use the cool VWD features with this database, if and when i can get it to work.
Would anyone be able to help Please please
Thanks from Ian in South England

ODBC <> FileMaker VWD ODBC Bug?