Sign in to follow this  
Followers 0
faustf

strange postgresql mysql odbc connector problem

3 posts in this topic

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 

 

 

Share this post


Link to post
Share on other sites



and where's the part for MyQQL?

Share this post


Link to post
Share on other sites

i  have  solved  i renstall a postgres connector  and  now  go correctly   :)

the part of  mysql  is  old topic

 thankz  AutoBert  for answer :)

 

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0