Nic ODBC Problems
I tried to configure an ODBC connection to an SQL Server (Dedicated Application). I'm running enVision 3.7
I configured all the relevant details step by step.
My problem is that enVision isn't query at all the relevant database. I can't see the new device in monitored device.
Can someone help?
MS SQL configurations can be tricky, but try looking in the enVision Event Viewer for clues.
Set the device type to NIC System and search for the string ODBC - that will show you any SQL errors that enVision is generating as it tries to run the script against the database and may provide some clues to a solution.
I checked it. I found an error reporting on something like: DSN Problem connection and error on device driver.
I'm trying to connect to SQL 2000, Should I need to install a specific driver on the enVsion Server or should the existing is fine?
I configured the DSN ODBC on the enVsion Server and the connection test is successfully. What do you think is my problem?
The standard MSSQL driver that comes with the lastest MDAC (2.8 I think is the latest) should work just fine in the system DSN on the enVision Collector, and you say the test connection works so that is probably not the issue.
I can't say I've personally seen any such message before. If you have the exact syntax of the error, you can post it here and maybe someone can help, or Tech Support may have seen it.