Hi,
We are getting below error while creating ODBC DSN. We have SQL server 2008 R2 and Windows 2019 server. Any help will be really appreciated.
*
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Error executing 'ADD' task on 'tes1dsn' ODBC_DSN ---> System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.NullReferenceException: Object reference not set to an instance of an object.
at SolidCP.Providers.OS.Windows2003.RegisterDSN(String dsnName, String driverName)
at SolidCP.Providers.OS.Windows2003.CreateMsSqlDsn(SystemDSN dsn, String driverName)
at SolidCP.Server.OperatingSystem.CreateDSN(SystemDSN dsn)
--- End of inner exception stack trace ---
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at SolidCP.EnterpriseServer.OperatingSystemController.AddOdbcSource(SystemDSN item)
--- End of inner exception stack trace ---
at SolidCP.EnterpriseServer.OperatingSystemController.AddOdbcSource(SystemDSN item)
at SolidCP.EnterpriseServer.esOperatingSystems.AddOdbcSource(SystemDSN item)
--- End of inner exception stack trace ---
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at SolidCP.EnterpriseServer.esOperatingSystems.AddOdbcSource(SystemDSN item)
at SolidCP.Portal.OdbcEditSource.SaveItem()
Hi,
Any help on this?
the odbc script is really never tested with windows 2019, however can you verify the mssql driver is listed in:
Control Panel -> System and Security -> Administrative Tools -> ODBC Data Sources -> Drivers tab
Regards,
Marco