Brad Marks
BradM at blackforestltd.com
Fri Apr 30 12:19:46 CDT 2010
Jim, Thanks for the tip. I will add this to my bag of tricks. The problem that I was having last night with building an ODBC connection was resolved this morning. I turns out that when my User_ID was set up, it was not given all of the authorizations that it needed. The end result was that when I tried to set up the ODBC connection, I could "see" the DB Server, but I could not see all of the databases on the DB Server. After a little time with the Windows Server Administrator we discovered the missing authorization piece and he added it for me. After this, I could see all of the databases on the DB Server. Thanks again for your ideas as they may come in handy down the road. Brad PS. In my prior life (IBM mainframe) the security that I worked with was a bit different. You could always see all file names, etc, but security controlled what you could do with the files. I am not quite adjusted to the Microsoft world where you don't see things based on security. Sort of makes sense, but a bit confusing for me still. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Friday, April 30, 2010 12:56 AM To: 'Access Developers discussion and problem solving' Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.