Search results for query: *

thank you olaf but in the server i create new user "user1" with ALL PRIVILEGES and i specifiy my ip adress , and in my code i try to connect with user 1

hi, I try to connect to mysql database on ip adresse with visual foxpro9 but i got this message : Connection failed: [HY000] [Mysql][ODBC 5.1 driver]Can't connect to MySQL server on 'ipaddress' (10060) can you help me !

hi, I try to connect to mysql database on ip adresse with visual foxpro9 but i got this message : Connection failed: [HY000] [Mysql][ODBC 5.1 driver]Can't connect to MySQL server on 'ipaddress' (10060) can you help me !

Hi, this problem was resolved . it's caused by Kaspersky Antivirus. I disabled Anti Hacker, Proactive Defense , Anti Spam And Access Control and i was able to get rid of the error.

thanks all for your help, yes i try my project in other version of windows in 2 other pc and idon't have this problem and my project execute correctly

Hi, I have a problem when I try to build an executable project in visual foxpro 9 and I am having this message error "FIle is not open" can you help me please?

This is the local DataBase (table : cheques and client ): and this is the server DataBase (table :article): vfpcon="DRIVER={Oracle dans OraDb11g_home1};UID=admin;PWD=admin;Server=x.x.x.x ; SID=ORCL; DATABASE=ORCL ;DRIVER ={Oracle dans OraDb11g_home1};PORT=1158;" gnConnHandle=...

Hi, Thank you for your quick reply. I'm connected to the server database, but when I excute the query I got data from the local database. I mean that the data that I got don't even exists on the server database. How do you explain that ?

Hi, Thank you all for your response, I tried Mike code and it works just fine but I noticed that I'm accessing only Local liste tables. I tried also Olaf code but I got the same error, so I assume it is a connection problem.

when I use AERROR() i got this message error : 1526 Erreur de connectivite :[Oracle][ODBC][ORA][ORA-00942 : Table ou vue inexistante I'm going to corect what I said before, I thonk I have a probleme with the connection to the server in the first place. I'm sure that the table exist in the...

Hi I'm using this code to connect and select data from a local database, but when i try with the distant one, I'm able to connect succefully to the database but I can't select any data. I'm getting this msg : "NOT Successful Execution! " vfpcon1="DRIVER={Oracle dans...

Hi, During the installation process, I faced the error illustrated in the first image. https://res.cloudinary.com/engineering-com/image/upload/v1461054875/tips/imgg_whw9go.bmp Than, after executing the ".bat" like the assistant configuration suggested. I faced the second error (image 2) when I...

It works perfectly thanks for your reply. :)

Hi, It works for me !!! You need a 32bit oracle version and win 32bit. Thank you :)

Hi, I can't update my 'client' table in oracle database with VFP 9, this is my code : cSQLCommand = "UPDATE admin.CLIENT SET raison ='blablaa' where cod_cli='4000'" nRet = SQLEXEC(gnConnHandle ,cSQLCommand) IF nRet = 1 MESSAGEBOX("Successful Execution") ELSE MESSAGEBOX(" NOT Successful...

Hi, I already established a successful connection via ODBC connection to my oracle database but when i try via Fox pro I can't establish a connection. (gnConnHandle=-1) I'm using win 7, oracle 11g and VFP 6. This is my code : vfpcon="DRIVER={Oracle dans...