RE: Trouble linking tables from sql server via odbc

I assume you have created an ODBC DSN in Control Pannel/Administrative
Tools/Data Sources (ODBC). When you create your DSN (which assumes you
have rights to the sql server tables...) you can click on the "Test
Connection" button in the ODBC wizard here. It will tell you if you
have a connection or not. Assuming you have a good connection when you
go to your mdb - to the Tables window

Right-click anywhere in the window and select "Link Tables" from the
dropdown menu. When the dialog comes up go to the bottom of that dialog
to the "File Of Types" dropdown box. Scroll to the very bottom of that
and select ODBC Databases. When the "Data Source" dialog appears -
select the "Machine Data Source" tab. You will see a list of data
sources. Scroll that list until you see your DSN. Select your DSN and
click "OK". If you used Windows Authentication, then you shouldn't get
prompted for a password. If you used Password and ID, then you will be
prompted for UID and password. Make sure to check the checkbox that
says to remember the password so that you don't get prompted everytime
you access your ODBC table.



Rich

*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: Word 2000/2002 - Proper Mail Merge steps for ODBC?
    ... > Document to connect to a Secured Access Database, ... using the ODBC provider for OLEDB. ... they have a .dsn extension. ... directly (in the Open/Select Data Source dialog box). ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Does connection string need anything on system?
    ... Open DataBase Connectivity (ODBC) is a Microsoft standard (albeit an old ... This DSN needed to be configured to know which database ... driver was going to be needed and which actual data source was being used. ... connection string? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Does connection string need anything on system?
    ... This DSN needed to be configured to know which database driver was going to be needed and which actual data source was being used. ... This is what the ODBC Manager tool in Control Panel> Admin Tools is for...setting up a DSN. ... With OLEDB, you code directly against the provider and, as long as the provider is present on the target machine, the code can talk to it. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Local database with ODBC interface
    ... Microsoft Access Driver ... The login name and password window is normally an ODBC window. ... then the system must have a hardcoded dsn or connection name. ...
    (microsoft.public.access.externaldata)
  • Re: Access sql with python, please. Im desperate
    ... > But I cannot even connect to the access database. ... we create and ODBC DSN (Data Source Name) ...
    (comp.lang.python)