FWH and MS SQL

[cdmmaui]

Hello Everyone,

We are looking to integrate MS SQL to our FWH ADS/DBF application. Does anyone have any examples on connecting/ending connection to MS SQL server and commands (SELECT, INSERT, UPDATE, DELETE)? It would be must appreciated.

Sincerely,

[anserkk]

Connecting to MS SQL Database

Code: Select all  Expand view

// Connecting to MS SQL Database
cConnectSring:="Provider=SQLOLEDB;server=YourIP;database=YourDbName;uid=YourUserName;pwd=YourPassword"
TRY
  oConnection:=CreateObject("ADODB.Connection")
CATCH
  MsgInfo("It seems that your PC does not have MDAC installed OR MDAC is corrupted.")
  Return .F.
END
oConnection:ConnectionString:=cConnectSring

TRY
  oConnection:Open()
CATCH oError
  MsgInfo("Failed to Connect to the Database")
  RETURN .F.
END

Disconnecting from the database

Code: Select all  Expand view

// Disconnecting
if oConnection:State() = adStateOpen
  oConnection:Close()
Endif
oConnection:=NIL

For more eg on ADO and FWH visit the following article in FWH Wiki by Mr.Rick Lipkin
http://fivetechsoft.com/wiki/doku.php?id=ado-related_stuffs&rev=1216796127

Regards
Anser

[cdmmaui]

Thank you for your assistance