Loading

DataTable works fine on Local but Not Server

Agyekum Essien

It gets data populated fine in the dataTable on local database with default Local connectionString but when I change it to use server database with connectionString by the server is the case; Check my connectionString below:

Local:

providerName="System.Data.SqlClient" />

Server:

Thanks in advance.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta8y ago
Accepted answer
When you host your db, they will provide an Ip address, just use that instead of domain name alongwith that juat confirm your id and password. First try to connect with ssms then apply on connection string