I haven't found the link on the Microsoft site for downloading Compact 3.5
SP1.
We are replicating with SQL Server 2008 and *need* 3.5 SP1. I think Compact
3.5 SP1 is installed with SQL Server 2008 but I was hoping to find a link
on the Microsoft site to download it. The only link available is for
downloading Compact 3.5 (without SP1).
Thanks
Tom Baxter
It seems Comapct 3.5 SP1 is currently in beta. It is available with the
November, 2007 CTP of SQL Server 2008. You can find the installation in:
\servers\setup\SSCERunTime.msi of the SQL Server 2008 installtion image.
Incidentally, SQL Server 2008 will replicate just fine with either SQL
Server Compact 3.5 RTM *OR* SQL Server Compact 3.5 SP1 Beta.
Tom Baxter
"Tom Baxter" wrote:
> I haven't found the link on the Microsoft site for downloading Compact 3.5
> SP1.
> We are replicating with SQL Server 2008 and *need* 3.5 SP1. I think Compact
> 3.5 SP1 is installed with SQL Server 2008 but I was hoping to find a link
> on the Microsoft site to download it. The only link available is for
> downloading Compact 3.5 (without SP1).
> Thanks
> --
> Tom Baxter
Showing posts with label compact. Show all posts
Showing posts with label compact. Show all posts
Thursday, March 22, 2012
Compact 3.5 SP1 "LoadProperties()" Thows Exception
Hi all,
I have SQL Server 2008 (Nov. CTP) as a publisher and a SQL Server Compact
3.5 SP1 as a client for merge replication.
The Compact database has two subscriptions. The synchronization worked
perfectly many times. If I look at the Compact database in Management Studio
I can see my subscriptions in the Replication folder.
Everything looked so promising.....until I added a call to
"SqlCeReplication.LoadProperties()". At this point I see an error that simply
says, "Unhandled Exception: The subscription could not be loaded because it
was not saved.".
In doing some research it turns out this is error:
SSCE_M_SUBSCRIPTIOWASNOTSAVED
described here: http://technet.microsoft.com/en-us/library/ms172898.aspx
The web page indicates:
"If the error appears again, you should immediately contact Microsoft
Product Support Services. The internal errors cannot be resolved by common
troubleshooting techniques."
Which is why I am posting here. Hopefully someone from Microsoft can
respond. The relevant code is listed here:
SqlCeReplication repl = new SqlCeReplication();
repl.Publisher = @."AOS-LAPASO-4\AOS_1";
repl.PublisherDatabase = @."RepTest";
repl.SubscriberConnectionString = @."Data Source=""C:\test.sdf"";Max Database
Size=128;Default Lock Escalation =100;";
repl.Publication = @."TestPub";
Console.WriteLine("LoadProperties: " + repl.LoadProperties());
Thanks very much.
Tom Baxter
Hi Tom,
Appreciate your understanding that our MSDN newsgroups are not very good at
handling such issue since this issue is an internal error and dump analysis
would be required in this case. We recommended that you contact Microsoft
Product Support Services (PSS) via telephone so that a dedicated Support
professional can assist you in a more efficient manner. Please be advised
that contacting phone support will be a charged call.
To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
If you have any other questions or concerns, please feel free to let us
know. Have a good day!
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
sql
I have SQL Server 2008 (Nov. CTP) as a publisher and a SQL Server Compact
3.5 SP1 as a client for merge replication.
The Compact database has two subscriptions. The synchronization worked
perfectly many times. If I look at the Compact database in Management Studio
I can see my subscriptions in the Replication folder.
Everything looked so promising.....until I added a call to
"SqlCeReplication.LoadProperties()". At this point I see an error that simply
says, "Unhandled Exception: The subscription could not be loaded because it
was not saved.".
In doing some research it turns out this is error:
SSCE_M_SUBSCRIPTIOWASNOTSAVED
described here: http://technet.microsoft.com/en-us/library/ms172898.aspx
The web page indicates:
"If the error appears again, you should immediately contact Microsoft
Product Support Services. The internal errors cannot be resolved by common
troubleshooting techniques."
Which is why I am posting here. Hopefully someone from Microsoft can
respond. The relevant code is listed here:
SqlCeReplication repl = new SqlCeReplication();
repl.Publisher = @."AOS-LAPASO-4\AOS_1";
repl.PublisherDatabase = @."RepTest";
repl.SubscriberConnectionString = @."Data Source=""C:\test.sdf"";Max Database
Size=128;Default Lock Escalation =100;";
repl.Publication = @."TestPub";
Console.WriteLine("LoadProperties: " + repl.LoadProperties());
Thanks very much.
Tom Baxter
Hi Tom,
Appreciate your understanding that our MSDN newsgroups are not very good at
handling such issue since this issue is an internal error and dump analysis
would be required in this case. We recommended that you contact Microsoft
Product Support Services (PSS) via telephone so that a dedicated Support
professional can assist you in a more efficient manner. Please be advised
that contacting phone support will be a charged call.
To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
If you have any other questions or concerns, please feel free to let us
know. Have a good day!
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
sql
Replicating Between Server 2008 and Compact 3.5 ?
Hi all,
I'm sorry for two quick back to back questions.
I want to set up a publication on SQL Server 2008 for a Compact 3.5 client.
The SQL Server Comapct 3.5 BOL
(ms-help://MS.SSC.v35/MS.SSC.v35.EN/sscmain/html/b5ffa86b-03da-4427-b340-9f53dc22c8a9.htm)
indicates I should set the "Subscriber Type" to "SQL Server Compact 3.5" when
using the Publication Wizard. Unfortunately, the "Subscriber Types" page of
the wizard does not allow me to create a subscription for Compact 3.5. I can
create a subscription for SQL Server 2005 Compact Edition but not for Compact
3.5 -- the option is simply not there.
Is there something special I need to do to get the Compact 3.5 option to
appear in the Publication Wizard?
thanks much.
Tom Baxter
Hello Tom,
I think it's a BOL issue since it's not updated when the SQL Server Comapct
3.5 is released. SQL Server 2005 Compact Edition (new version) is the
released name of SQL Server compact 3.5.
SQL Server Compact 3.5 Features Datasheet (Datasheet)
http://download.microsoft.com/download/7/f/c/7fc20778-4e2e-4944-b432-ed74b40
4e542/sqlservercompactdatasheet_final.doc
You just choose "SQL Server 2005 Compact Edition" in publication wizard.
I have forwarded your feedback on this to the proper channel. Also, I
encourage you submit via the link below and our product team would like to
hear your voice:
http://lab.msdn.microsoft.com/productfeedback/default.aspx
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Thank you, Peter.
Tom Baxter
""Peter Yang[MSFT]"" wrote:
> Hello Tom,
> I think it's a BOL issue since it's not updated when the SQL Server Comapct
> 3.5 is released. SQL Server 2005 Compact Edition (new version) is the
> released name of SQL Server compact 3.5.
>
> SQL Server Compact 3.5 Features Datasheet (Datasheet)
> http://download.microsoft.com/download/7/f/c/7fc20778-4e2e-4944-b432-ed74b40
> 4e542/sqlservercompactdatasheet_final.doc
> You just choose "SQL Server 2005 Compact Edition" in publication wizard.
> I have forwarded your feedback on this to the proper channel. Also, I
> encourage you submit via the link below and our product team would like to
> hear your voice:
> http://lab.msdn.microsoft.com/productfeedback/default.aspx
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||""Peter Yang[MSFT]"" wrote:
> Hello Tom,
> I think it's a BOL issue since it's not updated when the SQL Server Comapct
> 3.5 is released. SQL Server 2005 Compact Edition (new version) is the
> released name of SQL Server compact 3.5.
Peter, Are you sure about this?
Take a look at this page:
http://www.microsoft.com/downloads/details.aspx?FamilyID=85E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en
This page provides the download for SQL Server Compact 2005 but the "Quick
Details" section of the page indicates version 3.1.
Now, take a look at this page:
http://www.microsoft.com/downloads/details.aspx?&FamilyID=7849b34f-67ab-481f-a5a5-4990597b0297&DisplayLang=en
This page provides the download for SQL Server Compact 3.5 but the "Quick
Details" section of the page indicates version 3.5.5386.0.
I'm confused. Are you sure SQL Server Comapct 2005 is the release name for
SQL Server 3.5? If so, how do you account for the version number differences?
Thank you very much.
> SQL Server Compact 3.5 Features Datasheet (Datasheet)
> http://download.microsoft.com/download/7/f/c/7fc20778-4e2e-4944-b432-ed74b40
> 4e542/sqlservercompactdatasheet_final.doc
> You just choose "SQL Server 2005 Compact Edition" in publication wizard.
> I have forwarded your feedback on this to the proper channel. Also, I
> encourage you submit via the link below and our product team would like to
> hear your voice:
> http://lab.msdn.microsoft.com/productfeedback/default.aspx
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||As a follow up, here is more "evidence" that 3.5 is newer than SQL Server
2005 Compact:
http://msdn2.microsoft.com/en-us/sqlserver/bb204609.aspx
Here's a quote from this page:
SQL Server 2005 Compact Edition is the earlier version of SQL Server Compact
3.5 and was previously named SQL Server 2005 Everywhere Edition during the
product development phase.
So, it looks like version 3.5 is NOT the release name of SQL Server 2005
Compact.
Tom Baxter
"Tom Baxter" wrote:
[vbcol=seagreen]
> ""Peter Yang[MSFT]"" wrote:
>
> Peter, Are you sure about this?
> Take a look at this page:
> http://www.microsoft.com/downloads/details.aspx?FamilyID=85E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en
> This page provides the download for SQL Server Compact 2005 but the "Quick
> Details" section of the page indicates version 3.1.
> Now, take a look at this page:
> http://www.microsoft.com/downloads/details.aspx?&FamilyID=7849b34f-67ab-481f-a5a5-4990597b0297&DisplayLang=en
> This page provides the download for SQL Server Compact 3.5 but the "Quick
> Details" section of the page indicates version 3.5.5386.0.
> I'm confused. Are you sure SQL Server Comapct 2005 is the release name for
> SQL Server 3.5? If so, how do you account for the version number differences?
> Thank you very much.
>
|||Hello Tom,
Sorry for the late response. I agree with you that SQL Server 2005 Compact
Edition is the earlier version of SQL Server Compact 3.5 so I mentioned SQL
Server 2005 Compact Edition (new version) in my reply. However, I still
think this subscriber type SQL Server 2005 Compact should be choosen if you
want to replicate with SQL Server Compact 3.5.
I will contact developer team to see if they have more explanation for
this. Also, do you encounter any actual error if you use this subscriber
type? Actually, from my test machine I saw "SQL Server 2005 Everywhere
Edition" in subscriber type dialog.
Did you install Microsoft SQL Server Compact 3.5 Server Tools? Which SQL
Server verion do you use? Do you use SQL server 2005 or 2008 CTP?
In addition, will you please get a screen shot of the subscriber typ
selection dialog and send it to me at petery@.microsoft.com? Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
================================================== ===
When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Peter,
I've done more research sinc emy original posting. We are synchronizing with
SQL Server 2008 and from what I read
(http://blogs.msdn.com/sqlservercompact/) we *MUST* use SQL Compact 3.5 SP1.
We *CANNOT* replicate compact 3.5 with SQL Server 2008.
So, at this point I am looking for the SP1 download. It does not sema to be
available from the Microsoft site (although Compact 3.5 SP1 *IS* installed as
part of SQL Server 2008).
Tom Baxter
""Peter Yang[MSFT]"" wrote:
> Hello Tom,
> Sorry for the late response. I agree with you that SQL Server 2005 Compact
> Edition is the earlier version of SQL Server Compact 3.5 so I mentioned SQL
> Server 2005 Compact Edition (new version) in my reply. However, I still
> think this subscriber type SQL Server 2005 Compact should be choosen if you
> want to replicate with SQL Server Compact 3.5.
> I will contact developer team to see if they have more explanation for
> this. Also, do you encounter any actual error if you use this subscriber
> type? Actually, from my test machine I saw "SQL Server 2005 Everywhere
> Edition" in subscriber type dialog.
> Did you install “Microsoft SQL Server Compact 3.5 Server Tools”? Which SQL
> Server verion do you use? Do you use SQL server 2005 or 2008 CTP?
> In addition, will you please get a screen shot of the subscriber typ
> selection dialog and send it to me at petery@.microsoft.com? Thanks.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> ================================================== ===
> When responding to posts, please "Reply to Group" via your
> newsreader so that others may learn and benefit from this issue.
> ================================================== ====
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||It seems Comapct 3.5 SP1 is currently in beta. It is available with the
November, 2007 CTP of SQL Server 2008. You can find the installation in:
\servers\setup\SSCERunTime.msi of the SQL Server 2008 installtion image.
Incidentally, SQL Server 2008 will replicate just fine with either SQL
Server Compact 3.5 RTM *OR* SQL Server Compact 3.5 SP1 Beta.
Tom Baxter
"Tom Baxter" wrote:
[vbcol=seagreen]
> Hi Peter,
> I've done more research sinc emy original posting. We are synchronizing with
> SQL Server 2008 and from what I read
> (http://blogs.msdn.com/sqlservercompact/) we *MUST* use SQL Compact 3.5 SP1.
> We *CANNOT* replicate compact 3.5 with SQL Server 2008.
> So, at this point I am looking for the SP1 download. It does not sema to be
> available from the Microsoft site (although Compact 3.5 SP1 *IS* installed as
> part of SQL Server 2008).
> --
> Tom Baxter
>
> ""Peter Yang[MSFT]"" wrote:
|||Hello Tom,
Thank you for your update and your experience should benefit the community!
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
================================================== ===
When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
I'm sorry for two quick back to back questions.
I want to set up a publication on SQL Server 2008 for a Compact 3.5 client.
The SQL Server Comapct 3.5 BOL
(ms-help://MS.SSC.v35/MS.SSC.v35.EN/sscmain/html/b5ffa86b-03da-4427-b340-9f53dc22c8a9.htm)
indicates I should set the "Subscriber Type" to "SQL Server Compact 3.5" when
using the Publication Wizard. Unfortunately, the "Subscriber Types" page of
the wizard does not allow me to create a subscription for Compact 3.5. I can
create a subscription for SQL Server 2005 Compact Edition but not for Compact
3.5 -- the option is simply not there.
Is there something special I need to do to get the Compact 3.5 option to
appear in the Publication Wizard?
thanks much.
Tom Baxter
Hello Tom,
I think it's a BOL issue since it's not updated when the SQL Server Comapct
3.5 is released. SQL Server 2005 Compact Edition (new version) is the
released name of SQL Server compact 3.5.
SQL Server Compact 3.5 Features Datasheet (Datasheet)
http://download.microsoft.com/download/7/f/c/7fc20778-4e2e-4944-b432-ed74b40
4e542/sqlservercompactdatasheet_final.doc
You just choose "SQL Server 2005 Compact Edition" in publication wizard.
I have forwarded your feedback on this to the proper channel. Also, I
encourage you submit via the link below and our product team would like to
hear your voice:
http://lab.msdn.microsoft.com/productfeedback/default.aspx
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Thank you, Peter.
Tom Baxter
""Peter Yang[MSFT]"" wrote:
> Hello Tom,
> I think it's a BOL issue since it's not updated when the SQL Server Comapct
> 3.5 is released. SQL Server 2005 Compact Edition (new version) is the
> released name of SQL Server compact 3.5.
>
> SQL Server Compact 3.5 Features Datasheet (Datasheet)
> http://download.microsoft.com/download/7/f/c/7fc20778-4e2e-4944-b432-ed74b40
> 4e542/sqlservercompactdatasheet_final.doc
> You just choose "SQL Server 2005 Compact Edition" in publication wizard.
> I have forwarded your feedback on this to the proper channel. Also, I
> encourage you submit via the link below and our product team would like to
> hear your voice:
> http://lab.msdn.microsoft.com/productfeedback/default.aspx
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||""Peter Yang[MSFT]"" wrote:
> Hello Tom,
> I think it's a BOL issue since it's not updated when the SQL Server Comapct
> 3.5 is released. SQL Server 2005 Compact Edition (new version) is the
> released name of SQL Server compact 3.5.
Peter, Are you sure about this?
Take a look at this page:
http://www.microsoft.com/downloads/details.aspx?FamilyID=85E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en
This page provides the download for SQL Server Compact 2005 but the "Quick
Details" section of the page indicates version 3.1.
Now, take a look at this page:
http://www.microsoft.com/downloads/details.aspx?&FamilyID=7849b34f-67ab-481f-a5a5-4990597b0297&DisplayLang=en
This page provides the download for SQL Server Compact 3.5 but the "Quick
Details" section of the page indicates version 3.5.5386.0.
I'm confused. Are you sure SQL Server Comapct 2005 is the release name for
SQL Server 3.5? If so, how do you account for the version number differences?
Thank you very much.
> SQL Server Compact 3.5 Features Datasheet (Datasheet)
> http://download.microsoft.com/download/7/f/c/7fc20778-4e2e-4944-b432-ed74b40
> 4e542/sqlservercompactdatasheet_final.doc
> You just choose "SQL Server 2005 Compact Edition" in publication wizard.
> I have forwarded your feedback on this to the proper channel. Also, I
> encourage you submit via the link below and our product team would like to
> hear your voice:
> http://lab.msdn.microsoft.com/productfeedback/default.aspx
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||As a follow up, here is more "evidence" that 3.5 is newer than SQL Server
2005 Compact:
http://msdn2.microsoft.com/en-us/sqlserver/bb204609.aspx
Here's a quote from this page:
SQL Server 2005 Compact Edition is the earlier version of SQL Server Compact
3.5 and was previously named SQL Server 2005 Everywhere Edition during the
product development phase.
So, it looks like version 3.5 is NOT the release name of SQL Server 2005
Compact.
Tom Baxter
"Tom Baxter" wrote:
[vbcol=seagreen]
> ""Peter Yang[MSFT]"" wrote:
>
> Peter, Are you sure about this?
> Take a look at this page:
> http://www.microsoft.com/downloads/details.aspx?FamilyID=85E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en
> This page provides the download for SQL Server Compact 2005 but the "Quick
> Details" section of the page indicates version 3.1.
> Now, take a look at this page:
> http://www.microsoft.com/downloads/details.aspx?&FamilyID=7849b34f-67ab-481f-a5a5-4990597b0297&DisplayLang=en
> This page provides the download for SQL Server Compact 3.5 but the "Quick
> Details" section of the page indicates version 3.5.5386.0.
> I'm confused. Are you sure SQL Server Comapct 2005 is the release name for
> SQL Server 3.5? If so, how do you account for the version number differences?
> Thank you very much.
>
|||Hello Tom,
Sorry for the late response. I agree with you that SQL Server 2005 Compact
Edition is the earlier version of SQL Server Compact 3.5 so I mentioned SQL
Server 2005 Compact Edition (new version) in my reply. However, I still
think this subscriber type SQL Server 2005 Compact should be choosen if you
want to replicate with SQL Server Compact 3.5.
I will contact developer team to see if they have more explanation for
this. Also, do you encounter any actual error if you use this subscriber
type? Actually, from my test machine I saw "SQL Server 2005 Everywhere
Edition" in subscriber type dialog.
Did you install Microsoft SQL Server Compact 3.5 Server Tools? Which SQL
Server verion do you use? Do you use SQL server 2005 or 2008 CTP?
In addition, will you please get a screen shot of the subscriber typ
selection dialog and send it to me at petery@.microsoft.com? Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
================================================== ===
When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Peter,
I've done more research sinc emy original posting. We are synchronizing with
SQL Server 2008 and from what I read
(http://blogs.msdn.com/sqlservercompact/) we *MUST* use SQL Compact 3.5 SP1.
We *CANNOT* replicate compact 3.5 with SQL Server 2008.
So, at this point I am looking for the SP1 download. It does not sema to be
available from the Microsoft site (although Compact 3.5 SP1 *IS* installed as
part of SQL Server 2008).
Tom Baxter
""Peter Yang[MSFT]"" wrote:
> Hello Tom,
> Sorry for the late response. I agree with you that SQL Server 2005 Compact
> Edition is the earlier version of SQL Server Compact 3.5 so I mentioned SQL
> Server 2005 Compact Edition (new version) in my reply. However, I still
> think this subscriber type SQL Server 2005 Compact should be choosen if you
> want to replicate with SQL Server Compact 3.5.
> I will contact developer team to see if they have more explanation for
> this. Also, do you encounter any actual error if you use this subscriber
> type? Actually, from my test machine I saw "SQL Server 2005 Everywhere
> Edition" in subscriber type dialog.
> Did you install “Microsoft SQL Server Compact 3.5 Server Tools”? Which SQL
> Server verion do you use? Do you use SQL server 2005 or 2008 CTP?
> In addition, will you please get a screen shot of the subscriber typ
> selection dialog and send it to me at petery@.microsoft.com? Thanks.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> ================================================== ===
> When responding to posts, please "Reply to Group" via your
> newsreader so that others may learn and benefit from this issue.
> ================================================== ====
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||It seems Comapct 3.5 SP1 is currently in beta. It is available with the
November, 2007 CTP of SQL Server 2008. You can find the installation in:
\servers\setup\SSCERunTime.msi of the SQL Server 2008 installtion image.
Incidentally, SQL Server 2008 will replicate just fine with either SQL
Server Compact 3.5 RTM *OR* SQL Server Compact 3.5 SP1 Beta.
Tom Baxter
"Tom Baxter" wrote:
[vbcol=seagreen]
> Hi Peter,
> I've done more research sinc emy original posting. We are synchronizing with
> SQL Server 2008 and from what I read
> (http://blogs.msdn.com/sqlservercompact/) we *MUST* use SQL Compact 3.5 SP1.
> We *CANNOT* replicate compact 3.5 with SQL Server 2008.
> So, at this point I am looking for the SP1 download. It does not sema to be
> available from the Microsoft site (although Compact 3.5 SP1 *IS* installed as
> part of SQL Server 2008).
> --
> Tom Baxter
>
> ""Peter Yang[MSFT]"" wrote:
|||Hello Tom,
Thank you for your update and your experience should benefit the community!
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
================================================== ===
When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
Errors in Connecting to SQL Server Compact 3.4 ?
underprocessableTom,
Have you tried selecting the database in VS 2008 Data Connections, then
right-click and select Modify Connection, then click the Advanced button to
change the Max Database Size?
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:OIQfX7OQIHA.748@.TK2MSFTNGP04.phx.gbl...
> Hi everyone,
> First, let me apologize for the cross-post. I was really at a loss for the
> proper group.
> I'm using Visual Studio 2008 with a SQL Server Compact 3.5 database.
> Using the VS 2008 "Server Explorer", I wish to add an index on a column in
> my database. I right-click on the table name and select "Table
> Properties". This gives me an error:
> "Index out of range. Must be non-negative and less than the size of the
> collection. Parameter name: index".
> I included a screenshot of the dialog window (e1.jpg).
> Since that didn't work I tried to right-click on the table name and select
> "Edit Table Schema". This gives me an error:
> "The database file is larger than the configured maximum database size.
> This setting takes effect on the first concurrent connection only.
> [Required Max Database Size (in MB; 0 if unknown) = 0]".
> I included a screenshot of the dialog window (e2.jpg).
> The connection string for this database has an entry, "Max Database
> Size=4091" and the size of the physical size of the file is 322 MB.
> So, at this point I am getting these weird errors that are preventing me
> from administering the SQL Server Compact DB.
> Any help would be greatly appreciated.
> Tom
>
>|||Yes, I've done that. (When you say, "Data Connections" I assume you mean the
"Data Connections" node in Server Explorer.)
My "Max Database Size" is listed as 4091.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in mes
sage
news:OTAhvKPQIHA.5524@.TK2MSFTNGP05.phx.gbl...
> Tom,
> Have you tried selecting the database in VS 2008 Data Connections, then
> right-click and select Modify Connection, then click the Advanced button
> to change the Max Database Size?
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:OIQfX7OQIHA.748@.TK2MSFTNGP04.phx.gbl...
>|||Tom,
Are you not able to change the Max Database Size from there? I was able to
change the Max Database Size for one of my SSC 3.5 files, but it wasn't a
big one like yours is.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:%23rJshqYQIHA.1164@.TK2MSFTNGP02.phx.gbl...
> Yes, I've done that. (When you say, "Data Connections" I assume you mean
> the "Data Connections" node in Server Explorer.)
> My "Max Database Size" is listed as 4091.
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:OTAhvKPQIHA.5524@.TK2MSFTNGP05.phx.gbl...
>|||Yes, I *AM* able to change the Max Database Size there but it's already at
the maximum allowed (4091).
I still get the errors, even though the database appears to be configured
for its maximum size.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in mes
sage
news:A4BBC5A2-7626-42D8-B430-B560CB8C9648@.microsoft.com...
> Tom,
> Are you not able to change the Max Database Size from there? I was able to
> change the Max Database Size for one of my SSC 3.5 files, but it wasn't a
> big one like yours is.
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:%23rJshqYQIHA.1164@.TK2MSFTNGP02.phx.gbl...
>|||Tom,
Yes it looks like you're right as the max size is supposed to represent
megabytes. Are you able to open the big database programmaticlly?
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:ObL5RWcQIHA.5264@.TK2MSFTNGP02.phx.gbl...
> Yes, I *AM* able to change the Max Database Size there but it's already at
> the maximum allowed (4091).
> I still get the errors, even though the database appears to be configured
> for its maximum size.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:A4BBC5A2-7626-42D8-B430-B560CB8C9648@.microsoft.com...
>|||Yes, Ginny, I am able to open the database programatically and I am able to
add records to it. The actual database size is only 322 MB.
It's a pretty simple situation. If you are really interested, send me a
private email and I will set up the file on an FTP server and maybe you can
look at it. If you really want to, my email is tlbaxter99 <at> Yahoo ~DOT~
com.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in mes
sage
news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
> Tom,
> Yes it looks like you're right as the max size is supposed to represent
> megabytes. Are you able to open the big database programmaticlly?
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:ObL5RWcQIHA.5264@.TK2MSFTNGP02.phx.gbl...
>|||Tom, please see your email.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:O2pisxlQIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Yes, Ginny, I am able to open the database programatically and I am able
> to add records to it. The actual database size is only 322 MB.
> It's a pretty simple situation. If you are really interested, send me a
> private email and I will set up the file on an FTP server and maybe you
> can look at it. If you really want to, my email is tlbaxter99 <at> Yahoo
> ~DOT~ com.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
>|||Tom Baxter wrote:
> I included a screenshot of the dialog window (e2.jpg).
Side note: this is an old no-no in Usenet (except for groups
with "binaries" in the name, and a handful of self-identified
exceptions). At least these weren't too big, but they eat
resources on every server carrying these groups (from whose
perspective Usenet is a push medium). The preferred alternative
is to either type it up (when practical, as would've been here),
or post the files somewhere else (e.g. web server, binaries group)
and then post a link here.|||Tom,
Thanks for emailing me a download link to your big database. I was able to
reproduce your problem, but I was also able to work around it and
successfully connect to the database using VS 2008 by chaning the Connect
Timeout value to 500 from the default 30.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:O2pisxlQIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Yes, Ginny, I am able to open the database programatically and I am able
> to add records to it. The actual database size is only 322 MB.
> It's a pretty simple situation. If you are really interested, send me a
> private email and I will set up the file on an FTP server and maybe you
> can look at it. If you really want to, my email is tlbaxter99 <at> Yahoo
> ~DOT~ com.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
>
Have you tried selecting the database in VS 2008 Data Connections, then
right-click and select Modify Connection, then click the Advanced button to
change the Max Database Size?
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:OIQfX7OQIHA.748@.TK2MSFTNGP04.phx.gbl...
> Hi everyone,
> First, let me apologize for the cross-post. I was really at a loss for the
> proper group.
> I'm using Visual Studio 2008 with a SQL Server Compact 3.5 database.
> Using the VS 2008 "Server Explorer", I wish to add an index on a column in
> my database. I right-click on the table name and select "Table
> Properties". This gives me an error:
> "Index out of range. Must be non-negative and less than the size of the
> collection. Parameter name: index".
> I included a screenshot of the dialog window (e1.jpg).
> Since that didn't work I tried to right-click on the table name and select
> "Edit Table Schema". This gives me an error:
> "The database file is larger than the configured maximum database size.
> This setting takes effect on the first concurrent connection only.
> [Required Max Database Size (in MB; 0 if unknown) = 0]".
> I included a screenshot of the dialog window (e2.jpg).
> The connection string for this database has an entry, "Max Database
> Size=4091" and the size of the physical size of the file is 322 MB.
> So, at this point I am getting these weird errors that are preventing me
> from administering the SQL Server Compact DB.
> Any help would be greatly appreciated.
> Tom
>
>|||Yes, I've done that. (When you say, "Data Connections" I assume you mean the
"Data Connections" node in Server Explorer.)
My "Max Database Size" is listed as 4091.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in mes
sage
news:OTAhvKPQIHA.5524@.TK2MSFTNGP05.phx.gbl...
> Tom,
> Have you tried selecting the database in VS 2008 Data Connections, then
> right-click and select Modify Connection, then click the Advanced button
> to change the Max Database Size?
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:OIQfX7OQIHA.748@.TK2MSFTNGP04.phx.gbl...
>|||Tom,
Are you not able to change the Max Database Size from there? I was able to
change the Max Database Size for one of my SSC 3.5 files, but it wasn't a
big one like yours is.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:%23rJshqYQIHA.1164@.TK2MSFTNGP02.phx.gbl...
> Yes, I've done that. (When you say, "Data Connections" I assume you mean
> the "Data Connections" node in Server Explorer.)
> My "Max Database Size" is listed as 4091.
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:OTAhvKPQIHA.5524@.TK2MSFTNGP05.phx.gbl...
>|||Yes, I *AM* able to change the Max Database Size there but it's already at
the maximum allowed (4091).
I still get the errors, even though the database appears to be configured
for its maximum size.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in mes
sage
news:A4BBC5A2-7626-42D8-B430-B560CB8C9648@.microsoft.com...
> Tom,
> Are you not able to change the Max Database Size from there? I was able to
> change the Max Database Size for one of my SSC 3.5 files, but it wasn't a
> big one like yours is.
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:%23rJshqYQIHA.1164@.TK2MSFTNGP02.phx.gbl...
>|||Tom,
Yes it looks like you're right as the max size is supposed to represent
megabytes. Are you able to open the big database programmaticlly?
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:ObL5RWcQIHA.5264@.TK2MSFTNGP02.phx.gbl...
> Yes, I *AM* able to change the Max Database Size there but it's already at
> the maximum allowed (4091).
> I still get the errors, even though the database appears to be configured
> for its maximum size.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:A4BBC5A2-7626-42D8-B430-B560CB8C9648@.microsoft.com...
>|||Yes, Ginny, I am able to open the database programatically and I am able to
add records to it. The actual database size is only 322 MB.
It's a pretty simple situation. If you are really interested, send me a
private email and I will set up the file on an FTP server and maybe you can
look at it. If you really want to, my email is tlbaxter99 <at> Yahoo ~DOT~
com.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in mes
sage
news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
> Tom,
> Yes it looks like you're right as the max size is supposed to represent
> megabytes. Are you able to open the big database programmaticlly?
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:ObL5RWcQIHA.5264@.TK2MSFTNGP02.phx.gbl...
>|||Tom, please see your email.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:O2pisxlQIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Yes, Ginny, I am able to open the database programatically and I am able
> to add records to it. The actual database size is only 322 MB.
> It's a pretty simple situation. If you are really interested, send me a
> private email and I will set up the file on an FTP server and maybe you
> can look at it. If you really want to, my email is tlbaxter99 <at> Yahoo
> ~DOT~ com.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
>|||Tom Baxter wrote:
> I included a screenshot of the dialog window (e2.jpg).
Side note: this is an old no-no in Usenet (except for groups
with "binaries" in the name, and a handful of self-identified
exceptions). At least these weren't too big, but they eat
resources on every server carrying these groups (from whose
perspective Usenet is a push medium). The preferred alternative
is to either type it up (when practical, as would've been here),
or post the files somewhere else (e.g. web server, binaries group)
and then post a link here.|||Tom,
Thanks for emailing me a download link to your big database. I was able to
reproduce your problem, but I was also able to work around it and
successfully connect to the database using VS 2008 by chaning the Connect
Timeout value to 500 from the default 30.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:O2pisxlQIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Yes, Ginny, I am able to open the database programatically and I am able
> to add records to it. The actual database size is only 322 MB.
> It's a pretty simple situation. If you are really interested, send me a
> private email and I will set up the file on an FTP server and maybe you
> can look at it. If you really want to, my email is tlbaxter99 <at> Yahoo
> ~DOT~ com.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
>
Errors in Connecting to SQL Server Compact 3.4 ?
Hi everyone,
First, let me apologize for the cross-post. I was really at a loss for the
proper group.
I'm using Visual Studio 2008 with a SQL Server Compact 3.5 database.
Using the VS 2008 "Server Explorer", I wish to add an index on a column in
my database. I right-click on the table name and select "Table Properties".
This gives me an error:
"Index out of range. Must be non-negative and less than the size of the
collection. Parameter name: index".
I included a screenshot of the dialog window (e1.jpg).
Since that didn't work I tried to right-click on the table name and select
"Edit Table Schema". This gives me an error:
"The database file is larger than the configured maximum database size. This
setting takes effect on the first concurrent connection only. [Required Max
Database Size (in MB; 0 if unknown) = 0]".
I included a screenshot of the dialog window (e2.jpg).
The connection string for this database has an entry, "Max Database
Size=4091" and the size of the physical size of the file is 322 MB.
So, at this point I am getting these weird errors that are preventing me
from administering the SQL Server Compact DB.
Any help would be greatly appreciated.
Tom
Tom,
Have you tried selecting the database in VS 2008 Data Connections, then
right-click and select Modify Connection, then click the Advanced button to
change the Max Database Size?
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:OIQfX7OQIHA.748@.TK2MSFTNGP04.phx.gbl...
> Hi everyone,
> First, let me apologize for the cross-post. I was really at a loss for the
> proper group.
> I'm using Visual Studio 2008 with a SQL Server Compact 3.5 database.
> Using the VS 2008 "Server Explorer", I wish to add an index on a column in
> my database. I right-click on the table name and select "Table
> Properties". This gives me an error:
> "Index out of range. Must be non-negative and less than the size of the
> collection. Parameter name: index".
> I included a screenshot of the dialog window (e1.jpg).
> Since that didn't work I tried to right-click on the table name and select
> "Edit Table Schema". This gives me an error:
> "The database file is larger than the configured maximum database size.
> This setting takes effect on the first concurrent connection only.
> [Required Max Database Size (in MB; 0 if unknown) = 0]".
> I included a screenshot of the dialog window (e2.jpg).
> The connection string for this database has an entry, "Max Database
> Size=4091" and the size of the physical size of the file is 322 MB.
> So, at this point I am getting these weird errors that are preventing me
> from administering the SQL Server Compact DB.
> Any help would be greatly appreciated.
> Tom
>
>
|||Yes, I've done that. (When you say, "Data Connections" I assume you mean the
"Data Connections" node in Server Explorer.)
My "Max Database Size" is listed as 4091.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in message
news:OTAhvKPQIHA.5524@.TK2MSFTNGP05.phx.gbl...
> Tom,
> Have you tried selecting the database in VS 2008 Data Connections, then
> right-click and select Modify Connection, then click the Advanced button
> to change the Max Database Size?
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:OIQfX7OQIHA.748@.TK2MSFTNGP04.phx.gbl...
>
|||Tom,
Are you not able to change the Max Database Size from there? I was able to
change the Max Database Size for one of my SSC 3.5 files, but it wasn't a
big one like yours is.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:%23rJshqYQIHA.1164@.TK2MSFTNGP02.phx.gbl...
> Yes, I've done that. (When you say, "Data Connections" I assume you mean
> the "Data Connections" node in Server Explorer.)
> My "Max Database Size" is listed as 4091.
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:OTAhvKPQIHA.5524@.TK2MSFTNGP05.phx.gbl...
>
|||Yes, I *AM* able to change the Max Database Size there but it's already at
the maximum allowed (4091).
I still get the errors, even though the database appears to be configured
for its maximum size.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in message
news:A4BBC5A2-7626-42D8-B430-B560CB8C9648@.microsoft.com...
> Tom,
> Are you not able to change the Max Database Size from there? I was able to
> change the Max Database Size for one of my SSC 3.5 files, but it wasn't a
> big one like yours is.
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:%23rJshqYQIHA.1164@.TK2MSFTNGP02.phx.gbl...
>
|||Tom,
Yes it looks like you're right as the max size is supposed to represent
megabytes. Are you able to open the big database programmaticlly?
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:ObL5RWcQIHA.5264@.TK2MSFTNGP02.phx.gbl...
> Yes, I *AM* able to change the Max Database Size there but it's already at
> the maximum allowed (4091).
> I still get the errors, even though the database appears to be configured
> for its maximum size.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:A4BBC5A2-7626-42D8-B430-B560CB8C9648@.microsoft.com...
>
|||Yes, Ginny, I am able to open the database programatically and I am able to
add records to it. The actual database size is only 322 MB.
It's a pretty simple situation. If you are really interested, send me a
private email and I will set up the file on an FTP server and maybe you can
look at it. If you really want to, my email is tlbaxter99 <at> Yahoo ~DOT~
com.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in message
news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
> Tom,
> Yes it looks like you're right as the max size is supposed to represent
> megabytes. Are you able to open the big database programmaticlly?
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:ObL5RWcQIHA.5264@.TK2MSFTNGP02.phx.gbl...
>
|||Tom, please see your email.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:O2pisxlQIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Yes, Ginny, I am able to open the database programatically and I am able
> to add records to it. The actual database size is only 322 MB.
> It's a pretty simple situation. If you are really interested, send me a
> private email and I will set up the file on an FTP server and maybe you
> can look at it. If you really want to, my email is tlbaxter99 <at> Yahoo
> ~DOT~ com.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
>
|||Tom Baxter wrote:
> I included a screenshot of the dialog window (e2.jpg).
Side note: this is an old no-no in Usenet (except for groups
with "binaries" in the name, and a handful of self-identified
exceptions). At least these weren't too big, but they eat
resources on every server carrying these groups (from whose
perspective Usenet is a push medium). The preferred alternative
is to either type it up (when practical, as would've been here),
or post the files somewhere else (e.g. web server, binaries group)
and then post a link here.
|||Tom,
Thanks for emailing me a download link to your big database. I was able to
reproduce your problem, but I was also able to work around it and
successfully connect to the database using VS 2008 by chaning the Connect
Timeout value to 500 from the default 30.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:O2pisxlQIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Yes, Ginny, I am able to open the database programatically and I am able
> to add records to it. The actual database size is only 322 MB.
> It's a pretty simple situation. If you are really interested, send me a
> private email and I will set up the file on an FTP server and maybe you
> can look at it. If you really want to, my email is tlbaxter99 <at> Yahoo
> ~DOT~ com.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
>
First, let me apologize for the cross-post. I was really at a loss for the
proper group.
I'm using Visual Studio 2008 with a SQL Server Compact 3.5 database.
Using the VS 2008 "Server Explorer", I wish to add an index on a column in
my database. I right-click on the table name and select "Table Properties".
This gives me an error:
"Index out of range. Must be non-negative and less than the size of the
collection. Parameter name: index".
I included a screenshot of the dialog window (e1.jpg).
Since that didn't work I tried to right-click on the table name and select
"Edit Table Schema". This gives me an error:
"The database file is larger than the configured maximum database size. This
setting takes effect on the first concurrent connection only. [Required Max
Database Size (in MB; 0 if unknown) = 0]".
I included a screenshot of the dialog window (e2.jpg).
The connection string for this database has an entry, "Max Database
Size=4091" and the size of the physical size of the file is 322 MB.
So, at this point I am getting these weird errors that are preventing me
from administering the SQL Server Compact DB.
Any help would be greatly appreciated.
Tom
Tom,
Have you tried selecting the database in VS 2008 Data Connections, then
right-click and select Modify Connection, then click the Advanced button to
change the Max Database Size?
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:OIQfX7OQIHA.748@.TK2MSFTNGP04.phx.gbl...
> Hi everyone,
> First, let me apologize for the cross-post. I was really at a loss for the
> proper group.
> I'm using Visual Studio 2008 with a SQL Server Compact 3.5 database.
> Using the VS 2008 "Server Explorer", I wish to add an index on a column in
> my database. I right-click on the table name and select "Table
> Properties". This gives me an error:
> "Index out of range. Must be non-negative and less than the size of the
> collection. Parameter name: index".
> I included a screenshot of the dialog window (e1.jpg).
> Since that didn't work I tried to right-click on the table name and select
> "Edit Table Schema". This gives me an error:
> "The database file is larger than the configured maximum database size.
> This setting takes effect on the first concurrent connection only.
> [Required Max Database Size (in MB; 0 if unknown) = 0]".
> I included a screenshot of the dialog window (e2.jpg).
> The connection string for this database has an entry, "Max Database
> Size=4091" and the size of the physical size of the file is 322 MB.
> So, at this point I am getting these weird errors that are preventing me
> from administering the SQL Server Compact DB.
> Any help would be greatly appreciated.
> Tom
>
>
|||Yes, I've done that. (When you say, "Data Connections" I assume you mean the
"Data Connections" node in Server Explorer.)
My "Max Database Size" is listed as 4091.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in message
news:OTAhvKPQIHA.5524@.TK2MSFTNGP05.phx.gbl...
> Tom,
> Have you tried selecting the database in VS 2008 Data Connections, then
> right-click and select Modify Connection, then click the Advanced button
> to change the Max Database Size?
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:OIQfX7OQIHA.748@.TK2MSFTNGP04.phx.gbl...
>
|||Tom,
Are you not able to change the Max Database Size from there? I was able to
change the Max Database Size for one of my SSC 3.5 files, but it wasn't a
big one like yours is.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:%23rJshqYQIHA.1164@.TK2MSFTNGP02.phx.gbl...
> Yes, I've done that. (When you say, "Data Connections" I assume you mean
> the "Data Connections" node in Server Explorer.)
> My "Max Database Size" is listed as 4091.
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:OTAhvKPQIHA.5524@.TK2MSFTNGP05.phx.gbl...
>
|||Yes, I *AM* able to change the Max Database Size there but it's already at
the maximum allowed (4091).
I still get the errors, even though the database appears to be configured
for its maximum size.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in message
news:A4BBC5A2-7626-42D8-B430-B560CB8C9648@.microsoft.com...
> Tom,
> Are you not able to change the Max Database Size from there? I was able to
> change the Max Database Size for one of my SSC 3.5 files, but it wasn't a
> big one like yours is.
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:%23rJshqYQIHA.1164@.TK2MSFTNGP02.phx.gbl...
>
|||Tom,
Yes it looks like you're right as the max size is supposed to represent
megabytes. Are you able to open the big database programmaticlly?
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:ObL5RWcQIHA.5264@.TK2MSFTNGP02.phx.gbl...
> Yes, I *AM* able to change the Max Database Size there but it's already at
> the maximum allowed (4091).
> I still get the errors, even though the database appears to be configured
> for its maximum size.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:A4BBC5A2-7626-42D8-B430-B560CB8C9648@.microsoft.com...
>
|||Yes, Ginny, I am able to open the database programatically and I am able to
add records to it. The actual database size is only 322 MB.
It's a pretty simple situation. If you are really interested, send me a
private email and I will set up the file on an FTP server and maybe you can
look at it. If you really want to, my email is tlbaxter99 <at> Yahoo ~DOT~
com.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in message
news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
> Tom,
> Yes it looks like you're right as the max size is supposed to represent
> megabytes. Are you able to open the big database programmaticlly?
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:ObL5RWcQIHA.5264@.TK2MSFTNGP02.phx.gbl...
>
|||Tom, please see your email.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:O2pisxlQIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Yes, Ginny, I am able to open the database programatically and I am able
> to add records to it. The actual database size is only 322 MB.
> It's a pretty simple situation. If you are really interested, send me a
> private email and I will set up the file on an FTP server and maybe you
> can look at it. If you really want to, my email is tlbaxter99 <at> Yahoo
> ~DOT~ com.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
>
|||Tom Baxter wrote:
> I included a screenshot of the dialog window (e2.jpg).
Side note: this is an old no-no in Usenet (except for groups
with "binaries" in the name, and a handful of self-identified
exceptions). At least these weren't too big, but they eat
resources on every server carrying these groups (from whose
perspective Usenet is a push medium). The preferred alternative
is to either type it up (when practical, as would've been here),
or post the files somewhere else (e.g. web server, binaries group)
and then post a link here.
|||Tom,
Thanks for emailing me a download link to your big database. I was able to
reproduce your problem, but I was also able to work around it and
successfully connect to the database using VS 2008 by chaning the Connect
Timeout value to 500 from the default 30.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:O2pisxlQIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Yes, Ginny, I am able to open the database programatically and I am able
> to add records to it. The actual database size is only 322 MB.
> It's a pretty simple situation. If you are really interested, send me a
> private email and I will set up the file on an FTP server and maybe you
> can look at it. If you really want to, my email is tlbaxter99 <at> Yahoo
> ~DOT~ com.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
>
Errors in Connecting to SQL Server Compact 3.4 ?
Hi everyone,
First, let me apologize for the cross-post. I was really at a loss for the
proper group.
I'm using Visual Studio 2008 with a SQL Server Compact 3.5 database.
Using the VS 2008 "Server Explorer", I wish to add an index on a column in
my database. I right-click on the table name and select "Table Properties".
This gives me an error:
"Index out of range. Must be non-negative and less than the size of the
collection. Parameter name: index".
I included a screenshot of the dialog window (e1.jpg).
Since that didn't work I tried to right-click on the table name and select
"Edit Table Schema". This gives me an error:
"The database file is larger than the configured maximum database size. This
setting takes effect on the first concurrent connection only. [Required Max
Database Size (in MB; 0 if unknown) = 0]".
I included a screenshot of the dialog window (e2.jpg).
The connection string for this database has an entry, "Max Database
Size=4091" and the size of the physical size of the file is 322 MB.
So, at this point I am getting these weird errors that are preventing me
from administering the SQL Server Compact DB.
Any help would be greatly appreciated.
Tom
Tom,
Have you tried selecting the database in VS 2008 Data Connections, then
right-click and select Modify Connection, then click the Advanced button to
change the Max Database Size?
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:OIQfX7OQIHA.748@.TK2MSFTNGP04.phx.gbl...
> Hi everyone,
> First, let me apologize for the cross-post. I was really at a loss for the
> proper group.
> I'm using Visual Studio 2008 with a SQL Server Compact 3.5 database.
> Using the VS 2008 "Server Explorer", I wish to add an index on a column in
> my database. I right-click on the table name and select "Table
> Properties". This gives me an error:
> "Index out of range. Must be non-negative and less than the size of the
> collection. Parameter name: index".
> I included a screenshot of the dialog window (e1.jpg).
> Since that didn't work I tried to right-click on the table name and select
> "Edit Table Schema". This gives me an error:
> "The database file is larger than the configured maximum database size.
> This setting takes effect on the first concurrent connection only.
> [Required Max Database Size (in MB; 0 if unknown) = 0]".
> I included a screenshot of the dialog window (e2.jpg).
> The connection string for this database has an entry, "Max Database
> Size=4091" and the size of the physical size of the file is 322 MB.
> So, at this point I am getting these weird errors that are preventing me
> from administering the SQL Server Compact DB.
> Any help would be greatly appreciated.
> Tom
>
>
|||Yes, I've done that. (When you say, "Data Connections" I assume you mean the
"Data Connections" node in Server Explorer.)
My "Max Database Size" is listed as 4091.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in message
news:OTAhvKPQIHA.5524@.TK2MSFTNGP05.phx.gbl...
> Tom,
> Have you tried selecting the database in VS 2008 Data Connections, then
> right-click and select Modify Connection, then click the Advanced button
> to change the Max Database Size?
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:OIQfX7OQIHA.748@.TK2MSFTNGP04.phx.gbl...
>
|||Tom,
Are you not able to change the Max Database Size from there? I was able to
change the Max Database Size for one of my SSC 3.5 files, but it wasn't a
big one like yours is.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:%23rJshqYQIHA.1164@.TK2MSFTNGP02.phx.gbl...
> Yes, I've done that. (When you say, "Data Connections" I assume you mean
> the "Data Connections" node in Server Explorer.)
> My "Max Database Size" is listed as 4091.
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:OTAhvKPQIHA.5524@.TK2MSFTNGP05.phx.gbl...
>
|||Yes, I *AM* able to change the Max Database Size there but it's already at
the maximum allowed (4091).
I still get the errors, even though the database appears to be configured
for its maximum size.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in message
news:A4BBC5A2-7626-42D8-B430-B560CB8C9648@.microsoft.com...
> Tom,
> Are you not able to change the Max Database Size from there? I was able to
> change the Max Database Size for one of my SSC 3.5 files, but it wasn't a
> big one like yours is.
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:%23rJshqYQIHA.1164@.TK2MSFTNGP02.phx.gbl...
>
|||Tom,
Yes it looks like you're right as the max size is supposed to represent
megabytes. Are you able to open the big database programmaticlly?
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:ObL5RWcQIHA.5264@.TK2MSFTNGP02.phx.gbl...
> Yes, I *AM* able to change the Max Database Size there but it's already at
> the maximum allowed (4091).
> I still get the errors, even though the database appears to be configured
> for its maximum size.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:A4BBC5A2-7626-42D8-B430-B560CB8C9648@.microsoft.com...
>
|||Yes, Ginny, I am able to open the database programatically and I am able to
add records to it. The actual database size is only 322 MB.
It's a pretty simple situation. If you are really interested, send me a
private email and I will set up the file on an FTP server and maybe you can
look at it. If you really want to, my email is tlbaxter99 <at> Yahoo ~DOT~
com.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in message
news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
> Tom,
> Yes it looks like you're right as the max size is supposed to represent
> megabytes. Are you able to open the big database programmaticlly?
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:ObL5RWcQIHA.5264@.TK2MSFTNGP02.phx.gbl...
>
|||Tom, please see your email.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:O2pisxlQIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Yes, Ginny, I am able to open the database programatically and I am able
> to add records to it. The actual database size is only 322 MB.
> It's a pretty simple situation. If you are really interested, send me a
> private email and I will set up the file on an FTP server and maybe you
> can look at it. If you really want to, my email is tlbaxter99 <at> Yahoo
> ~DOT~ com.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
>
|||Tom Baxter wrote:
> I included a screenshot of the dialog window (e2.jpg).
Side note: this is an old no-no in Usenet (except for groups
with "binaries" in the name, and a handful of self-identified
exceptions). At least these weren't too big, but they eat
resources on every server carrying these groups (from whose
perspective Usenet is a push medium). The preferred alternative
is to either type it up (when practical, as would've been here),
or post the files somewhere else (e.g. web server, binaries group)
and then post a link here.
|||Tom,
Thanks for emailing me a download link to your big database. I was able to
reproduce your problem, but I was also able to work around it and
successfully connect to the database using VS 2008 by chaning the Connect
Timeout value to 500 from the default 30.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:O2pisxlQIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Yes, Ginny, I am able to open the database programatically and I am able
> to add records to it. The actual database size is only 322 MB.
> It's a pretty simple situation. If you are really interested, send me a
> private email and I will set up the file on an FTP server and maybe you
> can look at it. If you really want to, my email is tlbaxter99 <at> Yahoo
> ~DOT~ com.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
>
First, let me apologize for the cross-post. I was really at a loss for the
proper group.
I'm using Visual Studio 2008 with a SQL Server Compact 3.5 database.
Using the VS 2008 "Server Explorer", I wish to add an index on a column in
my database. I right-click on the table name and select "Table Properties".
This gives me an error:
"Index out of range. Must be non-negative and less than the size of the
collection. Parameter name: index".
I included a screenshot of the dialog window (e1.jpg).
Since that didn't work I tried to right-click on the table name and select
"Edit Table Schema". This gives me an error:
"The database file is larger than the configured maximum database size. This
setting takes effect on the first concurrent connection only. [Required Max
Database Size (in MB; 0 if unknown) = 0]".
I included a screenshot of the dialog window (e2.jpg).
The connection string for this database has an entry, "Max Database
Size=4091" and the size of the physical size of the file is 322 MB.
So, at this point I am getting these weird errors that are preventing me
from administering the SQL Server Compact DB.
Any help would be greatly appreciated.
Tom
Tom,
Have you tried selecting the database in VS 2008 Data Connections, then
right-click and select Modify Connection, then click the Advanced button to
change the Max Database Size?
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:OIQfX7OQIHA.748@.TK2MSFTNGP04.phx.gbl...
> Hi everyone,
> First, let me apologize for the cross-post. I was really at a loss for the
> proper group.
> I'm using Visual Studio 2008 with a SQL Server Compact 3.5 database.
> Using the VS 2008 "Server Explorer", I wish to add an index on a column in
> my database. I right-click on the table name and select "Table
> Properties". This gives me an error:
> "Index out of range. Must be non-negative and less than the size of the
> collection. Parameter name: index".
> I included a screenshot of the dialog window (e1.jpg).
> Since that didn't work I tried to right-click on the table name and select
> "Edit Table Schema". This gives me an error:
> "The database file is larger than the configured maximum database size.
> This setting takes effect on the first concurrent connection only.
> [Required Max Database Size (in MB; 0 if unknown) = 0]".
> I included a screenshot of the dialog window (e2.jpg).
> The connection string for this database has an entry, "Max Database
> Size=4091" and the size of the physical size of the file is 322 MB.
> So, at this point I am getting these weird errors that are preventing me
> from administering the SQL Server Compact DB.
> Any help would be greatly appreciated.
> Tom
>
>
|||Yes, I've done that. (When you say, "Data Connections" I assume you mean the
"Data Connections" node in Server Explorer.)
My "Max Database Size" is listed as 4091.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in message
news:OTAhvKPQIHA.5524@.TK2MSFTNGP05.phx.gbl...
> Tom,
> Have you tried selecting the database in VS 2008 Data Connections, then
> right-click and select Modify Connection, then click the Advanced button
> to change the Max Database Size?
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:OIQfX7OQIHA.748@.TK2MSFTNGP04.phx.gbl...
>
|||Tom,
Are you not able to change the Max Database Size from there? I was able to
change the Max Database Size for one of my SSC 3.5 files, but it wasn't a
big one like yours is.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:%23rJshqYQIHA.1164@.TK2MSFTNGP02.phx.gbl...
> Yes, I've done that. (When you say, "Data Connections" I assume you mean
> the "Data Connections" node in Server Explorer.)
> My "Max Database Size" is listed as 4091.
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:OTAhvKPQIHA.5524@.TK2MSFTNGP05.phx.gbl...
>
|||Yes, I *AM* able to change the Max Database Size there but it's already at
the maximum allowed (4091).
I still get the errors, even though the database appears to be configured
for its maximum size.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in message
news:A4BBC5A2-7626-42D8-B430-B560CB8C9648@.microsoft.com...
> Tom,
> Are you not able to change the Max Database Size from there? I was able to
> change the Max Database Size for one of my SSC 3.5 files, but it wasn't a
> big one like yours is.
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:%23rJshqYQIHA.1164@.TK2MSFTNGP02.phx.gbl...
>
|||Tom,
Yes it looks like you're right as the max size is supposed to represent
megabytes. Are you able to open the big database programmaticlly?
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:ObL5RWcQIHA.5264@.TK2MSFTNGP02.phx.gbl...
> Yes, I *AM* able to change the Max Database Size there but it's already at
> the maximum allowed (4091).
> I still get the errors, even though the database appears to be configured
> for its maximum size.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:A4BBC5A2-7626-42D8-B430-B560CB8C9648@.microsoft.com...
>
|||Yes, Ginny, I am able to open the database programatically and I am able to
add records to it. The actual database size is only 322 MB.
It's a pretty simple situation. If you are really interested, send me a
private email and I will set up the file on an FTP server and maybe you can
look at it. If you really want to, my email is tlbaxter99 <at> Yahoo ~DOT~
com.
"Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in message
news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
> Tom,
> Yes it looks like you're right as the max size is supposed to represent
> megabytes. Are you able to open the big database programmaticlly?
> --
> Ginny Caughey
> Device Application Development MVP
>
> "Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
> news:ObL5RWcQIHA.5264@.TK2MSFTNGP02.phx.gbl...
>
|||Tom, please see your email.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:O2pisxlQIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Yes, Ginny, I am able to open the database programatically and I am able
> to add records to it. The actual database size is only 322 MB.
> It's a pretty simple situation. If you are really interested, send me a
> private email and I will set up the file on an FTP server and maybe you
> can look at it. If you really want to, my email is tlbaxter99 <at> Yahoo
> ~DOT~ com.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
>
|||Tom Baxter wrote:
> I included a screenshot of the dialog window (e2.jpg).
Side note: this is an old no-no in Usenet (except for groups
with "binaries" in the name, and a handful of self-identified
exceptions). At least these weren't too big, but they eat
resources on every server carrying these groups (from whose
perspective Usenet is a push medium). The preferred alternative
is to either type it up (when practical, as would've been here),
or post the files somewhere else (e.g. web server, binaries group)
and then post a link here.
|||Tom,
Thanks for emailing me a download link to your big database. I was able to
reproduce your problem, but I was also able to work around it and
successfully connect to the database using VS 2008 by chaning the Connect
Timeout value to 500 from the default 30.
Ginny Caughey
Device Application Development MVP
"Tom Baxter" <tlbaxter99@.yahoo.com> wrote in message
news:O2pisxlQIHA.4712@.TK2MSFTNGP04.phx.gbl...
> Yes, Ginny, I am able to open the database programatically and I am able
> to add records to it. The actual database size is only 322 MB.
> It's a pretty simple situation. If you are really interested, send me a
> private email and I will set up the file on an FTP server and maybe you
> can look at it. If you really want to, my email is tlbaxter99 <at> Yahoo
> ~DOT~ com.
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@.wasteworks.com> wrote in
> message news:44BF83D8-3C7D-4107-9546-21ABFDEFB860@.microsoft.com...
>
Sunday, February 19, 2012
,Re: SQL Server Compact Edition RC1 Released
Dear Community,
The SQL Server Compact Edition RC1 has been released and is now available at download center http://www.microsoft.com/downloads/details.aspx?FamilyId=85E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en
Please note that the RC1 page link is the same as CTP page link, we have updated it for RC1. This doesn’t have ClickOnce files (Zip file) as the same is available with Tools for VS 2005 sp1 beta at download center at http://www.microsoft.com/downloads/details.aspx?FamilyID=61289b5d-af86-45dd-8962-e7dcc5221796&displaylang=en
We have blogged about it at http://blogs.msdn.com/sqlservereverywhere/ .
Please check out the RC1 bits.
Thanks
Sachin, Program Manager, SQL Server CE Team
I have downloaded the tools quoted by your link:
'Please note that the RC1 page link is the same as CTP page link, we have updated it for RC1. This doesn’t have ClickOnce files (Zip file) as the same is available with Tools for VS 2005 sp1 beta at download center at http://www.microsoft.com/downloads/details.aspx?FamilyID=61289b5d-af86-45dd-8962-e7dcc5221796&displaylang=en'
But when i run it i get:
'the upgrade patch cannot be installed by the windows installer service because the program to be upgraded may be missing
or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer
and you have the correct upgrade patch'
I have Visual Studio 2005 and had this working for some time now.
What does this mean ?
Help !!!
ps. I successfully installed SQL Compact edition first
Chris Anderson
|||You have to install the VS2005 SP1 beta first
|||
Thanks for your reply.
I have just today installed SP1. In my about box in the list of installed products, it shows:
Microsoft Visual Studio Professional Edition - ENU Service Pack 1 (VB918525)
At the top, the version shows:
Microsoft Visual Studio 2005 - 8.0.50727.363 (SP.050727-3600)
Microsoft .net framework version 2.0.50727)
Can you help further please ?
Many Thanks
Chris Anderson
|||Chris,
1. Install VS2005
2. Install VS2005 SP1 Beta
http://www.microsoft.com/downloads/details.aspx?FamilyID=8d702463-674b-4978-9e22-c989130f6553&DisplayLang=en
3. Install SQL Server Ce
4. Install SQL Server CE tools
Then you can open up a project and add a .sdf file (say Northwind) when the Data Source Configuration Wizard will auto start.
Brian|||
Brian,
Many thanks for your reply.
Sorry to bother you but I am still having problems.
I uninstalled everything back to VS2005 (didnt uninstall VS2005)
then i followed your list and i am still getting the error message. I rebooted after the installs.
Chris
|||Chris - I am aka Phoenix.Suggest we continue with this thread rather than the one on VBUG
Brian|||
Brian,
Ahh! thanks for your reply, will do. Any ideas at all? - i could uninstall VS2005 and start the whole process all over again
if you think that is beneficial.
Chris
|||I have no better suggestion I am afraid - I connot make go wrong on my PC Perhaps someone else has met this and got a work around?After the uninstall/install of VS2005 I would be inclined to run Microsoft Update to get the latest pathes and then add SP1|||
Brian,
Many thanks for your time, i think i will uninstall everything inc VS2005 and start again, then i can see where im going.
Thanks
Chris
|||Did you also install http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=774655&SiteID=1
after VS 2005 with Smart Device Programmability, VS 2005 SP1?
Thanks
Laxmi
Subscribe to:
Posts (Atom)