FiveTech Software tech support forums

... made by FW works fine, now we are made a change in the server and we have changed mysql by sql server and we have follow problem: [CODE] oApp:oCon:ConnectionString:= "Provider=SQLOLEDB;Password=xxxx3;Persist Security Info=True;User ID=XXXX;Initial Catalog=ERP6_base;Data Source=185.80.87.6\SQLEXPRESS2019" ...

... por sql server, y me estoy volviendo loco me da error en el recordset, os paso como lo hago a ver si a alguien se le ocurre el porqué: oApp:oCon:ConnectionString:= "Provider=SQLOLEDB;Password=xxxx3;Persist Security Info=True;User ID=XXXX;Initial Catalog=ERP6_base;Data Source=185.80.87.6\SQLEXPRESS2019" ...

... por sql server, y me estoy volviendo loco me da error en el recordset, os paso como lo hago a ver si a alguien se le ocurre el porqué: oApp:oCon:ConnectionString:= "Provider=SQLOLEDB;Password=xxxx3;Persist Security Info=True;User ID=XXXX;Initial Catalog=ERP6_base;Data Source=185.80.87.6\SQLEXPRESS2019" ...

can i use these ConnectionString with Fivewin Yes oCn := FW_OpenAdoConnection( cYourConnectionString, .t. ) Syntax: FW_OpenAdoConnection( cFWConnectSpec[or]cYourConnectionString, [lShowError],[@oError]) ...

hi, i want to use PostgreSQL with ADO (Xbase++ v2.x use PostgreSQL) these ConnectionString are from ADORDD STATIC FUNCTION ADOOPENCONNECT( cDB, cServer, cPort, cEngine, cUser, cPass, oCn )LOCAL oCatalog   oCn:ConnectionTimeOut := 60                   ...

... name="Process_Sql"> <s:complexType> <s:sequence> <s:element minOccurs="0" maxOccurs="1" name="ConnectionString" type="s:string" /> <s:element minOccurs="0" maxOccurs="1" name="sql" type="s:string" ...

... ELSE ? 'CONEXION OK' ENDIF FUNCTION CONECTA(cCADENA) TRY oApp:= TOleAuto():new("adodb.connection") CATCH oERRX RETURN(.F.) END oApp:ConnectionString:= cCADENA TRY oApp:Open() CATCH oERRX RETURN(.F.) END RETURN(.T.)

... * "UID="+cUseBas+";PASSWORD="+cPasUse+"; OPTION=3" oCon := TOleAuto():new("ADODB.Connection") oCon:ConnectionString := cDriSql TRY oCon:Open() lConnect := .t. CATCH oError showError( oError ) END return lConnect

... DATETIME, este me muestra en blanco, y su VALTYPE es "U" abro a db con: oConL := TOleAuto():new( "adodb.connection" ) oConL:ConnectionString := "Data Source=xharbour;Version=3;New=True;Compress=True;" TRY oConL:Open() CATCH MsgStop( "No Hay Conexion ODBC - ...

hi Mr Rao this is my code: function Main()   local cServer     := "MYSERVER\MSSQLSERVER08"   local cUser       := "sa"   local cPassword   := "pass"   local cDatabase   := "DATABASE"   local cTable      := "TABLE"   local oCn, oRs   oCn   := ...

>>>
otmp:open(SQLCommando,ADO_SQL_Connectionstring)

>>>
If you want speed, do not use connection strings, use connection object which is already open.

James,

I never used it, but there is a connectionstring for a DBF

https://www.connectionstrings.com/dbf-foxpro/

I found the problem. I use a connectionstring "{MySQL ODBC 5.2w Driver}". This not included in the saProviders-array in addofuncs.prg now I use oCn   := FW_OpenAdoConnection(  "Driver={MySQL ODBC 5.2w Driver};Server=localhost;Port=3306;Database=MyDatabase;User=root;Password=MyPassword;Option=3;", ...

otro ejemplo

oApp:ConnectionString := "Driver={SQL Server};Server=192.168.1.100;" + ;
"Trusted_Connection=no;Database=polizas" + ;
";Uid=contab;Pwd=Polizas123;"

Dear Antonio, Can you show us how the connectionstring should look like. These are my parameters I use in HeidiSQL which work fine. LOCAL cHost := "box894.bluehost.com" LOCAL cUser := "axxxxnge" LOCAL cPsw := "14Adxxxx1" ...