DBVerify query

Top  Previous  Next

DBVerify queries are created for clients that use Database passthrough. The DBVerify query attempts to query the database using the login and password provided when a user logs into Crash Magic. If Crash Magic does not have a Crash Magic account for the user or the query fails to access the database, the user will be denied access to Crash Magic.


An example query might be:

SELECT Crash.CrashID

FROM Crash



The purpose of the query is not to retrieve data from the database, but to check that the user has access to the database. All DBVerify queries should have a where clause of 1=0 to ensure that no data is actually returned by the query.