|
Home > Archive > MS SQL Server ODBC > May 2005 > Not getting database list while trying to chage default db.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Not getting database list while trying to chage default db.
|
|
|
| I need some help!
We're correcting some security things on our SQL server and now when I try
to establish an ODBC connection, I can no longer choose the default database
for the connection from the drop down list.
It has to be related to user rights we removed on the SQL Server, but I
can't figure out what. If anyone has an idea what is used to populate that
list of databases, I'd appreciate knowing that info.
Thanks a bunch
Corey
| |
| Sue Hoegemeier 2005-05-02, 7:23 am |
| If no databases are showing up in the drop down, you can
type the database name. To have databases show up in the
drop down when creating DSNs, you need to select the option:
Connect to SQL Server to obtain default settings for the
additional configuration options. The ODBC data source
administrator will then execute:
select name from master..sysdatabases where
has_dbaccess(name)=1
So what shows in the drop down at that point depends on what
you are using in the Authentication settings for the same
screen in the ODBC data source administrator.
-Sue
On Fri, 29 Apr 2005 14:46:06 -0700, "cmies"
<cmies@discussions.microsoft.com> wrote:
>I need some help!
>
>We're correcting some security things on our SQL server and now when I try
>to establish an ODBC connection, I can no longer choose the default database
>for the connection from the drop down list.
>
>It has to be related to user rights we removed on the SQL Server, but I
>can't figure out what. If anyone has an idea what is used to populate that
>list of databases, I'd appreciate knowing that info.
>
>Thanks a bunch
>
>Corey
|
|
|
|
|