sql - Terminating Query If Not Connection -


i have code uploads data sql server database, trying add in if line of code saying if there connection continue, if there not connection end. having difficult time figuring out wording , placement though. beginning of code connects is:

public function update() dim cdb dao.database, qdf dao.querydef  dim rs dao.recordset  dim err dao.error  const connectionstring = _         "odbc;" & _             "driver={sql server native client 10.0};" & _             "server=serv;" & _             "database=db;" & _             "uid=id;" & _             "pwd=pwd;" set cdb = currentdb set qdf = cdb.createquerydef("")  set rs = currentdb.openrecordset("cddata", dbopentable)  qdf.connect = connectionstring  while not rs.eof

while 1 can simple attempt execute query or command, “time out” , delay test active connection can result in long delay. result wonderful trick exists uses different connection mechanism in access , “reduces” potential long delay when attempting use saved query based on linked tables. (that "different" connection system occurs when create querydef opposed linked table or query based on linked table sql server)

the follow code return true or false if have working sql connection:

function testlogin(strcon string) boolean    on error goto testerror    dim dbs          dao.database   dim qdf          dao.querydef    set dbs = currentdb()   set qdf = dbs.createquerydef("")     qdf.connect = strcon     qdf.returnsrecords = false     'any valid sql statement runs on server work below.     qdf.sql = "select 1 test"    qdf.execute     testlogin = true     exit function  testerror:    testlogin = false    exit function

end function

so in code connection string code go:

if testlogin(strconn) = false     msgbox "no connection or logon invalid"     exit sub end if  ' record processing code goes here successful logon/connection.

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