sql - Access query called as stored procedure via ADO can't retrieve from linked tables -


i'm trying use vba excel 2007 execute query in access 2007 db stored procedure. query retrieves data few ms sql tables linked via odbc dsn. authentication external tables done windows nt authentication trusted_connection=yes

i have tried connecting linked tables both user , system dsn - either way works fine when run query access 2007.

when try using vba in excel data should coming windows authenticated tables isn't retrieved. able retrieve data set of linked ms sql tables using stored uid.

here connection string i'm using:

strdb = xlwb.path & "\database\dbqueries.accdb" conn.open "provider=microsoft.ace.oledb.12.0;" & _     "data source=" & strdb & ";"

and here command that's partially successful (with data uid authenticated tables):

with cmd2     .activeconnection = conn     .commandtext = "qryappendtbloutput"     .commandtype = adcmdstoredproc     .parameters.append cmd2.createparameter("[start date]", addbdate, adparaminput, , startdate) end  cmd2.execute

thanks in advance!

i have been able resolve issue switching access odbc driver instead of ole db provider. changed connection string to:

strdb = xlwb.path & "\database\dbqueries.accdb" conn.open "driver={microsoft access driver (*.mdb, *.accdb)};" & _    "dbq=" & strdb & ";" & _    "trusted_connection=yes;"

then, had adjust syntax of underlying queries in access meet requirements of driver (i had replace double quotes singles).

thanks reviewed question :)!


Comments

Post a Comment

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

i have add following code htaccess file removing .php extension , add trailing slash urls. worked fine reduced page loading speed , css code not loading @ all. pages ugly. please help rewriteengine on rewritebase / ## hide .php extension snippet # externally redirect /dir/foo.php /dir/foo rewritecond %{the_request} ^[a-z]{3,}\s([^.]+)\.php [nc] rewriterule ^ %1/ [r,l] # add trailing slash rewritecond %{request_filename} !-f rewritecond %{request_uri} !/$ rewriterule . %{request_uri}/ [l,r=301] # internally forward /dir/foo /dir/foo.php rewritecond %{request_filename} !-d rewritecond %{request_filename}.php -f rewriterule ^(.*?)/?$ $1.php [l] we can rewrite urls using .htaccess files. before writing in .htaccess files need verify kind of server using. can check server adding a <?php phpinfo(); ?> in php page. ensure mod_rewrite module enabled in apache server. can identified checking phpinfo included page. common methods used url rewriting follows ...
Read more

javascript - jQuery show full size image on click -

pretty self explanatory not workking . i want display full image when user click on image... yes know there tons of plugins but i want keep simple. any idea ? css : .full { display: none; width: 500px; height: 500px; margin-left: 100px; margin-top: -300px; position: fixed; background-color: #f00; z-index: 6; } .thumbnail { width: 50px; height: 50px; } html: <img class="thumbnail" src="http://4.bp.blogspot.com/-uhbdp2esxng/txneptvi92i/aaaaaaaaaky/upfqis7zto0/s1600/rihanna-wallpaper.jpg"> jquery: $(document).ready(function() { $('.thumbnail').on('click', function() { var img = $('<img />',{src:this.src,'class':'full'}); $('.full').html(img).show(); console.log('done!'); }); }); try looking how jquery works. $(document).ready(function() { $('.thumbnail').on('click', function(...
Read more