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
Cursing is the subclass of drunken working... Oscar Wilde (abridged)