MDB to SDF

Hello, everyone.

I am a new developer of .NET CF. Currently, I have a project that needs transferring tables from a existing Access database to SQL Server 2005 Mobile database. Does anybody know how to do it?

Thanks in advance.

Are you talking about MS Access Database or MS Pocket Access Database. In any case, we dont have any tools for doing that automatically.

However, you can always open two cursors (Datasets) against two DBs and transfer the data one row by row. I know its a slow operation but it is all design time.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

Thanks for your help.

It looks like that I have to develop a tool myself.

|||

We are really sorry that we could not help you much in this regard. But we would surely take this as feedback and work on this seriously.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

Raise an issue (as a suggestion) in the public Feedback Database if you'd like such a tool to be included in a future SQL Server release:

http://lab.msdn.microsoft.com/productfeedback/

|||

Are you talking about MS Access Database or MS Pocket Access Database. In any case, we dont have any tools for doing that automatically.

However, you can always open two cursors (Datasets) against two DBs and transfer the data one row by row. I know its a slow operation but it is all design time.

Is there any walkthru that I can perview on exactly how to do that?

MDB to SDF

Hello, everyone.

I am a new developer of .NET CF. Currently, I have a project that needs transferring tables from a existing Access database to SQL Server 2005 Mobile database. Does anybody know how to do it?

Thanks in advance.

Are you talking about MS Access Database or MS Pocket Access Database. In any case, we dont have any tools for doing that automatically.

However, you can always open two cursors (Datasets) against two DBs and transfer the data one row by row. I know its a slow operation but it is all design time.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

Thanks for your help.

It looks like that I have to develop a tool myself.

|||

We are really sorry that we could not help you much in this regard. But we would surely take this as feedback and work on this seriously.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation

|||

Raise an issue (as a suggestion) in the public Feedback Database if you'd like such a tool to be included in a future SQL Server release:

http://lab.msdn.microsoft.com/productfeedback/

|||

Are

you talking about MS Access Database or MS Pocket Access Database. In

any case, we dont have any tools for doing that automatically.

However, you can always open two cursors (Datasets) against two DBs

and transfer the data one row by row. I know its a slow operation but

it is all design time.

Is there any walkthru that I can perview on exactly how to do that?

mdb file support UTF8

i create mdb file in VB.NET project in vs2005 . i want that it support UTF8 for arabic language.

thanks .

There are two ways to do that you can create typed dataset with UTF8 or use some configuration provided by Microsoft, so there is no standard way to do it. Hope this helps.

http://msdn2.microsoft.com/en-us/library/aa662944(office.11).aspx

http://office.microsoft.com/en-us/ork2003/HA011402281033.aspx

MBSA and MSXML 2.6

Dear All,
MBSA is saying that I currently have MSXML 2.6 SP2, and that I should
upgrade to SP3. When I did a search on the net, not only is SP3 not
publicly available, it is also included in MS SQL 2000 SP3 that I
already have installed.
How come I am still getting these errors from MBSA despite my servers
having MS SQL 2000 SP3 installed?
Is there a way to manually check my version of MSXML 2.6?
Has anyone had a similar problem?
Thanks.
Aramid"Aramid" <aramid@.hotmail.com> wrote in message
news:63drc112j512d4dntnt2t5q3butk2v51h3@.
4ax.com...
> Dear All,
> MBSA is saying that I currently have MSXML 2.6 SP2, and that I should
> upgrade to SP3. When I did a search on the net, not only is SP3 not
> publicly available, it is also included in MS SQL 2000 SP3 that I
> already have installed.
> How come I am still getting these errors from MBSA despite my servers
> having MS SQL 2000 SP3 installed?
> Is there a way to manually check my version of MSXML 2.6?
This may seem funny but it's no joke: the only KB article I could find, for
checking the XML version called by IE was to get filemon.exe from the
SysInternals.com site, open an XML file with IE, locate the reference to
msxml?.dll in filemon output, and get its properties to check its version.
Here's the article, it's a scream:
http://support.microsoft.com/defaul...kb;en-us;296647
This one is also an interesting read, and it contains links to the how-to
for upgrading your installed parser:
http://support.microsoft.com/defaul...kb;en-us;269238
-Mark

> Has anyone had a similar problem?
> Thanks.
> Aramid