odbc data source

20 pts.
Tags:
ODBC
ODBC Errors
SQL 2000
SQL 2008
odbc data source not displaying all dbs when pointing to sql2008. Only shows default db. odbc data source that points to sql2000 shows all dbs user has access to.

Software/Hardware used:
2003 server

Answer Wiki

Thanks. We'll let you know when a new response is added.

In ODBC data source System DSN

Add new DSN

Name = test
Desc = test
server = lksql
Next
user login id and password enterer by user
check Connect to sql server to obtain default setting
enter user name and pw
next
change the default database to: only has the default db the user is assigned on the sql server.

I’ve tried typing a db – error The database entered is not valid.

If I remove the check mark from Connect to SQL server to obtain default settings for the additional configuration options and leave authentication using login id and password checked, I can add the db and the test works.
But when I reopen I get error The database entered is not valid.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Where is it not displaying all DBs?
    66,290 pointsBadges:
    report
  • Tre
    I presume that the user is valid?
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following