SQL数据适配器 [英] SQL Data Adapter
问题描述
我对VB.Net比较陌生，所以请耐心等待。我可以使用Jet 4.0添加一个OleDBDataAdapter
而没有任何问题（虽然我在使用Date
和时间格式转移到数据库时遇到问题）。但是，我似乎无法让b / b $ b得到SQLDataAdapter。当我单击提供程序选项卡时，它默认为
到SQL Servera的Microsoft OLE DB提供程序??在连接选项卡上我有
输入SQL服务器名称的名称（下拉菜单显示
任何东西）。通过键入??（本地）a ??，我可以在我的PC上看到数据库。我可以
选择数据库并测试连接，它告诉我一个??测试连接
succeededa ??我点击一下?? OKa ??那个和一个?? OKa ??在a ??数据链路属性??框
我收到消息a ??无法连接到数据库。只有这个版本的Visual Studio.a可以连接到SQL Server桌面引擎数据库和Microsoft Access数据库
。任何人都可以帮我吗？
谢谢，
MikeS
I am relatively new to VB.Net so bear with me. I can add an OleDBDataAdapter
using the Jet 4.0 with no problem (although I''m having problems getting Date
and Time formats to carry over to the database). However, I can''t seem to
get the SQLDataAdapter to work. When I click on the provider tab it defaults
to a??Microsoft OLE DB Provider for SQL Servera??. On the connection tab I have
to enter the name of an SQL server name (the drop down doesna??t show
anything). By typing in a??(local)a??, I can see the database on my PC. I can
select the database and test the connection and it tells me a??Test connection
succeededa??. I click a??OKa?? to that and a??OKa?? on the a??Data Link Propertiesa?? box
and I get the message a??Unable to connect to database. It is only possible to
connect to SQL Server Desktop Engine databases and Microsoft Access databases
with this version of Visual Studio.a?? Can anyone help me with this?
Thanks,
MikeS
推荐答案
Mike，
版本VB 2002，VB2003和VB2005正在与提供商
向导不同。在那些版本中，有些版本的
版本的工作方式不同，因此您能告诉我们您使用的是什么吗？
Cor
" MikeS" < Mi *** @ discuss.microsoft.com>
Mike,
The versions VB 2002, VB2003 and VB2005 are working with the provider
wizards different. Than there is that inside those versions some of the
versions work different, therefore can you tell us what you are using?
Cor
"MikeS" <Mi***@discussions.microsoft.com>
我对VB.Net比较新，所以请耐心等待。我可以使用Jet 4.0添加一个
OleDBDataAdapter
没有问题（虽然我遇到了将日期
和时间格式转移到数据库的问题）。但是，我似乎无法让SQLDataAdapter工作。当我单击提供程序选项卡时，它默认
到Microsoft OLE DB Provider for SQL Server。在连接选项卡上我
输入SQL服务器名称的名称（下拉列表没有显示任何内容）。通过输入（本地），我可以在我的电脑上看到数据库。我可以
选择数据库并测试连接，它告诉我测试
连接成功。我点击确定那个和好的在数据链接属性框中，我收到消息无法连接到数据库。只能使用此版本的Visual Studio连接到SQL Server桌面引擎数据库和Microsoft Access数据库。
任何人都可以帮我这个吗？
谢谢，
MikeS
I am relatively new to VB.Net so bear with me. I can add an
OleDBDataAdapter
using the Jet 4.0 with no problem (although I''m having problems getting
Date
and Time formats to carry over to the database). However, I can''t seem to
get the SQLDataAdapter to work. When I click on the provider tab it
defaults
to "Microsoft OLE DB Provider for SQL Server". On the connection tab I
have
to enter the name of an SQL server name (the drop down doesn''t show
anything). By typing in "(local)", I can see the database on my PC. I
can
select the database and test the connection and it tells me "Test
connection
succeeded". I click "OK" to that and "OK" on the "Data Link Properties"
box
and I get the message "Unable to connect to database. It is only possible
to
connect to SQL Server Desktop Engine databases and Microsoft Access
databases
with this version of Visual Studio." Can anyone help me with this?
Thanks,
MikeS
这一定是因为代码没有获得名称
"（local）"的Db服务器。你必须明确地给出服务器的名称。检查
输出服务器名称。你可能错过了
名字中的某些内容。我有这个问题。在我的情况下，服务器名称太长了
不同然后我给了所以它无法找到，当然
有一些设置因为他们我是无法通过（本地）获得
服务器。这可能对你有帮助
this must be because the code is not getting the Db server by the name
"(local)". u must have give the name of the server explicitly. check
out the server name. it may be possible that u missed something in the
name. i had this problem. in my case the server name is too long and
differnt then i was giving so it was not able to find and of course
there are some settings because of them i was not able to get the
server by "(local)". this might help u
我也是VB.NET的新手（2天），我遇到了你的确切问题
是。两天后，我没有理由解决我们的问题。
-
谢谢
Dennis
" ; MIKES"写道：
I too am new to VB.NET(2 days), and am experiencing the exact problem you
are. After two days I have no light to shed on our problem.
--
Thanks
Dennis
"MikeS" wrote:
我对VB.Net比较新，所以请耐心等待。我可以使用Jet 4.0添加一个OleDBDataAdapter
没有问题（虽然我在将Date
和Time格式转移到数据库时遇到问题）。但是，我似乎无法让SQLDataAdapter工作。当我单击提供程序选项卡时，它默认为用于SQL Servera的Microsoft OLE DB提供程序。在连接选项卡上，我有输入SQL服务器名称的名称（下拉菜单显示
任何内容）。通过键入??（本地）a ??，我可以在我的PC上看到数据库。我可以选择数据库并测试连接，它告诉我一个??测试连接
succeededa ??我点击一下?? OKa ??那个和一个?? OKa ??在a ??数据链路属性??框
我得到的消息是??无法连接到数据库。只能使用此版本的Visual Studio连接到SQL Server桌面引擎数据库和Microsoft Access数据库。任何人都可以帮我这个吗？
谢谢，
MikeS
I am relatively new to VB.Net so bear with me. I can add an OleDBDataAdapter
using the Jet 4.0 with no problem (although I''m having problems getting Date
and Time formats to carry over to the database). However, I can''t seem to
get the SQLDataAdapter to work. When I click on the provider tab it defaults
to a??Microsoft OLE DB Provider for SQL Servera??. On the connection tab I have
to enter the name of an SQL server name (the drop down doesna??t show
anything). By typing in a??(local)a??, I can see the database on my PC. I can
select the database and test the connection and it tells me a??Test connection
succeededa??. I click a??OKa?? to that and a??OKa?? on the a??Data Link Propertiesa?? box
and I get the message a??Unable to connect to database. It is only possible to
connect to SQL Server Desktop Engine databases and Microsoft Access databases
with this version of Visual Studio.a?? Can anyone help me with this?
Thanks,
MikeS
这篇关于SQL数据适配器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
