我怎样才能给我连接到Sert上sql server上的sql server的连接字符串 [英] how can i give connection string that i connect to sql server on ser at perticular IP

问题描述

如何给连接字符串以113.30.141.10连接到服务器上的sql server
我在该服务器上创建数据库和表.
目前，我给本地连接字符串，如acess女士中的

how can i give connection string to connect to sql server on server at 113.30.141.10
i create database and table on that server.
currently i am give local connection string as in Ms acess

const String ConnectionStringSampleDB = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\ProjectDatabase\\CorporateDatabase1.mdb;Persist Security Info=True";

我该如何给出我在特定IP上以ser连接到sql server上的sql服务器的连接字符串

how can i give connection string that i connect to sql server on ser at perticular IP

推荐答案

关注:
通过C#访问SQL Server的入门指南 [ ^ ]

Follow:
Beginners guide to accessing SQL Server through C#[^]

将以下设置添加到您的Web配置文件中.

Add following setting to your web config file..

<connectionstrings>
<add name="ConnectionString" connectionstring="Data Source=113.30.141.10;Connection Timeout=3600;Initial Catalog=Databasename;User ID=test;Password=test" providername="System.Data.SqlClient" />
</connectionstrings>

这篇关于我怎样才能给我连接到Sert上sql server上的sql server的连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！