new to database

hello
I have developed applications but never used and created a database. .now I must make a database and I must reach it from 3 or 4 computer.database will not be huge. can I do this freely with sql? if not what do you suggest?

well you want to create a database and access it from someother machines i believe......if i understood it wrongly pls correct me you need to create linked server to access thosedbs from some other machines and run queries on them...

refer, http://technet.microsoft.com/en-us/library/ms186312.aspx > for db creation

http://technet.microsoft.com/en-us/library/ms176061.aspx > using T-SQL

refer ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/6ef578bf-8da7-46e0-88b5-e310fc908bb0.htm about linked servers

|||To speak in common, SQL Server is the scalable RDBMS of Microsoft. It scales up to thousands of clients and connections at a time. YOu should start at the http://www.microsoft.com/sql to see all the deature SQL Server provides. To keep a short answer, yes this could be the appropiate solution for you. Depending on your needs you will have to pick one edition from the available one which fits your needs (and budget).

See the different editions here: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Jens K. Suessmeyer.

http://www.sqlserver2005.de

New to CE and need some advice.

Hello,

I am new to the CE OS, SQL CE and mobile computing in general. I have been developing database applications using MS products ever since Windows 3.11 and Visual Basic 1.0. I have used MS Access and SQL Server since they were first released. But, I have never worked with Windows CE or any of the mobile OSs or with SQL CE or SQL Mobile.

We now have a project that requires us to develop a database application on handheld devices using the CE 4.2 and CE 5.0 OSs.We will be using CF 2.0, VS 2005 and SQL 2005 for our development environment.

My questions are:

1. Which version of mobile SQL will allow us to best develop for both the CE 4.2 and 5.0 OSs usinf VS 2005? I have done a lot of reading online and it's pretty confusing. There are quite a number of different versions out there. It seems some work with 4.2 and some with 5.0. Is there a version that will work for both?

2. Is SQL CE 3.0 (Sql 2005 Mobile) available for other than Laptop and Tablet use? When i finaly got to the download page for this version there was verbiage there that suggested it was not available for smart devices.

3. What is a good source of info to resolve these questions? I am using the MSDN areas for CE and SQL Mobile but haven't really found what I need to get started. Any suggestions on forums, books, articles, blogs, etc... would be greatly appreciated.

I know these are very broad questions but I want to get some advice from the experienced before going to far here.

1: SQL Compact Edition (3.1 aka 3.0.5300) does have support for CE 4.2 via this hotfix: http://support.microsoft.com/kb/934386/en-us

Support for CE 5.0 is built in the SDK:

http://www.microsoft.com/downloads/details.aspx?familyid=E9AA3F8D-363D-49F3-AE89-64E1D149E09B&displaylang=en

2: SQL CE 3.0 (SQL Server 2005 Mobile) is only licensed for Windows CE based devices and Tablet PC use.

SQL Compact Edition (3.1) is licensed for use on Windows CE and Win32 platforms.

3: The overview posts at the top of this forum is probably a good starting point.

|||

Thanks for the reply and the info Erik. That's what I neede to know.

I am now going though the "Creating a Mobile Application with SQL Server Mobile " SQL Server Mobile tutorial. I had a problem with the snapshot_agent user not being able to log in in order to run the SQL Server Snapshot Agent. But I found that if I add this user to the SQL Agent users group it works fine.

I have the replication setup and working and I am to the point now where I am creating the application in VS 2005. When I try to add a data connection I don't see "Microsoft SQL Server Mobile Edition" as one of the choices for Data Source. I have a reference to System.Data.SqlServerCe and I have put the "Using System.Data.SqlServerCe" directive in place. Any idea why this dtata source type wouldn't be available?

Thanks.

|||

You need to have the "Smart Device Programmability" VS setup option enabled. It is also a good idea to install VS 2005 SP1 and then add these "SQL Compact" tools for VS 2005 sp1:

http://www.microsoft.com/downloads/details.aspx?familyid=877C0ADC-0347-4A47-B842-58FB71D159AC&displaylang=en

|||

Erik,

Thanks for all the help. I really need to get this working.

Ok, I' m not sure where to set the "Smart Device programmability" option. I went to Add/Remove software in control panel and ran the VS 2005 Change/Remove option. I ran the Add/Remove components and repair/reinstall options and don't see the Smart Device progrmmability option.

I downloaded VS 2005 SP1 and installed it. that went ok.

I treid to install the SQL Compact tools for VS 2005 SP 1 ad it says that the patch can not be installed because the program to be upgraded is either missing or the wrong version.

Any other suggestions on this?

|||Under the feature tree, expand Visual C# or Visual Basic, there you will see "Smart Device Programmability"|||

Ok, I have reinstalled VS 2005 with "Smart Device Programmability" in place. I installed VS 2005 SP1 and the SQL CE Tools for VS 2005. Everything installed correctly. I was able to create and test the connection to the replication database file with no problem. However, when I try to create a new data source from the connection I get the following error.

Error creating new data source:

Could not get type information for 'app.appdataset'

After several internet and MS Knowledgebase searches I have found very little concerning this error. Several people are however having the same problem and I've tried all the fixes I've found but no luck. These include:

1. Making sure no tables are named like C# reserved words. The table names are "MembershipData" and "FlightData".

2. making sure that their are no extraneous characters in the connection string.

3. I have seen two references to logging in as a different user on the computer and this fixing the problem. I have tried this but it didn't help. I would also like to understand why this would solve the problem, if it did, so users could be set up correctly in the first place.

I hate to feel like I have to be lead through this process step-by-step but I don't know what else to do.

Thanks again,

Rick

|||Please refer to this (recently published) checklist: http://blogs.msdn.com/stevelasker/archive/2007/08/07/configuring-visual-studio-2005-for-use-wtih-sql-server-2005-compact-edition.aspx|||

Thanks Erik,

That's exactly what I needed. I have every thing running now except for merge replication through IIS. I'm sure that's an IIS configuration problem that I just have to work on.

Thanks again.

Rick

New to CE and need some advice.

Hello,

I am new to the CE OS, SQL CE and mobile computing in general. I have been developing database applications using MS products ever since Windows 3.11 and Visual Basic 1.0. I have used MS Access and SQL Server since they were first released. But, I have never worked with Windows CE or any of the mobile OSs or with SQL CE or SQL Mobile.

We now have a project that requires us to develop a database application on handheld devices using the CE 4.2 and CE 5.0 OSs.We will be using CF 2.0, VS 2005 and SQL 2005 for our development environment.

My questions are:

1. Which version of mobile SQL will allow us to best develop for both the CE 4.2 and 5.0 OSs usinf VS 2005? I have done a lot of reading online and it's pretty confusing. There are quite a number of different versions out there. It seems some work with 4.2 and some with 5.0. Is there a version that will work for both?

2. Is SQL CE 3.0 (Sql 2005 Mobile) available for other than Laptop and Tablet use? When i finaly got to the download page for this version there was verbiage there that suggested it was not available for smart devices.

3. What is a good source of info to resolve these questions? I am using the MSDN areas for CE and SQL Mobile but haven't really found what I need to get started. Any suggestions on forums, books, articles, blogs, etc... would be greatly appreciated.

I know these are very broad questions but I want to get some advice from the experienced before going to far here.

1: SQL Compact Edition (3.1 aka 3.0.5300) does have support for CE 4.2 via this hotfix: http://support.microsoft.com/kb/934386/en-us

Support for CE 5.0 is built in the SDK:

http://www.microsoft.com/downloads/details.aspx?familyid=E9AA3F8D-363D-49F3-AE89-64E1D149E09B&displaylang=en

2: SQL CE 3.0 (SQL Server 2005 Mobile) is only licensed for Windows CE based devices and Tablet PC use.

SQL Compact Edition (3.1) is licensed for use on Windows CE and Win32 platforms.

3: The overview posts at the top of this forum is probably a good starting point.

|||

Thanks for the reply and the info Erik. That's what I neede to know.

I am now going though the "Creating a Mobile Application with SQL Server Mobile " SQL Server Mobile tutorial. I had a problem with the snapshot_agent user not being able to log in in order to run the SQL Server Snapshot Agent. But I found that if I add this user to the SQL Agent users group it works fine.

I have the replication setup and working and I am to the point now where I am creating the application in VS 2005. When I try to add a data connection I don't see "Microsoft SQL Server Mobile Edition" as one of the choices for Data Source. I have a reference to System.Data.SqlServerCe and I have put the "Using System.Data.SqlServerCe" directive in place. Any idea why this dtata source type wouldn't be available?

Thanks.

|||

You need to have the "Smart Device Programmability" VS setup option enabled. It is also a good idea to install VS 2005 SP1 and then add these "SQL Compact" tools for VS 2005 sp1:

http://www.microsoft.com/downloads/details.aspx?familyid=877C0ADC-0347-4A47-B842-58FB71D159AC&displaylang=en

|||

Erik,

Thanks for all the help. I really need to get this working.

Ok, I' m not sure where to set the "Smart Device programmability" option. I went to Add/Remove software in control panel and ran the VS 2005 Change/Remove option. I ran the Add/Remove components and repair/reinstall options and don't see the Smart Device progrmmability option.

I downloaded VS 2005 SP1 and installed it. that went ok.

I treid to install the SQL Compact tools for VS 2005 SP 1 ad it says that the patch can not be installed because the program to be upgraded is either missing or the wrong version.

Any other suggestions on this?

|||

Under the feature tree, expand Visual C# or Visual Basic, there you will see "Smart Device Programmability"|||

Ok, I have reinstalled VS 2005 with "Smart Device Programmability" in place. I installed VS 2005 SP1 and the SQL CE Tools for VS 2005. Everything installed correctly. I was able to create and test the connection to the replication database file with no problem. However, when I try to create a new data source from the connection I get the following error.

Error creating new data source:

Could not get type information for 'app.appdataset'

After several internet and MS Knowledgebase searches I have found very little concerning this error. Several people are however having the same problem and I've tried all the fixes I've found but no luck. These include:

1. Making sure no tables are named like C# reserved words. The table names are "MembershipData" and "FlightData".

2. making sure that their are no extraneous characters in the connection string.

3. I have seen two references to logging in as a different user on the computer and this fixing the problem. I have tried this but it didn't help. I would also like to understand why this would solve the problem, if it did, so users could be set up correctly in the first place.

I hate to feel like I have to be lead through this process step-by-step but I don't know what else to do.

Thanks again,

Rick

|||Please refer to this (recently published) checklist: http://blogs.msdn.com/stevelasker/archive/2007/08/07/configuring-visual-studio-2005-for-use-wtih-sql-server-2005-compact-edition.aspx

|||

Thanks Erik,

That's exactly what I needed. I have every thing running now except for merge replication through IIS. I'm sure that's an IIS configuration problem that I just have to work on.

Thanks again.

Rick

sql

New SQL Database

I have set up applications in Access and am now starting in SQL Server. I
have taken a SQL class, but it did not cover starting from scratch. Our IT
dept set up a blank SQL database for me and gave me all permissions, but I'm
unsure of how to proceed. Do I need some sort of an interface set up on my
PC to connect?
You probably want to get the SQL Server install and choose Client Tools Only
option. Look in the Books Online that installs for how to register a server
in the Enterprise Manager (that is the SQL Server GUI for creating
databases, viewing various objects, etc.) The Query Analyzer is the utility
for creating everything but the most basic objects...
Post back as needed...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"bills249" <bills249@.discussions.microsoft.com> wrote in message
news:6D26CB63-283F-4395-B990-680187867E7B@.microsoft.com...
>I have set up applications in Access and am now starting in SQL Server. I
> have taken a SQL class, but it did not cover starting from scratch. Our
> IT
> dept set up a blank SQL database for me and gave me all permissions, but
> I'm
> unsure of how to proceed. Do I need some sort of an interface set up on
> my
> PC to connect?

New SQL Database

I have set up applications in Access and am now starting in SQL Server. I
have taken a SQL class, but it did not cover starting from scratch. Our IT
dept set up a blank SQL database for me and gave me all permissions, but I'm
unsure of how to proceed. Do I need some sort of an interface set up on my
PC to connect?You probably want to get the SQL Server install and choose Client Tools Only
option. Look in the Books Online that installs for how to register a server
in the Enterprise Manager (that is the SQL Server GUI for creating
databases, viewing various objects, etc.) The Query Analyzer is the utility
for creating everything but the most basic objects...
Post back as needed...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"bills249" <bills249@.discussions.microsoft.com> wrote in message
news:6D26CB63-283F-4395-B990-680187867E7B@.microsoft.com...
>I have set up applications in Access and am now starting in SQL Server. I
> have taken a SQL class, but it did not cover starting from scratch. Our
> IT
> dept set up a blank SQL database for me and gave me all permissions, but
> I'm
> unsure of how to proceed. Do I need some sort of an interface set up on
> my
> PC to connect?

New server with SQL Server 2005 standard x64 crashing

We have new 64-bit server and SQL Server 2005 where we moved databases and
applications from a 32-bit server and SQL Server 2000. Since we have moved
the databases and application to the new server the server crashes and
reboots at an irregular interval. This reboot seems to always be proceeded
by the memory working set for SQL Server being paged out and available memory
going up by a large amount. This usually occurs hours before the server
crashes. The available memory stays high until the server crashes.
OS: Server 2003 Standard edition x64 Edition
Version 5.2.3790 Service Pack 2 Build 3790
Hardware: HP ProLiant DL380 G5 with two Dual core cpu's 3000 MHz.
4 GB of memory
SQL Server Standard Edition (64-bit) Version: 9.00.3054.00
Using the performance monitory we can see the memory event that proceeds the
reboot and have ruled out some likely candidates like the Anti-virus and
backup software. The reboots occur anywhere from less the 24 hours apart to
4 days.
Does anyone know of any problems with SQL Server Standard x64 and memory
problems?
Any suggestions on how to identify if SQL Server is the problem or help
identifying some other service or driver as the cause of this problem?
--
MarkI have found it helpful to set the maximum memory setting in SQL Server to
less than the total available on the server. Based on the amount of memory
on the server this max amount would from 512 MB to 1024 MB less than the
maximum installed memory amount.
"masmith" wrote:
> We have new 64-bit server and SQL Server 2005 where we moved databases and
> applications from a 32-bit server and SQL Server 2000. Since we have moved
> the databases and application to the new server the server crashes and
> reboots at an irregular interval. This reboot seems to always be proceeded
> by the memory working set for SQL Server being paged out and available memory
> going up by a large amount. This usually occurs hours before the server
> crashes. The available memory stays high until the server crashes.
> OS: Server 2003 Standard edition x64 Edition
> Version 5.2.3790 Service Pack 2 Build 3790
> Hardware: HP ProLiant DL380 G5 with two Dual core cpu's 3000 MHz.
> 4 GB of memory
> SQL Server Standard Edition (64-bit) Version: 9.00.3054.00
> Using the performance monitory we can see the memory event that proceeds the
> reboot and have ruled out some likely candidates like the Anti-virus and
> backup software. The reboots occur anywhere from less the 24 hours apart to
> 4 days.
> Does anyone know of any problems with SQL Server Standard x64 and memory
> problems?
> Any suggestions on how to identify if SQL Server is the problem or help
> identifying some other service or driver as the cause of this problem?
> --
> Mark
>|||> Does anyone know of any problems with SQL Server Standard x64 and memory
> problems?
I dont have a link at hand, but I am pretty sure that SP2 for SQL Server
fixes this issue. We had the same issue from time to time, and we ended up
setting the min and max memory usage for the sql server 1 GB lower than the
total amount of memory. I searched google, and found a site saying, that the
SP2 would fix this issue.
If you haven't installed SP2, then you should take a look at the bugfixes
for that - and maybe you can permanent fix the problem with that.
/Sjang