SQL Spy Debug Service FAQ

Table of Contents

1. Why does my SQL statement have a bunch of question marks (?'s) in it?

Why does my SQL statement have a bunch of question marks (?'s) in it?

Contributed by Sharon Buntz

To avoid the ?s in your SQL messages (where the data would be), simply include a DisableBind=1 in your DbParm parameter:

DbParm=ConnectString='DSN=PFC;UID=dba;PWD=sql',DisableBind=1

This causes the database driver to not use memory mapped variables for SQL. Instead, it will pass the variables in clear text strings.

However, remember to turn this off for production applications. Because there are some performance penalties when doing this.

Contributed by PFCGuide staff, except where noted otherwise.
PFCGuide is sponsored by Dynamic Technology Group
The information provided is for advice only and not to be considered a contract or a liability against Dynamic Technology Group.

Last revised: February 15, 2004 03:58 AM.