in reply to Remove ODBC Data Source - Win32::ODBC

Try inserting an empty second parameter , to fill in the placeholder for the DRIVER.

ConfigDSN ( OPTION, DRIVER, ATTRIBUTE ... )

    ..."I don't know what the facts are but somebody's certainly going to sit down with him and find out what he knows that they may not know, and make sure he knows what they know that he may not know, and that's a good thing. I think it's a very constructive exchange," --Donald Rumsfeld

  • Comment on Re: Remove ODBC Data Source - Win32::ODBC

Replies are listed 'Best First'.
Re^2: Remove ODBC Data Source - Win32::ODBC
by briglass (Initiate) on Feb 16, 2005 at 16:48 UTC
    I have sufficient permissions. Also, I checked the Win32::ODBC documentation and the driver parameter is not needed. For removing a data source, only the "DSN=" parameter is needed. Something else must be going on...
      I can reproduce the problem - it looks like a bug in the ODBC module.

      Here is a TESTED Workaround (Yes it DID remove the DSN):

      >perl -MWin32::ODBC -e "Win32::ODBC::ConfigDSN( ODBC_REMOVE_DSN,'', qq +(DSN=TempDB) );"
      Notice - you need the NULL STRING as the DRIVER parameter.
      Update: undef also seems to work there.

          ..."I don't know what the facts are but somebody's certainly going to sit down with him and find out what he knows that they may not know, and make sure he knows what they know that he may not know, and that's a good thing. I think it's a very constructive exchange," --Donald Rumsfeld