SEO

permalink · #1 (**permalink**) 05-05-2008, 05:51 AM

Hello

I've created linked tables in Access to SQL Server using a DSN. The tables
open fine in Access & I can edit data.

However the same SQL queries scripted from a web server fail - this being a
query of the tables in Access that are actually links to the SQL Server.

Returns the error: DATABASE ERROR: S1000 [Microsoft][ODBC Microsoft Access
Driver] ODBC--connection to '<DSN name>' failed.

I don't see why the links that work in Access do not work when Access is
used as the date source.

Any help please?

Thanks

Tony.

permalink · #2 (**permalink**) 05-05-2008, 05:51 AM

It sounds like the web server can't open/find the DSN, but it's hard
to say without knowing more about the configuration issues involved.
That being said, it's recommended NOT to use a DSN when connecting
Access to SQL Server for several reasons, the main one being lack of
security. You can supply an ODBC connection string in code at run time
to create the TableDef links. I don't know if that alone will fix the
problem - there may be other security issues as well - but it's a
start.

--Mary

On Fri, 2 May 2008 05:24:00 -0700, Tony
<Tony@discussions.microsoft.com> wrote:

>Hello
>
>I've created linked tables in Access to SQL Server using a DSN. The tables
>open fine in Access & I can edit data.
>
>However the same SQL queries scripted from a web server fail - this being a
>query of the tables in Access that are actually links to the SQL Server.
>
>Returns the error: DATABASE ERROR: S1000 [Microsoft][ODBC Microsoft Access
>Driver] ODBC--connection to '<DSN name>' failed.
>
>I don't see why the links that work in Access do not work when Access is
>used as the date source.
>
>Any help please?
>
>Thanks
>
>Tony.
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Access linked to SQL Server - then web user querying Access