I used to have a desktop application pointing to a Sybase database through an .ini
file that had this connection string:
CONNECTION_NAME = "DSN="Dna_Name";UID="User";PWD="Password""
It worked perfectly.
A few days ago the database has been migrated to SQL Server 2008 R2 and I need to update the .ini
file to redirect the new production server. I updated the connection string as follow:
CONNECTION_NAME = "Provider=SQLNCLI10.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog="CatalogName";Data Source="Production_DNS""
But I'm getting the following error:
Named Pipe Provider: Could not open a connection to SQL Server [53]
Additional notes:
*.ini
file needs to be kept around.I've some hours browsing internet for error details with almost no results.
Does the new connection string seems correct?. Any idea of what can be generating the error? Recommendations?
Thanks in advance,
Fortunately after digging around for several hours I have been told there is a production DNS error that was causing my issue.
I fixed the issue by providing the server name on the Data Source connection attribue as follow:
CONNECTION_NAME = "Provider=SQLNCLI10.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog="CatalogName";Data Source="Production_Server_Name;""
Tip: to avoid errors on server name you can check it out through SQL Server Management Studio by executing the following T-SQL:
SELECT @@servername