|
|
You're in the
sql server programming
group:Can any one help me with this SQLXML 3.0 SP3 Problem?
sql server programming:
application to manipulate xml files and import them into an SQL Server database. Every time I run the application, the import fails. The error log contains the following xml: <code> <?xml version="1.0"?> <Result State="FAILED"> <Error> <HResult>0x80004005I32</HResult> <Description><![CDATA[Error connecting to the data source.]]></Description> <Source>XML BulkLoad for SQL Server</Source> <Type>FATAL</Type> </Error> </Result State> </code> I'm at a complete loss as to what's going on here. Any input would be greatly appreciated. I've included most of my code for reference. If anything else is needed, please let me know. The code that is supposed to be connecting to the database and executing the bulk transfer is as follows: <code> Private Function importToSQL(ByVal importXML As String) (where importXML = C:\SQL EXCHANGE\IDS\IN\filename.xml) Dim noErrors As Boolean Dim connectionString As String = "PROVIDER=SQLOLEDB; Server=(local); database=database; user id=username; password=password" Dim errorLog As String = importXML & ".errlog" Dim dataSchema As String = "C:\SQL EXCHANGE\IDS\IN\IDS XML Importer\IDS XML Importer.xsd" Dim bulkLoad As New SQLXMLBULKLOADLib.SQLXMLBulkLoad3 Try bulkLoad.KeepIdentity = False bulkLoad.KeepNulls = True bulkLoad.ErrorLogFile = errorLog bulkLoad.ConnectionString = connectionString bulkLoad.Execute(dataSchema, importXML) Catch ex As Exception noErrors = False End Try End Function </code> Lastly, a snippet of the .xsd file that I'm using to show that its structure: <code> <?xml version="1.0" ?> <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sql="urn:schemas-microsoft-com:mapping-schema"> <xsd:element name="File"> <xsd:complexType> <xsd:choice maxOccurs="unbounded"> <xsd:element name="CLAIM" sql:relation="IMPORT_IHS_DENTAL_CLAIMS"> <xsd:complexType> <xsd:sequence> <xsd:element name="CLAIM_NUM" type="xsd:string" sql:field="CLAIM_NUM" /> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ <xsd:element name="_240_TREATMENT_ZIP" type="xsd:string" sql:field="_240_TREATMENT_ZIP" /> </xsd:sequence> </xsd:complexType> </xsd:element> </xsd:choice> </xsd:complexType> </xsd:element> </xsd:schema> </code> Thanks in advance. -- Grant Smith
Try a semicolon after the password.
Rick Sawtell MCT, MCSD, MCDBA "Grant Smith - eNVENT Technologies" <grant.smith@envent-tech.com> wrote in message news:4Yudf.327077$084.13767@attbi_s22... [quoted text, click to view] > I'm having a problem with SQLXML. I have written a small VB.NET ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~> application to manipulate xml files and import them into an SQL Server > database. > > Every time I run the application, the import fails. The error log > contains the following xml: > > <code> > > <?xml version="1.0"?> > <Result State="FAILED"> > <Error> > <HResult>0x80004005I32</HResult> > <Description><![CDATA[Error connecting to the data > source.]]></Description> > <Source>XML BulkLoad for SQL Server</Source> > <Type>FATAL</Type> > </Error> > </Result State> > > </code> > > I'm at a complete loss as to what's going on here. Any input would be > greatly appreciated. I've included most of my code for reference. If > anything else is needed, please let me know. > > The code that is supposed to be connecting to the database and executing > the bulk transfer is as follows: > > <code> > > Private Function importToSQL(ByVal importXML As String) > > (where importXML = C:\SQL EXCHANGE\IDS\IN\filename.xml) > > Dim noErrors As Boolean > > Dim connectionString As String = "PROVIDER=SQLOLEDB; Server=(local); > database=database; user id=username; password=password" > Dim errorLog As String = importXML & ".errlog" > Dim dataSchema As String = "C:\SQL EXCHANGE\IDS\IN\IDS XML Importer\IDS > XML Importer.xsd" > > Dim bulkLoad As New SQLXMLBULKLOADLib.SQLXMLBulkLoad3 > > Try > > bulkLoad.KeepIdentity = False > bulkLoad.KeepNulls = True > bulkLoad.ErrorLogFile = errorLog > bulkLoad.ConnectionString = connectionString > bulkLoad.Execute(dataSchema, importXML) > > Catch ex As Exception > > noErrors = False > > End Try > > End Function > > </code> > > Lastly, a snippet of the .xsd file that I'm using to show that its > structure: > > <code> > > <?xml version="1.0" ?> > <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" > xmlns:sql="urn:schemas-microsoft-com:mapping-schema"> > <xsd:element name="File"> > <xsd:complexType> > <xsd:choice maxOccurs="unbounded"> > <xsd:element name="CLAIM" sql:relation="IMPORT_IHS_DENTAL_CLAIMS"> > <xsd:complexType> > <xsd:sequence> > <xsd:element name="CLAIM_NUM" type="xsd:string" > sql:field="CLAIM_NUM" /> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ [quoted text, click to view] > <xsd:element name="_240_TREATMENT_ZIP" type="xsd:string" > sql:field="_240_TREATMENT_ZIP" /> > </xsd:sequence> > </xsd:complexType> > </xsd:element> > </xsd:choice> > </xsd:complexType> > </xsd:element> > </xsd:schema> > > </code> > > Thanks in advance. > -- > Grant Smith > A+, Net+, MCP x 2
Hi
The error implies that you have not connected correctly to your database. Make sure that your connection string is correct. Check out the examples at http://www.perfectxml.com/articles/XML/ImportXMLSQL.asp John "Grant Smith - eNVENT Technologies" <grant.smith@envent-tech.com> wrote in message news:4Yudf.327077$084.13767@attbi_s22... [quoted text, click to view] > I'm having a problem with SQLXML. I have written a small VB.NET > application to manipulate xml files and import them into an SQL Server > database. > > Every time I run the application, the import fails. The error log contains > the following xml: > > <code> > > <?xml version="1.0"?> > <Result State="FAILED"> > <Error> > <HResult>0x80004005I32</HResult> > <Description><![CDATA[Error connecting to the data > source.]]></Description> > <Source>XML BulkLoad for SQL Server</Source> > <Type>FATAL</Type> > </Error> > </Result State> > > </code> > > I'm at a complete loss as to what's going on here. Any input would be > greatly appreciated. I've included most of my code for reference. If > anything else is needed, please let me know. > > The code that is supposed to be connecting to the database and executing > the bulk transfer is as follows: > > <code> > > Private Function importToSQL(ByVal importXML As String) > > (where importXML = C:\SQL EXCHANGE\IDS\IN\filename.xml) > > Dim noErrors As Boolean > > Dim connectionString As String = "PROVIDER=SQLOLEDB; Server=(local); > database=database; user id=username; password=password" > Dim errorLog As String = importXML & ".errlog" > Dim dataSchema As String = "C:\SQL EXCHANGE\IDS\IN\IDS XML Importer\IDS > XML Importer.xsd" > > Dim bulkLoad As New SQLXMLBULKLOADLib.SQLXMLBulkLoad3 > > Try > > bulkLoad.KeepIdentity = False > bulkLoad.KeepNulls = True > bulkLoad.ErrorLogFile = errorLog > bulkLoad.ConnectionString = connectionString > bulkLoad.Execute(dataSchema, importXML) > > Catch ex As Exception > > noErrors = False > > End Try > > End Function > > </code> > > Lastly, a snippet of the .xsd file that I'm using to show that its > structure: > > <code> > > <?xml version="1.0" ?> > <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" > xmlns:sql="urn:schemas-microsoft-com:mapping-schema"> > <xsd:element name="File"> > <xsd:complexType> > <xsd:choice maxOccurs="unbounded"> > <xsd:element name="CLAIM" sql:relation="IMPORT_IHS_DENTAL_CLAIMS"> > <xsd:complexType> > <xsd:sequence> > <xsd:element name="CLAIM_NUM" type="xsd:string" sql:field="CLAIM_NUM" /> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > <xsd:element name="_240_TREATMENT_ZIP" type="xsd:string" > sql:field="_240_TREATMENT_ZIP" /> > </xsd:sequence> > </xsd:complexType> > </xsd:element> > </xsd:choice> > </xsd:complexType> > </xsd:element> > </xsd:schema> > > </code> > > Thanks in advance. > -- > Grant Smith > A+, Net+, MCP x 2
[quoted text, click to view]
John Bell wrote: Thanks for the input John, but I changed my connection string to match > Hi > > The error implies that you have not connected correctly to your database. > Make sure that your connection string is correct. Check out the examples at > http://www.perfectxml.com/articles/XML/ImportXMLSQL.asp > > John > > "Grant Smith - eNVENT Technologies" <grant.smith@envent-tech.com> wrote in > message news:4Yudf.327077$084.13767@attbi_s22... > >>Snip > > > PerfecXML (which is what I started with, i might add) save for making UID and PWD appropriate for my server, and I still got the same results. -- Grant Smith A+, Net+, MCP x 2 Quality Production Liaison Hewlett Packard Company Database Administrator
[quoted text, click to view]
Rick Sawtell wrote: I added a semicolon as you directed and still got the same results.> Try a semicolon after the password. > > Rick Sawtell > MCT, MCSD, MCDBA > > > "Grant Smith - eNVENT Technologies" <grant.smith@envent-tech.com> wrote in > message news:4Yudf.327077$084.13767@attbi_s22... > >>Snip > > > -- Grant Smith A+, Net+, MCP x 2 Quality Production Liaison Hewlett Packard Company Database Administrator
[quoted text, click to view]
Rick Sawtell wrote: I tried this and got the same results.> Try a semicolon after the password. > > Rick Sawtell > MCT, MCSD, MCDBA > > > "Grant Smith - eNVENT Technologies" <grant.smith@envent-tech.com> wrote in > message news:4Yudf.327077$084.13767@attbi_s22... > >>Snip > > > Any more ideas? -- Grant Smith A+, Net+, MCP x 2 Quality Production Liaison Hewlett Packard Company Database Administrator
[quoted text, click to view]
John Bell wrote: I changed my connection string to exactly what PerfectXML had as an example (by the way, I started with this connection string originally) save for > Hi > > The error implies that you have not connected correctly to your database. > Make sure that your connection string is correct. Check out the examples at > http://www.perfectxml.com/articles/XML/ImportXMLSQL.asp > > John > > "Grant Smith - eNVENT Technologies" <grant.smith@envent-tech.com> wrote in > message news:4Yudf.327077$084.13767@attbi_s22... > >>Snip > > > the username and password values and still got the same results. Anything else you can think of? -- Grant Smith A+, Net+, MCP x 2 Quality Production Liaison Hewlett Packard Company Database Administrator
Hi
If the connection string PROVIDER=SQLOLEDB.1;SERVER=(local);DATABASE=database;UID=username;PWD=password; does not work, then you may want to check conectivity in general through query analyser. John [quoted text, click to view] Grant Smith - eNVENT Technologies wrote:
> Rick Sawtell wrote: > > Try a semicolon after the password. > > > > Rick Sawtell > > MCT, MCSD, MCDBA > > > > > > "Grant Smith - eNVENT Technologies" <grant.smith@envent-tech.com> wrote in > > message news:4Yudf.327077$084.13767@attbi_s22... > > > >>Snip > > > > > > > I added a semicolon as you directed and still got the same results. > > -- > Grant Smith > A+, Net+, MCP x 2 > > Quality Production Liaison > Hewlett Packard Company > > Database Administrator > Renaissance Systems and Services, LLC
Don't see what you're looking for? Try a search.
|
January 2003
March 2003
April 2003
May 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
April 2008
| home · blog · groups | Questions? Comments? Contact the dn |