ThatBruceGuy
Programmer
Hello, all,
I'm at the earliest stages of integrating an external application with SMS, and am the greenest of novices regarding SMS.
My application uses either a preconfigured ODBC datasource to connect to external stores, or can use a connectionstring entered at runtime.
The application connects with no errors, but when I try any valid "select" statement, an error is returned:
-2147467259 (80004005): Unspecified error
This error occurs from any machine where I run the application. I found a quick app at that allows the WBEM source to prompt for all values before connecting. The connection string result is:
Provider=MSDASQL.1;Extended Properties="DSN=WBEM Source;DBQ=root\CIMV2\SMS\DELTA;SERVER=;UIDPWDDEFINED=;PWD=;SYSPROPS=FALSE;NAMESPACES={root\CIMV2,deep}"
It connects, displays the string, then tries to run this SELECT:
SELECT Name FROM Win32_LogicalDisk
As soon as ADODB attemps to open the recordset, it returns the "Unspecified Error."
Any ideas? I get the same result when running either app from any machine that has the WBEM Source, including the SMS server. I must use ODBC because this application is built around using standard SELECT statements to retrieve data. Therefore, using any other SMS API is not an option.
Bruce
I'm at the earliest stages of integrating an external application with SMS, and am the greenest of novices regarding SMS.
My application uses either a preconfigured ODBC datasource to connect to external stores, or can use a connectionstring entered at runtime.
The application connects with no errors, but when I try any valid "select" statement, an error is returned:
-2147467259 (80004005): Unspecified error
This error occurs from any machine where I run the application. I found a quick app at that allows the WBEM source to prompt for all values before connecting. The connection string result is:
Provider=MSDASQL.1;Extended Properties="DSN=WBEM Source;DBQ=root\CIMV2\SMS\DELTA;SERVER=;UIDPWDDEFINED=;PWD=;SYSPROPS=FALSE;NAMESPACES={root\CIMV2,deep}"
It connects, displays the string, then tries to run this SELECT:
SELECT Name FROM Win32_LogicalDisk
As soon as ADODB attemps to open the recordset, it returns the "Unspecified Error."
Any ideas? I get the same result when running either app from any machine that has the WBEM Source, including the SMS server. I must use ODBC because this application is built around using standard SELECT statements to retrieve data. Therefore, using any other SMS API is not an option.
Bruce