WBEM ODBC Driver Problem - Empty Recordset

[chulivek]

When i'm trying to open query which should have answer with empty recordset, WBEM ODBC Driver (WBEMDR32.DLL ver. 1.50.1085.06) doesn't respond and my program is frozen.
In case answer is not empty, everything goes OK. Can anybody help me , please ?

P.S. Excuse my broken english please.

 

[SmsMike]

Can you post your query? There are alot of possibilities are you using WMI? SQL?
Need more info.


Mike

 

[chulivek]

I'm using ODBC so i'm writing queries in SQL. Query looks like this: SELECT something.SMS_R_System, something.SMS_G_VIDEO FROM SMS_R_System, SMS_G_VIDEO WHERE ResourceId.SMS_R_System = ResourceId.SMS_G_VIDEO AND AdapterCompatibility.SMS_G_VIDEO='string'

And when there is no record with AdapterCompatibility='string' ODBC Driver doesn't respond. If there is everything goes OK.
I have tried to query against one table (SM_G_VIDEO) and it was OK.

I's it clear now ?

Thank you for reaction .

Chulivek

 

[SmsMike]

I ran your query successfully by adding an inner join. Since I don't know exactly what you're querying for, you will have to change appropriate values.

Hope this helps.

Mike


select distinct SMS_R_System.ResourceId
from SMS_R_System
inner join SMS_G_System_VIDEO
on SMS_G_System_VIDEO.ResourceID = SMS_R_System.ResourceId where SMS_G_System_VIDEO.ResourceID = SMS_R_System.ResourceId and SMS_G_System_VIDEO.AdapterCompatibility = ##PRM:SMS_G_System_VIDEO.AdapterCompatibility##