August 23, 2004 at 10:07 am
when creating odbc dsn with user other than sa, user databases are not listed
in the drop down list for 'set default database'
tracing the odbc set up with profiler shows the following statement trying to run
select name from master..sysdatabases where has_dbaccess(name)=1
running this through query analyser connected with user other than sa gives the following error
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 73 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
(7 row(s) affected
)
running through query analyser connected as sa is ok.
Also "select name from master..sysdatabases" runs OK whoever is logged in
August 23, 2004 at 10:12 am
The odbc connection wizard will only show dbs that the user has access to. You need to give the user access to the dbs you wish for him/her to use prior to setting up the odbc connection.
August 23, 2004 at 10:24 am
Sorry about that..I should have put into the post (I thought it would be assumed) that these users have access to the Databases, but they aren't coming up on the drop down list. Actually the user(s) are getting Some databases on the drop down list that they do not have access to.
The users can access the correct DB's via ISQL but not via ODBC
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply