FiveTech Software tech support forums

ryugarai27 wrote:Lailton,

No. I've already installed ADS ODBC driver. I remember I didn't supply a username during ODBC driver installation, thus :

Local oODBC := TOdbc():New("AdvData")

solved the problem.

Thanks anyway..

Hey bro...
Kamusta ka na?

Best regards,
from us.

Lailton,

No. I've already installed ADS ODBC driver. I remember I didn't supply a username during ODBC driver installation, thus :

Local oODBC := TOdbc():New("AdvData")

solved the problem.

Thanks anyway..

... #include "fivewin.ch" #include "ads.ch" #include "xbrowse.ch" #include "sql.ch" Function Main() Local oODBC := TOdbc():New("AdvData","ryugarai","") If !oOdbc:lSuccess oOdbc:ShowErrorList("ODBC session not successfully ...

... from FW to FWH . I use MySql , and in FW I used class TDbOdbc in this way : oDbf := TDbOdbc():new("SELECT * FROM mytab....... " , oOdbc) and then I scan ODbf structure to retrieve data . I use this method also in FWH and it work fine: why Antonio says that Tdbodbc is only for 16 ...

... Program: #include "FiveWin.ch" #include "XBrowse.Ch" #include "sql.ch" function Main() local adsn local xdsn local oodbc local oodbca xdsn:="inkom" oodbc:=TOdbc():new(xdsn) oOdbc:Create( "Test", { { "Name", "C", 50, 0,"NOT ...

Hi, I've upgraded my xHarbour & FW and i'm getting the following error message when i'm trying to make a connection to a Sage table using oOdbc := TOdbc():New(cDsn, cName, cPass) AutoCommit could not be set from TOdbc:New() This worked on the previous version i used (FW0712) Any ideas? Thanks ...

... I install the ODBC driver from Filemaker and make some test with SQL . The questions are : How to know the number of record with a select clause : oODBC := TOdbc():New("NEPHRO", "admin", "123") oDbf := oOdbc:execute("SELECT IPP FROM PATREC where IPP='25' ) How ...

Ad un server con SQL accedevo tramite ODBC con l'istruzione oOdbc := TOdbc():New( cDSN, cName, cPass ) e mi tiravo la mia query con: oDbf := oOdbc:Query(.....) il responsabile del server dopo un aggiornamento non riesce ad attivare più l'ODBC, di conseguenza ...

... I have two problems regarding a MS Access database. 1) From time to time I need to copy an entire access table to a dbf. I use oOdbc:Query("SELECT * FROM " + cTable) to create a temporary dbf then I read through it and append it to a dbf within the application. This is very ...

... conecer cuales son los comandos adicionales y si se le pude poner un alias. Mi idea es utilizar solo instrucciones SQL saludos, Marcelo oDbf := oOdbc:Query( "SELECT codigo,nom,tdebe,thaber FROM cc ") oDbf:lDateAsStr := .t. oDbf:cRDD := "DBFNTX" oDbf:Open() oDbf:Complete() Esto me funciona bien ...

Estimados Amigos, estoy comenzando a utilizar ms-sql con odbc, oDbf := oOdbc:Query( "SELECT codigo,nom,tdebe,thaber FROM cc ") oDbf:lDateAsStr := .t. oDbf:cRDD := "DBFNTX" oDbf:Open() oDbf:Complete() Esto me funciona bien , pero quiero ponerle un alias al oDbf ...

... "Server01", cDsn) cName := oIni:Get( "ODBC", "DsnLoginID", "nn", cName) cPass := oIni:Get( "ODBC", "DsnPassWord", "xxxxxxxx", cPass) oOdbc := TOdbc():New(cDsn, cName, cPass) If !oOdbc:lSuccess .OR. lError(,,, .t.) oOdbc:ShowErrorList(LoadValue(1051, CH)) // ODBC session not successfully ...

Hola amigos del foro Por favor que alguien me indique cual es el error en la siguiente instruccion: cTable:="ITEMS" arti:="43434" oDbf := oOdbc:Query( "SELECT * FROM " + cTable WHERE codigo=arti ORDER BY CODIGO ) Saludos Erick Almanza dicoms@gmail.com cTable:="ITEMS" arti:="43434" oDbf := ...

Hola amigos del foro

Por favor que alguien me indique cual es el error en la siguiente instruccion:
cTable:="ITEMS"
arti:="43434"
oDbf := oOdbc:Query( "SELECT * FROM " + cTable WHERE codigo=arti ORDER BY CODIGO )






Saludos
Erick Almanza
dicoms@gmail.com

... spazio al suo interno. In pratica c'è una tabella denominata ANAGRAFICO CONDOMINI e se provo a leggerla con cTable:="ANAGRAFICO CONDOMINI" oDbf:=oOdbc:Query("SELECT * FROM "+cTable) non me la trova. Esiste un modo per leggerla senza doverla rinominare nel file mdb ? Grazie