连接字符串问题 [英] Connection string problem

查看:79
本文介绍了连接字符串问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

先生
请告诉我必须对代码进行的更改

添加名称="abc"连接字符串=提供者= microsoft.jet.odbc.4.0; dsn = lex_hotel".\提供者名称="system.data.odbc"

同时使用sql server 2000作为后端替换ms-access2003.

谢谢.

解决方案

查看以下内容: http://www. connectionstrings.com/access-2007 [ ^ ]


您必须使用SQL Connection才能使用sql server2000.

在web.config中写入连接字符串

 <  添加   名称  ="    连接字符串  ="  提供商名称  ="    / >  

您的数据库将在服务器资源管理器窗口中,然后右键单击您的数据库并转到属性,在该属性上单击.属性窗口将打开,它将每次都包含您所需的连接字符串,并且对于evry数据库.


thnks希望对您有帮助!


sir
Plz tell me the change I have to made of the code

add name = "abc" Connection string = "provider =microsoft.jet.odbc.4.0; dsn = lex_hotel".\provider name ="system.data.odbc"

while use sql server 2000 as backend replacing ms-access 2003.

thank u.

解决方案

Check this out:http://www.connectionstrings.com/access-2007[^]


Hi, You have to use SQL Connection to use sql server 2000.

write connection string in web.config

<add name="LocalConn" connectionstring="Data Source=SERVER\SQLSERVERR2;Initial Catalog=EBS_Local;User ID=publishing;Password=sql;MultipleActiveResultSets=True" providername="System.Data.SqlClient" />


Hi You can do one thing to get right connection string . in your visual studio id go to server explorer add your database by making connection to you database .
your database will be in server explorer window after that right click on your database and go to property click on it property window will open and it will contain your desired connection string every time and for evry database.


thnks hope it help you !


这篇关于连接字符串问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆