so here's the situation.
We use an old proprietary piece of software made in vb.net from a long time ago. We don't have the source code. We need this service for a few more months but we migrated to a new hosting provider who won't support sql 2000, so we put it on sql 2008 R2 with compatibility mode on for sql 2000. Everything seems fine except, the login from the app (using odbc) will fail if we put regular LOWER case characters (a,b,c,d,e,f...etc) in there. If we use numbers only and/or some non-ascii characters (I know - and ! and @ work fine) or even all upper case it works. I'm trying to figure out what's going on here, it just uses the SQL server login credential for access, any Ideas? I know the coalition is the same, I'm assuming it's something in the way sql 2008 is interpreting the connection. The ODBC connection using the same credentials itself works fine. Is there any way for me to capture the vb.net login when it passes the password?
I'm not a developer, I was a SQL dba in the past, but not for a few years, so my skills are extremely rusty. Please bear with me as I remember all my long forgotten techniques. I've tried all letters and they all fail.
any ideas would be great. If you need me to put any info in here, just let me know what.