Can we connect Sharepoint to SQL Server 6.5?

Not able to import application definition file!! Error: The metadata object with Name 'XYZ' and of Type 'LobSystemInstance' has a Property with Name 'DatabaseAccessProvider' that has either an invalid value or Type. Error was encountered at or just before Line: '10' and Position: '10'.

line 10 in ADF:

 <"Property Name="DatabaseAccessProvider" Type="System.String">SqlOledb<"/Property>

Please give me ideas on how to display data f开发者_如何学Gorom SQL Server 6.5 in Sharepoint?

The value of the node is invalid. You need to use SqlServer or OleDb. Check out this page for more information:

http://msdn.microsoft.com/en-us/library/ms550725(office.12).aspx

Im just starting on a similar task (so I found your unanswered question). I am trying to copy our documentation library in Sharepoint to an SQL db. Its not opening your file directly from SQL its using some c# code to setup a job which opens the sharepoint which may be what you are wanting.

There are two methods I have found so far: One is to copy your data from sharepoint to a linked list in Access and then use the OLEDB methods in to open it. Found here: C# Sync MS Access database to sql server

    private static void BulkCopyAccessToSQLServer
            (CommandType commandType, string sql, string destinationTable)
    {
        string connectionString = @"C:\Migration\Sharepoint Access SQL Batch Job\Database11.accdb";
        using (DataTable dt = new DataTable())
        {

            string ConnStr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Migration\Sharepoint Access SQL Batch Job\Database11.accdb;Jet OLEDB:Database Password=password";
            //using (OleDbConnection conn = new OleDbConnection(Settings.Default.CurriculumConnectionString))
            using (OleDbConnection conn = new OleDbConnection(ConnStr))
            using (OleDbCommand cmd = new OleDbCommand(sql, conn))
            using (OleDbDataAdapter adapter = new OleDbDataAdapter(cmd))
            {
                cmd.CommandType = commandType;
                cmd.Connection.Open();
                adapter.SelectCommand.CommandTimeout = 240;
                adapter.Fill(dt);
                adapter.Dispose();
            }



            using (SqlConnection conn2 = new SqlConnection(Settings.Default.qlsdat_extensionsConnectionString))

            using (SqlConnection conn2 = new SqlConnection(connectionString))
            {
                conn2.Open();
                using (SqlBulkCopy copy = new SqlBulkCopy(conn2))
                {
                    copy.DestinationTableName = destinationTable;
                    copy.BatchSize = 1000;
                    copy.BulkCopyTimeout = 240;
                    copy.WriteToServer(dt);
                    copy.NotifyAfter = 1000;
                }
            }
        }
    }

The other is to use the Microsoft.Sharepoint libraries and open your sharepoint directly from the c# then copy it into your SQL. Found here: http://www.dotnetspark.com/kb/3573-fetching-lists-from-sharepoint-2010-site.aspx

    using (SharePointclientObj.ClientContext ctx = new SharePointclientObj.ClientContext(clientContext))
        {                
            //Get the site
            SharePointclientObj.Web site = ctx.Web;
            ctx.Load(site);
            //Get Lists
            ctx.Load(site.Lists);
            //Query
            ctx.ExecuteQuery();
            //Fill List
            foreach (SharePointclientObj.List list in site.Lists)
            {
                Console.WriteLine(list.Title);                   
            }

        }