>From: scott.shelbourne@gmail.com (Scott Shelbourne)
>Newsgroups: microsoft.public.dotnet.languages.vb.data
>Subject: "Syntax Error or Access Violation" ???
>Date: 1 Dec 2004 14:55:06 -0800
>Organization: http://groups.google.com
>Lines: 29
>Message-ID: <c52260fd.0412011455.1aa86f55@posting.google.com>
>NNTP-Posting-Host: 12.171.176.254
>Content-Type: text/plain; charset=ISO-8859-1
>Content-Transfer-Encoding: 8bit
>X-Trace: posting.google.com 1101941707 14762 127.0.0.1 (1 Dec 2004
22:55:07 GMT)
>X-Complaints-To: groups-abuse@google.com
>NNTP-Posting-Date: Wed, 1 Dec 2004 22:55:07 +0000 (UTC)
>Path:

>Xref: cpmsftngxa10.phx.gbl microsoft.public.dotnet.languages.vb.data:4522
>X-Tomcat-NG: microsoft.public.dotnet.languages.vb.data
>
>I'm getting a "Syntax error or access violation" error when I try to
>run a SQLServer stored procedure from my ASP.NET application. I can
>run the same exact procedure from Query Analyzer with no problems. I
>have checked the security permissions on SQLServer and have ensured
>this user has db_owner rights. The strange thing is that if I run a
>stored procedure via the code that does a Select query it is fine.
>However, this one procedure I'm trying to run performs an Insert and
>it blows up.
>
>Does anyone have a clue at what I can look for with this problem? It
>has me baffled. The code I'm using is below. It dies when it gets to
>the ExecuteNonQuery call.
>
><code>
> Function ExecuteOLEDBStoredProcNonQuery() As Long
> Dim _connection As New OleDb.OleDbConnection(_DSN)
> Dim _command As New OleDb.OleDbCommand(_SQL, _connection)
> With _command
> .CommandType = CommandType.StoredProcedure
> _connection.Open()
> .ExecuteNonQuery()
> .Dispose()
> End With
> With _connection
> .Close()
> .Dispose()
> End With
> End Function
></code>
>