Q: iIs there a way to test ODBC connectivity to a MS SQL Server, Sybase or MySQL via command line on the Zenoss server? A: Yes. With isql.
Q: regarding the [SQL Server] label listed in the /etc/odbcinst.ini file, should there be a space between SQL and Server? A: MsSQLMon_ODBC ZenPack dosn't use it. Q: How is the zSQLInstance property used? A: zSQLInstance property is not a part of MsSQLMon_ODBC ZenPack. Q: How can I tell if the queries are working? Does isql work to test this? If so what do I need to run on the command line to test with? A: Yes. 1. Check /home/zenoss/.odbc.ini for DSNName. 2. echo "SELECT name, compatibility_level, state FROM sys.databases" | isql -b -v -x0x7C DSNName Username Password Egor -------------------- m2f -------------------- Read this topic online here: http://forums.zenoss.com/viewtopic.php?p=38908#38908 -------------------- m2f -------------------- _______________________________________________ zenoss-users mailing list zenoss-users@zenoss.org http://lists.zenoss.org/mailman/listinfo/zenoss-users
