HI,
I am trying to connect to SQL database on our server using Database Explorer. I can set up the connection and the test button says it is successful. I will add that I need to suppy the database name as the drop down doesn't show any of the names of the databases. When I go to the Database Explorer window I open a connection and the window blinks and than I get the error: Connection not found. Please open a connection. My computer is Windows 8 64 bit. By the way I can set up a succesful ODBC connection outside of Mathematica.
Any ideas of common problems?
Thanks.