Toon posts:

ODBC installatie script

Pagina: 1
Acties:

woensdag 8 mei 2002 09:33

Acties:

Verwijderd

Topicstarter
Heej tweakers,

Wie kan mij helpen? D.m.v. een script wil ik graag de ODBC instellen.

Hij werkt echter perfect, ik kom echter maar niet uit 2 dingen. ;(

1. Hoe kan ik de ODBC koppeling d.m.v. dit script automatisch een password meegeven.
2. Hoe kan ik er voor zorgen dat ook het keuzerondje van de vraag "How should SQL server verify the authenticity of the login" Wordt ingestel op "with SQL server login"

Hieronder het script: (helaas is van de tabs
weinig overgebleven, ik kan hem altijd ff mailen)

=======================================================

;Plaatsen ODBC settings t.b.v. test database

WRITEPROFILESTRING ("c:\windows\odbc.ini","ODBC 32 bit Data Sources","SICS 2.6 TEST","SQL Server (32 bit)")
WRITEPROFILESTRING ("c:\windows\odbc.ini","SICS 2.6 TEST","Driver32","C:\WINDOWS\SYSTEM\sqlsrv32.dll")

ADDKEY ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources","SICS 2.6 TEST","SQL Server","REG_SZ")

ADDKEY ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SICS 2.6 TEST")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SICS 2.6 Test","Driver", "C:\\WINDOWS\\SYSTEM\\sqlsrv32.dll","REG_SZ")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SICS 2.6 Test","Description","SICS 2.6 TEST","REG_SZ")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SICS 2.6 Test","Server","10.9.200.85","REG_SZ")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SICS 2.6 Test","Database","SICS_TST","REG_SZ")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SICS 2.6 Test","LastUser","SICSNT","REG_SZ")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SICS 2.6 Test","pw","SICSNT","REG_SZ")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SICS 2.6 Test","Trusted_Connection","Yes","REG_SZ")

ADDKEY ("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo","10.9.200.85","DBMSSOCN,10.9.200.85,1433","REG_SZ")

ADDKEY ("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\TDS")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\TDS","10.9.200.85","7.0","REG_SZ")
; KiX script voor updaten van BO Cliënt
; om te connecten met BO database
; 03-05-2000 door WJS
; versie 2.0

WRITEPROFILESTRING ("c:\windows\odbc.ini","ODBC 32 bit Data Sources","BO TestOmgeving","SQL Server (32 bit)")
WRITEPROFILESTRING ("c:\windows\odbc.ini","BO TestOmgeving","Driver32","C:\WINDOWS\SYSTEM\sqlsrv32.dll")

ADDKEY ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources","BO TestOmgeving","SQL Server","REG_SZ")

ADDKEY ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\BO TestOmgeving")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\BO TestOmgeving","Driver","C:\\WINDOWS\\SYSTEM\\sqlsrv32.dll","REG_SZ")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\BO TestOmgeving","Description","BO TestOmgeving","REG_SZ")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\BO TestOmgeving","Server","10.9.200.85","REG_SZ")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\BO TestOmgeving","Database","SICS_TST","REG_SZ")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\BO TestOmgeving","LastUser","SICSNT","REG_SZ")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\BO TestOmgeving","pw","SICSNT","REG_SZ")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\BO TestOmgeving","Trusted_Connection","Yes","REG_SZ")

ADDKEY ("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo","10.9.200.85","DBMSSOCN,10.9.200.85,1433","REG_SZ")

ADDKEY ("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\TDS")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\TDS","10.9.200.85","7.0","REG_SZ")

========================================================
Ik hoop dat iemand mij kan helpen!!

Alvast bedank!

woensdag 8 mei 2002 10:02

Acties:
  • Uiligheid
  • Registratie: December 2000
  • Laatst online: 20-08 15:21

Uiligheid

alle gekheid op een stokje

code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51

=======================================================

;Plaatsen ODBC settings t.b.v. test database

WRITEPROFILESTRING ("c:\windows\odbc.ini","ODBC 32 bit Data Sources","SICS 2.6 TEST","SQL Server (32 bit)")
WRITEPROFILESTRING ("c:\windows\odbc.ini","SICS 2.6 TEST","Driver32","C:\WINDOWS\SYSTEM\sqlsrv32.dll")

ADDKEY ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources","SICS 2.6 TEST","SQL Server","REG_SZ")

ADDKEY ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SICS 2.6 TEST")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SICS 2.6 Test","Driver", "C:\\WINDOWS\\SYSTEM\\sqlsrv32.dll","REG_SZ")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SICS 2.6 Test","Description","SICS 2.6 TEST","REG_SZ")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SICS 2.6 Test","Server","10.9.200.85","REG_SZ")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SICS 2.6 Test","Database","SICS_TST","REG_SZ")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SICS 2.6 Test","LastUser","SICSNT","REG_SZ")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SICS 2.6 Test","pw","SICSNT","REG_SZ")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\SICS 2.6 Test","Trusted_Connection","Yes","REG_SZ")

ADDKEY ("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo","10.9.200.85","DBMSSOCN,10.9.200.85,1433","REG_SZ")

ADDKEY ("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\TDS")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\TDS","10.9.200.85","7.0","REG_SZ")
; KiX script voor updaten van BO Cliënt
; om te connecten met BO database
; 03-05-2000 door WJS
; versie 2.0

WRITEPROFILESTRING ("c:\windows\odbc.ini","ODBC 32 bit Data Sources","BO TestOmgeving","SQL Server (32 bit)")
WRITEPROFILESTRING ("c:\windows\odbc.ini","BO TestOmgeving","Driver32","C:\WINDOWS\SYSTEM\sqlsrv32.dll")

ADDKEY ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources","BO TestOmgeving","SQL Server","REG_SZ")

ADDKEY ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\BO TestOmgeving")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\BO TestOmgeving","Driver","C:\\WINDOWS\\SYSTEM\\sqlsrv32.dll","REG_SZ")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\BO TestOmgeving","Description","BO TestOmgeving","REG_SZ")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\BO TestOmgeving","Server","10.9.200.85","REG_SZ")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\BO TestOmgeving","Database","SICS_TST","REG_SZ")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\BO TestOmgeving","LastUser","SICSNT","REG_SZ")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\BO TestOmgeving","pw","SICSNT","REG_SZ")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\BO TestOmgeving","Trusted_Connection","Yes","REG_SZ")

ADDKEY ("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo","10.9.200.85","DBMSSOCN,10.9.200.85,1433","REG_SZ")

ADDKEY ("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\TDS")
WRITEVALUE ("HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\TDS","10.9.200.85","7.0","REG_SZ")

========================================================

Zo, heb ik het al even leesbaar gemaakt... ;)
Password kun je toch gewoon in de connectionstring meegeven, of bedoel je dat niet?

Ceterum censeo Carthaginem esse delendam

woensdag 8 mei 2002 13:52

Acties:

Verwijderd

Topicstarter
Oke, dat password kom ik denk ik nog wel uit, ik hoop dat iemand mn 2e vraag kan beantwoorden.

Hoe kan ik er voor zorgen dat ook het keuzerondje van de vraag "How should SQL server verify the authenticity of the login" Wordt ingestel op "with SQL server login"
Reageer