Re: linked tables

From: Jon Rizzo (jrizzo)
Date: 12/22/04 

Date: Wed, 22 Dec 2004 15:37:18 -0500

Yes, when I try to access the linked table, I get this error message:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'MyDatabase'
failed.

If I import the same table rather than linking it, the code works fine.
What do I need to do in order to access this linked table?

Jon

"Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message
news:9e7js0l09k0nai78jd0gphuve5amocej9c@4ax.com...
> On Tue, 21 Dec 2004 11:08:24 -0500, "Jon Rizzo" <jrizzo at langan dot com>
wrote:
>
> ¤
> ¤ Hello,
> ¤
> ¤ I am having a problem, and I was hoping that someone here could help me.
I
> ¤ have an Access database define that contains two tables. There is a
third
> ¤ table defined in the Access database which is linked to a SQL Server
table.
> ¤ While I am in the Access environment, I can query between the linked and
> ¤ non-linked tables, but when I try to run a query that joins the linked &
> ¤ non-linked tables through ADO, it can't seem to access the linked table
> ¤ properly.
> ¤
> ¤ Can somebody explain to me how this is done in ADO?
> ¤
>
> What do you mean by "can't seem to access the linked table properly"? Are
you getting an error? A
> prompt for a user name and password?
>
>
> Paul ~~~ pclement@ameritech.net
> Microsoft MVP (Visual Basic)

Relevant Pages

  • Re: SQL Injection ASP + SQL Server (problem) ?!
    ... First Thkz for help and attention. ... Microsoft OLE DB Provider for ODBC Drivers ...
    (Pen-Test)
  • Re: mdb access to names containing ""
    ... references to myname since there are subsequent queries. ... >Microsoft OLE DB Provider for ODBC Drivers ...
    (microsoft.public.frontpage.programming)
  • Re: Oracle Connection threw ASP
    ... >Microsoft OLE DB Provider for ODBC Drivers error '80004005' ... >When I try to connect to an oracle database from my ASP page using VBScript. ...
    (microsoft.public.inetserver.iis)
  • Re: Reviewing my code. Displaying a BLOB image through a browser
    ... Ok I made that change and now I get this error message in my browser. ... Microsoft OLE DB Provider for ODBC Drivers ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • Oracle Connection threw ASP
    ... Microsoft OLE DB Provider for ODBC Drivers error '80004005' ... When I try to connect to an oracle database from my ASP page using VBScript. ... I have installed the Oracle Client which has installed Net 8 Libraries. ...
    (microsoft.public.inetserver.iis)
Loading