ODBC - Access Pass Through Query Issue

[fender78]

I've created a ODBC connection to a network server. Then it opens the Pass Through Query window. From here what kind of coding am I required to use. Is there a browse feature available to grab tables from the server. I work with Witness Monitoring Systems and am currently logging into the server to retrieve data tables. Trying to build a odbxc to run query right off the server. Any help would be greatly appreciated.

Jim

 

[OnTheFly]

If you have established an ODBC Connection you should be able to link to the tables in your database. That would allow you to use the query builder just as if the table were local.

To use the pass-through query window you would need to write the query from scratch in SQL.

Example: SELECT * FROM tblOne

Hope this helps.

OnTheFly

 

[fender78]

Thanks. I tried it out and it works perfect. Thanks for your help.

 

[PRMiller]

Fender/Other Witness users,

I have created an Access application for reporting Witness data. We are currently using Access 2002 and Witness v5.1 and v5.2.

Has anyone experience a problem with some systems rounding numbers retrieved through queries, but other systems not?

For example, one of my users is on Windows NT, while I am using Windows XP. A number returned from a query and placed on a report appears as 62 for me, but appears as 63 for her. I have not yet drilled down to the query level, as she is in a different state AND on a different server, and I have the only machine that can access both my Witness server and her server -- and it's an XP machine --, so I'd have to give her the source code. However, I suspect that rounding is the problem.

Thanks,
Paul

 

[PRMiller]

Fender,

A Witness forum has been created. It is available under Telephony from the forums menu.

Thanks,
Paul