Error while creatin...
 
Notifications
Clear all

Error while creating ODBC DSN

3 Posts
2 Users
0 Reactions
1,452 Views
Posts: 2
 Roy
Topic starter
(@roy)
New Member
Joined: 4 years ago

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()

2 Replies
Posts: 2
 Roy
Topic starter
(@roy)
New Member
Joined: 4 years ago

Hi,

Any help on this?

Reply
Posts: 1967
Admin
(@m-tiggelaar)
Noble Member
Joined: 9 years ago

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

Reply
Share: