VS 2003 +打开与SQL SERVER 2000数据库的连接 [英] VS 2003 + opening a connection to SQL SERVER 2000 database
问题描述
嘿所有
我正在建造一台新电脑。
我有Windows XP Pro SP2和所有更新。
我安装了VS 2003.
然后将项目从旧计算机复制到新计算机。
当我尝试运行项目..它错误地说它sql server确实
不存在或访问被拒绝
连接字符串显然与它时完全相同在旧的
计算机上运行...因为所有文件来自旧计算机......
项目工作得很好。
MSSQL服务器在一台单独的计算机上运行。
我可以打开查询分析器并访问数据库，没问题。在新的
机器上。
我甚至可以使用工具..连接到数据库...在VS 2003 IDE和
工作。 ..
只是在我的vb.net代码中它失败了......再次..它在旧的开发机器上工作得很好。
。 />
任何想法？
谢谢
Jon
Hey all
I am building a new computer.
I have Windows XP Pro with SP2 and all the updates.
I installed VS 2003.
Then copied a project from my old computer to the new one.
When I try and run the project .. it errors out saying it "sql server does
not exist or access denied"
The connection string is obviously the exact same as when it ran on the old
computer ... as all the files came from the old computer ... where the
project works just fine.
The MSSQL server is running on a seperate computer all together.
I can open query analyzer and access the database, no problem. On the new
machine.
I can even use Tools .. Connect to Database ... in VS 2003 IDE and that
works ...
Just in my vb.net code is it failing .. and again .. it work just fine on
the old development machine.
Any ideas ??
Thanks
Jon
推荐答案
你的字符串连接是什么？
" Jon Delano" < JD ***** @ hotmail.com> escribióenel mensaje
新闻：aq ******************** @ comcast.com ...
what is your string connection?
"Jon Delano" <jd*****@hotmail.com> escribió en el mensaje
news:aq********************@comcast.com...
嘿所有
我正在构建一台新电脑。
我有Windows XP Pro SP2和所有更新。
我安装了VS 2003.
然后将一个项目从我的旧计算机复制到新计算机。
当我尝试运行项目时...它错误地说它sql server确实不存在或访问被拒绝
连接字符串显然与在旧计算机上运行时完全相同...因为所有文件都来自旧计算机......其中
项目工作得很好。
MSSQL服务器在一台单独的计算机上运行。
我可以打开查询分析器并访问数据库，没问题。在新的
机器上。
我甚至可以使用工具..连接到数据库...在VS 2003 IDE中，
有效......
我的vb.net代码是失败的..再次..它在旧的开发机器上工作得很好。
任何想法？
谢谢
Jon
Hey all
I am building a new computer.
I have Windows XP Pro with SP2 and all the updates.
I installed VS 2003.
Then copied a project from my old computer to the new one.
When I try and run the project .. it errors out saying it "sql server does
not exist or access denied"
The connection string is obviously the exact same as when it ran on the
old computer ... as all the files came from the old computer ... where the
project works just fine.
The MSSQL server is running on a seperate computer all together.
I can open query analyzer and access the database, no problem. On the new
machine.
I can even use Tools .. Connect to Database ... in VS 2003 IDE and that
works ...
Just in my vb.net code is it failing .. and again .. it work just fine on
the old development machine.
Any ideas ??
Thanks
Jon
这是一个网络应用吗？你的连接字符串是什么样的？你是否使用集成安全性与
连接到SQL？是否正在尝试使用您的
本地ASPNET帐户？
Greg
" Jon Delano" < JD ***** @ hotmail.com>在消息中写道
新闻：aq ******************** @ comcast.com ...
Is this a web app? What is does your connection string look like? Are you
connection to SQL using integrated security? Is it using trying to use your
local ASPNET account?
Greg
"Jon Delano" <jd*****@hotmail.com> wrote in message
news:aq********************@comcast.com...
嘿所有
我正在构建一台新电脑。
我有Windows XP Pro SP2和所有更新。
我安装了VS 2003.
然后将项目从我的旧计算机复制到新计算机。
当我尝试运行项目时...它错误地说它sql server确实
不存在或访问被拒绝
连接字符串显然与在旧计算机上运行时完全相同...因为所有文件都来自旧计算机...
项目的工作原理很好。
MSSQL服务器在一台单独的计算机上运行。
我可以打开查询分析器并访问数据库，没问题。在新的
机器上。
我甚至可以使用工具..连接到数据库...在VS 2003 IDE中，
有效......
我的vb.net代码是失败的..再次..它在旧的开发机器上工作得很好。
任何想法？
谢谢
Jon
Hey all
I am building a new computer.
I have Windows XP Pro with SP2 and all the updates.
I installed VS 2003.
Then copied a project from my old computer to the new one.
When I try and run the project .. it errors out saying it "sql server does
not exist or access denied"
The connection string is obviously the exact same as when it ran on the
old computer ... as all the files came from the old computer ... where the
project works just fine.
The MSSQL server is running on a seperate computer all together.
I can open query analyzer and access the database, no problem. On the new
machine.
I can even use Tools .. Connect to Database ... in VS 2003 IDE and that
works ...
Just in my vb.net code is it failing .. and again .. it work just fine on
the old development machine.
Any ideas ??
Thanks
Jon
对不好的语法表示抱歉。 ：^）让我们再试一次。
这是一个网络应用程序吗？你的连接字符串是什么样的？你是否使用集成安全性连接到SQL？
？它是否尝试使用您当地的
ASPNET帐户？
" Greg Burns" < BL ******* @ newsgroups.nospam>在留言中写道
新闻：好的**************** @ TK2MSFTNGP12.phx.gbl ...
Sorry for the bad grammar. :^) Let''s try that again.
Is this a web app? What does your connection string look like? Are you
connecting to SQL using integrated security? Is it trying to use your local
ASPNET account?
"Greg Burns" <bl*******@newsgroups.nospam> wrote in message
news:OK****************@TK2MSFTNGP12.phx.gbl...
这是一个网络应用？你的连接字符串是什么样的？您是否使用集成安全性与SQL连接？它是否正在尝试使用您当地的ASPNET帐户？
Is this a web app? What is does your connection string look like? Are you
connection to SQL using integrated security? Is it using trying to use
your local ASPNET account?
这篇关于VS 2003 +打开与SQL SERVER 2000数据库的连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
