Re: ADODB.Connection funkiness

Just to check, I tested with SQL Server 2000 and SQL Server 7, and got the
same error message.

Dan

NMAv wrote on Fri, 12 May 2006 07:58:02 -0700:

Odd, "I've not tried on SQL2k5 but we are migrating that way so I might as
well just get rid of them. I'm going to parse the GO's out of the sql
statement and be done with it.

Thanks for your time.

"Daniel Crichton" wrote:

NMAv wrote on Fri, 12 May 2006 06:43:01 -0700:

Thank you for the reply.

I understand that GO is not a recognized TSQL statement, but rather a
isql/osql/query analyzer command. However, it seems that ADO is able to
deal with the GO statement just fine provided the the preceeding
statement do not end with a semi colon. This seems bizarre to me and
I'm hoping there is a simple explanation/fix short of just remove the
GOs or the semi colons.

Well, I just tested with ADO 2.8 on my PC here against a SQL Server 2005
database and GO isn't accepted at all - I get "Incorrect syntax near
'GO'" whether a semi-colon is there or not.

Dan



.

Relevant Pages

  • Re: How to Mimic Access Externally Linked Tables using ADO?
    ... > using SQL Server for efficiency reasons. ... > connection up programmatically using ADO or ADOX or some SQL Server API? ... >> newsgroup, but if you have a good reason to send me e-mail, you'll find ... ADO does not have a query engine. ...
    (microsoft.public.data.ado)
  • Re: How to access the SQL server express from mfc application?
    ... There are different ways to do this via MFC. ... You could certainly try ADO, ... the entire contents of the database to a SQL Server Standard Server. ...
    (microsoft.public.vc.mfc)
  • Re: DAO vs ADO
    ... and ADO when working with SQL Server data. ... which makes DAO a good choice. ... > add additional overhead by loading Jet, ...
    (microsoft.public.access.conversion)
  • Re: DAO vs ADO
    ... and ADO when working with SQL Server data. ... which makes DAO a good choice. ... > add additional overhead by loading Jet, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Text of Startup Option Application Title
    ... This is a quote from Mary Chipman, SQL Server MVP, ex-Access MVP, and author ... DAO was designed, customized, and tweaked specifically for the Jet ... ADO was designed as a general-purpose data access wrapper around OLE ...
    (microsoft.public.access.formscoding)