Database=Pubs with ODBC Connection

  • Thread starter Thread starter Bill
  • Start date Start date
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
 
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.
 
Back
Top