<div>
I assume you are in Access creating a Pass Through query in there. Yes you can. The easiest way to get your ODBC connect string is to attach a table and then look at the Description property in the Access table design, the ODBC connect string is everything excep the TableNam at the end.<br />
<br />
As far as the Dynamic bit then you may need to expand. You can not include parameters as everything in the Pass Through Query has to be Server related but you could modify the SQL in code.<br />
<br />
Cheers, Andrew
</div>


I assume you are in Access creating a Pass Through query in there. Yes you can. The easiest way to get your ODBC connect string is to attach a table and then look at the Description property in the Access table design, the ODBC connect string is everything excep the TableNam at the end.

As far as the Dynamic bit then you may need to expand. You can not include parameters as everything in the Pass Through Query has to be Server related but you could modify the SQL in code.

Cheers, Andrew

<div>
For the first part i got it,<br />
but im not so sure what u mean &quot;the Pass Through Query has to be Server related&quot;<br />
<br />
I copied this from the linked &quot;inventory table&quot;<br />
ODBC;DATABASE=jnbkcrop;DES<wbr />CRIPTION=J<wbr />NBKCorpLoc<wbr />alHost;DSN<wbr />=JNBKCorpL<wbr />ocalHost;O<wbr />PTION=0;PO<wbr />RT=0;SERVE<wbr />R=localhos<wbr />t;;TABLE=i<wbr />nventory<br />
<br />
SQL:<br />
SELECT ID, Title FROM jnbkcrop.inventory;<br />
<br />
I get &quot;Recordset is not updatable&quot;
</div>


For the first part i got it,
but im not so sure what u mean "the Pass Through Query has to be Server related"

I copied this from the linked "inventory table"
ODBC;DATABASE=jnbkcrop;DESCRIPTION=JNBKCorpLocalHost;DSN=JNBKCorpLocalHost;OPTION=0;PORT=0;SERVER=localhost;;TABLE=inventory

SQL:
SELECT ID, Title FROM jnbkcrop.inventory;

I get "Recordset is not updatable"

<div>
ahh, ok. <br />
I was very much off on the meaning of passtrough q.<br />
Thank's
</div>


ahh, ok.
I was very much off on the meaning of passtrough q.
Thank's

<div>
<div class="content wysiwyg-content">
How can i create a dynamic pass-through query in MYSQL?<br />
<br />
do i need to adjust my connection string?<br />
ODBC;UID=root;PWD=test;DSN<wbr />=localhost<wbr /><br />

</div>
</div>


How can i create a dynamic pass-through query in MYSQL?

do i need to adjust my connection string?
ODBC;UID=root;PWD=test;DSN=localhost


ACCESS to MYSQL Pass-Through Query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.