ODBC Visual Web Express won't work

[IanMcAll]

Hi all,

I've just started a new job, part of which is to make a nice snazzy front end for some external customers to access a small part of the massive FMPro database here. I hadn't seen FMP before i came here and i must say i do like it but for this one purpose i would like to use Microsoft's Visual Web Developer Express edition which they are giving away for a year.

My problem is that when i make an ODBC connection using either DSN or fileDSN i can use it perfectly with Excel but as when i try to use it from VWD i get to the point of being able to choose which fields i want to include but when i click the button to try the query or if i just go ahead and load the connection and then run the query by loading the webpage i get the error:

ERROR [42S02][FileMaker][ODBC FileMaker Pro Driver][FileMaker Pro]Database not open.

ERROR [42S02][FileMaker][ODBC FileMaker Pro Driver]Cannot open table:[iANDB1]

Can anyone help? I must get it working with VWD and hopefully before i get fired :-/

Cheers from Ian