SQL About AMO: edition

Showing posts with label edition. Show all posts

Thursday, March 29, 2012

Access Denied Error attaching an existing MDF

I guess I messed up somehow, but I am not sure how to fix this.

On Vista, with SQL Server 2005 Developer Edition, I created a 6GB database and loaded it up with data. I then decided that I wanted to burn a copy of the files, so I detached (no problem.) But when I wanted to copy the physical MDF and LOG file to another folder. Vista said I did not have access to the folder, but if I hit continue, no problem--it would correct the situation. I did. I copied the files (no problem), but now when I go to reattach to the MDF (that is still in the Data folder), I get a "CREATE FILE encountered operating system 5 (Access is denied)" error. I checked permissions and SQL Server has full rights. I am the only user on the system (Admin), and the files do not appear to have anything weird set (read only, advanced permissions, etc.)

What did I do wrong? And how do I fix this? Oh the joys of advanced Vista security features Even the admin is locked out now.

Thank you for your help!

Michael

Usually the difference for Vista is that you do not get access simply by being a member of the Administrators group. You would need to grant explicit access to the account for the SQL service as well as your own account.|||

I want to understand what you are saying. Are you saying the error is occuring because my login was added to the permissions on the Data folder? MSSQLSERVER has full permissions to the folder and file. That doesn't appear to have changed. Or are you saying that I need to add permissions back for another service like the Agent?

I am trying to understand what Vista did that makes this operation fail.

Thanks!

|||

Attach will attempt to verify that your account has access to the file before attaching it to the server. This keeps random users from attaching random files that they would not normally have access to.

Check the file permissions for both the service account and your account.

|||

Check the NTFS permissions on the actual files. I have see time where after detaching a database from the SQL Server the only user account which has access to the files is the user who detached the database. All other accounts are removed including the SQL Server.

It can be a deceving problem becuase the NTFS permissions on the folder look fine (because they are), but the NTFS permissions of the data files are screwed up.

|||

I will check that out when I get in front of that PC -- thanks! I am still baffled by it. I was able to copy the file to another folder and attach, so I was able to move on. However, the copy that was in the original location still has the issue.

Thank you for replying -- that actually makes sense.

Michael

|||Permission on detach works differently in sql2k5 than sql2k (i.e. it does not preserve all acls like sql2k). This has caught many sql2k users off guard.
http://msdn2.microsoft.com/en-us/library/ms189128.aspx

Tuesday, March 27, 2012

Access Database Synchronizer (ADS)

Hi All,

Today we are very pleased to announce the CTP release of Microsoft SQL Server 2005 Everywhere Edition Access Database Synchronizer (ADS) for which many of you been waiting eagerly. To download the product you can visit the SQL Server Mobile Edition/SQL Server Everywhere Edition product page or click on this link to Access Database Synchronizer reach the download page directly.

Access Database Synchronizer provides a way to synchronize data between Microsoft Access database on a desktop and Microsoft SQL Server 2005 Everywhere Edition database on a device.

For more details you can visit ourblog - http://blogs.msdn.com/sqlservereverywhere/archive/2006/08/29/729730.aspx

I urge you all to install and try out the solution. We look forward to you providing us feedback about this solution so that we can make it better and as close to customer’s requirements as possible.

You can provide us feedback at SQL Server Mobile Edition/SQL Server Everywhere Edition MSDN Forum or SQL Server Everywhere Edition Blog - Microsoft SQL Server 2005 Everywhere Edition Access Database Synchronizer (ADS) or email me directly manish.agnihotri@.microsoft.com

Thanks,

Manish

Manish Agnihotri, Program Manager, SQL Server 2005 Everywhere Edition

Good news. But I want to know wherether this ADS can sync over air (Wi-Fi / TCP/IP) by Dll ?

Thanks

|||

Great news but what about SQL Express

Most serious developers dont touch Access

1. Can we modify this to access sql express

2. Or can we do SQL Everywhere synch to another SQL Everywhere database

Thanks

|||

No, you cannot sync over the air. One needs to establish a USB Active sync connection to sync

Regards

Manish

|||

No this cannot be modified to work with SQL Express or SQL Server Everywhere on desktop. This solution is targeted for Microsoft Access only. We had a big ask for this feature from developer community

Regards

Manish

|||

It is so strange that I can't use this tool to convert Access database into SQL mobile database?

I can't find any "Destop Data Sync Wizard" under Start--> Programs. (the readme file tells me to look for this)

The file I installed is SyncWithAccess-EN.msi

|||

Finally, after looked through the posts here, I understand now, I need to compile that sample program then use it. But when I try to open the project, it prompts me an error:

Error retrieving information from user datastore. Platform not found.

Then it said:

The project could not be opened because it refers to a device platform that does not exist in your datastore.

I already installed the WM5 Emulator, when I tried to use Visual Studio to connect to the "WM5 Device", it said sucessfully connected.

I don't have a WM5 PDA yet. The Visual Studio.net 2005 product I installed includes: VB, C#, VC++. I never used C# or VC++ though.

Can anyone tell me what is wrong?

Thanks!

|||

Try installing this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=83a52af2-f524-4ec5-9155-717cbe5d25ed&DisplayLang=en

and this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=dc6c00cb-738A-4B97-8910-5cd29ab5f8d9&DisplayLang=en

Thanks,

Laxmi

|||Consider that SQL Compact is designed to be used "Everywhere" shouldn't you spend a little time designing a device to desktop 1-to-1 sync capability?

Currently most of my work is done on larger Mobile > SQL 2000 / 2005 merge applications, but I would like to leverage the embeddable capabilites of SQL Compact to build a desktop app that communicates to a single mobile device.

Using Access is not desireable. I don't mind that I would be limited to an ActiveSync connection, since only one device / one desktop is the core design consideration I am looking at. I'd would just rather avoid Access. Given the direction that SQL Compact is taking, it looks like the long term idea is to replace the Access engine anyway, why not throw us a bone...

Also, after reading up on the Access sync, it looks like it works very similar to merge replication anyway. Except instesad of running in IIS, it runs as its own service. Thats fine too.. But SQL > SQL is better.

Please let us know if SQL Compact > SQL Compact sync is in the works.
|||
Is there any chance that we could see a sample app or sample code demonstrating how one might go about creating "Custom Desktop Sync App" using ADS? There is a very brief explanation on how to do it on the ADS Readme file which says something about using “ssevas31.dll" and the ListenSyncRequest but I have not been successful in figuring it out.

Thanks!

Mike|||

I was getting the same message...

"Error retrieving information from user datastore. Platform not found."

... when opening the solution, until I added the WM5 SDK to my machine that alrady had VS2005 Sp1 on it.

However...

The ADS Wizard doesn't seem to be working at all.

My WM5 PPC phone has CF2, SQL CE 3, and the ADS Wizard. All installed without a problem. Laptop's Access 2003 is at SP2. Northwinds file is in c:\

When I go to the phone and connect to the access DB, it returns "Unspecified error [sqlceca30.dll]"

We are terribly interested in understanding more, and would like to see this working.

Anyone?

Cheers

|||

Have you installed the SQL CE replication components: Either sqlce30.repl.phone.wce5.armv4i.CAB for SmartPhone (non touch screen) or sqlce30.repl.ppc.wce5.armv4i.CAB for PocketPC (touch screen). Sqlceca30.dll is included in these components (see http://www.microsoft.com/sql/editions/sqlmobile/installsdk.mspx)

|||Hi!

I have the following problem: the program runs perfectly in all cases, when my computer is connected to the LAN, without LAN connection the "A request to send data to the computer running IIS has failed" error presents. All settings are the same, IIS is running on the computer, from the computer I can see the http://(computer-name):1024 page... so the service is also running. How can I solve this problem, is there any solution for this? I'm using the program on a laptop, so it's needed....
Thanks
|||

Have you added a firewall exception for the default port 1024 which ADS uses for communocating with the device? If not, adding the exception should solve your problem

|||

í can′t find the "Desktop Data Sync Wizard" either, i have installed the ADS without problems, but once done it, can′t find a way to configured it. I have installed it in a Windows XP Professional SP2 with MS Office 2003 and in the mobile device i′m running Windows CE 5.0. What i′m trying to do is to Sync an SDF database with MS Access 2003 in my PC. Is this posible? Should i installed in my PC or into the device or in both? Thank you very much for your help.

Regards,

Roberto.

Access Database Synchronizer (ADS)

Hi All,

Access Database Synchronizer provides a way to synchronize data between Microsoft Access database on a desktop and Microsoft SQL Server 2005 Everywhere Edition database on a device.

For more details you can visit our blog - http://blogs.msdn.com/sqlservereverywhere/archive/2006/08/29/729730.aspx

Thanks,

Manish

Manish Agnihotri, Program Manager, SQL Server 2005 Everywhere Edition

Good news. But I want to know wherether this ADS can sync over air (Wi-Fi / TCP/IP) by Dll ?

Thanks

|||

Great news but what about SQL Express

Most serious developers dont touch Access

1. Can we modify this to access sql express

2. Or can we do SQL Everywhere synch to another SQL Everywhere database

Thanks

|||

No, you cannot sync over the air. One needs to establish a USB Active sync connection to sync

Regards

Manish

|||

Regards

Manish

|||

It is so strange that I can't use this tool to convert Access database into SQL mobile database?

I can't find any "Destop Data Sync Wizard" under Start--> Programs. (the readme file tells me to look for this)

The file I installed is SyncWithAccess-EN.msi

|||

Finally, after looked through the posts here, I understand now, I need to compile that sample program then use it. But when I try to open the project, it prompts me an error:

Error retrieving information from user datastore. Platform not found.

Then it said:

The project could not be opened because it refers to a device platform that does not exist in your datastore.

I already installed the WM5 Emulator, when I tried to use Visual Studio to connect to the "WM5 Device", it said sucessfully connected.

I don't have a WM5 PDA yet. The Visual Studio.net 2005 product I installed includes: VB, C#, VC++. I never used C# or VC++ though.

Can anyone tell me what is wrong?

Thanks!

|||

Try installing this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=83a52af2-f524-4ec5-9155-717cbe5d25ed&DisplayLang=en

and this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=dc6c00cb-738A-4B97-8910-5cd29ab5f8d9&DisplayLang=en

Thanks,

Laxmi

|||Consider that SQL Compact is designed to be used "Everywhere" shouldn't you spend a little time designing a device to desktop 1-to-1 sync capability?

Please let us know if SQL Compact > SQL Compact sync is in the works.|||
Is

there any chance that we could see a sample app or sample code

demonstrating how one might go about creating "Custom Desktop Sync App"

using ADS? There is a very brief explanation on how to do it on the

ADS Readme file which says something about using “ssevas31.dll" and the

ListenSyncRequest but I have not been successful in figuring it out.

Thanks!

Mike|||

I was getting the same message...

"Error retrieving information from user datastore. Platform not found."

... when opening the solution, until I added the WM5 SDK to my machine that alrady had VS2005 Sp1 on it.

However...

The ADS Wizard doesn't seem to be working at all.

My WM5 PPC phone has CF2, SQL CE 3, and the ADS Wizard. All installed without a problem. Laptop's Access 2003 is at SP2. Northwinds file is in c:\

When I go to the phone and connect to the access DB, it returns "Unspecified error [sqlceca30.dll]"

We are terribly interested in understanding more, and would like to see this working.

Anyone?

Cheers

|||

|||Hi!

Have you added a firewall exception for the default port 1024 which ADS uses for communocating with the device? If not, adding the exception should solve your problem

|||

Regards,

Roberto.

Access Database Synchronizer (ADS)

Hi All,

Access Database Synchronizer provides a way to synchronize data between Microsoft Access database on a desktop and Microsoft SQL Server 2005 Everywhere Edition database on a device.

For more details you can visit our blog - http://blogs.msdn.com/sqlservereverywhere/archive/2006/08/29/729730.aspx

Thanks,

Manish

Manish Agnihotri, Program Manager, SQL Server 2005 Everywhere Edition

Good news. But I want to know wherether this ADS can sync over air (Wi-Fi / TCP/IP) by Dll ?

Thanks

|||

Great news but what about SQL Express

Most serious developers dont touch Access

1. Can we modify this to access sql express

2. Or can we do SQL Everywhere synch to another SQL Everywhere database

Thanks

|||

No, you cannot sync over the air. One needs to establish a USB Active sync connection to sync

Regards

Manish

|||

Regards

Manish

|||

It is so strange that I can't use this tool to convert Access database into SQL mobile database?

I can't find any "Destop Data Sync Wizard" under Start--> Programs. (the readme file tells me to look for this)

The file I installed is SyncWithAccess-EN.msi

|||

Finally, after looked through the posts here, I understand now, I need to compile that sample program then use it. But when I try to open the project, it prompts me an error:

Error retrieving information from user datastore. Platform not found.

Then it said:

The project could not be opened because it refers to a device platform that does not exist in your datastore.

I already installed the WM5 Emulator, when I tried to use Visual Studio to connect to the "WM5 Device", it said sucessfully connected.

I don't have a WM5 PDA yet. The Visual Studio.net 2005 product I installed includes: VB, C#, VC++. I never used C# or VC++ though.

Can anyone tell me what is wrong?

Thanks!

|||

Try installing this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=83a52af2-f524-4ec5-9155-717cbe5d25ed&DisplayLang=en

and this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=dc6c00cb-738A-4B97-8910-5cd29ab5f8d9&DisplayLang=en

Thanks,

Laxmi

|||Consider that SQL Compact is designed to be used "Everywhere" shouldn't you spend a little time designing a device to desktop 1-to-1 sync capability?

Please let us know if SQL Compact > SQL Compact sync is in the works.|||
Is

there any chance that we could see a sample app or sample code

demonstrating how one might go about creating "Custom Desktop Sync App"

using ADS? There is a very brief explanation on how to do it on the

ADS Readme file which says something about using “ssevas31.dll" and the

ListenSyncRequest but I have not been successful in figuring it out.

Thanks!

Mike|||

I was getting the same message...

"Error retrieving information from user datastore. Platform not found."

... when opening the solution, until I added the WM5 SDK to my machine that alrady had VS2005 Sp1 on it.

However...

The ADS Wizard doesn't seem to be working at all.

My WM5 PPC phone has CF2, SQL CE 3, and the ADS Wizard. All installed without a problem. Laptop's Access 2003 is at SP2. Northwinds file is in c:\

When I go to the phone and connect to the access DB, it returns "Unspecified error [sqlceca30.dll]"

We are terribly interested in understanding more, and would like to see this working.

Anyone?

Cheers

|||

|||Hi!

Have you added a firewall exception for the default port 1024 which ADS uses for communocating with the device? If not, adding the exception should solve your problem

|||

Regards,

Roberto.

sql

Access Database Synchronizer (ADS)

Hi All,

Access Database Synchronizer provides a way to synchronize data between Microsoft Access database on a desktop and Microsoft SQL Server 2005 Everywhere Edition database on a device.

For more details you can visit our blog - http://blogs.msdn.com/sqlservereverywhere/archive/2006/08/29/729730.aspx

Thanks,

Manish

Manish Agnihotri, Program Manager, SQL Server 2005 Everywhere Edition

Good news. But I want to know wherether this ADS can sync over air (Wi-Fi / TCP/IP) by Dll ?

Thanks

|||

Great news but what about SQL Express

Most serious developers dont touch Access

1. Can we modify this to access sql express

2. Or can we do SQL Everywhere synch to another SQL Everywhere database

Thanks

|||

No, you cannot sync over the air. One needs to establish a USB Active sync connection to sync

Regards

Manish

|||

Regards

Manish

|||

It is so strange that I can't use this tool to convert Access database into SQL mobile database?

I can't find any "Destop Data Sync Wizard" under Start--> Programs. (the readme file tells me to look for this)

The file I installed is SyncWithAccess-EN.msi

|||

Finally, after looked through the posts here, I understand now, I need to compile that sample program then use it. But when I try to open the project, it prompts me an error:

Error retrieving information from user datastore. Platform not found.

Then it said:

The project could not be opened because it refers to a device platform that does not exist in your datastore.

I already installed the WM5 Emulator, when I tried to use Visual Studio to connect to the "WM5 Device", it said sucessfully connected.

I don't have a WM5 PDA yet. The Visual Studio.net 2005 product I installed includes: VB, C#, VC++. I never used C# or VC++ though.

Can anyone tell me what is wrong?

Thanks!

|||

Try installing this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=83a52af2-f524-4ec5-9155-717cbe5d25ed&DisplayLang=en

and this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=dc6c00cb-738A-4B97-8910-5cd29ab5f8d9&DisplayLang=en

Thanks,

Laxmi

|||Consider that SQL Compact is designed to be used "Everywhere" shouldn't you spend a little time designing a device to desktop 1-to-1 sync capability?

Thanks!

Mike|||

I was getting the same message...

"Error retrieving information from user datastore. Platform not found."

... when opening the solution, until I added the WM5 SDK to my machine that alrady had VS2005 Sp1 on it.

However...

The ADS Wizard doesn't seem to be working at all.

My WM5 PPC phone has CF2, SQL CE 3, and the ADS Wizard. All installed without a problem. Laptop's Access 2003 is at SP2. Northwinds file is in c:\

When I go to the phone and connect to the access DB, it returns "Unspecified error [sqlceca30.dll]"

We are terribly interested in understanding more, and would like to see this working.

Anyone?

Cheers

|||

|||Hi!

Have you added a firewall exception for the default port 1024 which ADS uses for communocating with the device? If not, adding the exception should solve your problem

|||

Regards,

Roberto.

Access Database Synchronizer (ADS)

Hi All,

Access Database Synchronizer provides a way to synchronize data between Microsoft Access database on a desktop and Microsoft SQL Server 2005 Everywhere Edition database on a device.

For more details you can visit our blog - http://blogs.msdn.com/sqlservereverywhere/archive/2006/08/29/729730.aspx

Thanks,

Manish

Manish Agnihotri, Program Manager, SQL Server 2005 Everywhere Edition

Good news. But I want to know wherether this ADS can sync over air (Wi-Fi / TCP/IP) by Dll ?

Thanks

|||

Great news but what about SQL Express

Most serious developers dont touch Access

1. Can we modify this to access sql express

2. Or can we do SQL Everywhere synch to another SQL Everywhere database

Thanks

|||

No, you cannot sync over the air. One needs to establish a USB Active sync connection to sync

Regards

Manish

|||

Regards

Manish

|||

It is so strange that I can't use this tool to convert Access database into SQL mobile database?

I can't find any "Destop Data Sync Wizard" under Start--> Programs. (the readme file tells me to look for this)

The file I installed is SyncWithAccess-EN.msi

|||

Finally, after looked through the posts here, I understand now, I need to compile that sample program then use it. But when I try to open the project, it prompts me an error:

Error retrieving information from user datastore. Platform not found.

Then it said:

The project could not be opened because it refers to a device platform that does not exist in your datastore.

I already installed the WM5 Emulator, when I tried to use Visual Studio to connect to the "WM5 Device", it said sucessfully connected.

I don't have a WM5 PDA yet. The Visual Studio.net 2005 product I installed includes: VB, C#, VC++. I never used C# or VC++ though.

Can anyone tell me what is wrong?

Thanks!

|||

Try installing this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=83a52af2-f524-4ec5-9155-717cbe5d25ed&DisplayLang=en

and this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=dc6c00cb-738A-4B97-8910-5cd29ab5f8d9&DisplayLang=en

Thanks,

Laxmi

|||Consider that SQL Compact is designed to be used "Everywhere" shouldn't you spend a little time designing a device to desktop 1-to-1 sync capability?

Thanks!

Mike|||

I was getting the same message...

"Error retrieving information from user datastore. Platform not found."

... when opening the solution, until I added the WM5 SDK to my machine that alrady had VS2005 Sp1 on it.

However...

The ADS Wizard doesn't seem to be working at all.

My WM5 PPC phone has CF2, SQL CE 3, and the ADS Wizard. All installed without a problem. Laptop's Access 2003 is at SP2. Northwinds file is in c:\

When I go to the phone and connect to the access DB, it returns "Unspecified error [sqlceca30.dll]"

We are terribly interested in understanding more, and would like to see this working.

Anyone?

Cheers

|||

|||Hi!

Have you added a firewall exception for the default port 1024 which ADS uses for communocating with the device? If not, adding the exception should solve your problem

|||

Regards,

Roberto.

Access Database Synchronizer (ADS)

Hi All,

Access Database Synchronizer provides a way to synchronize data between Microsoft Access database on a desktop and Microsoft SQL Server 2005 Everywhere Edition database on a device.

For more details you can visit our blog - http://blogs.msdn.com/sqlservereverywhere/archive/2006/08/29/729730.aspx

Thanks,

Manish

Manish Agnihotri, Program Manager, SQL Server 2005 Everywhere Edition

Good news. But I want to know wherether this ADS can sync over air (Wi-Fi / TCP/IP) by Dll ?

Thanks

|||

Great news but what about SQL Express

Most serious developers dont touch Access

1. Can we modify this to access sql express

2. Or can we do SQL Everywhere synch to another SQL Everywhere database

Thanks

|||

No, you cannot sync over the air. One needs to establish a USB Active sync connection to sync

Regards

Manish

|||

Regards

Manish

|||

It is so strange that I can't use this tool to convert Access database into SQL mobile database?

I can't find any "Destop Data Sync Wizard" under Start--> Programs. (the readme file tells me to look for this)

The file I installed is SyncWithAccess-EN.msi

|||

Finally, after looked through the posts here, I understand now, I need to compile that sample program then use it. But when I try to open the project, it prompts me an error:

Error retrieving information from user datastore. Platform not found.

Then it said:

The project could not be opened because it refers to a device platform that does not exist in your datastore.

I already installed the WM5 Emulator, when I tried to use Visual Studio to connect to the "WM5 Device", it said sucessfully connected.

I don't have a WM5 PDA yet. The Visual Studio.net 2005 product I installed includes: VB, C#, VC++. I never used C# or VC++ though.

Can anyone tell me what is wrong?

Thanks!

|||

Try installing this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=83a52af2-f524-4ec5-9155-717cbe5d25ed&DisplayLang=en

and this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=dc6c00cb-738A-4B97-8910-5cd29ab5f8d9&DisplayLang=en

Thanks,

Laxmi

|||Consider that SQL Compact is designed to be used "Everywhere" shouldn't you spend a little time designing a device to desktop 1-to-1 sync capability?

Thanks!

Mike|||

I was getting the same message...

"Error retrieving information from user datastore. Platform not found."

... when opening the solution, until I added the WM5 SDK to my machine that alrady had VS2005 Sp1 on it.

However...

The ADS Wizard doesn't seem to be working at all.

My WM5 PPC phone has CF2, SQL CE 3, and the ADS Wizard. All installed without a problem. Laptop's Access 2003 is at SP2. Northwinds file is in c:\

When I go to the phone and connect to the access DB, it returns "Unspecified error [sqlceca30.dll]"

We are terribly interested in understanding more, and would like to see this working.

Anyone?

Cheers

|||

|||Hi!

Have you added a firewall exception for the default port 1024 which ADS uses for communocating with the device? If not, adding the exception should solve your problem

|||

Regards,

Roberto.

Access Database Synchronizer (ADS)

Hi All,

Access Database Synchronizer provides a way to synchronize data between Microsoft Access database on a desktop and Microsoft SQL Server 2005 Everywhere Edition database on a device.

For more details you can visit our blog - http://blogs.msdn.com/sqlservereverywhere/archive/2006/08/29/729730.aspx

Thanks,

Manish

Manish Agnihotri, Program Manager, SQL Server 2005 Everywhere Edition

Good news. But I want to know wherether this ADS can sync over air (Wi-Fi / TCP/IP) by Dll ?

Thanks

|||

Great news but what about SQL Express

Most serious developers dont touch Access

1. Can we modify this to access sql express

2. Or can we do SQL Everywhere synch to another SQL Everywhere database

Thanks

|||

No, you cannot sync over the air. One needs to establish a USB Active sync connection to sync

Regards

Manish

|||

Regards

Manish

|||

It is so strange that I can't use this tool to convert Access database into SQL mobile database?

I can't find any "Destop Data Sync Wizard" under Start--> Programs. (the readme file tells me to look for this)

The file I installed is SyncWithAccess-EN.msi

|||

Finally, after looked through the posts here, I understand now, I need to compile that sample program then use it. But when I try to open the project, it prompts me an error:

Error retrieving information from user datastore. Platform not found.

Then it said:

The project could not be opened because it refers to a device platform that does not exist in your datastore.

I already installed the WM5 Emulator, when I tried to use Visual Studio to connect to the "WM5 Device", it said sucessfully connected.

I don't have a WM5 PDA yet. The Visual Studio.net 2005 product I installed includes: VB, C#, VC++. I never used C# or VC++ though.

Can anyone tell me what is wrong?

Thanks!

|||

Try installing this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=83a52af2-f524-4ec5-9155-717cbe5d25ed&DisplayLang=en

and this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=dc6c00cb-738A-4B97-8910-5cd29ab5f8d9&DisplayLang=en

Thanks,

Laxmi

|||Consider that SQL Compact is designed to be used "Everywhere" shouldn't you spend a little time designing a device to desktop 1-to-1 sync capability?

Please let us know if SQL Compact > SQL Compact sync is in the works.|||
Is

there any chance that we could see a sample app or sample code

demonstrating how one might go about creating "Custom Desktop Sync App"

using ADS? There is a very brief explanation on how to do it on the

ADS Readme file which says something about using “ssevas31.dll" and the

ListenSyncRequest but I have not been successful in figuring it out.

Thanks!

Mike|||

I was getting the same message...

"Error retrieving information from user datastore. Platform not found."

... when opening the solution, until I added the WM5 SDK to my machine that alrady had VS2005 Sp1 on it.

However...

The ADS Wizard doesn't seem to be working at all.

My WM5 PPC phone has CF2, SQL CE 3, and the ADS Wizard. All installed without a problem. Laptop's Access 2003 is at SP2. Northwinds file is in c:\

When I go to the phone and connect to the access DB, it returns "Unspecified error [sqlceca30.dll]"

We are terribly interested in understanding more, and would like to see this working.

Anyone?

Cheers

|||

|||Hi!

Have you added a firewall exception for the default port 1024 which ADS uses for communocating with the device? If not, adding the exception should solve your problem

|||

Regards,

Roberto.

Access Database Synchronizer (ADS)

Hi All,

Access Database Synchronizer provides a way to synchronize data between Microsoft Access database on a desktop and Microsoft SQL Server 2005 Everywhere Edition database on a device.

For more details you can visit our blog - http://blogs.msdn.com/sqlservereverywhere/archive/2006/08/29/729730.aspx

Thanks,

Manish

Manish Agnihotri, Program Manager, SQL Server 2005 Everywhere Edition

Good news. But I want to know wherether this ADS can sync over air (Wi-Fi / TCP/IP) by Dll ?

Thanks

|||

Great news but what about SQL Express

Most serious developers dont touch Access

1. Can we modify this to access sql express

2. Or can we do SQL Everywhere synch to another SQL Everywhere database

Thanks

|||

No, you cannot sync over the air. One needs to establish a USB Active sync connection to sync

Regards

Manish

|||

Regards

Manish

|||

It is so strange that I can't use this tool to convert Access database into SQL mobile database?

I can't find any "Destop Data Sync Wizard" under Start--> Programs. (the readme file tells me to look for this)

The file I installed is SyncWithAccess-EN.msi

|||

Finally, after looked through the posts here, I understand now, I need to compile that sample program then use it. But when I try to open the project, it prompts me an error:

Error retrieving information from user datastore. Platform not found.

Then it said:

The project could not be opened because it refers to a device platform that does not exist in your datastore.

I already installed the WM5 Emulator, when I tried to use Visual Studio to connect to the "WM5 Device", it said sucessfully connected.

I don't have a WM5 PDA yet. The Visual Studio.net 2005 product I installed includes: VB, C#, VC++. I never used C# or VC++ though.

Can anyone tell me what is wrong?

Thanks!

|||

Try installing this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=83a52af2-f524-4ec5-9155-717cbe5d25ed&DisplayLang=en

and this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=dc6c00cb-738A-4B97-8910-5cd29ab5f8d9&DisplayLang=en

Thanks,

Laxmi

|||Consider that SQL Compact is designed to be used "Everywhere" shouldn't you spend a little time designing a device to desktop 1-to-1 sync capability?

Please let us know if SQL Compact > SQL Compact sync is in the works.|||
Is

there any chance that we could see a sample app or sample code

demonstrating how one might go about creating "Custom Desktop Sync App"

using ADS? There is a very brief explanation on how to do it on the

ADS Readme file which says something about using “ssevas31.dll" and the

ListenSyncRequest but I have not been successful in figuring it out.

Thanks!

Mike|||

I was getting the same message...

"Error retrieving information from user datastore. Platform not found."

... when opening the solution, until I added the WM5 SDK to my machine that alrady had VS2005 Sp1 on it.

However...

The ADS Wizard doesn't seem to be working at all.

My WM5 PPC phone has CF2, SQL CE 3, and the ADS Wizard. All installed without a problem. Laptop's Access 2003 is at SP2. Northwinds file is in c:\

When I go to the phone and connect to the access DB, it returns "Unspecified error [sqlceca30.dll]"

We are terribly interested in understanding more, and would like to see this working.

Anyone?

Cheers

|||

|||Hi!

Have you added a firewall exception for the default port 1024 which ADS uses for communocating with the device? If not, adding the exception should solve your problem

|||

Regards,

Roberto.

sql

Access Database Synchronizer (ADS)

Hi All,

Access Database Synchronizer provides a way to synchronize data between Microsoft Access database on a desktop and Microsoft SQL Server 2005 Everywhere Edition database on a device.

For more details you can visit our blog - http://blogs.msdn.com/sqlservereverywhere/archive/2006/08/29/729730.aspx

Thanks,

Manish

Manish Agnihotri, Program Manager, SQL Server 2005 Everywhere Edition

Good news. But I want to know wherether this ADS can sync over air (Wi-Fi / TCP/IP) by Dll ?

Thanks

|||

Great news but what about SQL Express

Most serious developers dont touch Access

1. Can we modify this to access sql express

2. Or can we do SQL Everywhere synch to another SQL Everywhere database

Thanks

|||

No, you cannot sync over the air. One needs to establish a USB Active sync connection to sync

Regards

Manish

|||

Regards

Manish

|||

It is so strange that I can't use this tool to convert Access database into SQL mobile database?

I can't find any "Destop Data Sync Wizard" under Start--> Programs. (the readme file tells me to look for this)

The file I installed is SyncWithAccess-EN.msi

|||

Finally, after looked through the posts here, I understand now, I need to compile that sample program then use it. But when I try to open the project, it prompts me an error:

Error retrieving information from user datastore. Platform not found.

Then it said:

The project could not be opened because it refers to a device platform that does not exist in your datastore.

I already installed the WM5 Emulator, when I tried to use Visual Studio to connect to the "WM5 Device", it said sucessfully connected.

I don't have a WM5 PDA yet. The Visual Studio.net 2005 product I installed includes: VB, C#, VC++. I never used C# or VC++ though.

Can anyone tell me what is wrong?

Thanks!

|||

Try installing this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=83a52af2-f524-4ec5-9155-717cbe5d25ed&DisplayLang=en

and this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=dc6c00cb-738A-4B97-8910-5cd29ab5f8d9&DisplayLang=en

Thanks,

Laxmi

|||Consider that SQL Compact is designed to be used "Everywhere" shouldn't you spend a little time designing a device to desktop 1-to-1 sync capability?

Thanks!

Mike|||

I was getting the same message...

"Error retrieving information from user datastore. Platform not found."

... when opening the solution, until I added the WM5 SDK to my machine that alrady had VS2005 Sp1 on it.

However...

The ADS Wizard doesn't seem to be working at all.

My WM5 PPC phone has CF2, SQL CE 3, and the ADS Wizard. All installed without a problem. Laptop's Access 2003 is at SP2. Northwinds file is in c:\

When I go to the phone and connect to the access DB, it returns "Unspecified error [sqlceca30.dll]"

We are terribly interested in understanding more, and would like to see this working.

Anyone?

Cheers

|||

|||Hi!

Have you added a firewall exception for the default port 1024 which ADS uses for communocating with the device? If not, adding the exception should solve your problem

|||

Regards,

Roberto.

Access Database Synchronizer (ADS)

Hi All,

Access Database Synchronizer provides a way to synchronize data between Microsoft Access database on a desktop and Microsoft SQL Server 2005 Everywhere Edition database on a device.

For more details you can visit our blog - http://blogs.msdn.com/sqlservereverywhere/archive/2006/08/29/729730.aspx

Thanks,

Manish

Manish Agnihotri, Program Manager, SQL Server 2005 Everywhere Edition

Good news. But I want to know wherether this ADS can sync over air (Wi-Fi / TCP/IP) by Dll ?

Thanks

|||

Great news but what about SQL Express

Most serious developers dont touch Access

1. Can we modify this to access sql express

2. Or can we do SQL Everywhere synch to another SQL Everywhere database

Thanks

|||

No, you cannot sync over the air. One needs to establish a USB Active sync connection to sync

Regards

Manish

|||

Regards

Manish

|||

It is so strange that I can't use this tool to convert Access database into SQL mobile database?

I can't find any "Destop Data Sync Wizard" under Start--> Programs. (the readme file tells me to look for this)

The file I installed is SyncWithAccess-EN.msi

|||

Finally, after looked through the posts here, I understand now, I need to compile that sample program then use it. But when I try to open the project, it prompts me an error:

Error retrieving information from user datastore. Platform not found.

Then it said:

The project could not be opened because it refers to a device platform that does not exist in your datastore.

I already installed the WM5 Emulator, when I tried to use Visual Studio to connect to the "WM5 Device", it said sucessfully connected.

I don't have a WM5 PDA yet. The Visual Studio.net 2005 product I installed includes: VB, C#, VC++. I never used C# or VC++ though.

Can anyone tell me what is wrong?

Thanks!

|||

Try installing this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=83a52af2-f524-4ec5-9155-717cbe5d25ed&DisplayLang=en

and this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=dc6c00cb-738A-4B97-8910-5cd29ab5f8d9&DisplayLang=en

Thanks,

Laxmi

|||Consider that SQL Compact is designed to be used "Everywhere" shouldn't you spend a little time designing a device to desktop 1-to-1 sync capability?

Please let us know if SQL Compact > SQL Compact sync is in the works.|||
Is

there any chance that we could see a sample app or sample code

demonstrating how one might go about creating "Custom Desktop Sync App"

using ADS? There is a very brief explanation on how to do it on the

ADS Readme file which says something about using “ssevas31.dll" and the

ListenSyncRequest but I have not been successful in figuring it out.

Thanks!

Mike|||

I was getting the same message...

"Error retrieving information from user datastore. Platform not found."

... when opening the solution, until I added the WM5 SDK to my machine that alrady had VS2005 Sp1 on it.

However...

The ADS Wizard doesn't seem to be working at all.

My WM5 PPC phone has CF2, SQL CE 3, and the ADS Wizard. All installed without a problem. Laptop's Access 2003 is at SP2. Northwinds file is in c:\

When I go to the phone and connect to the access DB, it returns "Unspecified error [sqlceca30.dll]"

We are terribly interested in understanding more, and would like to see this working.

Anyone?

Cheers

|||

|||Hi!

Have you added a firewall exception for the default port 1024 which ADS uses for communocating with the device? If not, adding the exception should solve your problem

|||

Regards,

Roberto.

Access Database Synchronizer (ADS)

Hi All,

Access Database Synchronizer provides a way to synchronize data between Microsoft Access database on a desktop and Microsoft SQL Server 2005 Everywhere Edition database on a device.

For more details you can visit our blog - http://blogs.msdn.com/sqlservereverywhere/archive/2006/08/29/729730.aspx

Thanks,

Manish

Manish Agnihotri, Program Manager, SQL Server 2005 Everywhere Edition

Good news. But I want to know wherether this ADS can sync over air (Wi-Fi / TCP/IP) by Dll ?

Thanks

|||

Great news but what about SQL Express

Most serious developers dont touch Access

1. Can we modify this to access sql express

2. Or can we do SQL Everywhere synch to another SQL Everywhere database

Thanks

|||

No, you cannot sync over the air. One needs to establish a USB Active sync connection to sync

Regards

Manish

|||

Regards

Manish

|||

It is so strange that I can't use this tool to convert Access database into SQL mobile database?

I can't find any "Destop Data Sync Wizard" under Start--> Programs. (the readme file tells me to look for this)

The file I installed is SyncWithAccess-EN.msi

|||

Finally, after looked through the posts here, I understand now, I need to compile that sample program then use it. But when I try to open the project, it prompts me an error:

Error retrieving information from user datastore. Platform not found.

Then it said:

The project could not be opened because it refers to a device platform that does not exist in your datastore.

I already installed the WM5 Emulator, when I tried to use Visual Studio to connect to the "WM5 Device", it said sucessfully connected.

I don't have a WM5 PDA yet. The Visual Studio.net 2005 product I installed includes: VB, C#, VC++. I never used C# or VC++ though.

Can anyone tell me what is wrong?

Thanks!

|||

Try installing this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=83a52af2-f524-4ec5-9155-717cbe5d25ed&DisplayLang=en

and this:

http://www.microsoft.com/downloads/details.aspx?FamilyID=dc6c00cb-738A-4B97-8910-5cd29ab5f8d9&DisplayLang=en

Thanks,

Laxmi

|||Consider that SQL Compact is designed to be used "Everywhere" shouldn't you spend a little time designing a device to desktop 1-to-1 sync capability?

Please let us know if SQL Compact > SQL Compact sync is in the works.|||
Is

there any chance that we could see a sample app or sample code

demonstrating how one might go about creating "Custom Desktop Sync App"

using ADS? There is a very brief explanation on how to do it on the

ADS Readme file which says something about using “ssevas31.dll" and the

ListenSyncRequest but I have not been successful in figuring it out.

Thanks!

Mike|||

I was getting the same message...

"Error retrieving information from user datastore. Platform not found."

... when opening the solution, until I added the WM5 SDK to my machine that alrady had VS2005 Sp1 on it.

However...

The ADS Wizard doesn't seem to be working at all.

My WM5 PPC phone has CF2, SQL CE 3, and the ADS Wizard. All installed without a problem. Laptop's Access 2003 is at SP2. Northwinds file is in c:\

When I go to the phone and connect to the access DB, it returns "Unspecified error [sqlceca30.dll]"

We are terribly interested in understanding more, and would like to see this working.

Anyone?

Cheers

|||

|||Hi!

Have you added a firewall exception for the default port 1024 which ADS uses for communocating with the device? If not, adding the exception should solve your problem

|||

Regards,

Roberto.

Access database connection

I am running Visual Studios 2005 enterprise edition and I am creating a mobile application to keep track of some receipts. The problem I'm currently having is that even though I can connect to the MS Access Database with Server Explorer that I'll be aquiring data from; Everytime I attempt to use the Data Configuration Wizard to add a new data source that namely the database I get this error message:

The new connection uses a data provider that is not supported. (end of message)

There is no username or password necessary to access this database and it is an Access 2003 database.

Any help would be greatly appreciated.

Just to make sure...

You did change the Data Source to:

Microsoft Access Database File (OLE DB)

Which will use the following .NET Data Provider:

.NET Framework Data Provider for OLE DB

I assume you did in order to select the database, but I just want to make sure.

And when you click the button "Test Connection", it gives you that error?

Regards,

Dave

|||

Well that is the default settings so I just left those as they were and once I had figured out how to connect to the database thru server explorer, whenever I hit the test connection it said Connection ok. However the error message pops up when I attempt to add the database thru the add new datasource wizard.

|||Perhaps I'm missing something, but didn't you say this was a mobile app? Isn't the reason that VS is refusing to use the data source simply because the JET database engine doesn't run on mobile devices? -- Brendan Reynolds Access MVP wrote in message news:b986531d-b456-4194-af38-649f7db26f0d@.discussions.microsoft.com... >I am running Visual Studios 2005 enterprise edition and I am creating a
> mobile application to keep track of some receipts. The problem I'm
> currently having is that even though I can connect to the MS Access
> Database with Server Explorer that I'll be aquiring data from; Everytime
> I attempt to use the Data Configuration Wizard to add a new data source
> that namely the database I get this error message: >
> The new connection uses a data provider that is not supported. (end of
> message) >
> There is no username or password necessary to access this database and
> it is an Access 2003 database. >
> Any help would be greatly appreciated. >
>|||

To: Mr. Reynolds
I have no idea sir, I started the project as a smart device app, and in all the walkthroughs I have viewed nothing has been said about the Jet database engine being incompatible with mobile devices. If this is the case I'd like to know because this project is currently dependent on VS being able to connect with our Access database.

|||

I'm not sure of the limitations, you're best asking at the SQL Mobile Forum.

http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=152&SiteID=1

Am moving this thread to there.

Here's some info on SQL Server 2005 Mobile Edition

http://msdn.microsoft.com/sql/mobile/default.aspx

Alex.

|||The JET database engine runs only on desktop and server versions of Windows. It's certainly possible to develop a mobile web app that talks to a JET database on the server, but if you need a local data store on the mobile device that will remain available when the device is not connected to the network, then you will not be able to use JET. Your alternatives - as I understand it - include SQL Server CE and XML. There is a database engine on the Pocket PC called 'Pocket Access' but it has very little to do with the desktop product, and there is no built-in support for 'Pocket Access' in the .NET framework. There is, however, a third-party component you could look at. There's an article on this at the URL below, and there's a link from the article to the vendor of the third-party component. Note that I haven't personally used this, and I don't know what plans, if any, Microsoft has to continue to support 'Pocket Access'. So this isn't a recommendation, just something that may be worth further investigation. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnroad/html/road10222003.asp There's an interesting article on 'Data Access Strategies for the Microsoft ..NET Compact Framework' at the following URL. Although the article dates back to the .NET 1.0 timeframe, I believe it is still relevant. http://msdn.microsoft.com/mobility/understanding/articles/default.aspx?pull=/library/en-us/dnnetcomp/html/dataaccessstrategy.asp -- Brendan Reynolds Access MVP wrote in message news:703e94a5-811d-4486-927c-34c62b34dc36_WBRev1_@.discussions.microsoft.com...
> This post has been edited either by the author or a moderator in the
> Microsoft Forums: http://forums.microsoft.com
> To: Mr. Reynolds
> I have no idea sir, I started the project as a smart device app, and in
> all the walkthroughs I have viewed nothing has been said about the Jet
> database engine being incompatible with mobile devices. If this is the
> case I'd like to know because this project is currently dependent on VS
> being able to connect with our Access database. > > > >
>|||Thank you for the information. Unfortunately I have a follow up question. If I were to make an intermediate SQL database to function as the go between for a SQL Mobile database and a Microsoft access database, is such a solution even possible? Our organization recently purchased VS 2005 on the assumption that it would be easy to use the .NET framework to develop a mobile app that would easily transfer data to an access database. Now with this new information its quite possible the data will go SQL Mobile -> SQL Database -> MS Access database.
Footnote:
The SQL Database would just function as a temporary store to check data generated from receipts made in the mobile database. Once the checks are done the corrected data would be passed to the MS Access database. Then the SQL database would wipe itself clean.
|||

Yes, but it makes no sense. To accomplish that you would have to purchase SQL 2000/2005 and pay CALs per device (or per CPU license). If that’s acceptable, simply get rid of Access and use much more powerful SQL you've paid for.

Alternative solution is to use Web Service to talk to Access database. Create couple WEB methods to talk to access and call them from device. Something like this should do:

DataSet GetAccessData(String command, …)

{

// Connect to Access DB here, execute command and populate data set with returned data.

return dataSet;

}

Bool UpdateAccessData(DataSet dataSet, … )

{

// Connect to Access DB here and update DB with data from Data Set.

return success;

}

|||To: Ilya
The enterprise edition that we purchased of VBS 2005 came with SQL server 2005 and I just installed it upon learning that I can't communicate directly with the Access database. I'm not sure if we still have to pay the CALS per device though.
If I used these web service methods where would I write them? In the upload and download portion of the code for the mobile app?
|||

I believe it comes with 5 CALs (to be verified).

These WS methods would run on desktop via IIS which would host WS. To create them, please click ‘Create/Web Site’ and choose "ASP.Net Web Service". You'll get project skeleton, simply add code you need and run it. Decorate added methods with WebMethod attribute. This is desktop project, so you could use anything desktop has to offer.

Calling WS from device pretty much looks like a normal function call. All necessary code would be created for you automatically as soon as you add Web Reference to your project.

|||i want to connecting Access database on PDA ?
i am setting Access database on PDA..
can i do ?
and how i doing?|||How would one connect to an access database inside the web method?
|||

while the .NET Compact Framework has no APIs to leverage Access databases, there is an open source set of APIs that support Access at www.opennetcf.org

there are also some commercial libraries available - use Google Advanced Groups search on microsoft.public.dotnet.framework.compactframework and look for "Access Database"

Darren

Thursday, March 29, 2012

Access Denied Error attaching an existing MDF

Tuesday, March 27, 2012

Access Database Synchronizer (ADS)

Access Database Synchronizer (ADS)

Access Database Synchronizer (ADS)

Access Database Synchronizer (ADS)

Access Database Synchronizer (ADS)

Access Database Synchronizer (ADS)

Access Database Synchronizer (ADS)

Access Database Synchronizer (ADS)

Access Database Synchronizer (ADS)

Access Database Synchronizer (ADS)

Access Database Synchronizer (ADS)

Access database connection

SQL About AMO

Blog Archive

About Me