How to run a CS program at client without SQL Server!
-
We developed a CS program by C#,the server is SQL Server,i copyed the program to a system without SQL Server,the program can not be run,the error report is something like this:"Can't connect to Database".when i installed the "Connectivity Only" option of SQL Server,the program can be run in this system. what i want to know is how to run our program without install anything of SQL Server, or just copy something usefull to the system from SQL Server. Tuliplanet
-
We developed a CS program by C#,the server is SQL Server,i copyed the program to a system without SQL Server,the program can not be run,the error report is something like this:"Can't connect to Database".when i installed the "Connectivity Only" option of SQL Server,the program can be run in this system. what i want to know is how to run our program without install anything of SQL Server, or just copy something usefull to the system from SQL Server. Tuliplanet
Hi, Seems like you are pointing towards the local machine in your code. Obviously if there is no SQL server on the machine it can't connect. Itz advisable that you keep the connection string configurable and change the connection string in the configuration and make it point towards a machine where you have SQL Server. remember .NET requires MDAC 2.5 and above to connect to any database... regards, Aryadip. Cheers !! and have a Funky day !!
-
Hi, Seems like you are pointing towards the local machine in your code. Obviously if there is no SQL server on the machine it can't connect. Itz advisable that you keep the connection string configurable and change the connection string in the configuration and make it point towards a machine where you have SQL Server. remember .NET requires MDAC 2.5 and above to connect to any database... regards, Aryadip. Cheers !! and have a Funky day !!
NO,I Pointed towards to the right machine. Tuliplanet
-
We developed a CS program by C#,the server is SQL Server,i copyed the program to a system without SQL Server,the program can not be run,the error report is something like this:"Can't connect to Database".when i installed the "Connectivity Only" option of SQL Server,the program can be run in this system. what i want to know is how to run our program without install anything of SQL Server, or just copy something usefull to the system from SQL Server. Tuliplanet
-
How Are you connecting, OBDC dsn? Is it setup? SQL SERVER client utility? Show us your connection string( leave out sensitive values of course). Sql Server does not need to run on the computer the app is on.
Ok！The Connection string is："Server=XXX";uid=XXX;pwd=XXX;database=XXX". anything wrong? Tuliplanet
-
Ok！The Connection string is："Server=XXX";uid=XXX;pwd=XXX;database=XXX". anything wrong? Tuliplanet
OK, look at the Server name. Do you have the proper ODBC/Client Utility settings that allow you to access that data server. Test your connections. If you want to connect to Sql server you will need something to access it. You can not just say go talk to this server you need to have connectivity thru software like ODBC/Sql server Client Utility.