Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Create ODBC "default database" Drop-Down Missing Databases

Status
Not open for further replies.

plocks

Programmer
Aug 26, 2011
16
0
0
US
On SQL Server 2008, under Security, I have a user set up with "User Mapping" set up for specific databases. This user is set up just like the others, but for some reason can only see a couple of the databases when they try to create a ODBC System DSN.

I thought I might try deleting the user from SQL Server and re-adding him, but every time I delete the user I can't recreate him because it says he's still there, and suddenly his login it back.

This is been ongoing for a couple days now and I give up, anyone have any suggestions?
 
You might want to post this in forum183.

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top