Export to SQL Server Everywhere Database

Hello!

I want to export a table in a SQL Server 2005 database to an SQL Server 2005 Everywhere database (sdf file). I use the assistent by calling "Management/Export data". The source is "SQL Native Client" showing to a certain database. The destination is "SQL Server 2005 Everywhere Edition" with an SDF File set. Then after defining the tables to be exported I come to a page showing me the steps of the export. At step "Before execution" I get the error messages (translated from German):

Error 0xc0202009: Data flow task: OLE DB error. Error code 0x80040E37

Error 0xc02020e8: Data flow task: Error opening a rowset for "TABLE_NAME". Validate the existance of the object in the database.

Does someone know what the problem is? The source is completely ok. The source table is existing and contains over 3.000 datasets.

Robert

i have the same problem|||

Import/Export from/to SQL Server Everywhere Edition (SSEv) is not implemented.

The immediate question would be why is it shown their in the list of data providers?

All the data related tools (ex: SQL Server Management Studio, Microsoft Office Word, Microsoft Office Excel ..etc) show a list of data providers from a OLEDB Provider database of the system. Since, SSEv also registers its OLEDB Provider to system, it gets listed automatically.

Thanks,

Laxmi

Export to SQL Server Everywhere Database

Hello!

I want to export a table in a SQL Server 2005 database to an SQL Server 2005 Everywhere database (sdf file). I use the assistent by calling "Management/Export data". The source is "SQL Native Client" showing to a certain database. The destination is "SQL Server 2005 Everywhere Edition" with an SDF File set. Then after defining the tables to be exported I come to a page showing me the steps of the export. At step "Before execution" I get the error messages (translated from German):

Error 0xc0202009: Data flow task: OLE DB error. Error code 0x80040E37

Error 0xc02020e8: Data flow task: Error opening a rowset for "TABLE_NAME". Validate the existance of the object in the database.

Does someone know what the problem is? The source is completely ok. The source table is existing and contains over 3.000 datasets.

Robert

i have the same problem|||

Import/Export from/to SQL Server Everywhere Edition (SSEv) is not implemented.

The immediate question would be why is it shown their in the list of data providers?

All the data related tools (ex: SQL Server Management Studio, Microsoft Office Word, Microsoft Office Excel ..etc) show a list of data providers from a OLEDB Provider database of the system. Since, SSEv also registers its OLEDB Provider to system, it gets listed automatically.

Thanks,

Laxmi

Export to PDF and print in landscape

Hello

I have a report which I can print on legal paper, once I choose the landscape settings on print menu. When the same report is set to export to a file share in pdf format, it renders in portrait format. Is it possible to have the pdf document look like the landscape view so that the user can just hit print.

Thanks

Inder

No,

you would probably have to setup two reports, one in landscape and one in portrait.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hello

Thanks for the answer, but how do I set up the report in landscape or for that matter portrait?

|||

HI,

In the report designer, click on the small square in the top left hand corner of the page so you can view the page properties. Now set the page size in the properties box to 29.7 width and 21 height.

I can get screenshots if you need them?