FM9 Server Link to SQL Failure

[systwo]

Hi Guys!

I'm struggling! I have a FM 9.03 Windows Server 2003. I am attempting to drop in some tables from an external SQL server database (on my web server) so that users can dynamically update records on the SQL server.

I have no problem creating a System DSN and putting the required tables into the ralationship graph, then creating the link to the FM tables and then updating the required fields in SQL.

BUT, it will only work for one user. I can create the external data source in FM I can only crete it with the 'Prompt user for username and password" option because if I try to use the "Specify username.... (applies to all users)" option it gives me an error "The specified table cannot be found".

There seems no way around it as I cannot enter a table in the fields as I get the same error.

I have spoken to support and all the say is that I need the correct SQL native client 2005.90.3042.00, but where do I find this?

Any help gratefully received.

[Dino]

Chris, we are having the same issue, just found some information at:

http://msdn.microsoft.com/en-us/library/ms131321.aspx