Conexión con MSSQL

[leandro]

Buenas tardes para todos

Como dice el encabezado, necesito realizar una conexión con MSSQL. Alguien ha tenido experiencia con esto? Alguna cadena de conexión?

Saludos

[Baxajaun]

Buenos días Leandro,

aquí las tienes https://www.connectionstrings.com/sql-server/

Saludos

[Rick Lipkin]

LEANDRO

If you want to use the native OleDB 32 bit provider ( included in all versions of windows 32 bit ) .. here is an example of how to create your global connection

Code: Select all  Expand view

Local xProvider,xSource,xCatalog,xUseris,xPassword,xString
Public oConnect

xSource   := "<your server name"
xPROVIDER := "SQLOLEDB"
xCATALOG  := "<your database>"
xUSERID   := "<your userid that has rights to your database>"
xPASSWORD := <your password to the above userid >

xString := 'Provider='+xPROVIDER+';Data Source='+xSOURCE+';Initial Catalog='+xCATALOG+';User Id='+xUSERID+';Password='+xPASSWORD

oConnect := CREATEOBJECT( "ADODB.Connection" )    // oConnect is public connection object

TRY
   oConnect:Open( xString )
CATCH oErr
   Saying := "Could not open a Global Connection to Database "+xSource
   MsgInfo( Saying )
     RETURN(.F.)
END TRY
 

Once you create your global connection string you can pass oConnect to open any recordset.

Rick Lipkin

[leandro]

Muchas gracias por responder:

Voy a hacer unas pruebas y comento.