I am currently trying to set up a link to my SQL server database on my local machine (SQL 7.0) using ODBC links.

The problem I am experiencing is that when I am prompted to select the database I want to use as the default, my new database isn't in the list and I only get the following displayed :

master
model
msdb
tempdb

I added the new table into the servre and now when trying to access it using the ODBC wizard I am having issues with it's visibilities.

Anyone any ideas how to configure my server to make this databases visibile if that's the issue, failing that, how do I need to use the ODBC wizard.

I am restricted to using ODBC for this project so ideally looking for a solution using this technology.

Any help, greatly appreciated,

All the best,

Simon