连接字符串不起作用

问题描述

嗨



我有一个SQL服务器数据库（SQL Server 2008 R2），我使用我的经典asp网络应用程序。



我最近使用SQL Server Management studio创建了一个具有匹配凭据的登录名和用户。我将登录详细信息修改为我的连接字符串。我无法再连接到数据库了。



请协助，我还在这个领域学习



我的初始字符串：Provider = SQLOLEDB; data source =（local）; Integrated Security = SSPI; Initial Catalog = myDBName; Trusted_Connection = Yes



新字符串： Provider = SQLOLEDB; data source =（local）; Database = JointsDB; Uid = myUser; Pwd = myPassword

Hi

I have a SQL server DB (SQL Server 2008 R2) that I use with my classic asp web app.

I recently created a login and user with matching credentials using SQL Server Management studio. I amended the login details to my connection string. I can no longer connect to the database.

Please assist, I am still learning in this field

My initial string: " Provider = SQLOLEDB; data source=(local);Integrated Security=SSPI; Initial Catalog= myDBName; Trusted_Connection=Yes"

New string: " Provider = SQLOLEDB; data source=(local); Database= JointsDB; Uid= myUser; Pwd= myPassword"

推荐答案

"Provider=SQLOLEDB;data source=(local);User id=myUser;Password=myPassword;Initial Catalog=JointsDB"

希望它有所帮助。

Hope it helps.

这篇关于连接字符串不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！