FW MS-SQL Server

[ip_ram]

Hello!

Does FW access MS-SQl Server as well as access MySQL?

Tks

Rodrigo Melo
Brazil

[nageswaragunupudi]

YES

[ip_ram]

Tks

[Rick Lipkin]

Ado connects to most Sql Databases ... go to the website Connectionstrings.com

https://www.connectionstrings.com/ole-d ... ql-server/

Code: Select all  Expand view

xPROVIDER    := "SQLOLEDB"
xSOURCE      := "MYCOMUTER-PC\SQLEXPRESS"
xCatalog       := "MyDatabaseName"
xUserId         := "sqluserID"
xPASSWORD := "mypassword"


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


// global connection string
xConnect := CREATEOBJECT( "ADODB.Connection" )

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

 

Or have a look at
\source\function\adofuncs.prg ... simplified ado wrappers

Rick Lipkin

[ip_ram]

Rick,

Tks

[nageswaragunupudi]

FWH recommends:

Code: Select all  Expand view

oCn := FW_OpenAdoConnection( { "MSSQL", cServer, cCatalog, cUser, cPassword }, .t. )
if oCn == nil
   ? "not connected"
return nil
// do your work
oCn:Close()
 

You need not bother about connection strings. FWH does all that work for you.