Needed: Working VB6 example of DAO DSN LESS connection using MyODBC to MySQL preferably with passthruquery
Thanks, Barry G. Sumpter Proud Tritoneer President - Triton Woodworkers Club Holmesglen THE TRITONEER Woodworking Australia Bulletin Board Triton Owners and Users Forum Holmesglen Short/DIY Courses Triton Weekend Workshop Triton Woodworking Systems I Triton Woodworking Systems II [EMAIL PROTECTED] (613) 9889-6727 0407 856 646 -Original Message- From: Barry G. Sumpter [mailto:[EMAIL PROTECTED]] Sent: Sunday, 26 January 2003 2:33 PM To: '[EMAIL PROTECTED]' Subject: Needed: Working VB6 example of DAO DSN LESS connection using MyODBC to MySQL preferably with passthruquery This message intended for MyODBC questions list. Hello VB6, MySQL, and DAO developers, A very simple example of my problem: Dim ws As Workspace Dim conn As Connection Dim str As String Set ws = DBEngine.CreateWorkspace(testing, , , dbUseODBC) str = odbc;driver={MySQL ODBC 3.51 Driver}; _ SERVER=localhost; _ DATABASE=test; _ UID=;PWD=;OPTION=3 Set conn = ws.OpenConnection(test, dbDriverNoPrompt, False , str) 'this last line errors with ' -- Run-time error '3146' - ODBC--Call Failed. 'if I use: ' Set conn = ws.OpenConnection(test, dbDriverPrompt, False , str) 'and just select OK on the ODBC Connection Manager ' everything work properly - I can't figure out why. ' Maybe because this turns my connection into a DSN connection. I'm using all the latest and gratest installs on a MS WIndows 2000. Does anyone know OFFICIALLY if the DAO DSN LESS openconnection is supposed to work or not? If so, could you please post hyperlink for all to share? Can anyone please test this OpenConnection on their PC? Can you get it to work? If so, Could you please post the working code here for all to share? Does anyone have DAO DSN LESS openconnection code working? If so, Could you please post your working code here for all to share? I'm interested in working/tested/proven code examples. Also, could someone please point me in the right direction for setting the passthruquery flag? Where do I set the flag? MySQL or maybe in the connection settings? If you don't know what DSN LESS means then please post your question in another thread. If you want to discuss ADO over DAO please post your question in another thread. Thanks, Barry G. Sumpter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Is there anything like Query Analyser for MySQl
I've just downloaded it and it works for me. Thanks, Barry G. Sumpter -Original Message- From: Loren McDonald [mailto:[EMAIL PROTECTED]] Sent: Monday, 27 January 2003 7:26 AM To: 'Karam Chand'; 'Scott Lewis'; [EMAIL PROTECTED] Subject: RE: Is there anything like Query Analyser for MySQl That seems to be a dead download link. -- Loren McDonald AKA MisterrMac Gods Of Music Reviewer/Editor [EMAIL PROTECTED] http://www.GodsOfMusic.com -Original Message- From: Karam Chand [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 26, 2003 11:42 AM To: Scott Lewis; [EMAIL PROTECTED] Subject: Re: Is there anything like Query Analyser for MySQl Hey Try SQLyog at http://www.webyog.com/sqlyog Similar interface like MS Query Analyzer and extremely fast. Karam --- Scott Lewis [EMAIL PROTECTED] wrote: I was wondering, is there a program simialar to MS SQL server - Query Analyser, where you can write sql queries to query MySQl databases? Scott - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Needed: Working VB6 example of DAO DSN LESS connection using MyODBC to MySQL preferably with passthruquery
This message intended for MyODBC questions list. Hello VB6, MySQL, and DAO developers, A very simple example of my problem: Dim ws As Workspace Dim conn As Connection Dim str As String Set ws = DBEngine.CreateWorkspace(testing, , , dbUseODBC) str = odbc;driver={MySQL ODBC 3.51 Driver}; _ SERVER=localhost; _ DATABASE=test; _ UID=;PWD=;OPTION=3 Set conn = ws.OpenConnection(test, dbDriverNoPrompt, False , str) 'this last line errors with ' -- Run-time error '3146' - ODBC--Call Failed. 'if I use: ' Set conn = ws.OpenConnection(test, dbDriverPrompt, False , str) 'and just select OK on the ODBC Connection Manager ' everything work properly - I can't figure out why. ' Maybe because this turns my connection into a DSN connection. I'm using all the latest and gratest installs on a MS WIndows 2000. Does anyone know OFFICIALLY if the DAO DSN LESS openconnection is supposed to work or not? If so, could you please post hyperlink for all to share? Can anyone please test this OpenConnection on their PC? Can you get it to work? If so, Could you please post the working code here for all to share? Does anyone have DAO DSN LESS openconnection code working? If so, Could you please post your working code here for all to share? I'm interested in working/tested/proven code examples. Also, could someone please point me in the right direction for setting the passthruquery flag? Where do I set the flag? MySQL or maybe in the connection settings? If you don't know what DSN LESS means then please post your question in another thread. If you want to discuss ADO over DAO please post your question in another thread. Thanks, Barry G. Sumpter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php