Hi, I am trying to connect to a SQL server from my computer.
I have done this before (but not from this computer) and I know the basics.
I am using the "Microsoft OLE DB Provider for SQL Server" and I have all necessary info such as ServerName, UserName and password. The connection works and the OLE DB string is created but once I try to access the database no tables or views are visible or accessible.
I have also tried using ODBC with the same result.
When I try to do the same thing using Xls it works and I can see all of the tables and views in the data base.
Actually, master is a database (at least afaik). Perhaps you've got the wrong database too. A SQL Server instance can have many databases. Perhaps you should ask your local friendly database administrator to help you get connected correctly.