Rx_
Nothing In Moderation
- Local time
- Today, 00:45
- Joined
- Oct 22, 2009
- Messages
- 2,803
This is my Bat file for SQL Server, does anyone have a better suggestion?
It is all I could find and it seems to work.
Was updating some BAT files. A Citrix Application Server has a copy of Access to run for the users. It also has a unattended version of Access to run the Rule Engine with no interface.
But, the SQL Server also ties into an Oracle Java application to provide Linked Servers. Thought it might be usefull to someone else too.
It is all I could find and it seems to work.
Was updating some BAT files. A Citrix Application Server has a copy of Access to run for the users. It also has a unattended version of Access to run the Rule Engine with no interface.
But, the SQL Server also ties into an Oracle Java application to provide Linked Servers. Thought it might be usefull to someone else too.
Code:
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ServerNameHere]
"Driver"="C:\\Windows\\system32\\sqlncli11.dll"
"Description"="ServerNameHere"
"Server"="ServerNameHere\\SubServerName"
"LastUser"="SQLServerUserName-NotIntegrated"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
"denregsql"="SQL Server Native Client 11.0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Core]
"UsageCount"=dword:00000001
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Driver 11 for SQL Server]
"UsageCount"=dword:00000001
"Driver"="C:\\Windows\\system32\\msodbcsql11.dll"
"Setup"="C:\\Windows\\system32\\msodbcsql11.dll"
"APILevel"="2"
"ConnectFunctions"="YYY"
"CPTimeout"="60"
"DriverODBCVer"="03.80"
"FileUsage"="0"
"SQLLevel"="1"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers]
"SQL Server"="Installed"
"SQL Server Native Client 10.0"="Installed"
"ODBC Driver 11 for SQL Server"="Installed"
"SQL Server Native Client 11.0"="Installed"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Translators]
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Server]
"UsageCount"=dword:00000001
"Driver"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,53,00,51,00,4c,00,53,00,52,00,\
56,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"Setup"=hex(2):25,00,57,00,49,00,4e,00,44,00,49,00,52,00,25,00,5c,00,73,00,79,\
00,73,00,74,00,65,00,6d,00,33,00,32,00,5c,00,73,00,71,00,6c,00,73,00,72,00,\
76,00,33,00,32,00,2e,00,64,00,6c,00,6c,00,00,00
"SQLLevel"="1"
"FileUsage"="0"
"DriverODBCVer"="03.50"
"ConnectFunctions"="YYY"
"APILevel"="2"
"CPTimeout"="60"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Server Native Client 10.0]
"UsageCount"=dword:00000001
"Driver"="C:\\Windows\\system32\\sqlncli10.dll"
"Setup"="C:\\Windows\\system32\\sqlncli10.dll"
"APILevel"="2"
"ConnectFunctions"="YYY"
"CPTimeout"="60"
"DriverODBCVer"="10.00"
"FileUsage"="0"
"SQLLevel"="1"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Server Native Client 11.0]
"UsageCount"=dword:00000001
"Driver"="C:\\Windows\\system32\\sqlncli11.dll"
"Setup"="C:\\Windows\\system32\\sqlncli11.dll"
"APILevel"="2"
"ConnectFunctions"="YYY"
"CPTimeout"="60"
"DriverODBCVer"="03.80"
"FileUsage"="0"
"SQLLevel"="1"
