[AccessD] Access 2007 ODBC Connection to SQL Server

Hi Brad:

I have posted this here can couple of times but here is the method I use
when creating a connection to a server of various types.

1. Create an empty text file on the desktop but make the extension ".udl" 
2. An ODBC module will appear and then you can create a connection to a MS
SQL or any other standard database connection. You can then test to see if
the connection does connect.
3. If you want to take that connection text so you can insert that info in
you Access application rename the ODBC connection module to a file with a
".txt" extension. 

You can switch back and forth by just changing the extension.

HTH
Jim

  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Thursday, April 29, 2010 7:49 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Access 2007 ODBC Connection to SQL Server

This is probably a really dumb question, but I am fairly new to SQL Server
plus I may have some brain damage due to many years of working with DB2.

I am trying to build an ODBC connection to a SQL Server Database so that I
can access it with Access 2007.

I have been given the Server Name and the Database Name.

When setting up the ODBC connection, I can see the Server in a drop-down,
but I cannot see the Database Name. (I can see other Databases in the
drop-down).   The funny thing is that another person on another PC can see
the database name that was given.

This seems really strange.  Is this possibly due to a security/authorization
setting?  I am really puzzled.

Thanks,

Brad
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com