批量命令& MS-访问 [英] Batch commands & Ms-Access

问题描述

您好我正在使用针对Ms-Access的批处理命令并收到错误

消息在SQL语句结束后找到的字符。字符串


这是我的sql Dim str_screens As String =" Select * from Screens Order by

ScreenName; Select * from Functions"


如何解决此问题。非常感谢任何帮助。


Selva

Hi I am using batch commands against Ms-Access and getting an error
Message "Characters found after end of SQL statement." String

Here is my sql Dim str_screens As String = "Select * from Screens Order by
ScreenName;Select * from Functions"

How can I fix this problem. Any help is greatly appreciated.

Selva

推荐答案

" Selva Chinnasamy" < SE ***************** @ online.nospam> schrieb

"Selva Chinnasamy" <se*****************@online.nospam> schrieb

您好我正在对Ms-Access使用批处理命令并收到错误
消息在SQL语句结束后找到字符。字符串

这是我的sql Dim str_screens As String =" Select * from Screens
Order by ScreenName; Select * from Functions"

如何修复此问题问题。

Hi I am using batch commands against Ms-Access and getting an error
Message "Characters found after end of SQL statement." String

Here is my sql Dim str_screens As String = "Select * from Screens
Order by ScreenName;Select * from Functions"

How can I fix this problem.

在SQL语句结束后删除字符。结尾是;>

BTW，这是数据库相关问题的组：

micrsoft.public.dotnet.framework.adonet

Armin

Remove the characters after the end of SQL statement. The end is the ";"
BTW, this is the group for database related questions:
micrsoft.public.dotnet.framework.adonet
Armin

Hey Selva，


我也发现有人遇到过这个问题。实际上它是由Access数据库查询引擎引起的，因为它不支持多个查询

语句批量执行。我们可能需要使用两个SqlCommands通过相同的sqlconnection来执行两个sqlstatements ....你还可以在下面的线程中找到关于这个的讨论：

http://forums.asp.net/936743 /showpost.aspx


谢谢，


Steven Cheng

Microsoft在线支持

安全！ www.microsoft.com/security

（此帖子按原样提供，不作任何保证，并且不授予

权利。）

---------------- ----

|来自：Selva Chinnasamy < se ***************** @ online.nospam>

|主题：批量命令& Ms-Access

|日期：星期一，2005年12月12日13:33:51 -0500

|行数：12

| X-Priority：3

| X-MSMail-Priority：正常

| X-Newsreader：Microsoft Outlook Express 6.00.2800.1506

| X-MimeOLE：由Microsoft MimeOLE制作V6.00.2800.1506

|消息ID：< u2 ************** @ TK2MSFTNGP15.phx.gbl>

|新闻组：microsoft.public.dotnet.languages.vb

| NNTP-Posting-Host：w27fw1.pb.com 199.231.49.128

|路径：TK2MSFTNGXA02.phx.gbl！TK2MSFTNGP08.phx.gbl！TK2MSFT NGP15.phx.gbl

|外部参照：TK2MSFTNGXA02.phx.gbl microsoft.public.dotnet.languages.vb:308263

| X-Tomcat-NG：microsoft.public.dotnet.languages.vb

|

|嗨我正在对Ms-Access使用批处理命令并收到错误

|消息在SQL语句结束后找到的字符。字符串

|

|这是我的sql Dim str_screens As String =" Select * from Screens Order by

| ScreenName;从函数中选择*

|

|我该如何解决这个问题。非常感谢任何帮助。

|

| Selva

|

|

|

|

Hey Selva,

I''ve also found someone else encountered this problem. Actually it is
caused by the Access db query engine dosn''t support mulitple query
statement batch executing. We may need to use two SqlCommands to execute
the two sqlstatements through the same sqlconnection .... You can also
found the discussion on this in the following thread:

http://forums.asp.net/936743/showpost.aspx

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
--------------------
| From: "Selva Chinnasamy" <se*****************@online.nospam>
| Subject: Batch commands & Ms-Access
| Date: Mon, 12 Dec 2005 13:33:51 -0500
| Lines: 12
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
| Message-ID: <u2**************@TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.dotnet.languages.vb
| NNTP-Posting-Host: w27fw1.pb.com 199.231.49.128
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP15.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.dotnet.languages.vb:308263
| X-Tomcat-NG: microsoft.public.dotnet.languages.vb
|
| Hi I am using batch commands against Ms-Access and getting an error
| Message "Characters found after end of SQL statement." String
|
| Here is my sql Dim str_screens As String = "Select * from Screens Order by
| ScreenName;Select * from Functions"
|
| How can I fix this problem. Any help is greatly appreciated.
|
| Selva
|
|
|
|

Stevan，谢谢你的回复。但是我找不到问题的答案。

非常感谢任何解决问题的帮助。


Selva


Steven Cheng [MSFT]"写道：

Stevan, Thanks for your reply. But I couldn''t find an answer for the problem.
Any help to resolve the problem is greatly appreciated.

Selva

"Steven Cheng[MSFT]" wrote:

嘿塞尔瓦，

我也发现有人遇到过这个问题。实际上它是由Access数据库查询引擎引起的，不支持多个查询语句批量执行。我们可能需要使用两个SqlCommands来通过相同的sqlconnection执行两个sqlstatements ....你还可以在以下主题中找到关于这个的讨论：

< a rel =nofollowhref =http://forums.asp.net/936743/showpost.aspxtarget =_ blank> http://forums.asp.net/936743/showpost.aspx

谢谢，

Steven Cheng
微软在线支持

安全！ www.microsoft.com/security
（此帖已提供按原样，没有任何保证，也没有赋予
权利。）
--------------------
|来自：Selva Chinnasamy < se ***************** @ online.nospam>
|主题：批量命令& Ms-Access
|日期：星期一，2005年12月12日13:33:51 -0500
|行数：12
| X-Priority：3
| X-MSMail-Priority：正常
| X-Newsreader：Microsoft Outlook Express 6.00.2800.1506
| X-MimeOLE：由Microsoft MimeOLE制作V6.00.2800.1506
|消息ID：< u2 ************** @ TK2MSFTNGP15.phx.gbl>
|新闻组：microsoft.public.dotnet.languages.vb
| NNTP-Posting-Host：w27fw1.pb.com 199.231.49.128
|路径：TK2MSFTNGXA02.phx.gbl！TK2MSFTNGP08.phx.gbl！TK2MSFT NGP15.phx.gbl
|外部参照：TK2MSFTNGXA02.phx.gbl microsoft.public.dotnet.languages.vb:308263
| X-Tomcat-NG：microsoft.public.dotnet.languages.vb
|
|嗨我正在使用针对Ms-Access的批处理命令并收到错误
|消息在SQL语句结束后找到的字符。字符串
|
|这是我的sql Dim str_screens As String =" Select * from Screens Order by
| ScreenName;从函数中选择*
|
|我该如何解决这个问题。非常感谢任何帮助。
|
| Selva
|
|
|
|

Hey Selva,

I''ve also found someone else encountered this problem. Actually it is
caused by the Access db query engine dosn''t support mulitple query
statement batch executing. We may need to use two SqlCommands to execute
the two sqlstatements through the same sqlconnection .... You can also
found the discussion on this in the following thread:

http://forums.asp.net/936743/showpost.aspx

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
--------------------
| From: "Selva Chinnasamy" <se*****************@online.nospam>
| Subject: Batch commands & Ms-Access
| Date: Mon, 12 Dec 2005 13:33:51 -0500
| Lines: 12
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1506
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506
| Message-ID: <u2**************@TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.dotnet.languages.vb
| NNTP-Posting-Host: w27fw1.pb.com 199.231.49.128
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP15.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.dotnet.languages.vb:308263
| X-Tomcat-NG: microsoft.public.dotnet.languages.vb
|
| Hi I am using batch commands against Ms-Access and getting an error
| Message "Characters found after end of SQL statement." String
|
| Here is my sql Dim str_screens As String = "Select * from Screens Order by
| ScreenName;Select * from Functions"
|
| How can I fix this problem. Any help is greatly appreciated.
|
| Selva
|
|
|
|

这篇关于批量命令&amp; MS-访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！