"Orbital" <sian.clarke@newhamhealth.nhs.uk> wrote in message
news:eto7MV0TGHA.4952@TK2MSFTNGP09.phx.gbl...
> Hi All,
>
> Newbie question for you all, sorry. I'm currently migrating my DB's to a
> new SQL 2000 server and am wondering if there's any way of centrally
> changing the ODBC settings of all my workstations? I really don't want to
> have the support guys visit each machine in turn and do this manually.
>
>
> Any advice gratefully received.
> Orb.
>

"Orbital" <sian.clarke@newhamhealth.nhs.uk> wrote in message
news:esSsqa1TGHA.4900@TK2MSFTNGP12.phx.gbl...
> Hi Keith,
>
> Thanks for replying. I thought this might be the case, I just wondered if
> I was missing any fancy enterprise tools which would do this for me ;o)
>
>
> Many Thanks,
> Orb.
>
>
> "Keith Kratochvil" <sqlguy.back2u@comcast.net> wrote in message
> news:%23tn$eu0TGHA.5332@tk2msftngp13.phx.gbl...
>> The ODBC aliases are stored within the registry. Assuming that you are
>> just changing a server name or IP address of the currently configured
>> database server you should be able to create a .reg file that your users
>> can "run" within the logon script.
>>
>> There is one issue with this method: The users have to have the ability
>> to write to that part of the registry.
>>
>> --
>> Keith Kratochvil
>>
>>
>> "Orbital" <sian.clarke@newhamhealth.nhs.uk> wrote in message
>> news:eto7MV0TGHA.4952@TK2MSFTNGP09.phx.gbl...
>>> Hi All,
>>>
>>> Newbie question for you all, sorry. I'm currently migrating my DB's to
>>> a new SQL 2000 server and am wondering if there's any way of centrally
>>> changing the ODBC settings of all my workstations? I really don't want
>>> to have the support guys visit each machine in turn and do this
>>> manually.
>>>
>>>
>>> Any advice gratefully received.
>>> Orb.
>>>
>>
>>
>
>

"Keith Kratochvil" <sqlguy.back2u@comcast.net> wrote in message
news:%23tn$eu0TGHA.5332@tk2msftngp13.phx.gbl...
> The ODBC aliases are stored within the registry. Assuming that you are
> just changing a server name or IP address of the currently configured
> database server you should be able to create a .reg file that your users
> can "run" within the logon script.
>
> There is one issue with this method: The users have to have the ability
> to write to that part of the registry.
>
> --
> Keith Kratochvil
>
>
> "Orbital" <sian.clarke@newhamhealth.nhs.uk> wrote in message
> news:eto7MV0TGHA.4952@TK2MSFTNGP09.phx.gbl...
>> Hi All,
>>
>> Newbie question for you all, sorry. I'm currently migrating my DB's to a
>> new SQL 2000 server and am wondering if there's any way of centrally
>> changing the ODBC settings of all my workstations? I really don't want
>> to have the support guys visit each machine in turn and do this manually.
>>
>>
>> Any advice gratefully received.
>> Orb.
>>
>
>