oracle - Jet Database and pass-through queries, parameters -


I am connecting with Jet 4 DB via Odyssey. Jet DB has used pass-through questions to Oracle DB. It works so far (direct P-T questions can not be used, but there is a trick by creating an opinion on the query).

I need some subsets of data provided by P-SS. Parameters will be the best, but not supported.

Two questions:

1) Where the jet seems to be able to push something from the oracle. For example, I have a passthrough query that returns 100k rows. With a single flirting section on Pete (such as "District = '1010'"), a scene is very fast, so processing takes place at the oracle. Adding more cloud can slow down the query, looping for minutes with high CPU usage. Is there any documentation on what has been passed on the jet side and what has been done?

2) How to create dynamic passphrase with VBA / Access There are lots of tutorials to make it possible to do with Jet (or anything with that effect) carried through Odyssey?

Thanks Martin

Edit: Sorry to be so clear

I have a reporting tool that is available through ODBC From Jet to DB reaches. Jet DB has some data and many passphrase questions for Oracle DB. A specific use case would be a generating report for a given department and a given date, using the data of Jet and Oracle. It works very well in theory.

The problem is that there can be no parameters in passthrough questions. A passthrough query works like a view, so I can just select from "pt_query" where the dep = 'a' and date = somedate "can execute. Jet, however, loads all the rows from PT and does a full scan on the client side. It's unusually slow to see a 100k-rows and I need to find a way to avoid it. For some simple selection, Jet seems to work harder to Oracle And did not load all the rows, so my question is 1.

If that does not work, I have to find a way to force Jet to load only data from Oracle for any given request.

I know that I can modify PT through Access VBA, but I only connect to ODBC, so I can only pass SBU to Jet, do not call VB API (Unless possible to inline the VB in the SQL statement).

It is not impossible that the query has been created due to a table scan, and causing this problem Used to be .

You are working in VBA, creating a few interesting questions in the form of SQL strings in VBA and saving them new questions, updating existing questions, using the form for record sources, Or it is possible to use open recordsets. Depending on what you want to do, you can use DAO or ADO. I have an Oracle, so what I can suggest suggests using SQL Server, the connection in square brackets can be found by viewing the connection of a linked table (current DB. TableDefs ("NameOfTable") Connect):

Due to the new ADODB.Connection CNA you have Microsoft.ACE.OLEDB.12.0 or Microsoft.Jet.OLEDB.4.0 scn = "Provider = Microsoft.ACE.OLEDB .12.0; User ID = Administrators can use; Data Source = "_ & amp; CurrentProject.FullName cn.Open scn '' One inclusive question, but you can see that it will be easy to select from two different databases' s = "INSERT [ODBC; Description = test; driver = SQL Server; " _ & Amp; "Server = Server Name \ SQLEXPRESS; Trusted_Connection = Yes," _ & Amp; "Database = Test]. Select Table2 (ID, Attax) ID, Table 1" cn.Execute s

or 

  '' Http: /www.carlprothman.net/Default.aspx?tabid=87 strConnect = _ "Provider = sqloledb;" & Amp; _ "Data source = myServerName;" & Amp; _ "Initial catalog = test;" & Amp; CMD with _ "Integrated Security = SSPI" Active Connection = Strontonct. Common Type = ADCMD Text Command Text: "Selection ID, Test one 2 Test 2" _ and & quot; "WHERE ID =?" .Parameters.Append .CreateParameter _ ("ID", adInteger, adParamInput, 1). Comma timeout = 0 set rs =. Exempt End

-

Comments

Post a Comment

Popular posts from this blog

Eclipse CDT variable colors in editor -

I hope this is a good question to ask here. This programming is related, so I thought it would be better than the superuser, so I am using the CDT C ++ Eclipse plugin. I know how the editor changes colors for some things But is there a way to do that all the variables are different colors? For example in KDEValue, it sets the local variables and square variables in different colors and bold square squares. Can I copy it to CDT? Eclips provides some level of color customization for text editor syntax You can see it on the following: There are many elements, including the Window> Preferences> C / C ++> Editor> Syntax color code that can be changed, assembly, Comments, Preprocessor and Doxian Under the code, it is possible to change the color of some variable types, such as global variables, local variable announcements, local variable references, and parameter variables. But I do not think the code is capable of changing the color of each variable declared....
Read more

AJAX doesn't send POST query -

$ (दस्तावेज़) .ready (function () {function ajaxselectrss (rssurlvar) {var ajaxRequest; // वेरिएबल जो अजाक्स को संभव बनाता है! कोशिश करें कि {// ओपेरा 8.0+, फ़ायरफ़ॉक्स, सफारी अजाक्स अनुरोध} = नया एक्सएमएलएचटीपीआरइवेस्ट ();} कैच (ई) {// इंटरनेट एक्सप्लोरर ब्राउज़र्स {ajaxRequest = new ActiveXObject ("Msxml2.XMLHTTP");} पकड़ो (ई) {try {ajaxRequest = new ActiveXObject ("Microsoft.XMLHTTP");} कैच (ई) {// कुछ गलत चेतावनी ("आपका ब्राउज़र तोड़ दिया!"); वापसी झूठी;}}} // एक बनाएं फ़ंक्शन जो सर्वर से भेजे गए डेटा प्राप्त करेंगे ajaxRequest.onreadystatechange = function () {if (ajaxRequest.readyState == 4) {var ajaxDisplay = document.getElementById ('news'); ajaxDisplay.innerHTML = ajaxRequest.responseText;}} / / Var rssurlvar = $ (this) .attr ("title"); var queryString = "rurl =" + rssurlvar; var urltofile = "rssget.php"; ajaxRequest.open ("पोस्ट", urltofile, सच); ajaxRequ Est.setRequestHeader ("सामग्री-प्र...
Read more

wpf - Custom Message Box Advice -

Well, I'm using a custom window box that comes with some custom control boxes that accompany the text The producers who are displayed are called. I have a defined event, which has been subscribed through the original class, it gets burnt when clicking on the button. However, I can not see how to use it effectively, I would like to return one yes, whether yes or not, but obviously my code will continue to execute, so this Below is some example code to clarify the problem that the method has subscibed by clicking on the button. Message box window Public partial class custom message box: window {public representative message messagebox object sender, event events e); Public event messagebox handler messagebox document; Public Customs Box () {Initial group (); } Public Customsbox (String Message) {InitializeComponent (); This.txtdescription.Text = Message; } Public Customsbox (String Message, String Title, String First BTNtext) {Initialization (); This.lbltitle.Content =...
Read more