RemoteDataAccess

Dear Friends,

To use RDA, do I still have to use Replication, Publishing? if yes which publication need to be used? is it Transaction

If you can guide me as to how I can imliment RDA, would be a great help.

Check the topic: Remote Data Access (RDA)

at http://msdn2.microsoft.com/en-us/library/aa257442(SQL.80).aspx

It also has examples in the Push/Pull etc methods.

|||

Thankx,

But what I need to know is if i need to use replication publishing of the SQL server db?

Is there any way that I can access the SQL server DB directly?

Regards

RemoteDataAccess

Dear Friends,

To use RDA, do I still have to use Replication, Publishing? if yes which publication need to be used? is it Transaction

If you can guide me as to how I can imliment RDA, would be a great help.

Check the topic: Remote Data Access (RDA)

at http://msdn2.microsoft.com/en-us/library/aa257442(SQL.80).aspx

It also has examples in the Push/Pull etc methods.

|||

Thankx,

But what I need to know is if i need to use replication publishing of the SQL server db?

Is there any way that I can access the SQL server DB directly?

Regards

Remote Data Access (RDA.Pull)

Hi,

I am trying to use RDA.pull to pull data from SQL server 2000 to sql mobile, but it fails when some columns are included in the SQLSelectString, though the datatypes involved are only char, float, smallint and smalldatetime, and nothing is longer than 30. Since there is a very large number of columns, it is difficult to isolate the guilty one by trial and error! Coud someone please help?

- Nag Rao

Can you please try pulling a table with no.of columns less than 128!

Thanks,

Laxmi

Remote Data Access (RDA.Pull)

Hi,

I am trying to use RDA.pull to pull data from SQL server 2000 to sql mobile, but it fails when some columns are included in the SQLSelectString, though the datatypes involved are only char, float, smallint and smalldatetime, and nothing is longer than 30. Since there is a very large number of columns, it is difficult to isolate the guilty one by trial and error! Coud someone please help?

- Nag Rao

Can you please try pulling a table with no.of columns less than 128!

Thanks,

Laxmi