Connection string question

[wanyunyang]

Hi guys,

Under my connection string, multiple databases are available, but I want to set one database to default.

I tried:

LIB CONNECT TO 'NAV 

DBQ=Gabriel_Nav_Prod.dbo';

"NAV" is the connection name, and Gabriel_Nav_Prod is the database under NAV connection which I want to set to default. But it threw an error. 

Any ideas? Thanks in advance!

[stevejoyce · Accepted solution]

The default database is in the definition of your actual connection.  Edit your connection "NAV" and add default db there.