Trying to set up a data service in VS2010 to use with linq to XML

I'm pretty lost here. I'm trying to setup a Visual Studio program to parse and store XML in a database. The XML is from embedded XMlL files in OpenOffice Word Documents.
I'm doing ok except with the parsing, etc, but getting the data into the database is a problem. The example I'm following says I need to add a server reference.

I'm not sure what database is best to use - compact model, edo, mdf, etc? I wasnt' sure even if SQL was working properly so I upgraded to 2008 r2.
The project no longer allows me to use the compact 3.5 database I had been using as the datasource for the Edo Model Entity object.

I know this is not clear, as I'm very new to this, but sure could use a little guidance.
thanks
jodyfaisonAsked:
Who is Participating?
 
käµfm³d 👽Connect With a Mentor Commented:
With respect, your question is a little convoluted. Can you break down the problem you are having and possibly post any code that is giving you problems?
0
 
jodyfaisonAuthor Commented:
Yes, thank you kaufmed! "Convoluted" is being kind. ha.
Well. I've been trying all kinds of stuff, trying to learn this stuff.

I basically want to load an SQL database with XML data.
Let me just ask a few basic questions.
Is it ok to use in a VS 2010 project the SQL Server named after my machine? Server = PC-Jody ?

Also I've worked out a few things. I got SQLXML 4 sp1 loaded and in my SQL manager and have been able to create a table with a querry. So that's good. Now I'm trying to run a vbscript I found to upload bulk XML into a SQL server. It seems to be working ok, but it faullters as it doesn't like my connection string.
<objBL.ConnectionString = "provider=.NET Framework Data Provider for SQL Server;Data Source=JODY-PC;Initial Catalog=Briefs;Integrated Security=True"> I've attached the script.
ValidateAndBulkload.vbs
0
 
jodyfaisonAuthor Commented:
Ok, I got a con. string to work and actually loaded data to a table. So now I'm going to try and adapt my tables to that example.
0
 
jodyfaisonAuthor Commented:
Hey got that bulk loader to work. I'll check back when I can be more exact with a question. Thanks.
0
 
jodyfaisonAuthor Commented:
thanks
0
All Courses

From novice to tech pro — start learning today.