This is a discussion on ODBC DSN created via script is not visible in "ODBC Datasource Administrator" within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Hi, I have used script, specified below, to add ODBS DSN After I executed this script, the DSN was ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Hi, I have used script, specified below, to add ODBS DSN After I executed this script, the DSN was created and my application used it, BUT - this DSN was not visible in "ODBC Datasource Administrator". Furthermore , now if I add another DSN via "ODBC Datasource Administrator", I can not see it there. It work, it appear in registry, but not visible in "ODBC Datasource Administrator". Please, help to find out how to fix it. ' *********** ODBC ********************* strKeyPath = "SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources" strODBCname = "localcrm" strValue = "SQL Server" objReg.SetStringValue HKEY_CURRENT_USER,strKeyPath,strODBCname,strValue strKeyPath = "SOFTWARE\ODBC\ODBC.INI\"+strODBCname objReg.CreateKey HKEY_CURRENT_USER,strKeyPath strValueName = "Database" strValue = "MSCRM_MSDE" objReg.SetStringValue HKEY_CURRENT_USER,strKeyPath,strValueName,strValue strValueName = "Driver" strValue = "C:\WINDOWS\System32\SQLSRV32.dll" objReg.SetStringValue HKEY_CURRENT_USER,strKeyPath,strValueName,strValue strValueName = "Server" strValue = strComputerName+"\crm" objReg.SetStringValue HKEY_CURRENT_USER,strKeyPath,strValueName,strValue strValueName = "Trusted_Connection" strValue = "Yes" objReg.SetStringValue HKEY_CURRENT_USER,strKeyPath,strValueName,strValue I'm working on Windows XP SP2, with all last updates and patches. Thanks, Alex. |