View source for DROP CONNECTION

==Purpose==
Delete a gateway connection file


==Syntax==
DROP CONNECTION <filename>


==See Also==
[[CREATE CONNECTION]], [[SQL Remote Data Connectivity Functions|REMOTE DATA CONNECTIVITY FUNCTIONS]]


==Description==
The DROP CONNECTION command is used to delete a gateway connection file to an external SQL database.  Connection files are created by the CREATE CONNECTION command and can be used by the SQLCONNECT() and SQLSTRINGCONNECT() remote data connectivity functions to establish a connection for SQL access to a database.



{| class="wikitable"
!Keywords||Description
|-
|filename||The name of the gateway connection.  If no file extension is specified, then .gtw is used.
|-
|}


==Example==
<code lang="recital">
// config.db
set sql to vfp
set sql on
// end of config.db

CREATE CONNECTION conn1 DATASOURCE "server1" USERID "user1";
  PASSWORD "pass1" DATABASE "/usr/recital/data/demo"
nStatHand = SQLCONNECT("conn1.gtw")
if nStatHand < 1
    dialog box [Could not connect]
else
    nTabEnd = SQLTABLES(nStatHand)
    if nTabEnd = 1
        select sqlresult
        browse
    endif
    SQLDISCONNECT(nStatHand)
endif
DROP CONNECTION conn1
</code>


==Products==
Recital Server, Recital 
[[Category:Documentation]]
[[Category:SQL]]
[[Category:Commands]]