Issues with Nserver "one or more of the required columns no

General information about Neurotechnology and its software

Issues with Nserver "one or more of the required columns no

Postby mulareddy » Jan 09, 2018 17:01

I am getting error "one or more of the required columns not specified in the select query"
I am using 10.0 SDK


Code: Select all
Nserver.conf

Server.ClientListenPort = 25452
Server.ClientListenAddr = 0.0.0.0
Server.AdminListenPort = 24932
Server.AdminListenAddr = 0.0.0.0
Server.LogFileName = NServer.log
Server.DefaultLogMethod = 1
Server.RemoteLoggerPort = 27759
Server.RemoteLoggerAddr = 127.0.0.1
Server.SqlQueryPattern = Select dbid,Template,id from usertbl
Server.SqlUidColumnName = dbid
Server.SqlTemplateColumnName  = template
Server.BiographicDataSchema = ()
Server.SqlDriverName = ODBC
Server.SqlDataSourceName = DSN=fpbios;UID=bidev_user;PWD=bidev

Database: Sqlserver


CREATE TABLE [dbo].[usertbl](
   [template] [varbinary](max) NOT NULL,
   [dbid] [varchar](255) NOT NULL,
   [id] [int] IDENTITY(1,1) NOT NULL,
PRIMARY KEY CLUSTERED
(
   [id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
mulareddy
 
Posts: 1
Joined: Oct 03, 2017 16:26

Re: Issues with Nserver "one or more of the required column

Postby MartynasV » Jan 10, 2018 12:24

Hello mulareddy,

First, use "SDK\Bin\Win32_x86\Server\NServer\NServer.ODBC_Sample.conf" as example, because there are missing lines in your file.

I'm guessing that it doesn't like, that you specified "Template" column name in select query, but it looks for "template"(capital 'T' in select query).
Code: Select all
Server.SqlQueryPattern = Select dbid,Template,id from usertbl
Server.SqlUidColumnName = dbid
Server.SqlTemplateColumnName  = template
Martynas V
Neurotechnology
MartynasV
Neurotechnology
 
Posts: 394
Joined: Feb 27, 2015 11:24
Location: Vilnius, Lithuania


Return to Public

Who is online

Users browsing this forum: No registered users and 1 guest

cron