>I have a project with numerous remote views to an MS SQL 2000 server.
>
>In the project manager I select the DBC, the select the view and hit Modify (or browse) and it give me the error:
>
>Connectivity Error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
>
>Obviously I have named my DSN wrong when I set it up.
>
>How can I find out what is the name of the DSN it is looking for on a given Remote View?

This assumes that you defined the view using a named conection in the DBC and either the connection or the DSN that is uses was subsequently deleted. If the DSN was deleted, but the connection still exists in the DBC, create a new DSN in the ODBC admin for your SQL server database, open the DBC exclusively delete & recreate the same named connection or modify the connection pointing it to the new DSN and the view should open in the view designer.

If the connection was deleted and you don't remember the name of the connection or DSN, Open your DBC as a table, locate the record for the view, open the property memo field and you should see the name of the connection that the view is using. The name of the connection will be seen after the SQL Select that defines the remote view. You can then locate the record for the connection if it exists, open the property memo field and see the name of the DNS that it uses. The name of the DSN will be readable towards the end of the property memo. You can also copy the SQL connect from the View's properties memo field if you need to recreate the view again.

Close the DBC (opened as a table) and open it with modify data. You can define a connection with the name found in the view's properties, open the view to copy the SQL to recreate the view with the correct connection name.