ODBC Test returns error

thomasschmeidl · Post by **thomasschmeidl** » Mon Aug 14, 2006 8:50 am

OS: W2003 HM 6.10 SQL-Server 2000

I set up an ODBC SQL test which performs fine as long as I test the SQL-Statement in the ODBC-SQL-Test-dialog (Message: "Query executed, Value in the field specified: GATEWAY").

Refreshing the test in the test list pane it produces the error: "[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid Object Name 'HoHospitalisation'"

Using exactly the same SQL-Statement in the SQL Query analyzer everything is ok.

I've made some screenshots - if you tell me where to send them to I will do so.

Any idea?

Regards
Thomas

KS-Soft Europe · Post by **KS-Soft Europe** » Mon Aug 14, 2006 9:04 am

I suppose, you are using ODBC test to access MS SQL Server database, right? Could you provide exact SQL sentence here?

Regards,
Max

KS-Soft Europe · Post by **KS-Soft Europe** » Mon Aug 14, 2006 9:16 am

thomasschmeidl wrote:Refreshing the test in the test list pane it produces the error: "[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid Object Name 'HoHospitalisation'"

I think, you should try to rewrite SQL sentence into single line (remove #13#10 chars), and enclose the table name into the brackets, e.g. [Hospitalisation].

Regards,
Max

thomasschmeidl · Post by **thomasschmeidl** » Mon Aug 14, 2006 9:45 am

Hello again,

- The database is a MSSQL2000 Server
- The statement is: Select HoAktUser from HoHospitalisation where ((HoAktUser='GATEWAY') and (Datediff(mi,Hoakt,Getdate())<15))
- There are no CR/LFs in the statement
- Enclosing the table name into brackets doesn't help.

It's really strange: When I test the test it works, but when I apply it, it doesn't.
What is the difference?

Regards

Thomas

KS-Soft Europe · Post by **KS-Soft Europe** » Mon Aug 14, 2006 12:50 pm

thomasschmeidl wrote:- The statement is: Select HoAktUser from HoHospitalisation where ((HoAktUser='GATEWAY') and (Datediff(mi,Hoakt,Getdate())<15))

Perhaps, you should specify database name in conjunction with tablename, e.g.: somedatabase..HoHospitalisation
It might help.

thomasschmeidl wrote:It's really strange: When I test the test it works, but when I apply it, it doesn't.
What is the difference?

Yes, very strange. Here should not be any difference.

BTW. What version of HostMonitor do you use?

Regards,
Max

KS-Soft · Post by **KS-Soft** » Mon Aug 14, 2006 1:30 pm

HostMonitor is running as application? Or service? May be you have started 2 instances of HostMonitor: one is running as service, while you are using second instance to modify tests?

Regards
Alex

thomasschmeidl · Post by **thomasschmeidl** » Mon Aug 14, 2006 3:29 pm

We use HM 6.10 running as a service and access HM only by RCC.

Specifying the name of the database to the table-name was the solution!!!

Thanks a lot

Thomas

ODBC Test returns error

ODBC Test returns error

Re: ODBC Test returns error