Hi I have a web DB proyect and I would like to make a VB6 client where I can connect to a local X database and a Web MySQL on a UNIX server.
So far, locally everything works great with VB6 and MySQL, the grids, textbox, ADO control, etc.(DNS-Less and with DNS). But when I connect to the DB on the web(Troughchj), which uses the same MySQL structure, I get errors like "CANNOT INITIALIZE DATA BINDINGS" from the grid control and I supose is going to be the same with some other controls. Any way, I understand that there must be some options changed on the ADO object(control..?), like the cursorlocation, type, etc. this are the things that I haven't get clear, I been reading little things about this from there and there(like a puzzle)... and didn't work until I remembered read (from MySQL site I guess) that it cannot use the SELECT * statement.. so I tried specifyng the fields and it worked(DataGrid)... So, What would be the rules I need to look for in order to get VB to work with web MySQL DBs..? Is it mandatory NOT to use the ' * ' in the SQL query..? By the way, has anyone used DBSync from Sandshot software..? I'm trying to use it as a way of avoiding the need of developing my own VB replicator, but I have some wired eorros with remote MySQL DBs. Thank you very much Jorge Garza (Sorry about my english :) My system features(just in case) Win ME MyODBC 3.5 MySQL server VB 6 Also have... PWS 4 with PHP server MyCC MM Ultradev --------------------------------------------------------------------- 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
