ODBC Connection Using MS Excel

[Rosann]

I have a database named ET4.2. This is vendor software and the vendor requested that name and like a fool I let them use that. Now I am stuck with the consequences. Most of the time it is just irritating and wrapping it in double quotes does the trick like use "ET4.2" in SQL Query Analyzer.

Now I am trying to connect to this database using an ODBC connection with the SQL Server driver through Microsoft Excel. No matter what I do it tells me "Could not find server 'ET4' in sysservers". Does anyone have any suggestions how to get around this? This is a production database so renaming it isn't really an option.

[Stephen]

Try [ET4.2] instead

[Rosann]

Thank you for the suggestion. I tried that and it tells me invalid database name.