PC Review


Reply
Thread Tools Rate Thread

connect to paradox db from sqlserver database table

 
 
vishruth
Guest
Posts: n/a
 
      11th Mar 2008
how to write data from data set in dotnet to paradox database in c#
In this code from Archive Sql Server database, Table named:tmsarcdata
I want all the details from tmsarcdata table to move to paradox database
My paradox database path is: =@"D:\\ArchiveBase\\CDFilesa"

This is the code I tried,but did not work:

private void button1_Click(object sender, System.EventArgs e)
{


try
{
string pPath=@"D:\\ArchiveBase\\CDFilesa";
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source="+pPath+";Extended Properties=Paradox 5.x;";
string command="select * from tmsarcdata";
OleDbCommand mCommand = new OleDbCommand();
OleDbConnection mConnection=new OleDbConnection(strConnection);
mConnection.Open();
mCommand.CommandText=command;
mCommand.ExecuteNonQuery();

}
catch(System.Exception Ex)
{
//Ex.Message;
}
}


Please help.....

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
automatically creating table links in access to new tables in sqlserver database Ruben Gouveia Microsoft Access VBA Modules 1 19th Dec 2009 04:48 AM
Migrating Paradox to MS Access Borland Paradox database to MS Acce Michico Microsoft Access External Data 0 28th Aug 2008 07:10 AM
How do I connect to a lookup table in another database? =?Utf-8?B?U3RldmVQ?= Microsoft Access External Data 13 15th May 2007 09:13 PM
access 2003 join on two sqlserver 2000 tables (one table is from a linked navision 3.70 server on sqlserver 2000) Hubert Mayr Microsoft Access 1 4th Jan 2006 01:22 AM
How can I execute a query/datareader connecting to Pervasive SQL2000i Database table and a Paradox table? Dan V. Microsoft ADO .NET 4 10th Jun 2004 09:35 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:04 AM.