与SQL SERVER链接 [英] LINK WITH SQL SERVER
问题描述
我正在用Visual Basic做一个proyect,我必须使用我已经在SQL SERVER上创建的
数据库。在我的电脑中我不得不安装WINDOWS 2000系列服务器,以便能够安装SQL SERVER
作为服务器而不是客户端,我完全可以看到完全<来自VB的
数据库。
问题是现在我有一台笔记本电脑,我想继续开发它,b $ b开发它,我已经安装了其他一些
之一,但是当我想建立
连接时,我无法看到SQL SERVER作为提供者。所以我不知道我是否必须做一些特殊的事情才能从Visual Basic中看到它。
我不想建立一个网络,我只想与笔记本电脑上的proyect
保持一致。
请有人帮助我。
Gloria(gl**********@yahoo.com.mx)写道:我在做使用Visual Basic进行安装,我必须使用我已在SQL SERVER上创建的数据库。在我的电脑中我不得不安装WINDOWS 2000系列服务器,能够安装SQL SERVER
作为服务器而不是客户端,我可以完美地看到VB中的数据库。<问题是,现在我有一台笔记本电脑,我想继续开发它,我已经安装了一些像其他的一样,但我不能当我想建立
连接时,请将SQL SERVER视为提供者。所以我不知道是否必须做一些特别的事情才能从Visual Basic中看到它。
我不太确定你的意思是你不能把SQL Server视为
提供者。你运行你的程序,你连接失败?或者它是否在开发环境中以某种方式遗漏了?
?在后一种情况下,
你可能最好在Visual Basic新闻组中询问。
-
Erland Sommarskog, SQL Server MVP, so****@algonet.se
联机丛书SQL Server SP3
http:// www.microsoft.com/sql/techinf...2000/books.asp
事实是当我尝试从Visual Basic建立连接时,我
必须指定OLE DB的提供者,所以我使用Microsoft OLE DB
Provider for SQL Sever,当我尝试检查连接时,有
一个错误,Visual Basic没有问题,所以我认为我做了一个错误的SQL SERVER安装。
你有什么建议我可以做的吗?
Gloria(gl**********@yahoo.com.mx)写道:事实是,当我尝试从Visual Basic建立连接时,我必须指定OLE DB的提供者,所以我使用Microsoft OLE DB
Provider for SQL Sever,当我尝试检查连接时出现错误,Visual Basic没有问题,所以我认为我的SQL SERVER安装有问题。
<你有什么建议我可以做的吗?
你能发贴相关的代码吗?
有很多可能性,但不必访问你的机器,我在黑暗中。
-
Erland Sommarskog,SQL Server MVP, so****@algonet.se
SQL Server SP3联机丛书
http://www.microsoft.com/sql/techinf...2000/books.asp
Hi, I''m doing a proyect with Visual Basic where I have to use a
database that I''ve already made on SQL SERVER. In my computer I had to
install WINDOWS 2000 family server, to be able to install SQL SERVER
as server not as a client, I can see perfectly and totally the
database from VB.
The problem is that now I have a laptop, and I want to continue
developing on it, I already installed everything like in the other
one, but I can''t see SQL SERVER as a provider when I want to make the
connection. So I don''t know if I have to do something special in order
to see it from Visual Basic.
I don''t want to make a network, I just want to keep with the proyect
from the laptop.
Please somebody help me.解决方案Gloria (gl**********@yahoo.com.mx) writes:Hi, I''m doing a proyect with Visual Basic where I have to use a
database that I''ve already made on SQL SERVER. In my computer I had to
install WINDOWS 2000 family server, to be able to install SQL SERVER
as server not as a client, I can see perfectly and totally the
database from VB.
The problem is that now I have a laptop, and I want to continue
developing on it, I already installed everything like in the other
one, but I can''t see SQL SERVER as a provider when I want to make the
connection. So I don''t know if I have to do something special in order
to see it from Visual Basic.
I''m not really sure what you mean with that you cannot see SQL Server as
provider. Do you run your program, and you fail to connect? Or is it
somehow missing in the developement environment? In the latter case,
you may be better off asking in a Visual Basic newsgroup.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
The fact is that when I try to make a connection from Visual Basic, I
have to specified the provider of OLE DB, so I use Microsoft OLE DB
Provider for SQL Sever, and when I try to check the connection there''s
an error, there is no problem with Visual Basic, so I think that I do
something wrong with the SQL SERVER installation.
Is there anything that you suggest I can do?
Gloria (gl**********@yahoo.com.mx) writes:The fact is that when I try to make a connection from Visual Basic, I
have to specified the provider of OLE DB, so I use Microsoft OLE DB
Provider for SQL Sever, and when I try to check the connection there''s
an error, there is no problem with Visual Basic, so I think that I do
something wrong with the SQL SERVER installation.
Is there anything that you suggest I can do?
Could you post the relevant piece of code?
There are a numbe of possibilities, but not having to access to your
machine, I''m in the dark.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
这篇关于与SQL SERVER链接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!