Showing posts with label asp. Show all posts
Showing posts with label asp. Show all posts

Thursday, March 22, 2012

error '800a03eb' Type mismatch

Maintaining database website,its running ASP pages on windows 2003 server with SQL server 2000. I have upgraded SP2 for SQL server to SP4 in maintance process.

The problem accur with some ASP pages are

server_errors [server_Errors] GetErrorMessage [serverSERVER version 1.0.0] error '800a03eb' Type mismatch

/server/asp/cmfls/errorconfirmation.asp, line

There may be permission /security issues related with database.help me to troubleshoot my problem.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=395969&SiteID=1

Wednesday, March 21, 2012

error '80004005' while accessing the ASP pages

hi,
I am having while accessing the asp pages in our the problem is
"Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
/pressreleases/pressroom.asp, line 90 "
If i restart the system then i am able to connect the database and working
well.. but afterdays again i am getting same error.. so please help me in
this. Thanks in advance
rajavelWhy are you using named pipes? See http://www.aspfaq.com/2126 for optimal
connection strings...
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Rajavelu Dhakshinamurthy" <rajavelu_d@.dev.visualsoft-tech.com> wrote in
message news:#xySVGH7DHA.2404@.TK2MSFTNGP12.phx.gbl...
> hi,
> I am having while accessing the asp pages in our the problem is
> "Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
> /pressreleases/pressroom.asp, line 90 "
>
> If i restart the system then i am able to connect the database and working
> well.. but afterdays again i am getting same error.. so please help me in
> this. Thanks in advance
> rajavel
>
>|||Either you have your database open while you are executing an asp page which
either reads or writes from a datagase or,
You don't have the permission to read/write your database
Click on My Computer icon on your desktop, keep clicking until you find the
folder where your database is. Right click on the database and select
properties and make sure the correct permissions are selected.
regards,
harsh.
"Rajavelu Dhakshinamurthy" <rajavelu_d@.dev.visualsoft-tech.com> wrote in
message news:#xySVGH7DHA.2404@.TK2MSFTNGP12.phx.gbl...
> hi,
> I am having while accessing the asp pages in our the problem is
> "Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
> /pressreleases/pressroom.asp, line 90 "
>
> If i restart the system then i am able to connect the database and working
> well.. but afterdays again i am getting same error.. so please help me in
> this. Thanks in advance
> rajavel
>
>|||In article <uukjTUH7DHA.2760@.TK2MSFTNGP09.phx.gbl>, "harsh" <harshalmistry@.hotmail.com> wrote:
>Either you have your database open while you are executing an asp page which
>either reads or writes from a datagase or,
>You don't have the permission to read/write your database
>Click on My Computer icon on your desktop, keep clicking until you find the
>folder where your database is. Right click on the database and select
>properties and make sure the correct permissions are selected.
>regards,
>harsh.
Huh?
I'm afraid you didn't catch the fact that this is a SQL Server DB.
SQL Server doesn't work like that.
What exactly is the SQL statement that is bombing out doing?
Have you tried running profiler when this occurs?|||Check this general guide how to troubleshoot the 80004005 error as well:
http://support.microsoft.com/default.aspx?scid=kb;en-us;306518.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Rajavelu Dhakshinamurthy" <rajavelu_d@.dev.visualsoft-tech.com> wrote in
message news:#xySVGH7DHA.2404@.TK2MSFTNGP12.phx.gbl...
> hi,
> I am having while accessing the asp pages in our the problem is
> "Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
> /pressreleases/pressroom.asp, line 90 "
>
> If i restart the system then i am able to connect the database and working
> well.. but afterdays again i am getting same error.. so please help me in
> this. Thanks in advance
> rajavel
>
>

error '80004005' while accessing the ASP pages

hi,
I am having while accessing the asp pages in our the problem is
"Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
/pressreleases/pressroom.asp, line 90 "
If i restart the system then i am able to connect the database and working
well.. but afterdays again i am getting same error.. so please help me in
this. Thanks in advance
rajavelWhy are you using named pipes? See http://www.aspfaq.com/2126 for optimal
connection strings...
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Rajavelu Dhakshinamurthy" <rajavelu_d@.dev.visualsoft-tech.com> wrote in
message news:#xySVGH7DHA.2404@.TK2MSFTNGP12.phx.gbl...
> hi,
> I am having while accessing the asp pages in our the problem is
> "Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
> /pressreleases/pressroom.asp, line 90 "
>
> If i restart the system then i am able to connect the database and working
> well.. but afterdays again i am getting same error.. so please help me in
> this. Thanks in advance
> rajavel
>
>|||Either you have your database open while you are executing an asp page which
either reads or writes from a datagase or,
You don't have the permission to read/write your database
Click on My Computer icon on your desktop, keep clicking until you find the
folder where your database is. Right click on the database and select
properties and make sure the correct permissions are selected.
regards,
harsh.
"Rajavelu Dhakshinamurthy" <rajavelu_d@.dev.visualsoft-tech.com> wrote in
message news:#xySVGH7DHA.2404@.TK2MSFTNGP12.phx.gbl...
> hi,
> I am having while accessing the asp pages in our the problem is
> "Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
> /pressreleases/pressroom.asp, line 90 "
>
> If i restart the system then i am able to connect the database and working
> well.. but afterdays again i am getting same error.. so please help me in
> this. Thanks in advance
> rajavel
>
>|||In article <uukjTUH7DHA.2760@.TK2MSFTNGP09.phx.gbl>, "harsh" <harshalmistry@.hotmail.com>
wrote:
>Either you have your database open while you are executing an asp page whic
h
>either reads or writes from a datagase or,
>You don't have the permission to read/write your database
>Click on My Computer icon on your desktop, keep clicking until you find the
>folder where your database is. Right click on the database and select
>properties and make sure the correct permissions are selected.
>regards,
>harsh.
Huh?
I'm afraid you didn't catch the fact that this is a SQL Server DB.
SQL Server doesn't work like that.
What exactly is the SQL statement that is bombing out doing?
Have you tried running profiler when this occurs?|||Check this general guide how to troubleshoot the 80004005 error as well:
http://support.microsoft.com/defaul...b;en-us;306518.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Rajavelu Dhakshinamurthy" <rajavelu_d@.dev.visualsoft-tech.com> wrote in
message news:#xySVGH7DHA.2404@.TK2MSFTNGP12.phx.gbl...
> hi,
> I am having while accessing the asp pages in our the problem is
> "Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
> /pressreleases/pressroom.asp, line 90 "
>
> If i restart the system then i am able to connect the database and working
> well.. but afterdays again i am getting same error.. so please help me in
> this. Thanks in advance
> rajavel
>
>

error '80004005' on .asp

I have the following error on executing a. asp file which uploads a file
into a 2005 SQL DB.
Take note that the SQL server and IIS resides in the same server.
Mcrosoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find se
rver
'servername' in sysservers. Execute sp_addlinkedserver to add the server to
sysservers.Hi Monica
You can use SQL Profiler to see the statements you are sending to the server
.
If the server has been renamed check out
http://support.microsoft.com/kb/303774.
John
"Monica" wrote:

> I have the following error on executing a. asp file which uploads a file
> into a 2005 SQL DB.
> Take note that the SQL server and IIS resides in the same server.
> --
> Mcrosoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find
server
> 'servername' in sysservers. Execute sp_addlinkedserver to add the server t
o
> sysservers.
> --
>
>|||hi John,
Is this also an issue even if the server was renamed even before I created
the DB? BTW, the Db came from a SQL 2000 version that was working fine, but
had this problem when I restored in the 2005 version.
Thanks,
Monica
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:FEB13C42-80EC-4218-B5F0-E6B2C0E841BD@.microsoft.com...[vbcol=seagreen]
> Hi Monica
> You can use SQL Profiler to see the statements you are sending to the
> server.
> If the server has been renamed check out
> http://support.microsoft.com/kb/303774.
> John
> "Monica" wrote:
>|||Hi Monica
This is a problem with the server and not the database. If you have not
renamed the SQL 2005 Server then you should not have this problem. Checking
@.@.SERVERNAME will show if you have this problem also check out "Hot to:
Rename a Stand-alone Instance of SQL Server 2005" in books online for more
information.
If @.@.SERVERNAME is correct you may have some SQL that is not compatible with
SQL 2005, this can be checked by running SQL Profiler.
John
"Monica" wrote:

> hi John,
> Is this also an issue even if the server was renamed even before I created
> the DB? BTW, the Db came from a SQL 2000 version that was working fine, b
ut
> had this problem when I restored in the 2005 version.
> Thanks,
> Monica
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:FEB13C42-80EC-4218-B5F0-E6B2C0E841BD@.microsoft.com...
>
>|||Hi John,
Now I have this error message,
Microsoft OLE DB Provider for ODBC Drivers error '80040e23'
[Microsoft][ODBC SQL Server Driver][SQL Server]The cursor does n
ot include
the table being modified or the table is not updatable through the cursor.
What does this mean?
Monica
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:3C74BC77-EF9F-4063-A26E-2110688DB2A5@.microsoft.com...[vbcol=seagreen]
> Hi Monica
> This is a problem with the server and not the database. If you have not
> renamed the SQL 2005 Server then you should not have this problem.
> Checking
> @.@.SERVERNAME will show if you have this problem also check out "Hot to:
> Rename a Stand-alone Instance of SQL Server 2005" in books online for more
> information.
> If @.@.SERVERNAME is correct you may have some SQL that is not compatible
> with
> SQL 2005, this can be checked by running SQL Profiler.
> John
>
> "Monica" wrote:
>|||Hi Monica
This sounds a bit like http://support.microsoft.com//kb/290413 although it
will not apply to your version, it could be something to do with how you are
forming your SQL statements, can you pinpoint the statement with SQL profile
r?
John
"Monica" wrote:

> Hi John,
> Now I have this error message,
> Microsoft OLE DB Provider for ODBC Drivers error '80040e23'
> [Microsoft][ODBC SQL Server Driver][SQL Server]The cursor does
not include
> the table being modified or the table is not updatable through the cursor.
> What does this mean?
>
> Monica
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:3C74BC77-EF9F-4063-A26E-2110688DB2A5@.microsoft.com...
>
>

error '80004005' on .asp

I have the following error on executing a. asp file which uploads a file
into a 2005 SQL DB.
Take note that the SQL server and IIS resides in the same server.
--
Mcrosoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server
'servername' in sysservers. Execute sp_addlinkedserver to add the server to
sysservers.
--Hi Monica
You can use SQL Profiler to see the statements you are sending to the server.
If the server has been renamed check out
http://support.microsoft.com/kb/303774.
John
"Monica" wrote:
> I have the following error on executing a. asp file which uploads a file
> into a 2005 SQL DB.
> Take note that the SQL server and IIS resides in the same server.
> --
> Mcrosoft OLE DB Provider for ODBC Drivers error '80004005'
> [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server
> 'servername' in sysservers. Execute sp_addlinkedserver to add the server to
> sysservers.
> --
>
>|||hi John,
Is this also an issue even if the server was renamed even before I created
the DB? BTW, the Db came from a SQL 2000 version that was working fine, but
had this problem when I restored in the 2005 version.
Thanks,
Monica
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:FEB13C42-80EC-4218-B5F0-E6B2C0E841BD@.microsoft.com...
> Hi Monica
> You can use SQL Profiler to see the statements you are sending to the
> server.
> If the server has been renamed check out
> http://support.microsoft.com/kb/303774.
> John
> "Monica" wrote:
>> I have the following error on executing a. asp file which uploads a file
>> into a 2005 SQL DB.
>> Take note that the SQL server and IIS resides in the same server.
>> --
>> Mcrosoft OLE DB Provider for ODBC Drivers error '80004005'
>> [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server
>> 'servername' in sysservers. Execute sp_addlinkedserver to add the server
>> to
>> sysservers.
>> --
>>|||Hi Monica
This is a problem with the server and not the database. If you have not
renamed the SQL 2005 Server then you should not have this problem. Checking
@.@.SERVERNAME will show if you have this problem also check out "Hot to:
Rename a Stand-alone Instance of SQL Server 2005" in books online for more
information.
If @.@.SERVERNAME is correct you may have some SQL that is not compatible with
SQL 2005, this can be checked by running SQL Profiler.
John
"Monica" wrote:
> hi John,
> Is this also an issue even if the server was renamed even before I created
> the DB? BTW, the Db came from a SQL 2000 version that was working fine, but
> had this problem when I restored in the 2005 version.
> Thanks,
> Monica
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:FEB13C42-80EC-4218-B5F0-E6B2C0E841BD@.microsoft.com...
> > Hi Monica
> >
> > You can use SQL Profiler to see the statements you are sending to the
> > server.
> >
> > If the server has been renamed check out
> > http://support.microsoft.com/kb/303774.
> >
> > John
> >
> > "Monica" wrote:
> >
> >> I have the following error on executing a. asp file which uploads a file
> >> into a 2005 SQL DB.
> >>
> >> Take note that the SQL server and IIS resides in the same server.
> >>
> >> --
> >>
> >> Mcrosoft OLE DB Provider for ODBC Drivers error '80004005'
> >> [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server
> >> 'servername' in sysservers. Execute sp_addlinkedserver to add the server
> >> to
> >> sysservers.
> >>
> >> --
> >>
> >>
> >>
>
>|||Hi John,
Now I have this error message,
Microsoft OLE DB Provider for ODBC Drivers error '80040e23'
[Microsoft][ODBC SQL Server Driver][SQL Server]The cursor does not include
the table being modified or the table is not updatable through the cursor.
What does this mean?
Monica
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:3C74BC77-EF9F-4063-A26E-2110688DB2A5@.microsoft.com...
> Hi Monica
> This is a problem with the server and not the database. If you have not
> renamed the SQL 2005 Server then you should not have this problem.
> Checking
> @.@.SERVERNAME will show if you have this problem also check out "Hot to:
> Rename a Stand-alone Instance of SQL Server 2005" in books online for more
> information.
> If @.@.SERVERNAME is correct you may have some SQL that is not compatible
> with
> SQL 2005, this can be checked by running SQL Profiler.
> John
>
> "Monica" wrote:
>> hi John,
>> Is this also an issue even if the server was renamed even before I
>> created
>> the DB? BTW, the Db came from a SQL 2000 version that was working fine,
>> but
>> had this problem when I restored in the 2005 version.
>> Thanks,
>> Monica
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:FEB13C42-80EC-4218-B5F0-E6B2C0E841BD@.microsoft.com...
>> > Hi Monica
>> >
>> > You can use SQL Profiler to see the statements you are sending to the
>> > server.
>> >
>> > If the server has been renamed check out
>> > http://support.microsoft.com/kb/303774.
>> >
>> > John
>> >
>> > "Monica" wrote:
>> >
>> >> I have the following error on executing a. asp file which uploads a
>> >> file
>> >> into a 2005 SQL DB.
>> >>
>> >> Take note that the SQL server and IIS resides in the same server.
>> >>
>> >> --
>> >>
>> >> Mcrosoft OLE DB Provider for ODBC Drivers error '80004005'
>> >> [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server
>> >> 'servername' in sysservers. Execute sp_addlinkedserver to add the
>> >> server
>> >> to
>> >> sysservers.
>> >>
>> >> --
>> >>
>> >>
>> >>
>>|||Hi Monica
This sounds a bit like http://support.microsoft.com//kb/290413 although it
will not apply to your version, it could be something to do with how you are
forming your SQL statements, can you pinpoint the statement with SQL profiler?
John
"Monica" wrote:
> Hi John,
> Now I have this error message,
> Microsoft OLE DB Provider for ODBC Drivers error '80040e23'
> [Microsoft][ODBC SQL Server Driver][SQL Server]The cursor does not include
> the table being modified or the table is not updatable through the cursor.
> What does this mean?
>
> Monica
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:3C74BC77-EF9F-4063-A26E-2110688DB2A5@.microsoft.com...
> > Hi Monica
> >
> > This is a problem with the server and not the database. If you have not
> > renamed the SQL 2005 Server then you should not have this problem.
> > Checking
> > @.@.SERVERNAME will show if you have this problem also check out "Hot to:
> > Rename a Stand-alone Instance of SQL Server 2005" in books online for more
> > information.
> >
> > If @.@.SERVERNAME is correct you may have some SQL that is not compatible
> > with
> > SQL 2005, this can be checked by running SQL Profiler.
> >
> > John
> >
> >
> > "Monica" wrote:
> >
> >> hi John,
> >>
> >> Is this also an issue even if the server was renamed even before I
> >> created
> >> the DB? BTW, the Db came from a SQL 2000 version that was working fine,
> >> but
> >> had this problem when I restored in the 2005 version.
> >>
> >> Thanks,
> >> Monica
> >>
> >> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> >> news:FEB13C42-80EC-4218-B5F0-E6B2C0E841BD@.microsoft.com...
> >> > Hi Monica
> >> >
> >> > You can use SQL Profiler to see the statements you are sending to the
> >> > server.
> >> >
> >> > If the server has been renamed check out
> >> > http://support.microsoft.com/kb/303774.
> >> >
> >> > John
> >> >
> >> > "Monica" wrote:
> >> >
> >> >> I have the following error on executing a. asp file which uploads a
> >> >> file
> >> >> into a 2005 SQL DB.
> >> >>
> >> >> Take note that the SQL server and IIS resides in the same server.
> >> >>
> >> >> --
> >> >>
> >> >> Mcrosoft OLE DB Provider for ODBC Drivers error '80004005'
> >> >> [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server
> >> >> 'servername' in sysservers. Execute sp_addlinkedserver to add the
> >> >> server
> >> >> to
> >> >> sysservers.
> >> >>
> >> >> --
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

Error 80004005

Running on NT4.0 SP6
Running SQL 6.50.201
SQL-DMO v.6.05.02
SQL-Library v.6.50.252
Trying to access via IIS with an ASP page
Getting the following error:
Microsoft OLE DB Provider for ODBC Drivers
error '80004005'
Specified driver could not be loaded due to system error 5
(SQL Server).
/ntahawaii/block.asp, line 13
Checked permissions, looks ok.
Anyone have any idea's as to what to do?
Thank!
billHere are some google hits that you may wish to inspect. Sorry if the link
wraps, tinyurl.com is down -- or at least too slow for me, I haven't got all
minute! :-)
http://groups.google.com/groups?q=%22system+error+5%22+group%3A*sqlserver*&ie=UTF-8&oe=UTF-8&hl=en
"Bill Mukaida" <bmukaida@.hawaii.rr.com> wrote in message
news:0c0701c34720$8ac3d000$a001280a@.phx.gbl...
> Running on NT4.0 SP6
> Running SQL 6.50.201
> SQL-DMO v.6.05.02
> SQL-Library v.6.50.252
> Trying to access via IIS with an ASP page
> Getting the following error:
> Microsoft OLE DB Provider for ODBC Drivers
> error '80004005'
> Specified driver could not be loaded due to system error 5
> (SQL Server).
> /ntahawaii/block.asp, line 13
> Checked permissions, looks ok.
> Anyone have any idea's as to what to do?
> Thank!
> bill
>

Wednesday, March 7, 2012

error 3926 , server failed to resume transaction

In a high load asp.net environment, I am getting an error.

The transation active in this session has been committed or aborted by another session.

Here is the code , I am getting error.

1object returnObject =null;2 SqlTransaction sqlTrans =null;3try4 {5//Getting new SqlConnection6 comm.Connection = GetConnection();7//Opening connection8 OpenConn(comm.Connection);9//beginning transaction10 sqlTrans = comm.Connection.BeginTransaction( IsolationLevel.ReadCommitted );11//setting transaction to SqlCommand object12 comm.Transaction = sqlTrans;13//executing operation14 returnObject = comm.ExecuteScalar();15//trying to commit.16 sqlTrans.Commit();171819 }20catch (SqlException sex)21 {22if (sqlTrans !=null)23 {24 sqlTrans.Rollback();25 }26 }27finally28 {29 comm.Connection.Close();30 }
Could you please explain , am I doing smthg wrong ?

Check out this link: http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2041937&SiteID=17

Good luck.

|||

Hi CS4Ever ,

Thanks for the reply, but as far as I understood , Thona just submitted the situation , not a solution and the 3rd reply belongs to me :)

What could I possibly do ? Submit a bug to Microsoft ?

Thanks in advance.

|||

Still no answers ?