trouble to run my app when installing on another system
I have trouble to run my app when installing on another system the language is c# and I used DataAdapter and drag table to form to connect to db. when I Install on another system it gives sql server error :
Unhandled exception has occurred ...
a network-related or instance-specific error occurred while establishing a connection to SQL Server the server was not found or was not accessible. verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces. error Locating Server/Instance Specified)
please help me to solve this problem. thanks
1 answer
Check to make sure that the target machine has the same version that you're compiling for. Also, make sure that if it's running on a 32-bit system, that you're not compiling for the 64-bit. Lastly, make sure that you're including all of the necessary libraries. Just by looking at those errors, there's obviously some sort of problem with either missing dependencies or maybe permissions?
Best Limo Fort Belvoir
Post an answer but please login first
Similar Questions
Excel 2016 VBA OLE SQL connection help
Excel 2016 VBA to create an OLE connection to a sql 2014 db and then execute a stored procedure returning the results starting cell A1 on sheet :StoredProcData. Server & instance is QGZZZ\MYINSTANCE db is data
how to use regional settings when connecting to SQL Server with a connection string? Is there a parameter for it?
How do i specifiy to use the regional settings (those settings in Windows control panel) for numbers, dates and currency? When defining a DSN connection in ODBC manager Windows i can check to use the regional settings.
Unable to connect to SQL Server 2014 via sConnString
Trying to connect to a SQL Server 2014 and receive the error : (System.Data.OleDb.OleDbException: '[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.')
Add MARS to connection string
Hi, I'm maintaining a C# .NET application. It is connected to an MSSQL database via ODBC connection. The constring is: Driver={SQL Server};Server=##.##.#.#;Database=QA;UID=SYS;PWD=__;
Password for ODBC Connections
Hi everyone I´m working with Visual studio data tools to create a DTSX that will work in SSIS. when I create the ODBC Connection I need to write a USER and PASSWORD for this connection but the password is not persistent.
Hosted website won't start with SQL Server connection
I have developed an ASP.Net Web Forms website on my local computer. I installed SQL Server Express 2017 on the local computer. I have a SQL Server database connected to SQL Server Express using the following code in web.config:
Hosted website won't start with SQL Server connection
I have developed an ASP.Net Web Forms website on my local computer. I installed SQL Server Express 2017 on the local computer. I have a SQL Server database connected to SQL Server Express using the following code in web.config:
Connection is not opening for SQL server 2016 with port 1600 using VB.Net
Connection is not opening when I try to open using VB.Net to MS SQL server 2016 with port 1600. My connection string is "Public globconnectionstring As String = "Server=learningserver.com,1600;Database=learning;User ID=readonly;Password=readonly"
FYI Released: Microsoft OLE DB Driver for SQL Server
Hi ADO is undeprecated. There is a new release of ADODB driver for SQL Server. It supports SQL Server from 2012 to 2017 and Azure also. Follow the link: https://blogs.msdn.microsoft.com/sqlnativeclient/2018/03/30/released-microsoft-ole-db-driver-for-sql-server/
Logged in windows user is different than a domain user has SQL access
I have to use fixed Domain user in connection string to connect to SQL server. But the logged user for windows is different. Is there any solution . this is requirement of our project. Please help .
- Load more posts