Visual Login Issues

RMA db issue, 9 April 14
New (3rd, from backup restore) database-9275 error @ login

Connection from client to the existing 2 dbs works.

Can connect & query in Studio, problem isn't DB.



Connection from server works- problem isn't db or SYSADM acct

Look in adv system settings > environment variables  (see photo), added the 52 runtime path @ the beginning

Connection from another PC works. This + the above mean the issue is PC specific.

Check 32 & 64bit ODBC, no DSNs set up the same name as

Check sql.ini file- directory, run  to ensure the path is correct- file is correctly configured and the correct file is being pointed to in Windows.

Check HOME directory for Visual (on server), no sql.ini file there.

Changed the start in to the server directory (with the .exe), and Visual connected to the new db.

Check local directory on client PC and found a sql.ini file w/o the add'l statement for the new db.

Deleted the sql.ini in the local directory & the issue was resolved. Pointed the Start In back to local directory.

