FiveTech Software tech support forums

Good morning Mr. Rao, I thought I had this problem solved, but suddenly the error is back, reading here an there I found that the error I am getting refers to a timeout from the client side, I was wondering if you know where I can define this timeout parameter or where I can find it (if such a param...

Mr. Rao and all that might find this useful, I didn´t give up with this, studied the "adofunc.prg" file and changed the line:         if snDbms == DB_MSSQL            cSql  += " DateTime"  // Date dataype not compat with older servers                                       // Even...

Mr. Rao, I kept trying to understand the reason I got the problem and my conclusion is: The field type in SQL should be "date", I noticed that when importing DBF's the date type field created in SQL is "datetime", I think it is pointless to generate this type of field due to the ...

If so, the above sample should work with dates also.
Thinking ...

Mr. Rao, it works:

FWH ADO functions convert dates for MSSQL like this:

Code: Select all  Expand view

"insert into table (fecha1,fecha2) values ('2019-09-23','2019-12-12')"

Can you try if this format is working on your MSSQL server?

Yes Mr. Rao, I only changed the values for the sentence to go to my server changing nothing else, the line is this: MsgRun( "Connecting to MSSQL Cloud Server", FWVERSION, { || ;          oCn := FW_OpenAdoConnection( { "MSSQL", "MyServer", "MyTable...

Mr. Rao, I tested the program and it worked perfectly on the cloud server, it connects, creates and fills teh table, on my server on the other hand it did not work. When you converted my sample to use your server, please change this line only       oCn := FW_OpenAdoConnection( &#...

Mr. Rao, I tested the program and it worked perfectly on the cloud server, it connects, creates and fills teh table, on my server on the other hand it did not work. In order to see what the problem was I eliminated all the fields that contained dates, tried again and now it worked, so it obvoiusly h...

Mr. Rao, I will try and let you know if it works.

You seem to be using FWH1604. I do not have that version with me. I tried with even an older version FWH1602. We provide an MSSQL server in the cloud for a demonstration to our users. In the following sample, we connect to this demo server in the cloud and test exporting your DBF. Our test program: ...

please send your dbf to me

nageswaragunupudi@gmail.com

Mr. Rao, thanks for your response, unfortunatelly the error remains. The DBF's structure seems very simple to me, but I am sharing it, perhaps you see something in it. This is the DBF structure https://i.postimg.cc/Y0gMsrqt/DBFstru.jpg And this is the SQL structure, I see no importan...

Please try function importDBF    local oCn      oCn   := FW_OpenAdoConnection( { "MSSQL", xSOURCE, xCATALOG, xUSERID, xPASSWORD }, .t. )   if oCn == nil      ? "Failed to connect"      re...

Good day fiveWINERS, I am facing an error trying to use FW_AdoImportFromDBF, given the code: Function importDBF      local oCn, oRs        xString := ('Provider='+xPROVIDER+';Data Source='+xSOURCE+';Initial Catalog='+xCATALOGA+';User Id='+xUSERID+';Password='+xPASSWORD )   oCn := CREATEOBJEC...