Hello!
Does FW access MS-SQl Server as well as access MySQL?
Tks
Rodrigo Melo
Brazil
FiveTech Support Forums
FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour FW MS-SQL Server
YES
Regards
G. N. Rao.
Hyderabad, India
G. N. Rao.
Hyderabad, India
Tks
Ado connects to most Sql Databases ... go to the website Connectionstrings.com
https://www.connectionstrings.com/ole-d ... ql-server/
Or have a look at
\source\function\adofuncs.prg ... simplified ado wrappers
Rick Lipkin
https://www.connectionstrings.com/ole-d ... ql-server/
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 TRYOr have a look at
\source\function\adofuncs.prg ... simplified ado wrappers
Rick Lipkin
Rick,
Tks
FWH recommends:
You need not bother about connection strings. FWH does all that work for you.
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.
Regards
G. N. Rao.
Hyderabad, India
G. N. Rao.
Hyderabad, India