Why do exists & In fail?

2004-08-07 Thread john sayre
I'm trying to do some simple in or exists queries, but am getting syntax error on queries that appear to be correct. If I run the outside & sub queries alone, not problem. In the In subquery, if I hardcode a value, ok but this fails: SELECT * FROM erestbase WHERE erestbase.id in(SELECT distin

Logging on through ODBC w/o UN & Password (Why is my query tool allowing this?)

2004-07-23 Thread john sayre
I am able to log onto a database through ODBC without using a user name or password. I don't want this to be possible for obvious security reasons. What do I need to do to prevent this? This seems pretty freaky!