What login are you using in ODBC to access SQL Server? Does this login has rights to access your new database?


>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