Neuron ESB User Network

The Service Bus for the Connected Business

SQL Adapter Endpoint Properties

Hi Guys

Setting up an Endpoint for SQLAdapter for publish mode not stored prod, getting an OK for "Test Connection" of the Connection String.

But keep getting this event:

Event Info: Adapter Endpoint 'SQLEndpoint' reporting information.

SQL Adapter error: General error in SQL adapter

Exception: Invalid object name 'VLE.T_ExportFile'.


Method: OnError

Stack: SqlError in - 208 Severity 16 - Invalid object name 'VLE.T_ExportFile'.

My tables name is VLE.T_ExportFile and I can work with it from C# on the same server so should not be a rights problem.

In the Properties field "Database Table" I have simply entered VLE.T_ExportFile

Am I doing something wrong?

Anyone got an SQL adapter running and got a hint for my Properties?

Views: 164

▶ Reply to This

Replies to This Discussion

Permalink Reply by Martin Wasznicky on June 30, 2017 at 8:17am

please make sure you do not use the SQL Adapter. it was deprecated years ago. you should only use the ODBC adapter.

here's the docs: http://www.neuronesb.com/neuron/Help3/Development/Developing_Neuron...

the docs are a bit outdated....but will work its an awsome adapter with a ton of features

Permalink Reply by André Bach on June 30, 2017 at 8:18am
Thx for Swift reply. Will do.

RSS

Neuron ESB Product Support Forums and Communities

Latest Activity

Anupama Nair posted a discussion

Marketo Adapter Invalid Token

Hi,We are using the Marketo adapter to push account updates to Marketo. It works well for some time then starts failing with Invalid Token unless restarted. Is there a configuration that can be done so it can auto refresh the token when required?Thanks!See More
Nov 6, 2023
1 Comment
Sayantini Basak posted a discussion

Maximum payload size(REST API) for requests interfacing to NeuronESB

I am new to Neuron ESB and in our current scenario,We need to process batch transactions comprising of ~1000 records and send them to Neuron ESB for further processing. I would like to understand what is the maximum size of payload that can be transferred using REST interface to Neuron ESB.See More
Jul 22, 2022
0 Comments
Profile IconRobert E Dunie and Sayantini Basak joined Neuron ESB User Network
Apr 28, 2022
Profile IconDayanand, Frederic C, Steffen Greve-Oksfeldt and 1 more joined Neuron ESB User Network
Mar 16, 2022
Profile IconCam Vong and Mitja Luznar joined Neuron ESB User Network
Jan 27, 2022
Profile IconWill Hitzges, Chad Parsons, michael larsen and 4 more joined Neuron ESB User Network
Jun 11, 2021
Anupama Nair posted a discussion

ODBC stored proc polling with temporary tables

We have set up an ODBC adapter to poll a stored proc.We found that if the stored proc has a temporary table defined the rows returned are always 0.Any idea why this would be and what we can do to get around it?See More
Dec 14, 2020
3 Comments
Prasanth Kharade is now a member of Neuron ESB User Network
Dec 30, 2019
Welcome Them!

Badge

Loading…

Get Badge

© 2024   Created by Neuron Admin.   Powered by

Badges  |  Report an Issue  |  Terms of Service

Sign in to chat!