Error from msxml6.dll

Hi,
i have a problem. when i try to validate an xml file with his schema
the msxml6.dll return this error:
01.xsd#/schema/element[1][@.name =
'T_CampiAree']/complexType[1]/sequence[1]/element[1][@.name =
'nomecampo']/simpleType[1]/restriction[1] Type
'{http://schemas.microsoft.com/sqlserver/2004/sqltypes}varchar' is
either not declared or not a simpleType.
i use a XMLSCHEMA option to generate a xsd and xml file
Anybody can help me?
Thanks!!
You will need to retrieve the schema from
http://schemas.microsoft.com/sqlserver/2004/sqltypes and load it into your
schema cache so that the validation finds it.
Best regards
Michael
"maurox" <mrago@.inwind.it> wrote in message
news:1140011253.493383.193650@.o13g2000cwo.googlegr oups.com...
> Hi,
> i have a problem. when i try to validate an xml file with his schema
> the msxml6.dll return this error:
> 01.xsd#/schema/element[1][@.name =
> 'T_CampiAree']/complexType[1]/sequence[1]/element[1][@.name =
> 'nomecampo']/simpleType[1]/restriction[1] Type
> '{http://schemas.microsoft.com/sqlserver/2004/sqltypes}varchar' is
> either not declared or not a simpleType.
> i use a XMLSCHEMA option to generate a xsd and xml file
> Anybody can help me?
> Thanks!!
>

Error from msxml6.dll

Hi,
i have a problem. when i try to validate an xml file with his schema
the msxml6.dll return this error:
01.xsd#/schema/element[1][@.name =
'T_CampiAree']/complexType[1]/sequence[1]/element[1][@.name =
'nomecampo']/simpleType[1]/restriction[1] Type
'{http://schemas.microsoft.com/sqlserver/2004/sqltypes}varchar' is
either not declared or not a simpleType.
i use a XMLSCHEMA option to generate a xsd and xml file
Anybody can help me?
Thanks!!You will need to retrieve the schema from
http://schemas.microsoft.com/sqlserver/2004/sqltypes and load it into your
schema cache so that the validation finds it.
Best regards
Michael
"maurox" <mrago@.inwind.it> wrote in message
news:1140011253.493383.193650@.o13g2000cwo.googlegroups.com...
> Hi,
> i have a problem. when i try to validate an xml file with his schema
> the msxml6.dll return this error:
> 01.xsd#/schema/element[1][@.name =
> 'T_CampiAree']/complexType[1]/sequence[1]/element[1][@.name =
> 'nomecampo']/simpleType[1]/restriction[1] Type
> '{http://schemas.microsoft.com/sqlserver/2004/sqltypes}varchar' is
> either not declared or not a simpleType.
> i use a XMLSCHEMA option to generate a xsd and xml file
> Anybody can help me?
> Thanks!!
>

error executing assemblie

hellow i execute assemblie in sql server, assemblie opens up file and writes some information, when i run that esemblie i get the follwing message

An error occured: Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

thanks for any ideas

i found solution myself

solution is tu make your assemblie to have external access, but now other error occured when the assemblie is trying to write to file

An error occured: Access to the path 'C:\log.txt' is denied.

(1 row(s) affected)

|||When SQL Server executes something that goes outside of SQL (i.e file access), it does that under the security context of the account SQL runs under. It might be that, that account does not have sufficient permissions for that file.

If that's the case you can (if the original caller uses integrated security) do a impersonation, by using SqlContext.WindowsIdentity.

Niels

error during quiet installation of June CTP.

I am trying quiet installation of June CTP with the .ini file .

The installation is failing with Last Action :Install Finalize:
The sql server service failed to start.
Error number:29523
--
My ini file settings were as folllows
[snip]
SQLBROWSERACCOUNT= "NT AUTHORITY\LOCAL SERVICE"
SQLBROWSERPASSWORD=

SQLACCOUNT="NT AUTHORITY\LOCAL SERVICE"
SQLPASSWORD=

AGTACCOUNT="NT AUTHORITY\LOCAL SERVICE"
AGTPASSWORD=

ASACCOUNT=
ASPASSWORD=

RSACCOUNT=
RSPASSWORD=
[snip]
-
As mentioned in one of the mails in the group i changed the three accounts to
"NT AUTHORITY\LOCAL SYSTEM".

Now i get new errors as follows
Last Action : Validate_ServiceAccounts
Error String : SQL Server Setup was unable to validate the account or accounts you provided. To continue, verify that the user name, password, and domain name are correct, or provide another user account for SQL Server service login.
The logon account cannot be validated for the service SQL Browser.
Error Number : 29609
--

One observation is that the installation goes fine with <domain\user> and providing the password . But in my case i will have to ship the ini file with the product and dont the the settings on the customer system.
So i cannot use domain user.

Try removing the unused parameters (e.g. SQLBROWSERPASSWORD=, ASACCOUNT=, etc). When using a built-in account the password parameter is not necessary. Also, if you're installing on a localized OS (e.g. German or French) you need to pass the localized version of the built-in account. For example, Local System on a German OS is: NT-AUTORIT?T\SYSTEM

You can find the complete list in the setup help file, setupsql9.chm, under the topic Setting Up Windows Service Accounts.

If you still get errors please post your entire .ini file here.

Dan|||

Hello Dan,

Thanks for your reply.

I have made changes as per your suggestions , but still getting the validation error.

Last Action : Validate_ServiceAccounts
Error String : SQL Server Setup was unable to validate the account or accounts you provided. To continue, verify that the user name, password, and domain name are correct, or provide another user account for SQL Server service login.
The logon account cannot be validated for the service SQL Browser.
Error Number : 29609

Here is the test.ini file.

-
[Options]
;--
; If USERNAME or COMPANYNAME are not specified, the default operating system username and company name values for the server are used.
; Note: If names contain spaces, surround the names with quotes.

USERNAME=test
COMPANYNAME=test
;--
; Usage: PIDKEY=ABCDE12345FGHIJ67890KLMNO (This is not an actual key value.)

; NOTE: For the SQL Server 2005 CTP releases, the following PIDKEY command is not required
; because the PIDKEY parameter for the MSI file is preset. However, the final released version
; of SQL Server 2005 will require the PIDKEY parameter.
; NOTE: PIDKEY is not required for SQL Server Express Edition.
; NOTE: Do not include "-" in the PIDKEY.

;PIDKEY=
;--
; INSTALLSQLDIR specifies the location for the instance specific binary files.
; Default location is: %ProgramFiles%\Microsoft SQL Server\
; To use the default path, do not specify the following parameter.

; NOTE: INSTALLSQLDIR is REQUIRED for clustered installations and must point to a local
; drive for which the drive letter exists on all nodes in the cluster definition.
; NOTE: If there is a space in a specified path, surround the path with quotes
; and end every path with a '\'.

INSTALLSQLDIR="C:\Program Files\Microsoft SQL Server\"
;--
; INSTALLSQLSHAREDDIR specifies a custom location for Integration Services
; Notification Services, Client Components, SQL Server Books Online and Samples.
; To use the default path, do not specify the following parameter. Default path is %ProgramFiles%\Microsoft SQL Server\

; If Tools components are already installed on the computer, this parameter is ignored.
; NOTE: If there is a space in a specified path, surround the path with quotes
; and end every path with a '\'.

; The installation paths will be:
;<InstallDir>\90\DTS
;<InstallDir>\90\Notification
;<InstallDir>\90\Tools

INSTALLSQLSHAREDDIR=
;--
; INSTALLSQLDATADIR specifies the location for the SQL Server data files.
; Default: INSTALLSQLDIR\Data\
; To use the default path, do not specify the following parameter.

; NOTE: INSTALLSQLDATADIR is REQUIRED for clustered installations and must point to a
; shared drive which is a member of the cluster group specified for installation.
; NOTE: If there is a space in a specified path, surround the path with quotes
; and end every path with a '\'.

INSTALLSQLDATADIR=
;--
; INSTALLASDATADIR specifies the location for the Analysis Server Data Files.
; Default: INSTALLSQLDIR\Data\
; If Analysis Server is already installed on the computer, this parameter is ignored.
; To use the default path, do not specify the following parameter.

; NOTE: Do not use with a SQL Server Express installation.
; NOTE: If there is a space in a specified path, surround the path with quotes
; and end every path with a '\'.

INSTALLASDATADIR=
;--
; ADDLOCAL specifies which components to install. If ADDLOCAL is not
; specified, setup will fail.
; See SQL Server Books Online for more information on this topic.

ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_Replication,SQL_FullText,Client_Components,Connectivity,SQL_Tools90,SQL_Profiler90,SQLXML,SQL_Documentation,SQL_BooksOnline,SQL_SQLServerBooksOnline

INSTANCENAME=MSSQLSERVER
;--
; The UPGRADE property specifies which product to upgrade.
; The allowed values are SQL_Engine, RS_Server and AS_Server.
; If the UPGRADE option is specified, the INSTANCENAME parameter
; is REQUIRED to define which instance to upgrade.

;--
; The services for SQL Server and Analysis Server are set auto start. To use the *ACCOUNT settings
; make sure to specify the DOMAIN, e.g. SQLACCOUNT=DOMAINNAME\ACCOUNT
; NOTE: When installing SQL_Engine 3 accounts are REQUIRED: SQLACCOUNT, AGTACCOUNT and SQLBROWSERACCOUNT.
; SQLACCOUNT Examples:
; SQLACCOUNT=<domain\user>
; SQLACCOUNT="NT AUTHORITY\SYSTEM"
; SQLACCOUNT="NT AUTHORITY\NETWORK SERVICE"
; SQLACCOUNT="NT AUTHORITY\LOCAL SERVICE"

;Note that if SQLBrowser is already installed, SQLBROWSERACCOUNT and SQLBROWSERPASSWORD are ignored.
SQLBROWSERACCOUNT= "NT AUTHORITY\LOCAL SYSTEM"
;SQLBROWSERPASSWORD=

SQLACCOUNT="NT AUTHORITY\LOCAL SYSTEM"
;SQLPASSWORD=

AGTACCOUNT="NT AUTHORITY\LOCAL SYSTEM"
;AGTPASSWORD=

;ASACCOUNT=
;ASPASSWORD=

;RSACCOUNT=
;RSPASSWORD=
;--
; To use the *AUTOSTART features, specify 1 to start automatically or 0 to start manually.
; NOTE: If you decide to start SQL Agent automatically, then SQL is also started automatically.
; If *AUTOSTART is not specified on the command line, startup is set to manual.

SQLBROWSERAUTOSTART=1
SQLAUTOSTART=1
AGTAUTOSTART=1
ASAUTOSTART=0
RSAUTOSTART=0
;--
; To use Mixed mode authentication, use SECURITYMODE=SQL.
; If SECURITYMODE=SQL is not specified, then Windows Authentication only will be used by default.
; If you use SQL Authentication, you are REQUIRED to provide a strong system administrator (SA) password.
; If you use Windows Authentication, the SA account will be disabled.
; To set SA password specify SAPWD.

SECURITYMODE=SQL
SAPWD=Ericsson
;--
; SQLCOLLATION specifies the collation for Database Services.
; ASCOLLATION specifies the collation for Analysis Server.
; See SQL Server Books Online for more information on collation options.

SQLCOLLATION=SQL_Latin1_General_Cp1_CS_AS
ASCOLLATION=SQL_Latin1_General_Cp1_CS_AS
;--

I am not able to figure out what is wrong with this file.
However as specified in the setupsql9.chm file i am successfully installing from
command line using

Start /wait <DVD Drive>\setup.exe /qn INSTANCENAME=<InstanceName> ADDLOCAL=SQL_Engine,SQL_Replication SAPWD=<StrongPassword>

Here nothing is specified about the service accounts . It seems specifying them
i am gettting into trouble.

Regards
Ray

|||

I have tried removing all the accounts related information from the inin file . Then installation fails with

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_DNASERVER3_SQL.log
Last Action : SetUnattendedSvcAccountProp
Error String : SQL Server Setup has determined that the following account properties are not specified: 'SQLBROWSERACCOUNT, AGTACCOUNT, SQLACCOUNT' . The properties specify the startup account for the services that are installed. To proceed, refer to the template.ini and set the properties to valid account names. If you are specifying a windows user account, you must also specify the password for the account.
Error Number : 28006

Ray

|||

Well the ini file should be like this ..
[snip]
SQLACCOUNT="NT AUTHORITY\SYSTEM"
;SQLPASSWORD=

AGTACCOUNT="NT AUTHORITY\SYSTEM"
;AGTPASSWORD=

SQLBROWSERACCOUNT= "NT AUTHORITY\SYSTEM"
;SQLBROWSERPASSWORD=

;ASACCOUNT=
;ASPASSWORD=

;RSACCOUNT=
;RSPASSWORD=
[snip]

I had put "NT AUTHORITY\LOCAL SYSTEM" instead.. A very painful oversight.

However there is a new problem . On 2003 server installation goes on just fine
but on 2000 server it fails with ->[Microsoft][SQL Native Client]Encryption not supported on the client. Refer to the blah blah blah.

On 2003 i have cryptography sercices running ...
Has neone faced this problem before

|||

Well the ini file should be like this ..
[snip]
SQLACCOUNT="NT AUTHORITY\SYSTEM"
;SQLPASSWORD=

AGTACCOUNT="NT AUTHORITY\SYSTEM"
;AGTPASSWORD=

SQLBROWSERACCOUNT= "NT AUTHORITY\SYSTEM"
;SQLBROWSERPASSWORD=

;ASACCOUNT=
;ASPASSWORD=

;RSACCOUNT=
;RSPASSWORD=
[snip]

I had put "NT AUTHORITY\LOCAL SYSTEM" instead.. A very painful oversight.

However there is a new problem . On 2003 server installation goes on just fine
but on 2000 server it fails with ->[Microsoft][SQL Native Client]Encryption not supported on the client. Refer to the blah blah blah.

On 2003 i have cryptography sercices running ...
Has neone faced this problem before?

Ray

Error during Loading Data form a falt file into DB2 database??

Hi,

I have a problem loading data from a flat file into a DB2 Dtabase by using the OLE DB Provider for DB2.

I read the data from a flat file in the unicode format and as soon as the data is to be written in the DB2 database the following error occurs and the loading process is aborted:

Information: 0x402090DE at Data Flow Task, Flat File Source [813]: The total number of data rows processed for file "C:\Dokumente und Einstellungen\Administrator\Desktop\SSIS1.txt" is 2.
Error: 0xC0202009 at Data Flow Task, OLE DB Destination [842]: An OLE DB error has occurred. Error code: 0x80040E53.
Error: 0xC0047022 at Data Flow Task, DTS.Pipeline: The ProcessInput method on component "OLE DB Destination" (842) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0202009.
Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning.......

......Warning: 0x80019002 at Package: The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "Package 1.dtsx" finished: Failure.

I dont know waht those error codes meanand I tried so many things already. The tables in the database are created correctly and also, SSIS can read the data from the database if I use the preview function, but somehow, the program never starts to write data into the database for some reason. Can anyone help me?

Thx, andy

It looks like some other have had similar problems using the OLE DB Source with DB2.

One user fixed the problem but using a DataReader source and an ODBC connection to DB2 (see this post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=250370&SiteID=1)

Another user seems to have fixed it by restarting the Distributed Transaction Coordinator service although he was using beta 2 of SQL Server. See here: http://www.ureader.com/message/287061.aspx

Hope this helps.

Jason|||Hi,

I'm Facing almost similar kind of problem.
Got to load data to DB2 data base taken from AS400.

I'm using dataReader ( ADO .Net connection (ODBC connection did not work, its a work around to fetch data)) to fetch data from AS400 Server and trying to load it to a DB2 datbase ( OLEDB conection manager - using IBM OLEDB provider for DB2)

>> Is there a compatibility issue with DataReader Source and OLEDB destination ?
>> Any other alternative in that case?

PLZ help !!!!!!!!!!

Here is the ERROR Message i get on execution:

Error: 0xC0202009 at Data Reader to DB2, OLE DB Destination [12]: An OLE DB error has occurred. Error code: 0x80040E53.

Error: 0xC0047022 at Data Reader to DB2, DTS.Pipeline: The ProcessInput method on component "OLE DB Destination" (12) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.

Error: 0xC0047021 at Data Reader to DB2, DTS.Pipeline: Thread "WorkThread0" has exited with error code 0xC0202009.

Information: 0x4004300B at Data Reader to DB2, DTS.Pipeline: "component "OLE DB Destination" (12)" wrote 0 rows.

Task failed: Data Reader to DB2

SSIS package "Package.dtsx" finished: Success.

sql

error during installing SP3

Hi
I've got following error during installing SP3
by running this file Sql2kasp3.exe after successfully
installation sql 2ksp3.exe,
(SQL server 2000,server station)
"an error occurred during move data process : -145"
Thanks for any reply
--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/Are you running analysis services?
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"RM" <m_r1824@.yahoo.co.uk> wrote in message
news:opr1kakxwshqligo@.msnews.microsoft.com...
> Hi
> I've got following error during installing SP3
> by running this file Sql2kasp3.exe after successfully
> installation sql 2ksp3.exe,
> (SQL server 2000,server station)
> "an error occurred during move data process : -145"
> Thanks for any reply
> --
> Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/sql

error during installing SP3

Hi
I've got following error during installing SP3
by running this file Sql2kasp3.exe after successfully
installation sql 2ksp3.exe,
(SQL server 2000,server station)
"an error occurred during move data process : -145"
Thanks for any reply
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/Are you running analysis services?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"RM" <m_r1824@.yahoo.co.uk> wrote in message
news:opr1kakxwshqligo@.msnews.microsoft.com...

quote:

---

> Hi
> I've got following error during installing SP3
> by running this file Sql2kasp3.exe after successfully
> installation sql 2ksp3.exe,
> (SQL server 2000,server station)
> "an error occurred during move data process : -145"
> Thanks for any reply
> --
> Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

---

Error during backup verify

SQL Server 2000.
Doing an SQL backup to a network shared drive on our file server.
Any help appreciated ...
During the verify on several different databases, I find the following
error in the Maintenance Plan log:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3203:
[Microsoft][ODBC SQL Server Driver][SQL Server]Read on
'\\Pfcdata\SQLBackup\PFCSQLT\pfcgold_db_200402102300.BAK' failed,
status = 64. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
terminating abnormally.
I get the following info from the SQL Server Error Log:
BackupMedium::ReportIoError: read failure on backup device
'\\Pfcdata\SQLBackup\PFCSQLT\pfcgold_db_200402162359.BAK'. Operating
system error 64(The specified network name is no longer available.).That is a common NT error. Could you test the network connections by copying
large files between the servers. Also have you checked the NT eventlogs on
the file server to see if you have any messages releated to network
problems.
Simon
This posting is provided "as is" with no warranties and confers no rights.
"SoCal Snapper" <snapperjackson@.juno.com> wrote in message
news:2d4f003f.0402251113.6c36d43d@.posting.google.com...
> SQL Server 2000.
> Doing an SQL backup to a network shared drive on our file server.
> Any help appreciated ...
> During the verify on several different databases, I find the following
> error in the Maintenance Plan log:
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3203:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Read on
> '\\Pfcdata\SQLBackup\PFCSQLT\pfcgold_db_200402102300.BAK' failed,
> status = 64. See the SQL Server error log for more details.
> [Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
> terminating abnormally.
> I get the following info from the SQL Server Error Log:
> BackupMedium::ReportIoError: read failure on backup device
> '\\Pfcdata\SQLBackup\PFCSQLT\pfcgold_db_200402162359.BAK'. Operating
> system error 64(The specified network name is no longer available.).

Error during backup verify

SQL Server 2000.
Doing an SQL backup to a network shared drive on our file server.
Any help appreciated ...
During the verify on several different databases, I find the following
error in the Maintenance Plan log:
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3203:
[Microsoft][ODBC SQL Server Driver][SQL Server]Read on
'\\Pfcdata\SQLBackup\PFCSQLT\pfcgold_db_
200402102300.BAK' failed,
status = 64. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE i
s
terminating abnormally.
I get the following info from the SQL Server Error Log:
BackupMedium::ReportIoError: read failure on backup device
'\\Pfcdata\SQLBackup\PFCSQLT\pfcgold_db_
200402162359.BAK'. Operating
system error 64(The specified network name is no longer available.).That is a common NT error. Could you test the network connections by copying
large files between the servers. Also have you checked the NT eventlogs on
the file server to see if you have any messages releated to network
problems.
Simon
This posting is provided "as is" with no warranties and confers no rights.
"SoCal Snapper" <snapperjackson@.juno.com> wrote in message
news:2d4f003f.0402251113.6c36d43d@.posting.google.com...
> SQL Server 2000.
> Doing an SQL backup to a network shared drive on our file server.
> Any help appreciated ...
> During the verify on several different databases, I find the following
> error in the Maintenance Plan log:
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3203:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Read on
> '\\Pfcdata\SQLBackup\PFCSQLT\pfcgold_db_
200402102300.BAK' failed,
> status = 64. See the SQL Server error log for more details.
> [Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE
is
> terminating abnormally.
> I get the following info from the SQL Server Error Log:
> BackupMedium::ReportIoError: read failure on backup device
> '\\Pfcdata\SQLBackup\PFCSQLT\pfcgold_db_
200402162359.BAK'. Operating
> system error 64(The specified network name is no longer available.).sql

error dump file

Hi,
Our production server had frozen suddenly (it was working=20
for years without any issues), and I noticed sql server=20
error dump file afterwards(see below). I think that=20
process SPID 60 caused the problem, but I'm not sure how=20
to find out what was SPID before the "accident". Is=20
it "SELECT" statement which can be seen in the first part=20
of dump file?
SqlDumpExceptionHandler: Process 60 generated fatal=20
exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server=20
is terminating this process..
*=20
************************************************** ********
*********************
*
* BEGIN STACK DUMP:
* 09/01/04 06:37:00 spid 60
*
* Exception Address =3D 004766C1 (CMemManager::ReleaseOS=20
+ 0000003A Line 0+00000000)
* Exception Code =3D c0000005=20
EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000008
* s p _ e x e c u 0d 00 73 00 70 00 5f 00 65 00 78 00=20
65 00 63 00 75 00
* t e s q l =E7 74 00 65 00 73 00 71 00 6c 00 02=20
00 00 00 e7 a2 13 09
* 4 S E L E C T 04 d0 00 34 a2 13 53 00 45 00 4c 00=20
45 00 43 00 54 00
* T i c k e r , P 20 00 54 00 69 00 63 00 6b 00 65 00=20
72 00 2c 00 50 00
******* list of columns in the statement follows *****
Thanks in advance,
Baki
Generally yes. For AV's you should really contact PSS to help you diagnose
the issue.
http://support.microsoft.com/default...s;Prodoffer41a
You'll get your money back if it's a bug (and AV's generally are)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Baki" <anonymous@.discussions.microsoft.com> wrote in message
news:0aaa01c490f1$4402d190$a401280a@.phx.gbl...
Hi,
Our production server had frozen suddenly (it was working
for years without any issues), and I noticed sql server
error dump file afterwards(see below). I think that
process SPID 60 caused the problem, but I'm not sure how
to find out what was SPID before the "accident". Is
it "SELECT" statement which can be seen in the first part
of dump file?
SqlDumpExceptionHandler: Process 60 generated fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
is terminating this process..
*
************************************************** ********
*********************
*
* BEGIN STACK DUMP:
* 09/01/04 06:37:00 spid 60
*
* Exception Address = 004766C1 (CMemManager::ReleaseOS
+ 0000003A Line 0+00000000)
* Exception Code = c0000005
EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000008
* s p _ e x e c u 0d 00 73 00 70 00 5f 00 65 00 78 00
65 00 63 00 75 00
* t e s q l 74 00 65 00 73 00 71 00 6c 00 02
00 00 00 e7 a2 13 09
* 4 S E L E C T 04 d0 00 34 a2 13 53 00 45 00 4c 00
45 00 43 00 54 00
* T i c k e r , P 20 00 54 00 69 00 63 00 6b 00 65 00
72 00 2c 00 50 00
******* list of columns in the statement follows *****
Thanks in advance,
Baki

error dump file

Hi,
Our production server had frozen suddenly (it was working for years without any issues), and I noticed sql server error dump file afterwards(see below). I think that process SPID 60 caused the problem, but I'm not sure how to find out what was SPID before the "accident". Is it "SELECT" statement which can be seen in the first part of dump file?
SqlDumpExceptionHandler: Process 60 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
* **********************************************************
*********************
*
* BEGIN STACK DUMP:
* 09/01/04 06:37:00 spid 60
*
* Exception Address =3D 004766C1 (CMemManager::ReleaseOS + 0000003A Line 0+00000000)
* Exception Code =3D c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000008
* s p _ e x e c u 0d 00 73 00 70 00 5f 00 65 00 78 00 65 00 63 00 75 00
* t e s q l =E7 74 00 65 00 73 00 71 00 6c 00 02 00 00 00 e7 a2 13 09
* 4 S E L E C T 04 d0 00 34 a2 13 53 00 45 00 4c 00 45 00 43 00 54 00
* T i c k e r , P 20 00 54 00 69 00 63 00 6b 00 65 00 72 00 2c 00 50 00
******* list of columns in the statement follows *****
Thanks in advance,
BakiGenerally yes. For AV's you should really contact PSS to help you diagnose
the issue.
http://support.microsoft.com/default.aspx?scid=fh;en-us;Prodoffer41a
You'll get your money back if it's a bug (and AV's generally are)
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Baki" <anonymous@.discussions.microsoft.com> wrote in message
news:0aaa01c490f1$4402d190$a401280a@.phx.gbl...
Hi,
Our production server had frozen suddenly (it was working
for years without any issues), and I noticed sql server
error dump file afterwards(see below). I think that
process SPID 60 caused the problem, but I'm not sure how
to find out what was SPID before the "accident". Is
it "SELECT" statement which can be seen in the first part
of dump file?
SqlDumpExceptionHandler: Process 60 generated fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
is terminating this process..
*
**********************************************************
*********************
*
* BEGIN STACK DUMP:
* 09/01/04 06:37:00 spid 60
*
* Exception Address = 004766C1 (CMemManager::ReleaseOS
+ 0000003A Line 0+00000000)
* Exception Code = c0000005
EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000008
* s p _ e x e c u 0d 00 73 00 70 00 5f 00 65 00 78 00
65 00 63 00 75 00
* t e s q l ç 74 00 65 00 73 00 71 00 6c 00 02
00 00 00 e7 a2 13 09
* 4 S E L E C T 04 d0 00 34 a2 13 53 00 45 00 4c 00
45 00 43 00 54 00
* T i c k e r , P 20 00 54 00 69 00 63 00 6b 00 65 00
72 00 2c 00 50 00
******* list of columns in the statement follows *****
Thanks in advance,
Baki

error dump file

Hi,
Our production server had frozen suddenly (it was working=20
for years without any issues), and I noticed sql server=20
error dump file afterwards(see below). I think that=20
process SPID 60 caused the problem, but I'm not sure how=20
to find out what was SPID before the "accident". Is=20
it "SELECT" statement which can be seen in the first part=20
of dump file?
SqlDumpExceptionHandler: Process 60 generated fatal=20
exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server=20
is terminating this process..
*=20
****************************************
******************
*********************
*
* BEGIN STACK DUMP:
* 09/01/04 06:37:00 spid 60
*
* Exception Address =3D 004766C1 (CMemManager::ReleaseOS=20
+ 0000003A Line 0+00000000)
* Exception Code =3D c0000005=20
EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000008
* s p _ e x e c u 0d 00 73 00 70 00 5f 00 65 00 78 00=20
65 00 63 00 75 00
* t e s q l =E7 74 00 65 00 73 00 71 00 6c 00 02=20
00 00 00 e7 a2 13 09
* 4 S E L E C T 04 d0 00 34 a2 13 53 00 45 00 4c 00=20
45 00 43 00 54 00
* T i c k e r , P 20 00 54 00 69 00 63 00 6b 00 65 00=20
72 00 2c 00 50 00
******* list of columns in the statement follows *****
Thanks in advance,
BakiGenerally yes. For AV's you should really contact PSS to help you diagnose
the issue.
http://support.microsoft.com/defaul...us;Prodoffer41a
You'll get your money back if it's a bug (and AV's generally are)
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Baki" <anonymous@.discussions.microsoft.com> wrote in message
news:0aaa01c490f1$4402d190$a401280a@.phx.gbl...
Hi,
Our production server had frozen suddenly (it was working
for years without any issues), and I noticed sql server
error dump file afterwards(see below). I think that
process SPID 60 caused the problem, but I'm not sure how
to find out what was SPID before the "accident". Is
it "SELECT" statement which can be seen in the first part
of dump file?
SqlDumpExceptionHandler: Process 60 generated fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
is terminating this process..
*
****************************************
******************
*********************
*
* BEGIN STACK DUMP:
* 09/01/04 06:37:00 spid 60
*
* Exception Address = 004766C1 (CMemManager::ReleaseOS
+ 0000003A Line 0+00000000)
* Exception Code = c0000005
EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000008
* s p _ e x e c u 0d 00 73 00 70 00 5f 00 65 00 78 00
65 00 63 00 75 00
* t e s q l 74 00 65 00 73 00 71 00 6c 00 02
00 00 00 e7 a2 13 09
* 4 S E L E C T 04 d0 00 34 a2 13 53 00 45 00 4c 00
45 00 43 00 54 00
* T i c k e r , P 20 00 54 00 69 00 63 00 6b 00 65 00
72 00 2c 00 50 00
******* list of columns in the statement follows *****
Thanks in advance,
Baki

Error Deploying Report

I'm getting a strange error when deploying a report:
Server was unable to process request. --> Could not find file "C:
\WINDOWS\TEMP\7qifavw2.dll".
The strange part is that the dll file name changes each time i try to
deploy. The deploy function was working when I left last night, and
not working first thing this morning. Any idea what's happening here?ugh
I rebooted and it started working again. Strange thing though. I was
trying this from my pc, as well as from the server itself, and got the
same error. Rebooting my pc did not help, but rebooting the server
did. Oh well, now if I had only rebooted a couple hours sooner :-(|||The reason the name of the DLL changes is that this is the compiled result
of some ASP.NET code. I'm surprised that the location is C:\WINDOWS\TEMP --
are you sure? -- but I would expect that location to be different on
different machines and in different OS.
This can happen when something on a site changes and ASP.NET tries to
refresh its compiled code but something interferes with the whole thing
happening correctly. Sometimes it may be a user session that is open and
"pointed" to a particular page on the site.
What I usually do is stop the application in question and clear out *all*
the compiled code for it, so that when the application starts up again
ASP.NET recompiles everything from scratch. I can't be more specific than
that because I really don't know why you would be getting this when
"deploying a report". Which action, exactly, invokes the error on your PC?
>L<
<c-eric.geil@.mci.com> wrote in message
news:1176998968.836336.124600@.e65g2000hsc.googlegroups.com...
> I'm getting a strange error when deploying a report:
> Server was unable to process request. --> Could not find file "C:
> \WINDOWS\TEMP\7qifavw2.dll".
> The strange part is that the dll file name changes each time i try to
> deploy. The deploy function was working when I left last night, and
> not working first thing this morning. Any idea what's happening here?
>

Error Deleteing Remote File

I am trying to delete a remote file as part of an SSIS package. The FTP Task I have to retrieve the file works fine. I use the same remote path variable and connection manager for both tasks. However, when the delete step executes I receive the error:

Error: 0xC002918E at FTP Task, FTP Task: Unable to delete remote files using "FTP Connection Manager 1".

Sounds like a permission issue.|||This is a known problem with the FTP task in SSIS trying to delete a file on a non-Windows FTP servers.

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

I do not know if SP2 fixes this problem or not.
|||I can delete the files from the FTP command line. I have a DTS package that uses a .bat file to do this, I just want to put it into SSIS. Thanks for the info.|||Is there a way to tell if the server is not Windows?|||HAs this issue been aknowledge by Microsoft? [Microsoft follow-up]|||

I don't understand your question. Your the closest thing to Microsoft that I have seen involved in any discussion in this area, anywhere I've looked.

Tim

|||Yes, it is still an active bug report, reported over 1 year ago.

See: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126207
|||No, you would have to know ahead of time what kind of server you are talking too.

However, there is a workaround on the thread I gave in the previous message. Basically, don't use the FTP task, use a script task and code it by hand.

|||We are aware of this bug and it will be fixed in the coming major release. Please contact CSS if you need a hotifx. Thanks

Error creating linked server to Excel

Hi,
Please help, I'm getting desperate. Any ideas warmly welcomed!
I'm trying to read from a basic excel file (1000 or so rows from
column A) but am having problems. The code I am using is:

Declare @.Return Int
SET NOCOUNT ON

Exec @.Return= [master]..[sp_addlinkedServer] 'READ_XLS', 'EXCEL',
'Microsoft.Jet.OleDB.4.0' , 'e:\jsbackup\RACodes.xls',
NULL, 'EXCEL 8.0'
print 'set up Return : ' + convert(varchar(10),@.Return)
--NB E: is the drive as seen oon the server

EXEC sp_addlinkedsrvlogin
@.rmtsrvname = 'READ_XLS',
@.useself = 'true'
print 'login Return : ' + convert(varchar(10),@.Return)

When I try to read from the (one) excel sheet in the file, via
Select * from [READ_XLS]...RACodes$
or to list what tables/sheets are available, via
exec sp_tables_ex 'READ_XLS'

I get the following error:

OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
Authentication failed.
[OLE/DB provider returned message: Cannot start your application. The
workgroup information file is missing or opened exclusively by another
user.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80040e4d: Authentication
failed.].

What am I missing?

*Many* thanks in advance.
AndyA few things to check:

Do you have the .xls file already open?
Is e:\jsbackup\RACodes.xls a server path?
I recall that you have to set named ranges for it to appear as tables
in Excel.

I don't know whether it helps but I have written an addin for Excel
that can push the data out from Excel (you are trying to pull it in
from the database). If you can reconsider your design and push it from
Excel you can perhaps use it.

SQL*XL is an addin for Excel that let you manage your database from
Excel. It is an end-user tool but it also lets you record all actions
as a macro (VBA) and therefore you can code/script applications with
it.

Have a look at SQL*XL at www.oraxcel.com

Best regards, Gerrit-Jan Linker
Linker IT Consulting Limited
www.oraxcel.com

error connecting to sql 2k from an app

Hi,
I rec'd this error.
open dbtables error: General error: Unable to write to file buffer dbtest.
when I connect to a sql 2k db from an test app.
Any ideas?
thanksCan you show the code that is trying to connect? This doesn't look like a
SQL Server error as far as I can tell.
"mecn" <mecn2002@.yahoo.com> wrote in message
news:OMglZPIPGHA.1676@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I rec'd this error.
> open dbtables error: General error: Unable to write to file buffer dbtest.
> when I connect to a sql 2k db from an test app.
> Any ideas?
> thanks
>|||I don't really have the source code.
I think the same as you--windows' problem.
Everytime the app runs it generated a temp file > 2GB.
I have no idea why the temp file gets generated when the app sends a query
statment.
That is the problem
Thanks,
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uwrjxcIPGHA.344@.TK2MSFTNGP11.phx.gbl...
> Can you show the code that is trying to connect? This doesn't look like a
> SQL Server error as far as I can tell.
>
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:OMglZPIPGHA.1676@.TK2MSFTNGP09.phx.gbl...
>

Error connecting to SQL 2000 db "The entry MCLConnectionString has already been added"

When I try to run my application using VWD from the file system I can connect and run the application and it connects to the remote SQL 2000 server with no problem.

However, when I publish to my web server I get the folloiwng error message:

Anyone got any ideas??

Configuration Error

Description:An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message:The entry 'MCLConnectionString' has already been added.

Source Error:

Line 11: <appSettings/>Line 12: <connectionStrings>Line 13: <add name="MCLConnectionString" connectionString="Data Source=GEACO1INTR1;Initial Catalog=MCL;Persist Security Info=True;User ID=ASPNET;Password=PAUL0001" providerName="System.Data.SqlClient"/>Line 14: </connectionStrings>Line 15: <system.web>

Source File:c:\inetpub\wwwroot\mcltest\web.config Line:13

I also notice that it works if I put the connection string in each form, but as soon as I try to add it to the web.config file I get the above error.

Thanks

Paul

|||

My guess is that you have a ConnectionString with the same name on a Parent Web Application, my advise would be either to change the name of the ConnectionString, or do this:

<connectionString>
<clear/>
<add name="MCLConnectionString" connectionString="..." />
</connectionStrings
Hope this Helps,

Roberto Hernandez-Pou
http://www.rhpconsulting.net

IMPORTANT: If you use the <clear/> to clean all connectionString keys, you would also be removing the ones for the SqlAuthenticationProvider and SqlRoleProvider.

|||

To add onto Roberto's reply...

If the MCLConnectionString does already exist higher in the configuration hierarchy, you don't have to add it again to use at this level. Remove it at this level's web.config and read the connection string as normal, and the configuration API will pick it up.

Don

|||

Thanks, that sorted it. I had a copy of the web.config file left in the root directory of the web server.

Thanks again for your help

Paul

Error connecting to Oracle 9i Database using SQL Linked Server : MSDAORA Error

Hi,

I have setup a linked server that intermittently crashes.

It connects to an Oracle Database on an alternate server. My tnsnames.ora file is correct and the Linked server does periodically work....

I am not sure what triggers it but it crashes and gives the following error:

Error 7399: OLE DB provider 'MSDAORA' reported an error. The provider did not give any information about the error.

OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.].

Can anyone help with this please ?

Which is the correct configuration in terms of drivers to use and vendor. Are there any registry settings that need changing?

Thanks,

Simon.

Hi Simon,
have you tried the ORACLE's OLE DB provider? For Oracle version later than 8, it's recommended that you try Oracle's own OLE DB provider.

Thanks.

Error connecting to Oracle 9i Database using SQL Linked Server : MSDAORA Error

Hi,

I have setup a linked server that intermittently crashes.

It connects to an Oracle Database on an alternate server. My tnsnames.ora file is correct and the Linked server does periodically work....

I am not sure what triggers it but it crashes and gives the following error:

Error 7399: OLE DB provider 'MSDAORA' reported an error. The provider did not give any information about the error.

OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.].

Can anyone help with this please ?

Which is the correct configuration in terms of drivers to use and vendor. Are there any registry settings that need changing?

Thanks,

Simon.

Hi Simon,
have you tried the ORACLE's OLE DB provider? For Oracle version later than 8, it's recommended that you try Oracle's own OLE DB provider.

Thanks.

Error connecting to .sdf database

Dear All,

I am trying to connect to a .sdf database. I am building a console application. First I got an error "Could not load file or assembly 'System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)". Then I manage to solve "Unable to load DLL 'sqlceme30.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)". So wat is the possible error on my side ?

Is it not amazing. I have been searching the forums for a solution to this specific problem for weeks now and everyone that answers has no idea what it is we are requesting. you get redirected to a thousand other sites that still can not answer this question. I dont think anyone knows how to solve this!

|||

Which version of the product are you using?

Checking the basics first: Is the product installed on your machine ( check in Add and remove programs).Also check that the System.Data.SqlServerCe.dll is in GAC (C:\windows\assembly).

If your installation was correct, then sqlceme30.dll (and other dlls) should be loaded automatically using some registry settings.

Btw, did you try reinstalling the runtime package on your machine?