ODBC DSN created via script is not visible in "ODBC Datasource Administrator"

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.
.

Relevant Pages

  • Re: [OT] Perl CGI script using Win::ODBC module - failed login on
    ... > Ok I have an issue with a CGI script that I have written in Perl using ... > associated with a trusted SQL server connection". ... username and password for the DSN properly in the ODBC manager (i.e., ... It definitely doesn't sound like a Perl problem, ...
    (comp.lang.perl.misc)
  • Perl CGI script using Win::ODBC module - failed login on
    ... Ok I have an issue with a CGI script that I have written in Perl using ... I have a System DSN that I have ... print "Error connecting to $DSN\n"; ...
    (comp.lang.perl.misc)
  • Re: PEAR newbie trying to user PEAR DB and falling at the first hurdle
    ... I use Pear DB too, ... Then check your connection string if that ... $dsn = array( ... a simple connection like so the script just seems to stop but no error ...
    (comp.lang.php)
  • Re: VB Scripting and XP Embedded
    ... Before going to the XPe troubleshooting route it may make sense to check out what's in your ... > script that contains a simple con.open connection string. ... > creating a DSN entry to the database, ... That may also mean you've got problems with OLE DB provider (SQL Server). ...
    (microsoft.public.windowsxp.embedded)
  • Re: Need help with Perl and MySQL database data load
    ... > I modified my script to declare ... > my $dsn ... > When I ran the script I got the message: ... Epur Si Muove (Gallileo Gallilei) ...
    (comp.lang.perl.misc)