David McAfee
davidmcafee at gmail.com
Thu Apr 29 23:08:19 CDT 2010
>From the Select Data Source window, Click on the Machine Data Source tab. If you don't see your connection there, click on New. Select either system or user data source. Scroll down and choose SQL Server. Click Next Click Finish Give the connection a name (I usually name them Server-Database) Give the connection a description, usually the same as above Choose the Server. Click Next. You should be able to choose your db name, choose SQL on Windows authentication and test your connection from the next screen. HTH David On Thu, Apr 29, 2010 at 7:49 PM, Brad Marks <brad.marks1 at gmail.com> wrote: > 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 >