Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Disable ODBC tracing
Message
 
 
To
02/05/2007 13:24:08
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows NT
Database:
MS SQL Server
Miscellaneous
Thread ID:
01221881
Message ID:
01221887
Views:
11
>Hello,
>
>It seems that there are no discussions here on disabling ODBC tracing. It's important that I disable the ability for someone to view the ODBC trace log as passwords are sent when using sp_setapprole.
>
>My connection string looks like:
>DRIVER=SQL Server;SERVER=XXX\SQLEXPRESS;DATABASE=DB;UID=Login;PWD=Pass;SQL_ATTR_TRACE=SQL_OPT_TRACE_OFF
>
>But when I go to the ODBC DataSource Administrator, and turn on tracing right before my connection is made, the trace log is filled with all my connection information (including the password sent).
>
>What am I doing wrong?

Check http://msdn2.microsoft.com/en-us/library/ms811006.aspx

http://www.querytool.com/help/341.htm - so there is a way to turn it off.

http://doc.ddart.net/mssql/sql2000/html/mdacxml/htm/wpunderstandodbcsecurity.htm
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform