how to write connection string for asp-remote sql server connectivity?

Question

i have tried to connect a centralised server for sql with html page using asp.iam encountering an error called "SQL server doesn't exist. or access denied".can anyone say the exact format for asp-remote sql server connectionstring?

Answer 1

Try this one:



connectionString="server= Yourservername;

database=YourDb; Trusted_Connection =no;

uid=yourSQLLoginName;pwd= yourPassword"



all one line and take out the spaces I put in so it writes correctly in this little box



Also you might need:



providerName="System.Data.SqlClient"



hope that helps

Answer 2

I don't know a whole lot about ASP or SQL, but I do know that you have to create an ODBC connection on the web server to the SQL server. Just something you might have overlooked. :)

Answer 3

sq. Server databases won't be able to be suitable to via their filename. You connect with their service operating on the server, making use of they server or social gathering call. service=SQLOLEDB;driving force={sq. Server};Server=YOURSERVERNAME;database=Y...