Category: XML

11 Apr 2014 00:07

Joined:	03/05/2013
Level:	Gold
Points:	15822

Points:	4

Error : http://schemas.microsoft.com/sqlserver/2004/sqltypes:int

Are you looking for a way to resolve error http://schemas.microsoft.com/sqlserver/2004/sqltypes:int ? then read this thread to know how to resolve it

Hi Everybody,

When i try to validate my xml file with schema i got this below error message. Can any one please tell me how to resolve this error. I google it, but no use.

This is the error message

Type 'http://schemas.microsoft.com/sqlserver/2004/sqltypes:int' is not declared

As of my understanding integer type is not declared, but my question is where we need to declare that.?

I'm awaiting for your feedback..

Regards,
Naveen

#743860

11 Apr 2014 00:24

Joined:	28/04/2006
Level:	Gold
Points:	29773

Points:	4

Hai Naveen,
It seems that the issue is in mapping between the XML Schema type and the SQL Schema types and due to that you are getting this error message.
All the schema types which you are using in your XSD document to validate the XML should be validated with the SQL Server table schema definition.
So you need to check in your SQL Schema whether you have the correct and validate type in the fields.
Check the below link for reference.
http://schemas.microsoft.com/sqlserver/2004/sqltypes/
Hope it will be helpful to you.

Regards,
Pawan Awasthi(DNS MVM)
+91 8123489140 (whatsApp), +60 14365 1476(Malaysia)
pawansoftit@gmail.com

#743861

11 Apr 2014 00:24

Joined:	13/06/2007
Level:	Gold
Points:	21327

Points:	2

Hi naveen
Are you looking to execute some sql statement here ? When you got this error ? when internet connection is ON on your server, is same error throw up ? cause the schema path in your error is from sql site only and when you switch ON internet on your machine the error will fly away.
I think you need to use some local schema location rather than 'http' web location.
checkout for following link for more detail
http://stackoverflow.com/questions/9514915/local-schemalocation

Thanks
Koolprasd2003
Editor, DotNetSpider MVM
Microsoft MVP 2014 [ASP.NET/IIS]

#743871

11 Apr 2014 00:46

Joined:	28/06/2007
Level:	Diamond
Points:	56294

Points:	1

Its the issue with the schema you are using for validating your XML. Best option is to make use of standard schema validation. Use the standard one.

Thanks & Regards
Anil Kumar Pandey
Microsoft MVP, DNS MVM

#743872

11 Apr 2014 00:47

Joined:	03/05/2013
Level:	Gold
Points:	15822

Points:	1

Hi Prasad,

Actually my user gave me one Schema file as well as one xml file. I just convert my xml file as same like schema using XSLT. After that i need to validate the new xml file with schema at that time i got this error message.

--------------------------------------------------------------------------------
Give respect to your work, Instead of trying to impress your boss.

N@veen
Blog : http://naveens-dotnet.blogspot.in/

Error : http://schemas.microsoft.com/sqlserver/2004/sqltypes:int

About dotnetspider.com

Quick Links

General

Services