Re: Refreshing the link on stored procedure

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Michel Elie (Michel.elie_at_ec.gc.ca)
Date: 04/12/04 

Date: Mon, 12 Apr 2004 03:49:14 -0700

It's an .MDB and the function change the DSN directly in
the registry on demand.
The DSN name and database name stay the same, I just
change the server name in the DSN. It work very well but
my only problem is those stored procedures, I have to
close and reopen Access to clear that little problem.

>-----Original Message-----
>Is this an MDB or ADP? How are you changing the DSN on
the fly? Are you
>changing the connection string of the linked tables? If
so, you have to
>change the same for any pass-through queries.
>
>--
>Duane Hookom
>MS Access MVP
>
>
>"Michel Elie" <Michel.Elie@ec.gc.ca> wrote in message
>news:1b1c901c41ff8$1c8427f0$a501280a@phx.gbl...
>> I have a little problem that I can't resolve.
>>
>> History:
>> I have built an interface on Access 2002 that is
link
>> too a database on SQL 2000. I have a 2 copies of the
same
>> database on two differents servers.
>> So, I have two structurally identical databases on
>> different server but the data inside the database are
not
>> the same.
>> I have created a function that can change my User
DSN
>> on the fly from server X to server Y or from server Y to
>> server X.
>>
>> Problem:
>> When I change from server X to server Y all my
tables,
>> views and queries see the change of server and I see the
>> data from server Y and that's perfect.
>> But my only little problem is that the stored procedure
>> don't see the change of server and I still see the data
>> from server X.
>> The only way I have found to refresh the change of
>> server for the stored procedure is to close the
>> application and Access and reopen it.
>>
>> Question:
>> Who can I Refresh or tell my stored procedure that I
>> have made a change of server whitout closing everything.
>>
>>
>> Thanks!!!
>
>
>.
>

Relevant Pages

  • Re: Creating a database
    ... Please do yourself a favor, find a local user group, or buy a beginning book on SQL Server or take a class, you will save yourself a great deal of pain in the long run. ... CREATE DATABASE Products ... I can create a stored procedure from within the Server Explorer and from ...
    (microsoft.public.dotnet.framework.adonet)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)
  • Re: Facing the same problem
    ... My stored procedure is being activated from a Service Broker ... remote server is denied because the current security context is not ... The linked server is a SQL server, but not one where I have any ... ALTER DATABASE db SET TRUSTWORTHY ...
    (microsoft.public.sqlserver.security)