Changing an ODBC custom data source
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?
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.