RDO DataType query.

A colleague is trying to get some SQL Server data into MS Access, and is querying the table from a VB program.

She opens an rdoconnection to an SQLServer database. When testing recordset.rdocolumns("fieldName").type it gives -9 as the value. This does not relate to any of VB's listed RDO connection types. It also shows the rdocolumns("fieldName").size as being twice what the database shows when viewed through Microsoft Access. What is this datatype?

Any ideas?

I've found various lists for datatype eNums for ADO, but nothing on RDO (as it's obviously obsolete). Anyone out there got any ideas (other than "use something else")?

Thanks in advance

Chris.

export the data from sql server using dts

call the dts from the apps using dts run utility

or

use ado

or use replication

rdl to word doc ?

Hi,

Can anyone assist me to convert .rdl files into an word file ?

Shall i need to write a program ?

Regards

Harsh

I think this is coming in RS2008.

In the meantime could try creating a webservice which creates the report as pdf, then just get a 3rd party component to convert the pdf to word.

or try this:
http://aspalliance.com/1080_Video_Generate_Microsoft_Word_Reports_From_SQL_Reporting_Services

RDA with Linked Servers

I am developing a WM5 program (C#.NET) using SQL Server Mobile, using RDA to pull and push data from/to SQL2005.

The question/issue is this: Does RDA work with linked servers, more specifically, if the RDA table is an Oracle table accessed through a linked server? I have a linked server defined in SQL2005, using the .NET Oracle provider (MSDAORA) linked to Oracle 10g. When I try to perform an RDA PULL operation from Windows Mobile 5 (Smartphone emulator) I get the following error:

“The query cannot be tracked. There might not be a primary key, or the query might involve multiple tables. [ Query string = SELECT * FROM DATABASE_NAME..SCHEMA_NAME.TABLE_NAME ]”

I have used at least 3 different test tables in Oracle, trying different options. The error message above implies that the table may not have a primary key but it does (constraint and index) and I have tried a few options with this. The message also implies that multiple tables may be involved but this is not the case either. I have tried variations on the select statement including specifying the columns. I tried building the CREATE TABLE statements with the PK using SQLServer to generate the SQL DDL to see if SQLServer might build the table, constraint, index with options the way it wants to see them – same result.

I can run most any queries (select, insert, etc.) from SQLServer using the linked server and the queries work. The only problems involve RDA to the linked server.

I tried turning tracking off on RDA and was able to pull the entire table from the linked server. However, RDA requires that you can only push a tracked table (change tracking on). I tried to push a non-tracked table and it fails.

Make sure that the table you are referring to is under DBO schema. If it is under any other schema, then RDA might be encountering problem in finding the Primary Key for that table.

Let me know the details after your trials!

Thanks,

Laxmi Narsimha Rao ORUGANTI, SQL Server Everywhere, Microsoft Corporation

|||

All of the objects in the SQL2005 database are in the dbo schema. However, the query from RDA pull references an Oracle table in a named schema, using 4-part name notation "SELECT * FROM DATABASE_NAME..SCHEMA_NAME.TABLE_NAME " per the SQL2005 distributed query guidelines. In this case, the credentials for the linked server Oracle access are for the owner of the named schema.

Thanks,

MattR-KS

|||

Hi Matt,

Just to narrow down the problem. What happens when you are pulling a table in a named schema from SQL Server than from oracle via linked SQL Server. What I mean is have the table in a name schema in SQL Server itself and do a RDA with that.

Thanks,

Laxmi Narsimha Rao ORUGANTI, SQL Server Everywhere, Microsoft Corporation

RDA question

i am using RDA to synch data between sql server 2000 and my PDA. i try to
get a parameter list according to the group of a user in my program. my
query to pull is something like that :
"select id ,name from parametertable where groupid in ( select g.id from
grouptable g inner join usertable u on u.groupid = g.id where u.is =
<<userid>>)" with TRACKINGOFF option
this query works well in sql server 2000 and brings what i want. but it
gets all the items of parameter table in the PDA. i do not understand why.
i am new to RDA , is there anything that i miss ?
thanks
try rewriting the query to not use subquery for the RDA pull.
use a join if possible.
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
"Yener" <someone@.com.com> wrote in message
news:ORi4O$6wFHA.2620@.TK2MSFTNGP09.phx.gbl...
>i am using RDA to synch data between sql server 2000 and my PDA. i try to
>get a parameter list according to the group of a user in my program. my
>query to pull is something like that :
> "select id ,name from parametertable where groupid in ( select g.id from
> grouptable g inner join usertable u on u.groupid = g.id where u.is =
> <<userid>>)" with TRACKINGOFF option
> this query works well in sql server 2000 and brings what i want. but it
> gets all the items of parameter table in the PDA. i do not understand
> why.
> i am new to RDA , is there anything that i miss ?
> thanks
>
>
|||i found another code at the bottom that pulls the same table again!
i am sorry!!
"Darren Shaffer" <darrenshaffer@.discussions.microsoft.com> wrote in message
news:O0%238iFgxFHA.1252@.TK2MSFTNGP09.phx.gbl...
> try rewriting the query to not use subquery for the RDA pull.
> use a join if possible.
> --
> Darren Shaffer
> .NET Compact Framework MVP
> Principal Architect
> Connected Innovation
> www.connectedinnovation.com
> "Yener" <someone@.com.com> wrote in message
> news:ORi4O$6wFHA.2620@.TK2MSFTNGP09.phx.gbl...
>
|||so is your problem solved? not sure if we've helped you here or not.
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com
"Yener" <someone@.com.com> wrote in message
news:%232QRy5CzFHA.2540@.TK2MSFTNGP09.phx.gbl...
> i found another code at the bottom that pulls the same table again!
> i am sorry!!
> "Darren Shaffer" <darrenshaffer@.discussions.microsoft.com> wrote in
> message news:O0%238iFgxFHA.1252@.TK2MSFTNGP09.phx.gbl...
>
|||yes Darren it is solved now. thanks anyway.
"Darren Shaffer" <darrenshaffer@.discussions.microsoft.com> wrote in message
news:eqyDGkMzFHA.3812@.TK2MSFTNGP09.phx.gbl...
> so is your problem solved? not sure if we've helped you here or not.
> --
> Darren Shaffer
> .NET Compact Framework MVP
> Principal Architect
> Connected Innovation
> www.connectedinnovation.com
> "Yener" <someone@.com.com> wrote in message
> news:%232QRy5CzFHA.2540@.TK2MSFTNGP09.phx.gbl...
>