[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1946
  • Last Modified:

SQL Server 2005 - Connecting MS Access through ODBC

I am using SQL Server 2005 Express and i wan to connect my MS accesss font end to a database I have created in SQL Server. I know how to set up ODBC connections but where I am having difficulty is pointing to where SQL SERVER Express has the actual database with in its system.

How can I find the database I created? Where is it usually kept on my gard drive?

Thanks in advance for your assistance.

LAD
0
Lou Dufresne
Asked:
Lou Dufresne
1 Solution
 
Marcel HopmanCommented:
Normaly C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data but you don't need this location when defining a ODBC connection to a SQL Server database. Use the SQL Server Driver en al you need is the server name and the name of your database.
0
 
Lou DufresneIT Business Analyst CSM / Project ManagerAuthor Commented:
mahopman
        This works but I get an error messageindicating SQL Server ODBC Connection timed out. Possibly the SQK Server Express 2005 is not set up to allow external ODBC Connections. I will write another question to handle this problem
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now