faustf Posted February 19, 2016 Share Posted February 19, 2016 hi guy , i have a very strange problem , i have a pc , with win 7 64 bit , and last installation of autoit , i have installed a odbc connector , 1 for postgres and 1 for mysql all version 64 bit (psqlodbc_09_05_0100-x64 -- and -- mysql-connector-net-6.9.8.msi ), i use scite for create script , in this script i must connect first in postgres and after in mysql , i write a part for connect postgres , and work good , $objConn = ObjCreate("ADODB.Connection") ; $objConn.Open('Dsn=PostgreSQL30;database='&GUICtrlRead ($odoo_Input8)&';server='&GUICtrlRead ($odoo_Input10)&';port='&GUICtrlRead ($odoo_Input9)&';uid='&GUICtrlRead ($odoo_Input7)&';pwd='&GUICtrlRead ($odoo_Input6)) $objConn.Open('Dsn=PostgreSQL30;database=openerp;server=127.0.0.1;port=5432;uid=postgres;pwd=xxxxx') $rsCustomers = $objConn.Execute("SELECT * FROM res_partner") With $rsCustomers While Not .EOF ConsoleWrite(.Fields("City").Value & " - " & .Fields("Display_name").Value & @LF) .MoveNext WEnd .Close EndWith $objConn.Close but when i write a part for mysql not work and give me some error . I just open a topic for this and with help of mlipok we solved , but the solution of problem is run a script in 64 bit mode , i add at top #AutoIt3Wrapper_UseX64=Y , and run it and now not work a postgres connect, if remove #AutoIt3Wrapper_UseX64=Y postgres restart go and mysql not someone have idea for solution ??? thankz at all P.S. this is a topic problem of mysql , the last script is correct Link to comment Share on other sites More sharing options...
AutoBert Posted February 19, 2016 Share Posted February 19, 2016 and where's the part for MyQQL? Link to comment Share on other sites More sharing options...
faustf Posted February 19, 2016 Author Share Posted February 19, 2016 i have solved i renstall a postgres connector and now go correctly the part of mysql is old topic thankz AutoBert for answer Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now