April 13, 2010 at 11:37 am
Hola!
Sorry if this isn't right forum, but it was kind of a coin toss as to which one to post to.
I am also not a db admin and don't know much about SQL Server, I'm doing .NET development and want to emulate what my customer's server. I just want to get to the point that I can connect to the database mdf they gave me using ODBC through linked tables in Access. I installed the Express edition, set up to use Windows authentication, and turned on the Server Browser. I then attached the customer supplied database.
I set up an ODBC connection to the SQL server and the Test Connection button returns a good result. But when I go to link tables in Access using that ODBC connection I get a huge list of system tables from the SQL server and none of the tables from the customer supplied database I attached.
Here are some of the tables I see;
dbo.MSreplication_options
dbo.spt_fallback_db
...
INFORMATION_SCHEMA.CHECK_CONSTRAINTS
INFORMATION_SCHEMA.COLUMN_DOMAIN_USAGE
...
sys.all_columns
sys.all_objects
...
Not knowing much about schemas, roles, database users, etc...I don't know what to do to make my attached database tables accessible. Since I am the System Admin and I am able to see these system tables, it seems like I should be able to see any tables attached to the server.
Please advise me!
Thank you.
April 13, 2010 at 11:46 am
In your ODBC setup/properties, make sure you have the default database set to the correct DB. Sounds like you have it set to be master.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 13, 2010 at 12:53 pm
BINGO!
What can I say but Thanks. I'm just happy it was as simple as that and that I don't have to get all crazy into understanding the server setup.
I did try changing the default database in my ODBC connection setup previously but it was when I was still troubleshooting getting any connection at all. Once I got the Server Browser started and the was able to connect to the server through ODBC, I didn't think to go back and see if other tables were listed in the ODBC setup.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply