Showing posts with label everywhere. Show all posts
Showing posts with label everywhere. Show all posts

Thursday, March 8, 2012

Can I use VB.NET 2003 with SQL Everywhere?

Hi,

Can I use VB.NET 2003 with SQL Everywhere on desktop?
Is it possible to create and populate data into .sdf with VB.NET 2003?
Please advice, thank you very much.

Best Regards,
Gabriel

I would like to know also...

I am having problem with reference System.Data.SqlServerCe.dll

Not valid assembly or COM component. VS 2003 C#?

Thanks

|||

No, SQL Mobile and SQL Everywhere require the 2.0 versions of .NET assemblies and Visual Studio 2005 (hence VB.NET 2005).

Darren

Can I use VB.NET 2003 with SQL Everywhere?

Hi,

Can I use VB.NET 2003 with SQL Everywhere on desktop?
Is it possible to create and populate data into .sdf with VB.NET 2003?
Please advice, thank you very much.

Best Regards,
Gabriel

I would like to know also...

I am having problem with reference System.Data.SqlServerCe.dll

Not valid assembly or COM component. VS 2003 C#?

Thanks

|||

No, SQL Mobile and SQL Everywhere require the 2.0 versions of .NET assemblies and Visual Studio 2005 (hence VB.NET 2005).

Darren

Wednesday, March 7, 2012

Can I use SQL Server Management Studio Express to work with SQL Server Everywhere?

Can I use SQL Server Management Studio Express to work with this...SQL Server Everywhere?

I bought VS2005 Pro and installed everything, including the Developers edition of SQL Server 2005.
I would love to play with this and try converting old Access desktop applications.
Unfortunately I am unsure how to create and modify a new database for SQL Server Everywhere using SSMSE.

I have several tables that have a thousand records or so used for ‘Look-Up’ tables and really need a way to import those tables.

Working within VS2005 and manually creating tables just isn’t cutting the mustard here…

What can I do?

no, you cannot work with SQL Mobile databases in SQL Express Mgmt Studio. if you have Access databases to convert over, have a look at the tools at www.primeworks.pt

Darren

|||Thanks Darren,

Hopefully Microsoft will come out with a GUI tool to help create / manage / structure SQL Server Everywhere databases and be available to Developers at no additional cost.
|||

Hey Rick and Darren,

Yes we are working on integrating SQL Server Everywhere with SQL Server Management Studio Express. However, I can not give out the timelines here.

Sweet news is not it!

Thanks,

Laxmi Narsimha Rao ORUGANTI, SQL Server Everywhere, Microsoft Corporation

|||

I have published today a new (still "Beta") version of SQL CE Console (I will change this name in the future, it's a promise!) that allows you to open and edit SDF files on the desktop. You just have to install the Everywhere CTP (or the desktop SQL Mobile bits in VS 2005, if your license allows) and you are off. Get the beta from this link:

http://www.primeworks-mobile.com/News/SCC_1.2.500Beta.html

Enjoy!

BTW: Feature suggestions are welcome!

|||

Hello Guys,

1) Think its important to hae SQL Server Management Studio Express to work with SQL Server Everywhere.

2) In the meantime, can anyone advise how to convert an existing SQL Server express database to a SQL Server Everywhere?

regards

|||

Check my site for database conversion tools:

www.primeworks-mobile.com

|||

Hi,

I did, but there is an error on using the tool "Cannot open Dataport"

regards

|||Please use the site's support forum to discuss this issue.

Sunday, February 19, 2012

Can I run the SQL Server 2005 Developer Edition in Standard Edition Mode?

As an ISV, I want to certify my product on Standard Edition. I am using Developer Edition everywhere. Is there a way I can do the certification using the Developer Edition, or do I need to obtain/purchase a copy of the Standard Edition?

I think you're asking if there's some way to temporarily turn off features in the Dev Edition that aren't available in the Standard Edition. That's an interesting idea but it's not something we support directly in SQL Server 2005. To absolutely insure that you didn't include any non-STD features in your app or to get precise STD performance/footprint characteristics, I guess you need a copy of STD.

Paul

|||

>> I guess you need a copy of STD.

Which Sexually Transmitted Disease does he need? (That's the common meaning of the acronym STD).

It may be a bit too late now, but fwiw, everybody who attended the VS.2005 product launch (in November 2005) came away with a real licensed copy of SQL Server 2005 Standard Edition. If you know of someone who was there, perhaps you can persuade them to clap a copy into your hands.

Josh

Can I run the SQL Server 2005 Developer Edition in Standard Edition Mode?

As an ISV, I want to certify my product on Standard Edition. I am using Developer Edition everywhere. Is there a way I can do the certification using the Developer Edition, or do I need to obtain/purchase a copy of the Standard Edition?

I think you're asking if there's some way to temporarily turn off features in the Dev Edition that aren't available in the Standard Edition. That's an interesting idea but it's not something we support directly in SQL Server 2005. To absolutely insure that you didn't include any non-STD features in your app or to get precise STD performance/footprint characteristics, I guess you need a copy of STD.

Paul

|||

>> I guess you need a copy of STD.

Which Sexually Transmitted Disease does he need? (That's the common meaning of the acronym STD).

It may be a bit too late now, but fwiw, everybody who attended the VS.2005 product launch (in November 2005) came away with a real licensed copy of SQL Server 2005 Standard Edition. If you know of someone who was there, perhaps you can persuade them to clap a copy into your hands.

Josh

Can I run the SQL Server 2005 Developer Edition in Standard Edition Mode?

As an ISV, I want to certify my product on Standard Edition. I am using Developer Edition everywhere. Is there a way I can do the certification using the Developer Edition, or do I need to obtain/purchase a copy of the Standard Edition?

I think you're asking if there's some way to temporarily turn off features in the Dev Edition that aren't available in the Standard Edition. That's an interesting idea but it's not something we support directly in SQL Server 2005. To absolutely insure that you didn't include any non-STD features in your app or to get precise STD performance/footprint characteristics, I guess you need a copy of STD.

Paul

|||

>> I guess you need a copy of STD.

Which Sexually Transmitted Disease does he need? (That's the common meaning of the acronym STD).

It may be a bit too late now, but fwiw, everybody who attended the VS.2005 product launch (in November 2005) came away with a real licensed copy of SQL Server 2005 Standard Edition. If you know of someone who was there, perhaps you can persuade them to clap a copy into your hands.

Josh