wwHTTPSQLServer::cConnectString
A SQL Connect string used to connect to the database. If you use this property a new connection is created for each request.
If you want to reuse a connection use the oSQL member to assign a persistent wwSQL object instance.
This property, if left blank on the server can be set from the client. If the client sets its cSqlConnectString property the value is passed forward to this property. You can force a specific connection by providing a connection string which will override anything the client sends. To completely disallow ODBC remote access use the special value of "NOACCESS".
o.cSQLConnectString
Default Value
Default: NOACCESS
Possible values:
"NOACCESS" - No SQL ConnectString to be used and doesn't read the SQL ConnectString from the XML
"" - The handler will read the SQL ConnectString from the XML
<set to a string> - use the string as the SQL Connect string
Note this property should be left at NOACCESS when connecting to native Fox data or when you are passing in an oSQL object reference. This setting basically disallows the handler to read a SQL ConnectString from the incoming XML which could be a potential security issue.
Example
loData = CREATE("wwHTTPSQLServer_Demo")
loData.cConnectString = "server=(local);driver={SQL Server};database=wwDeveloper;pwd=sa;uid=;"
loData.S_Execute( Request.FormXML() )
ShowXML( loData.cResponseXML )
See also:
Class wwHTTPSQLServer | wwHTTPSQLServer::oSQL
Comment or report problem with topic