ODBC System DSN change to SQL Authentication

Hi I need to change a Windows Authenticated ODBC connection to a SQL
Authenticated ODBC system DSN connection. I have looked at setting this
up via a Login Script and importing a registry key exported off a
PCthats correct via a .bat file.

The problem is, it imports the key and then says its successful I check
the ODBC connection and it hasnt changed. I have rebooted several times
but cannot get it to change from Windows to SQL authentication.

It runs the script and asks if its oK etc.

Stumped, does anyone know of a better way or why this isnt working. The
key comes from HKLM!!!!!

Thanks John

.

Relevant Pages

  • Re: AS400 to Access
    ... I have a vb program that opens an painfully slow ODBC connection to the 400 ... simply do an Insert for each record into our SQL server, ... > and internal employees I think some of the data will be able to be handled ... > adapter then update the Access OLEDB data adapter using the same dataset. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: SQL server vulnerability through ODBC
    ... Look into Application Roles in SQL Server. ... You can grant the necessary select/insert/delete/update privileges to the ... from setting up an ODBC connection or some way in SQL administration to ...
    (microsoft.public.sqlserver.security)
  • Re: Use Group Policy to set ODBC
    ... Is there any way to automate the ODBC connection setup using group policy? ... Both solution can not provide SQL Authentication, ... Cahnge NameofServer + NameofDatabase ... PART "Driver:" EDITTEXT ...
    (microsoft.public.win2000.group_policy)
  • Access FE link to two SQL database using ODBC...
    ... I have an Access FE with tables link to two SQL BE using ODBC connection. ... password for the "other" SQL database. ... "trust Connection" and it works. ...
    (microsoft.public.access.forms)
  • Re: Using Projects saved in an ODBC database
    ... This is the first I've heard of anyone saving to a VFP database. ... The documentation I have only mentions SQL Server and Oracle. ... > error when I try to Open from an VFP8 ODBC connection. ...
    (microsoft.public.project)