Re: Insert data

It would help us better assist you if you could include table DDL, query
strategy used so far, sample data in the form of INSERT statements, and an
illustration of the desired results. (For help with that refer to:
http://www.aspfaq.com/5006 and to
http://classicasp.aspfaq.com/general/how-do-i-make-sure-my-asp-question-gets-answered.html )



The less 'set up' work we have to do, the more likely you are going to have
folks tackle your problem and help you. Without this effort from you, we are
just playing guessing games.


--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"BMW" <BMW@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4B998D1D-D459-4374-BFE0-92D1A490DFF5@xxxxxxxxxxxxxxxx
Hi,

I haven't figure out why the store procedure execute withour error, but
the
data doesn't on the table.

I have a store procedure which is call by the component in the exchange
server.
I saw the store procedure is compelted on SQL Server Profiler and the
writer
comlun display '1'. However the data didn't insert on the table. Also the
store procedure returns the value to indicate there were success.

The exchange server connects to the server sql 2005 by using TCp/IP
protocol.
The user is domain admin.

I succeed add one new record only suddenly even the write column did show
'0'. For all tests, the data didn't insert on the table.

Hope someone help me to solve it.

Thanks.


.

Relevant Pages

  • Re: Insert data
    ... There is the script to create table, store procedure and the vb.net code. ... server are installed in different PC with same domain. ... SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ... Dim par2 As New SqlParameter("@RowCount", ...
    (microsoft.public.sqlserver.mseq)
  • Re: Weird Server errors in classic asp!!
    ... > (the other web apps running on the server seemed fine-only this one app ... > object I set it to nothing and then execute another store procedure. ... > set objRecord= Nothing ... Tom Kaminski IIS MVP ...
    (microsoft.public.inetserver.iis)
  • Re: Remote Stored Procedures
    ... I can run the store procedure in ... >to access a SQL Server that is higher than version 6.5. ... it looks like the difference is a remote server ...
    (microsoft.public.sqlserver.connect)
  • ODBC error 7410 (42000) Remote access not allowed for Windows NT u
    ... I want to create a store procedure in Server A, ... EXEC sp_addlinkedsrvlogin ServerB,false,sa,sa,passwordB ... When I execute the script, the error which shown on the subject occur. ...
    (microsoft.public.sqlserver.programming)
  • OWA... Cant get it to work.
    ... Do you install iis together with the exchange server in ... with the Microsoft Outlook Web Access components that are ... Microsoft Exchange Server ...
    (microsoft.public.exchange.misc)