Database=Pubs with ODBC Connection

B

Bill

What does Database=pubs do when connecting with ODBC.

I have to use it when connecting in house.

When connecting with New York I have to leave it out.

Does Anyone know why?

Thank You in advance

Bill Barber
 
D

Douglas J. Steele

Assuming you're using ODBC to connect to SQL Server, Database=pubs would
mean that your default database would be pubs: if you referred to any table
without qualifying the reference with a database name, it would look for the
table in the pubs database.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sqlite-odbc write conflict 2
Table Security in Access 2013 1
A couple questions BEFORE using Office 365 0
Can't send emails but can receive in Outlook 2019 1
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
How can the font and size of (all) citation numbers be altered? 1
Trusted Connection in Pass-trough query... 4
split data base using ODBC connection 1

Top