Creatng Charts Using scripts in sql server 2005 express

Hi all,

I want to Create charts for database table entries in sql server 2005 express edition, by using the scripts only not through wizards...

Plz help me for the above topic

Thanks & Regards,
Srinivaswhat scripts are you refering to? TSQL?|||Hi,
I just want to prepare the charts with out using wizards..., by using some stored proceduers we can get the data from database and then create the charts with some code( script).., that scripts r in visual studio or any thing ,

give me some idea about that one (or) give me some links related to this topic..

thanking you very much..

regards,
Srinivas|||

Hi,

I really did not understand what you are talking about, but perhaps you are referencing the ReportViewer controls..http://msdn2.microsoft.com/en-us/library/ms251671.aspx

regards

|||

T-SQL only returns data, you will need to use some other program to generate the charts from the data. You could use the Reporting controls in VS but I believe the report designer for VS is only available in VS Pro and as a download for VWD Express. (The other Express products don't have report design as a feature.) You can also consider Report Server, which is part of SQL Express Advanced. You will additionally need the SQL Express Toolkit to get the report design projects as part of BIDS.

Office also provides charting capabilities in both Excel and Access. Just retrieve the data and create your chart. In Office 2003 I found Access to have slightly better charting capabilities because of the use of the Office Web Components, but Excel has better analytical tools if you want to manipulate the data prior to creating your charts.

There are also a number of third-party tools and controls that you should be able to find by searching the web.

Regards,
Mike Wachal

creating system dsn to SQL server 2000 Sp 4 fails

Hi,

I hope someone can help me out here? I have a fresh install of SQL Server 2000 (standard edition - sp4), on a server running Windows 2003 SE (v 5.2.3790). I am trying to create a system dsn on my client pc (running Windows 2000) to a newly created database in SQL server called BLISS.

I am getting the following error message:

Connection failed:

SQL State :'01000'

SQL Server Error: 11001

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection Open (Connect()).

Connection Failed:

SQL State :'08001'

SQL Server Error: 6

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.

From support.microsft.com I have tried changing the TCPPort value to 0, but this has not helped. Does anyone have any further ideas please?

Jackie

Which protocols are enabled? Have you tried running cliconfg.exe?|||

Hi Anton,

I have looked at cliconfg.exe and have enabled TCP/IP and named pipes for genera connections. Both were already enabled for connections to this SQL Server installation.

Another thought is that the connection works top a server running SQL Server 2k sp 3a, but not to this server running SQL Server 2k sp4. Perhaps I should just reinstall and put sp3a on instead?

Jackie

|||Have you already exhausted all the possibilities mentioned in http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1

creating system dsn to SQL server 2000 Sp 4 fails

Hi,

I hope someone can help me out here? I have a fresh install of SQL Server 2000 (standard edition - sp4), on a server running Windows 2003 SE (v 5.2.3790). I am trying to create a system dsn on my client pc (running Windows 2000) to a newly created database in SQL server called BLISS.

I am getting the following error message:

Connection failed:

SQL State :'01000'

SQL Server Error: 11001

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Connection Open (Connect()).

Connection Failed:

SQL State :'08001'

SQL Server Error: 6

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.

From support.microsft.com I have tried changing the TCPPort value to 0, but this has not helped. Does anyone have any further ideas please?

Jackie

Which protocols are enabled? Have you tried running cliconfg.exe?|||

Hi Anton,

I have looked at cliconfg.exe and have enabled TCP/IP and named pipes for genera connections. Both were already enabled for connections to this SQL Server installation.

Another thought is that the connection works top a server running SQL Server 2k sp 3a, but not to this server running SQL Server 2k sp4. Perhaps I should just reinstall and put sp3a on instead?

Jackie

|||Have you already exhausted all the possibilities mentioned in http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1sql

Creating SQL Server 2005 Mobile Edition On Desktop

Hello Everybody

I want to create SQL server 2005 mobile database on desktop programmatically with some inital data for my application and load it into device. We can create database only in VS2005 server explorer or SQL server 2005 application.

Anybody having this solution for this prob.

Regards

Chikuu

Have you had any chance to look at:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=16369&SiteID=1

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||

Hello

My problem is solved using this link. I had copied those dll's into bin folder it woks fine on any windows desktop running VS2005.

Thanks

Chikuu

|||

Glad that I could help you.

Thanks,

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

|||

Hello

We are trying to install sdf creation code on windows server 2000, but it is giving message that ' sql mobile usage is restricted on this platform to use sql mobile you need dot net 2005,sql server 2005 or Tablet PC sku' i got this message eralier when i am installing it on windows server 2003 that time i had installed sql mobile sdk and then this message is not shown. Is there another solution for windows sever 2000, specifically in destributing these application.

Thanks

Chekku

|||

Chekku,

You really do need to install VS2005 or SS2005 on your Windows 2000 server to use SQL Mobile. It's part of the licensing.

-Darren

|||Hopefully the problems will be sorted with SQL Everywhere. You CAN get around the problem and still stay within Microsoft licencing terms without having to have Visual Studio, etc:

1) Download SQL Express from Microsoft (free download)

2) Extract to a folder using the /x option

3) In the 'Setup' folder there is a file called 'SqlSupport.msi'. Install this on your target PC (only a 9MB file so no big deal).

4) Also on your target PC, deploy the following files along with your app:

sqlceca30.dll

The SQL Server Mobile Client Agent. Required for applications that connect to SQL Server by using replication or remote data access.

sqlcecompact30.dll

Provides the compact database functionality. Required if your application will use compaction.

sqlceer30[language].dll

Contains error strings for SQL Server Mobile-generated errors. Required for all SQL Server Mobile applications.

sqlceme30.dll

Contains code required by the System.Data.SqlServerCe.dll file. Required for all SQL Server Mobile applications.

sqlceoledb30.dll

Provides OLE DB connectivity to SQL Server Mobile databases. Required only if your application uses OLE DB to connect to the SQL Server Mobile database.

sqlceqp30.dll

The SQL Server Mobile Query Processor. Required for all SQL Server Mobile applications.

sqlcese30.dll

The SQL Server Mobile Engine. Required for all SQL Server Mobile applications.

System.Data.SqlServerCe.dll

Seems bizarre how a free download keeps the licence happy !

Creating SQL Server 2005 Mobile Edition On Desktop

Hello Everybody

I want to create SQL server 2005 mobile database on desktop programmatically with some inital data for my application and load it into device. We can create database only in VS2005 server explorer or SQL server 2005 application.

Anybody having this solution for this prob.

Regards

Chikuu

Have you had any chance to look at:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=16369&SiteID=1

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||

Hello

My problem is solved using this link. I had copied those dll's into bin folder it woks fine on any windows desktop running VS2005.

Thanks

Chikuu

|||

Glad that I could help you.

Thanks,

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

|||

Hello

We are trying to install sdf creation code on windows server 2000, but it is giving message that ' sql mobile usage is restricted on this platform to use sql mobile you need dot net 2005,sql server 2005 or Tablet PC sku' i got this message eralier when i am installing it on windows server 2003 that time i had installed sql mobile sdk and then this message is not shown. Is there another solution for windows sever 2000, specifically in destributing these application.

Thanks

Chekku

|||

Chekku,

You really do need to install VS2005 or SS2005 on your Windows 2000 server to use SQL Mobile. It's part of the licensing.

-Darren

|||Hopefully the problems will be sorted with SQL Everywhere. You CAN get around the problem and still stay within Microsoft licencing terms without having to have Visual Studio, etc:

1) Download SQL Express from Microsoft (free download)

2) Extract to a folder using the /x option

3) In the 'Setup' folder there is a file called 'SqlSupport.msi'. Install this on your target PC (only a 9MB file so no big deal).

4) Also on your target PC, deploy the following files along with your app:

sqlceca30.dll

The SQL Server Mobile Client Agent. Required for applications that connect to SQL Server by using replication or remote data access.

sqlcecompact30.dll

Provides the compact database functionality. Required if your application will use compaction.

sqlceer30[language].dll

Contains error strings for SQL Server Mobile-generated errors. Required for all SQL Server Mobile applications.

sqlceme30.dll

Contains code required by the System.Data.SqlServerCe.dll file. Required for all SQL Server Mobile applications.

sqlceoledb30.dll

Provides OLE DB connectivity to SQL Server Mobile databases. Required only if your application uses OLE DB to connect to the SQL Server Mobile database.

sqlceqp30.dll

The SQL Server Mobile Query Processor. Required for all SQL Server Mobile applications.

sqlcese30.dll

The SQL Server Mobile Engine. Required for all SQL Server Mobile applications.

System.Data.SqlServerCe.dll

Seems bizarre how a free download keeps the licence happy !

Creating SQL Server 2005 Mobile Edition On Desktop

Hello Everybody

I want to create SQL server 2005 mobile database on desktop programmatically with some inital data for my application and load it into device. We can create database only in VS2005 server explorer or SQL server 2005 application.

Anybody having this solution for this prob.

Regards

Chikuu

Have you had any chance to look at:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=16369&SiteID=1

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||

Hello

My problem is solved using this link. I had copied those dll's into bin folder it woks fine on any windows desktop running VS2005.

Thanks

Chikuu

|||

Glad that I could help you.

Thanks,

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

|||

Hello

We are trying to install sdf creation code on windows server 2000, but it is giving message that ' sql mobile usage is restricted on this platform to use sql mobile you need dot net 2005,sql server 2005 or Tablet PC sku' i got this message eralier when i am installing it on windows server 2003 that time i had installed sql mobile sdk and then this message is not shown. Is there another solution for windows sever 2000, specifically in destributing these application.

Thanks

Chekku

|||

Chekku,

You really do need to install VS2005 or SS2005 on your Windows 2000 server to use SQL Mobile. It's part of the licensing.

-Darren

|||Hopefully the problems will be sorted with SQL Everywhere. You CAN get around the problem and still stay within Microsoft licencing terms without having to have Visual Studio, etc:

1) Download SQL Express from Microsoft (free download)

2) Extract to a folder using the /x option

3) In the 'Setup' folder there is a file called 'SqlSupport.msi'. Install this on your target PC (only a 9MB file so no big deal).

4) Also on your target PC, deploy the following files along with your app:

sqlceca30.dll

The SQL Server Mobile Client Agent. Required for applications that connect to SQL Server by using replication or remote data access.

sqlcecompact30.dll

Provides the compact database functionality. Required if your application will use compaction.

sqlceer30[language].dll

Contains error strings for SQL Server Mobile-generated errors. Required for all SQL Server Mobile applications.

sqlceme30.dll

Contains code required by the System.Data.SqlServerCe.dll file. Required for all SQL Server Mobile applications.

sqlceoledb30.dll

Provides OLE DB connectivity to SQL Server Mobile databases. Required only if your application uses OLE DB to connect to the SQL Server Mobile database.

sqlceqp30.dll

The SQL Server Mobile Query Processor. Required for all SQL Server Mobile applications.

sqlcese30.dll

The SQL Server Mobile Engine. Required for all SQL Server Mobile applications.

System.Data.SqlServerCe.dll

Seems bizarre how a free download keeps the licence happy !

Creating SQL Server 2005 Mobile Edition On Desktop

Hello Everybody

I want to create SQL server 2005 mobile database on desktop programmatically with some inital data for my application and load it into device. We can create database only in VS2005 server explorer or SQL server 2005 application.

Anybody having this solution for this prob.

Regards

Chikuu

Have you had any chance to look at:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=16369&SiteID=1

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||

Hello

My problem is solved using this link. I had copied those dll's into bin folder it woks fine on any windows desktop running VS2005.

Thanks

Chikuu

|||

Glad that I could help you.

Thanks,

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

|||

Hello

We are trying to install sdf creation code on windows server 2000, but it is giving message that ' sql mobile usage is restricted on this platform to use sql mobile you need dot net 2005,sql server 2005 or Tablet PC sku' i got this message eralier when i am installing it on windows server 2003 that time i had installed sql mobile sdk and then this message is not shown. Is there another solution for windows sever 2000, specifically in destributing these application.

Thanks

Chekku

|||

Chekku,

You really do need to install VS2005 or SS2005 on your Windows 2000 server to use SQL Mobile. It's part of the licensing.

-Darren

|||Hopefully the problems will be sorted with SQL Everywhere. You CAN get around the problem and still stay within Microsoft licencing terms without having to have Visual Studio, etc:

1) Download SQL Express from Microsoft (free download)

2) Extract to a folder using the /x option

3) In the 'Setup' folder there is a file called 'SqlSupport.msi'. Install this on your target PC (only a 9MB file so no big deal).

4) Also on your target PC, deploy the following files along with your app:

sqlceca30.dll

The SQL Server Mobile Client Agent. Required for applications that connect to SQL Server by using replication or remote data access.

sqlcecompact30.dll

Provides the compact database functionality. Required if your application will use compaction.

sqlceer30[language].dll

Contains error strings for SQL Server Mobile-generated errors. Required for all SQL Server Mobile applications.

sqlceme30.dll

Contains code required by the System.Data.SqlServerCe.dll file. Required for all SQL Server Mobile applications.

sqlceoledb30.dll

Provides OLE DB connectivity to SQL Server Mobile databases. Required only if your application uses OLE DB to connect to the SQL Server Mobile database.

sqlceqp30.dll

The SQL Server Mobile Query Processor. Required for all SQL Server Mobile applications.

sqlcese30.dll

The SQL Server Mobile Engine. Required for all SQL Server Mobile applications.

System.Data.SqlServerCe.dll

Seems bizarre how a free download keeps the licence happy !

Creating Reports on SQL Server 2005 Mobile Edition

I am looking for a reporting software to create reports (Invoices, Receipts) for PocketPC 2003 using Visual Studio 2005 and SQL Server 2005 Mobile Edition.
Any recommendations will be appreciated.

Thanks, Alla

At present SQL Server 2005 Mobile Edition doesnt have integration with SQL Reporting services or Crystal reports. You may need to author your own report and query SQL Mobile database for data.|||

In our development, we do it "by hands" and send to printer via a third party "PrinterCE".

HTH, Fabien.

Creating Reports on SQL Server 2005 Mobile Edition

I am looking for a reporting software to create reports (Invoices, Receipts) for PocketPC 2003 using Visual Studio 2005 and SQL Server 2005 Mobile Edition.
Any recommendations will be appreciated.

Thanks, Alla

At present SQL Server 2005 Mobile Edition doesnt have integration with SQL Reporting services or Crystal reports. You may need to author your own report and query SQL Mobile database for data.|||

In our development, we do it "by hands" and send to printer via a third party "PrinterCE".

HTH, Fabien.

Creating Partions on Developer Edition

Hi,

I was trying to partition my cube built in MSAS 2005 Developer Edition based on time dimension, however I was running into a lot of issues.

I just read an article which states that cube partition is only possible on Enterprise Edition of MSAS 2005 can someone verify if it is true and if thats the case then why do they provide an option to partition the cube in the developer edition.

Thanks

You can create partitions on developer edition of SQL Server 2005/SSAS2005. Build partitions in BI-Developer Studio, process and check the cube in Management Studio after. Under the Cubes-folder, The cube and the measure group for that cube you can see the partitions.

Regards

Thomas Ivarsson

|||

Thomas,

I tried doing that, however if I try to create a partition using query binding and specify a select statement with a where clause. The SQL that MSAS 2005 generates when it builds the cube has a bunch of sub-selects and it fails to validate and so I am unble to build the cube with any new partitions

Thanks

|||

Developer Edition supports the functionallity of Enterprise Edition but with licensing limitations, so the problem is not related to the edition you are using. (Please see the licensing terms for details.) A more likely culprit is the relational provider you are using as it sounds like the provider does not support sub-selects. See http://msdn2.microsoft.com/en-us/library/ms175608.aspx for a list of supported relational providers.

|||

Ok. It works with the Dev Edition so your problem is probably not about the version of SQL Server. It can be as simple as to check if a key is text, integer or any other datatype. IN 2005 you can build SQL statements for partitions in the same way you write a where clause in TSQL.

Run the new profiler that catches all statements from SSAS2005 and see if any strange behavior appears.

Regards

Thomas Ivarsson

|||

Hi,

Thanks for the response guys.

Matt I had one quick question if I am able to process a cube using table binding as opposed to query binding to create partitions and the sql generated during processing of the cube does have sub selects and it does build the cube sucessfully I dont think I would have an issue with my provider correct?

Thomas : I am not quite clear about the part where you say " It can be as simple as to check if a key is text, integer or any other datatype" can you please expand on this

|||

I do these errors myself. A key is an integer but I write with a ' ' around it(or reverse). I do not think that my query bound partitions do subselects. It is a normal select query, with a where clause added for you, when I have tried it.

Regards

Thomas Ivarsson

|||If you are using one of the supported providers you should not have any problem. If you are not, it may be that some things are supported in sub-selects but other things are not so some queries may succeed while others fail. You should be able to see the queries the server is generating them and then you can check and see if they are supported by the provider.

Creating Partions on Developer Edition

Hi,

I was trying to partition my cube built in MSAS 2005 Developer Edition based on time dimension, however I was running into a lot of issues.

I just read an article which states that cube partition is only possible on Enterprise Edition of MSAS 2005 can someone verify if it is true and if thats the case then why do they provide an option to partition the cube in the developer edition.

Thanks

You can create partitions on developer edition of SQL Server 2005/SSAS2005. Build partitions in BI-Developer Studio, process and check the cube in Management Studio after. Under the Cubes-folder, The cube and the measure group for that cube you can see the partitions.

Regards

Thomas Ivarsson

|||

Thomas,

I tried doing that, however if I try to create a partition using query binding and specify a select statement with a where clause. The SQL that MSAS 2005 generates when it builds the cube has a bunch of sub-selects and it fails to validate and so I am unble to build the cube with any new partitions

Thanks

|||

Developer Edition supports the functionallity of Enterprise Edition but with licensing limitations, so the problem is not related to the edition you are using. (Please see the licensing terms for details.) A more likely culprit is the relational provider you are using as it sounds like the provider does not support sub-selects. See http://msdn2.microsoft.com/en-us/library/ms175608.aspx for a list of supported relational providers.

|||

Ok. It works with the Dev Edition so your problem is probably not about the version of SQL Server. It can be as simple as to check if a key is text, integer or any other datatype. IN 2005 you can build SQL statements for partitions in the same way you write a where clause in TSQL.

Run the new profiler that catches all statements from SSAS2005 and see if any strange behavior appears.

Regards

Thomas Ivarsson

|||

Hi,

Thanks for the response guys.

Matt I had one quick question if I am able to process a cube using table binding as opposed to query binding to create partitions and the sql generated during processing of the cube does have sub selects and it does build the cube sucessfully I dont think I would have an issue with my provider correct?

Thomas : I am not quite clear about the part where you say " It can be as simple as to check if a key is text, integer or any other datatype" can you please expand on this

|||

I do these errors myself. A key is an integer but I write with a ' ' around it(or reverse). I do not think that my query bound partitions do subselects. It is a normal select query, with a where clause added for you, when I have tried it.

Regards

Thomas Ivarsson

|||If you are using one of the supported providers you should not have any problem. If you are not, it may be that some things are supported in sub-selects but other things are not so some queries may succeed while others fail. You should be able to see the queries the server is generating them and then you can check and see if they are supported by the provider.

Creating Partions on Developer Edition

Hi,

I was trying to partition my cube built in MSAS 2005 Developer Edition based on time dimension, however I was running into a lot of issues.

I just read an article which states that cube partition is only possible on Enterprise Edition of MSAS 2005 can someone verify if it is true and if thats the case then why do they provide an option to partition the cube in the developer edition.

Thanks

You can create partitions on developer edition of SQL Server 2005/SSAS2005. Build partitions in BI-Developer Studio, process and check the cube in Management Studio after. Under the Cubes-folder, The cube and the measure group for that cube you can see the partitions.

Regards

Thomas Ivarsson

|||

Thomas,

I tried doing that, however if I try to create a partition using query binding and specify a select statement with a where clause. The SQL that MSAS 2005 generates when it builds the cube has a bunch of sub-selects and it fails to validate and so I am unble to build the cube with any new partitions

Thanks

|||

Developer Edition supports the functionallity of Enterprise Edition but with licensing limitations, so the problem is not related to the edition you are using. (Please see the licensing terms for details.) A more likely culprit is the relational provider you are using as it sounds like the provider does not support sub-selects. See http://msdn2.microsoft.com/en-us/library/ms175608.aspx for a list of supported relational providers.

|||

Ok. It works with the Dev Edition so your problem is probably not about the version of SQL Server. It can be as simple as to check if a key is text, integer or any other datatype. IN 2005 you can build SQL statements for partitions in the same way you write a where clause in TSQL.

Run the new profiler that catches all statements from SSAS2005 and see if any strange behavior appears.

Regards

Thomas Ivarsson

|||

Hi,

Thanks for the response guys.

Matt I had one quick question if I am able to process a cube using table binding as opposed to query binding to create partitions and the sql generated during processing of the cube does have sub selects and it does build the cube sucessfully I dont think I would have an issue with my provider correct?

Thomas : I am not quite clear about the part where you say " It can be as simple as to check if a key is text, integer or any other datatype" can you please expand on this

|||

I do these errors myself. A key is an integer but I write with a ' ' around it(or reverse). I do not think that my query bound partitions do subselects. It is a normal select query, with a where clause added for you, when I have tried it.

Regards

Thomas Ivarsson

|||If you are using one of the supported providers you should not have any problem. If you are not, it may be that some things are supported in sub-selects but other things are not so some queries may succeed while others fail. You should be able to see the queries the server is generating them and then you can check and see if they are supported by the provider.

Creating Nested Tables inside of a Existing SQL Server Express Table

Hello,

Quick question, I hope, I am trying to create a table that has a column that is a nested table in SQL Server 2005 Express Edition. Any ideas how I could go about doing this?

Sincerely,

James Simpson

Straightway Technologies Inc.

The only way to "create a table that has a column that is a nested table", is to use an xml datatype.

Refer to Books Online, Topic: XML [SQL Server]

|||

As Arnie indicates, SQL Server doesn't support TABLE as a data type within a table. There is probably another way to accomlish what you're trying to do without going to XML, but it's hard to say without know what your goal is. In general, I'd suggest that you create a new table for your "nested" information and then use a 1:Many relationship between the two tables to map the nested info to the parent record.

Mike

creating master key sql 2005

Hi,
I've trying to create a master key in sql server express edition 2005. I'm
using the follow code:
CREATE MASTER KEY ENCRYPTION BY PASSWORD = '2005Password'
when i run this, the XM send me the follow message error:
Incorrect syntax near 'master'
Where is my mistake?
Att,
Leandro CarvalhoSupport is found here:
http://communities.microsoft.com/ne...lcid=us

--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Leandro Carvalho" <LeandroCarvalho@.discussions.microsoft.com> wrote in
message news:C4EA5452-D474-4D94-9576-7DF0DE6020C8@.microsoft.com...
> Hi,
> I've trying to create a master key in sql server express edition 2005. I'm
> using the follow code:
> CREATE MASTER KEY ENCRYPTION BY PASSWORD = '2005Password'
> when i run this, the XM send me the follow message error:
> Incorrect syntax near 'master'
> Where is my mistake?
> Att,
> Leandro Carvalho
>

Creating indexes on tables from the Database Explorer

I would like to create an index on a table from the Database Explorer.

I am using Microsoft Visual C# 2005 Express Edition.

I downloaded Microsoft SQL Server Management Studio Express with the intention of using it to create an index, but it does not seem to find the database that I created from the Database Explorer.

Thanks!

Are you sure you're looking at the right server and connection? Can you post a screenshot of the two environments?

Creating indexes on tables from the Database Explorer

I would like to create an index on a table from the Database Explorer.

I am using Microsoft Visual C# 2005 Express Edition.

I downloaded Microsoft SQL Server Management Studio Express with the intention of using it to create an index, but it does not seem to find the database that I created from the Database Explorer.

Thanks!

Are you sure you're looking at the right server and connection? Can you post a screenshot of the two environments?

Creating databases on WinXP SP2 with SQL Server 2005 CE RC

Hi,

For various reasons a new desktop application I am developing is using the SQL Server 2005 Compact Edition Release Candidate to store local data. On my development machine (XP SP2, VS2005, SQL Server 2005 Developer Edition) the software is able to create the database file, and read and write to it fine.

However on our test machine, which does not have any of the development tools the software is unable to create the database. A System.Data.SqlServerCe.SqlCeException is thrown. The message is: "SQL Mobile usage is restricted on this platform. To use SQL Mobile, you must install SQL Server 2005, Visual Studio 2005, or the Tablet PC SKU." Obviously this goes somewhat against the blurb for SQL Server CE.

Is this something that will be fixed shortly? Or is it the intention that databases can't be created on machines that do not SQL Server or Visual Studio installed? (Incidentally the reason for creating the database on the fly is that we are encrypting it, using the users credentials, so that only they can open the database.)

Thanks, Steve

The restriction has been removed in RC1 bits. Have you installed RC1 bits on your test machine? It looks like your test machine is using the old bits.

Thanks

Raja

|||

Hi,

I thought I was using the RC1 version of the software. Is there a list of the DLL's and versions that I can check against my machine, and the test machine?

Thanks, Steve

|||

Sorry for the delayed reply. RC1 bits are of the version 3.0.5258.0

When you are running your app through VS, please check the location and version of sqlcese30.dll. It should be loaded from C:\Program Files\Microsoft SQL Server Everywhere Edition\v3.1 and of the version 3.0.5258.0

Thanks

Raja

Creating databases on WinXP SP2 with SQL Server 2005 CE RC

Hi,

For various reasons a new desktop application I am developing is using the SQL Server 2005 Compact Edition Release Candidate to store local data. On my development machine (XP SP2, VS2005, SQL Server 2005 Developer Edition) the software is able to create the database file, and read and write to it fine.

However on our test machine, which does not have any of the development tools the software is unable to create the database. A System.Data.SqlServerCe.SqlCeException is thrown. The message is: "SQL Mobile usage is restricted on this platform. To use SQL Mobile, you must install SQL Server 2005, Visual Studio 2005, or the Tablet PC SKU." Obviously this goes somewhat against the blurb for SQL Server CE.

Is this something that will be fixed shortly? Or is it the intention that databases can't be created on machines that do not SQL Server or Visual Studio installed? (Incidentally the reason for creating the database on the fly is that we are encrypting it, using the users credentials, so that only they can open the database.)

Thanks, Steve

The restriction has been removed in RC1 bits. Have you installed RC1 bits on your test machine? It looks like your test machine is using the old bits.

Thanks

Raja

|||

Hi,

I thought I was using the RC1 version of the software. Is there a list of the DLL's and versions that I can check against my machine, and the test machine?

Thanks, Steve

|||

Sorry for the delayed reply. RC1 bits are of the version 3.0.5258.0

When you are running your app through VS, please check the location and version of sqlcese30.dll. It should be loaded from C:\Program Files\Microsoft SQL Server Everywhere Edition\v3.1 and of the version 3.0.5258.0

Thanks

Raja

Creating database and table on MS MSQL server

Hi All,
I want to use MS sql server edition 2000. I have installed the server. Now i
want to create the database on this server with tables and triggers. Can
please someone suggest me how to do this ?
Thanks a lot,
DineshCREATE DATABASE ...
CREATE TABLE ...
CREATE TRIGGER ...

Lookup these commands in Books Online

--
David Portas
SQL Server MVP
--