I am having trouble setting up a System DSN in ODBC
Administrator. I go through all of the setup steps,
including test connection (successful), but after
finishing, the DSN is not listed in the list of System
DSN's. But each time I try to manually set it up, I am
prompted by the system asking if I want to overwrite the
existing DSN, so it is detecting the previous setup. THis
then led me to the Registry where I did find a folder with
the ODBC files. I deleted these from the Registry, tried
again, with the same results.
This is on an XP Pro laptop connecting to a SQL 2000
Server, I am using the Administrators UN & PW to access
the laptop. I have setup several other laptops in
this environment (some W2K, some XP Pro) without problems,
but this one is giving me headaches. Any ideas what might
be causing this? Thanks.