sql - VBA query a MySQL database -


i'm getting crazy right now. found posts in here it's not working me...

what i'm trying have piece of vba code in excel can make query in database select * blabla

i'm having problems getting connection! seems examples found bit older. i'm using mysql 5.7.

i appreciate lot if can give me easy example our post online tutorial how that. because found code no explanation! if have little bit context code great! because don't have idea vba or making connection mysql databse :

set cn = new adodb.connection     cn.open "driver={mysql odbc 5.3 unicode driver};server=" & server_name & ";database=" & database_name & _     ";uid=" & user_id & ";pwd=" & password & ";"

for example (one thing found).

this whole code found

 ' carl sql server connection  '  ' code work  ' in vbe need go tools references , check microsoft active x data objects 2.x library  '     dim server_name string     dim database_name string     dim user_id string     dim password string     dim sqlstr string      server_name = "localhost" ' enter server name here     database_name = "tap" ' enter database name here     user_id = "bla" ' enter user id here     password = "blabla" ' enter password here      sqlstr = "select * result" ' enter sql here      set cn = new adodb.connection     cn.open "driver={mysql odbc 5.3 unicode driver};server=" & server_name & ";database=" & database_name & _     ";uid=" & user_id & ";pwd=" & password & ";"

but hell odbc or why using 5.3? want understand know need use

thanks


Comments

Post a Comment

Popular posts from this blog

php - How to add and update images or image url in Volusion using Volusion API -

actually have store importing products store product data insert , update image or image url not insert , update. this xml code name datapro.txt. <products_joined> <productcode>3710_012t</productcode> <vendor_partno>eah5450silent/di/1gd3(lp)</vendor_partno> <productname>test product ta</productname> <hideproduct>n</hideproduct> <stockstatus>20</stockstatus> <lastmodified>1/5/2016 10:25:00 am</lastmodified> <lastmodby>2</lastmodby> <productweight>0.9</productweight> <productprice>100</productprice> <productmanufacturer>asus tek</productmanufacturer> <vendor_price>32.69</vendor_price> <numproductssharingstock>0</numproductssharingstock> <categoryids>107</categoryids> <producturl>http://tebkq.mvlce.servertrust.com/productdetails.asp?productcode=3710_012t</producturl>
Read more

javascript - IE9 error '$'is not defined -

Image
<!--[if lte ie 9]><html class="lte9"><![endif]--><!--[if gt ie 9]><html><![endif]--> <!--[if !ie]><!--> <html> <!--<![endif]--> blah blah <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.1/jquery.min.js"></script> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script> <script src="{{ asset('js/mypage.js') }}" type="text/javascript"></script> </body> </html> when load page, ie9 brings error '$' not defined . how can solve error? +++ mypage.js $(function(){ //when load page, //ie9 tag not moving. $(window).load(function() { $('div.mask').hide(); }); // when click , willshow show. //for not ie 9 if (!$('html').hasclass('lte9')) { var = $('ul.about > li > span.activebtn');
Read more