NetXMS Forum

Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

SQL query problem

13 Posts 3 Posters 44.9k Views

E
E
Egert143

wrote on last edited by

#2

Hello

It means that ODBC driver is missing, need to install it seperately. Some info: https://stackoverflow.com/questions/17115632/microsoftodbc-driver-manager-data-source-name-not-found-and-no-default-drive
1 Reply Last reply

0
M
M
moudar123

wrote on last edited by

#3

Thanks for answer!
I am using database driver mssql.ddr not ODBC.ddr
why i am getting error about ODBC?
1 Reply Last reply

0
V
V
Victor Kirhenshtein

wrote on last edited by

#4

Hi,

error message is like this because MS SQL driver uses ODBC API internally. Do you have MS SQL native client installed on the server?

Best regards,
Victor
1 Reply Last reply

0
M
M
moudar123

wrote on last edited by

#5

this is the copy of SQL that i am using:
Microsoft SQL Server 2017 (RTM) - 14.0.1000.169 (X64) Aug 22 2017 17:04:49 Copyright (C) 2017 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)

Should i try to install SQL Server Native Client on the same server ?

Best regards
1 Reply Last reply

0
V
V
Victor Kirhenshtein

wrote on last edited by

#6

You have to install SQL Server Native Client on machine where you are installing NetXMS server.

Best regards,
Victor
1 Reply Last reply

0
M
M
moudar123

wrote on last edited by

#7

I did install SQL Server Native Client on machine where i am installing NetXMS server.
But a new error message started to appear!
Any ideas?
1 Reply Last reply

0
V
V
Victor Kirhenshtein

wrote on last edited by

#8

Hi,

you have to enable TCP/IP for both client and server. Those are relevant documentation pages: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-or-disable-a-server-network-protocol?view=sql-server-ver15 and https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-client-protocols?view=sql-server-ver15.

Best regards,
Victor
1 Reply Last reply

0
M
M
moudar123

wrote on last edited by

#9

both are enabled but same problem still there!
1 Reply Last reply

0
M
M
moudar123

wrote on last edited by

#10

Maybe it is named pipes i need to enable
i will test!
1 Reply Last reply

0
M
M
moudar123

wrote on last edited by

#11

Still same problem!
1 Reply Last reply

0
V
V
Victor Kirhenshtein

wrote on last edited by

#12

How did you specify server address? Try to use local IP address (127.0.0.1) instead of server name (I assume SQL server is on same machine).

Best regards,
Victor
1 Reply Last reply

0
M
M
moudar123

wrote on last edited by

#13

it is working now
it was wrong IP address
it is not local machine but another one

thank you for help
1 Reply Last reply

0

Hello! It looks like you're interested in this conversation, but you don't have an account yet.

Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

With your input, this post could be even better 💗