FiveTech Software tech support forums

Hi all I tried to import a .dbf file to a SQLEXPRESS server version 2019 but this error happens: 'NATIVEERROR : 3621', it seems to me that the problem stems from the conversion of the fields of type : 'DATE' to 'DATETIME' in fact changing the ...

... oCn := FW_OpenAdoConnection( Factura.mdb ), me mostraba sin error el Dialogo y con oCn := FW_OpenAdoConnection( { "MSSQL", "HPDESA\SQLEXPRESS", "Factura", "", ""} ) se mostraba descuadrado, cambié el RC a "FONT 10" y se solucionó el problema. ...

... La diferencia es esta : oCn := FW_OpenAdoConnection( G:\FactNew\Factura.mdb ) oCn := FW_OpenAdoConnection( { "MSSQL", "HPDESA\SQLEXPRESS", "Factura", "", ""} ) Gracias João, espero ahora se vean las fotos.

... "MYSQL,localhost,rj,root,1234", .t. ) // con esta conexión no trae la tabla * oCn := FW_OpenAdoConnection( "SQLSERVER,desarrollo\sqlexpress,rj,sa,1234", .t. ) // con esta conexión la trae perfecto tabla if oCn == nil ? "Connect fail" return nil endif msgrun( "Connected." ...

... el UDL generar la cadena de conexión. El tema es que cuando quiero conectarme con ADODB no logro conectarme, tambien tengo instalado en otra pc sqlexpress y la conexión funciona perfecto. La conexión es "Provider=MSDASQL.1;Password=Cava1234;Persist Security Info=True;User ID=root;Data Source=jpcavagnaro;Initial ...

... provides convenient wrapper functions for ADO and makes it easy to use ADO. For testing and development on local server, we can download the free SQLEXPRESS and install on our PC.

... not look sophisticated but works well and is not unduly slow. This is a program I just tested for copying "customer" table from my local SQLEXPRESS server to a temporary table "#customer" on the cloud server provided by FWH for our test use. #include "fivewin.ch"function ...

Estimados,

Con mysqldump.exe hacemos backup de MySql/MariaDB

Cómo se hace para SQLEXPRESS?

Gracias por la ayuda.

Armando porfa me puede enviar a acuellar@lostajiboshotel.com Gracias

My preferences:
1. MariaDB ( free, powerful and no limitations )
2. SQLEXPRESS ( free. works same way as MSSQL server with limitations on datasize, etc. But these limitations are not at all important )

... //----------------------------------------------------------------// REQUEST DBFCDX function Main() local cServer := "localhost\SQLEXPRESS" local cDatabase := "SBODemoUS" local oCn, oRs, aTables, cTable oCn := FW_OpenAdoConnection( { "MSSQL", cServer, ...

... //----------------------------------------------------------------// REQUEST DBFCDX function Main() local cServer := "localhost\SQLEXPRESS" local cUser := "SA" local cPassword := "1234" local cDatabase := "SBODemoUS" local cTable := "OCRD" ...

... //----------------------------------------------------------------// REQUEST DBFCDX function Main() local cServer := "localhost\SQLEXPRESS" local cUser := "SA" local cPassword := "1234" local cDatabase := "SBODemoUS" local cTable := "OCRD" ...

... "FiveWin.ch" //----------------------------------------------------------------// function Main() local cServer := "localhost\SQLEXPRESS" local cUser := "SA" local cPassword := "1234" local cDatabase := "SBODemoUS" local cTable := "OCRD" ...

First thing is to connect to the server. The server can be a remote server or SQLEXPRESS on local PC. Please use this function to connect to the server. MSSQL Server/SQLEXPRESS can be configured to accept logins as user/password or with Windows authentication or ...

... and also is written in the database table. http://imagizer.imageshack.us/v2/xq90/633/DYrpvB.jpg This program is tested with MSSQL (SQLEXPRESS) and with MYSQL before posting. http://imagizer.imageshack.us/v2/xq90/633/DYrpvB.jpg Specific note for MySql: By default ...