Showing posts with label dll. Show all posts
Showing posts with label dll. Show all posts

Wednesday, March 7, 2012

Error 37000

Hello,
Does anyone know how I can reslove this error message:
VB Error: 40002
Generated by: MSRDO20.DLL
Description: 37000 [Microsoft][ODBC SQL Server Driver] [SQL Server] Cannot
open cursor-refereced object "name" during dynamic fetch.
This error message is being generated in sql server 6.5. Thanks.
--
New SQL Server DBA
--
New SQL Server DBAIt means what it says: it is having trouble creating the cursor, then it can
not reference it.
It might be helpful to see the VB call as well as the T-SQL you are
attempting to execute.
Sincerely,
Anthony Thomas
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:4BA5DD03-FBC3-422E-8FDD-11D8AFF8227D@.microsoft.com...
Hello,
Does anyone know how I can reslove this error message:
VB Error: 40002
Generated by: MSRDO20.DLL
Description: 37000 [Microsoft][ODBC SQL Server Driver] [SQL Server] Cannot
open cursor-refereced object "name" during dynamic fetch.
This error message is being generated in sql server 6.5. Thanks.
--
New SQL Server DBA
--
New SQL Server DBA

error 3624 severity 20 SQL server was stopped often

hi~~
anyone met this error message
server is SQL2000(sp3)
below is the error log
---
spid66 Using 'dbghelp.dll' version '4.0.5'...
spid66 Stack Signature for the dump is 0x50347D98
spid66 SQL Server assertion : file : <recbase.cpp>,line=1378 ...
spid66 Using 'dbghelp.dll' version '4.0.5'...
spid66 SQL Server assertion: file: <umsio.cpp>,line=117 ...
spid66 Stack Signature for the dump is 0x57421D8E
Using 'dbghelp.dll' version '4.0.5'...
spid119 error: 3624, severity 20, state: 1.
spid66 SQL Server assertion file: <umsio.cpp>,line=563 ...
---
help me~~~~These types of problems are most often bugs in SQL Server. If you are up on service pack and didn't
find anything in KB about your problems you should open a case with MS Support.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"changsoon" <pcs73@.chol.com> wrote in message news:OrsfPMOrDHA.920@.TK2MSFTNGP10.phx.gbl...
> hi~~
> anyone met this error message
> server is SQL2000(sp3)
> below is the error log
> ---
> spid66 Using 'dbghelp.dll' version '4.0.5'...
> spid66 Stack Signature for the dump is 0x50347D98
> spid66 SQL Server assertion : file : <recbase.cpp>,line=1378 ...
> spid66 Using 'dbghelp.dll' version '4.0.5'...
> spid66 SQL Server assertion: file: <umsio.cpp>,line=117 ...
> spid66 Stack Signature for the dump is 0x57421D8E
> Using 'dbghelp.dll' version '4.0.5'...
> spid119 error: 3624, severity 20, state: 1.
> spid66 SQL Server assertion file: <umsio.cpp>,line=563 ...
> ---
> help me~~~~
>

Sunday, February 19, 2012

Error 22272: Cannot load the DLL xpstar.dll...

Hi,

I'm running SQL Server 2000 on a Windows 2003 server. It's serving
several small web site databases.

About a month ago my automatic backups stopped working, and whenever I
try to edit or set up a new maintenance plan or export or import data
through Enterprise Manager, I get the following error:

Error 22272: Cannot load the DLL xpstar.dll, or one of the DLLs it
references. Reason: 127(The specified procedure could not be found.).

I've also tried doing these tasks with some third-party apps (EMS,
Teratrax), and I get the same errors.

I've Googled this but the two fixes I've read about (reinstalling MDAC
and reinstalling SP4) didn't work for me.

I'm not sure what caused it -- probably a Windows update -- because I
didn't notice it until several weeks later.

Any idea what I can do to fix this without completely reinstalling SQL
Server? Its other functionality is unaffected; maybe it's a Windows
problem?

At a loss. Thanks.Pupkin (spamagnet@.dorrk.com) writes:

Quote:

Originally Posted by

About a month ago my automatic backups stopped working, and whenever I
try to edit or set up a new maintenance plan or export or import data
through Enterprise Manager, I get the following error:
>
Error 22272: Cannot load the DLL xpstar.dll, or one of the DLLs it
references. Reason: 127(The specified procedure could not be found.).
>
I've also tried doing these tasks with some third-party apps (EMS,
Teratrax), and I get the same errors.


I would look for MSVCR71.DLL in SYSTEM32. I would suspect that this is
what is missing.)

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||In article <Xns981A1C3B728EYazorman@.127.0.0.1>, esquel@.sommarskog.se
says...

Quote:

Originally Posted by

Pupkin (spamagnet@.dorrk.com) writes:

Quote:

Originally Posted by

About a month ago my automatic backups stopped working, and whenever I
try to edit or set up a new maintenance plan or export or import data
through Enterprise Manager, I get the following error:

Error 22272: Cannot load the DLL xpstar.dll, or one of the DLLs it
references. Reason: 127(The specified procedure could not be found.).

I've also tried doing these tasks with some third-party apps (EMS,
Teratrax), and I get the same errors.


>
I would look for MSVCR71.DLL in SYSTEM32. I would suspect that this is
what is missing.)
>


Nope. That one's in 9 different places in the system, including
system32.|||Pupkin (spamagnet@.dorrk.com) writes:

Quote:

Originally Posted by

In article <Xns981A1C3B728EYazorman@.127.0.0.1>, esquel@.sommarskog.se
says...

Quote:

Originally Posted by

>Pupkin (spamagnet@.dorrk.com) writes:

Quote:

Originally Posted by

About a month ago my automatic backups stopped working, and whenever I
try to edit or set up a new maintenance plan or export or import data
through Enterprise Manager, I get the following error:
>
Error 22272: Cannot load the DLL xpstar.dll, or one of the DLLs it
references. Reason: 127(The specified procedure could not be found.).
>
I've also tried doing these tasks with some third-party apps (EMS,
Teratrax), and I get the same errors.


>>
>I would look for MSVCR71.DLL in SYSTEM32. I would suspect that this is
>what is missing.)
>>


>
Nope. That one's in 9 different places in the system, including
system32.


And XPSTAR.DLL itself is in the BINN directory for the instance?

I chanced on MSVCR71 after having looked at the dependencies for
XPSTAR.DLL and that was the only that looked suspicious.

Then again, the message says that the procedure could not be found.
I believe that if an entire DLL was missing, the error would be another.
But whether this missing procedure is xpstar.dll itself, or in a
referenced DLL that has been replaced I have no idea.

Reinstall the SQL Server tools? Don't forget to reapply service packs.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Error 22272: Cannot load the DLL xpstar.dll,...

Hi,

I'm running SQL Server 2000 on a Windows 2003 server.

About some days ago, my automatic backups stopped working, and whenever I try to edit or set up a new maintenance plan or export or import data through Enterprise Manager, I get the following error:

Error 22272: Cannot load the dll xptar.dll, or one of the dll's it references. Reason: 126 (the specified module could not be found.)

Any Idea why ?

Look for MSVCR71.DLL in SYSTEM32 directory whether it is present or not.

If no luck then you have to reinstall client tools.

|||Hi,

MSVCR71.DLL in SYSTEM32 directory is present ,. but still i am getting the same error what should i do ?

Please help
|||

That's only one of the files you'd want to look for. You would want to check what files xpstar.dll has dependencies on and search based on all the files. You can use a dependency tool to check the dependencies - try this one:

http://www.dependencywalker.com/

and point it to xpstar.dll

You may also want to try reapplying the last service pack you have installed - that will sometimes find and install the missing files, depending on what is missing.

-Sue

Error 22272: Cannot load the DLL xpstar.dll,...

Hi,

I'm running SQL Server 2000 on a Windows 2003 server.

About some days ago, my automatic backups stopped working, and whenever I try to edit or set up a new maintenance plan or export or import data through Enterprise Manager, I get the following error:

Error 22272: Cannot load the dll xptar.dll, or one of the dll's it references. Reason: 126 (the specified module could not be found.)

Any Idea why ?

Look for MSVCR71.DLL in SYSTEM32 directory whether it is present or not.

If no luck then you have to reinstall client tools.

|||Hi,

MSVCR71.DLL in SYSTEM32 directory is present ,. but still i am getting the same error what should i do ?

Please help
|||

That's only one of the files you'd want to look for. You would want to check what files xpstar.dll has dependencies on and search based on all the files. You can use a dependency tool to check the dependencies - try this one:

http://www.dependencywalker.com/

and point it to xpstar.dll

You may also want to try reapplying the last service pack you have installed - that will sometimes find and install the missing files, depending on what is missing.

-Sue

Wednesday, February 15, 2012

Error 20534 "Error detected by database DLL"

hi,

I'm using Crystal reports 8.0 with VB 6.0 and SQL Server 2000..I am getting the error "Error detected by database DLL" We were using SQL server 7.0 earlier and have recently upgraded to SQL 2000.The error appeared after this upgradation.Could anyone please help me with this.I've found some threads related to this error but none of them could solve my problem..Any help would be highly appreciated.

Thanks & Regards,
Ekta Singh.how are you passing the values to the report ? And also, are you using tables or stored procedures in the report ?|||If you installed ur package some where and getting this error then just make a check for the list of DLLs mentioned below, if any of them is not present in ur package then manually add it.

' FOR VB 6.0
MSVBVM50.DLL
MSVBVM60.DLL
msvcp50.dll
msvcp60.dll

'For SQL connection
P2ssql.dll
P2lsql.dll

'For Crystal reports
craxddt.dll
craxdrt.dll
Crpaig80.dll
crviewer.dll
Crxlat32.dll
Implode.dll
itircl.dll
itss.dll
MSADODC.OCX
MSBIND.DLL
MSSTDFMT.DLL
MSVCRT.DLL
MSVCRT40.DLL
msvfw32.dll
OLEAUT32.DLL
OLEPRO32.DLL
P2smon.dll
p2sodbc.dll
p2soledb.dll
SHLWAPI.DLL
sscdlg.dll
sscrc.dll
sscsdk80.dll
STDOLE2.TLB
u252000.dll
u25dts.dll
u2dapp.dll
u2ddisk.dll
u2dmapi.dll
u2dnotes.dll
u2fhtml.dll
u2frtf.dll
u2ftext.dll
u2fwks.dll
u2fwordw.dll
u2fxls.dll
u2l2000.dll
URLMON.DLL

'Not necessary to include
msldbusr.dll
UXDDISK.DLL
UXFDOC.DLL
UXFWKS.DLL
UXFWORDW.DLL

Still if u r facing the same error, then either problem with the connection string or some table or field or SP or view missing.

Make sure and checkout.|||I'm using Crystal reports 8.0 with VB 6.0 and SQL Server 2005..I am getting the error "Error detected by database DLL" when i create a left outer join on the table .
plz answer.....|||I'm using Crystal reports 8.0 with VB 6.0 and SQL Server 2005..I am getting the error "Error detected by database DLL" when i create a left outer join on the table .
plz answer.....

it happens when query is wrong
review your query using query analyzer of SQL server.