×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

SMS queries from Front Page

SMS queries from Front Page

SMS queries from Front Page

(OP)
Hi,

Can someone point me to a good resource for querying SMS data from MS Front Page?

I have created a query in SMS with this syntax:

select IPAddresses, Name, OperatingSystemNameandVersion, SystemRoles from  SMS_R_System where IPAddresses >= "24.1.21.32" and IPAddresses <= "24.1.21.63" order by IPAddresses

and I get the desired results in SMS.

I created an ODBC connection to the SMS server from my IIS server. When I verify this same query in Front Page, I get the following result:

Server error: Unable to retrieve schema information from the query:

(connection info, yadda yadda , no errors)

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'SMS_R_System'.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147467259 (0x80004005)


Thanks for any help,

Chris

RE: SMS queries from Front Page

You might try using a different ODBC driver.  I notice you are trying to use the SQL ODBC driver instead of the WMI ODBC driver.  Try looking on the SMS 2.0 CD for the WMI ODBC driver, which will allow you to access the schema.   (sorry don't have the path for this handy).  Try searching for *.exe, since it's most likely an SMS installer file to install the ODBC on your FrontPage server.

RE: SMS queries from Front Page

I want to know if any one has tried using concatenated SMS. SMS beyond length of 160 chars.

Harry

RE: SMS queries from Front Page

(OP)
Make sure that you have the Frontpage server extensions installed and that you have allowed scripting on the relevant webpage. Let me know if you have problems....

RE: SMS queries from Front Page

To clarify my post above:  The query, as written in your post, will not work (as you have obviously experienced).

It will not work because the query language you cut and pasted from the SMS Admin Console is written in WQL, which wants to access tables through WMI, not SQL.  (if you are unaware:  WMI is an abstraction layer to the SQL tables themselves)  

This means that if you query using the SQL ODBC driver (as your error message describes), but use a query from he SMS Admin Console (WQL), then you will get the error you describe.

The only was to get this query to work is to either use the WMI ODBC driver instead, or to create a SQL view for he data you are querying for, then use the SQL ODBC driver on your web site (this second option is a lot of work, but if you use Microsoft Web Reports, you'll save a lot of effort).

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close