Skip to content


Changing an ODBC custom data source

Lou Spevack asked 5 years ago
 I have a map using a custom ODBC link.  I am trying to change the data source to point to a different server. I am able to change the connection string, test the connection and preview data successfully.  But I’m unable to save the change.  When I re-open the map, the original connection string is back.  I am an admin in SmartConnect and I have data_write in the SmartConnect DB.  What is the best way to change the server for this map.
Ethan Sorenson Staff replied 5 years ago

I have a couple questions so I can better understand the situation.
What are you using ODBC to connect to? SQL, EXCEL, Oracle?
“But I’m unable to save the change.” Are you getting an errors or messages when you try to save the map?

Lou Spevack replied 5 years ago

We are moving data from a custom table into sales order transactions.
The current connection string is: DRIVER=SQL Server Native Client 11.0;SERVER=S-DBSERVER01;UID=xxx;PWD=xxx;APP=eOne.SmartConnect.UI.External;WSID=S-APPSERVER01;DATABASE=TrxData;

To change the connection string I click on the elipse. A message pops up: “Opening this connection setup window will remove your current connection details. Do you want to continue?” Yes
I select the Connection MSSQLServer2012 SQL Security
I enter the connection details and the connection string now reads: DRIVER=SQL Server Native Client 11.0;SERVER=S-DBSERVER02;UID=xxx;PWD=xxx;APP=eOne.SmartConnect.UI.External;WSID=S-APPSERVER02;DATABASE=TrxData;
Validation Connection was succesful.
Data Preview was succesful.
I click SAVE.
I get a small SmartConnect popup window with a red ‘X’ and no message.
I close the map. A pop up saks if I would like to save the changes. Yes. No errors.
I reopen the map and the original connection string is there. My change was not saved.
I checked the SmartConnect Event Viewer log and see this message: ‘not-null property references a null or transient value eOne.SmartConnect.Connectors.Microsoft.Dynamics.Gp.MsGpRollingColumn.Description’


If you would like to submit an answer or comment, please sign in to the eOne portal.