Book a Demo

Author Topic: Microsoft OLE DB Provider for SQL Server - [DBDNETLIB] ConnectionWrite(send())  (Read 9241 times)

Miso2018

  • EA Novice
  • *
  • Posts: 19
  • Karma: +0/-0
    • View Profile
EA (build 1427) reports this General network error number of times daily. We moved the EA repository from the network onto my laptop (using SSMS v17.8.1) to eliminate it, but the issuess continue. No other applications or systems are indicating any network issues.
Could anyone have a suggestions how to resolve it?

Sunshine

  • EA Practitioner
  • ***
  • Posts: 1353
  • Karma: +121/-10
  • Its the results that count
    • View Profile
Ahh network errors don't you hate them.
I also use EA V14.1 B1427 with SQL Server 2012 over our network and use Microsoft OLE DB Provider for SQL Server to connect to the SQL server but don't get network errors.

Given you've moved the database to your local machine and still get an error its kind of puzzling as the connection shouldn't go over the network anymore.

The only things that come to mind and worth investigation are;
  • May be just double check you are actually accessing the local one and not the one on the server across the network.
  • Not sure about this but perhaps the "OLE DB provider for SQL connector" resolves names using the DNS server to resolve IP address. Have a look at setting up an IP address to resolve server name in c:\Windows\System32\Drivers\etc\hosts
  • Do you use a  Sparx EA license server on the network? May be its that. Don't think it will as I'm pretty sure it only connects to that during start up of Sparx EA. You could  try a node locked licence to isolate

Well that's all I can think of.
Do let us know how you get on.
Happy to help
:)