Database

Install SQL Server on Vista

12-Jan-09 3:36

The confusing part was the connection strings and how different they were:

manzoor10 wrote:
// SQL Server authentication
connection->ConnectionString =
"User ID=sa; Password=;"
"Data Source=(local); Initial Catalog=DCV_DB;";

The above means that you connect to a default instance and use a database named DCV_DB, which is running all the time.

manzoor10 wrote:
// Windows Integrated Security
connection->ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DCV_DB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";

This again means that you connect to a named instance (SQLEXPRESS) on local host and when connecting a database is attached to the SQL Server instance. So the database available only on the instance when this connection exists. Also since the database is located under C:\Program Files\Microsoft SQL Server\MSSQL.1, it gives the impression that the database is designed to be available in the SQL Server all the time.

In many cases database files that are attached to an instance while connecting to it, are not located under that folder (although there's nothing wrong technically). This is because attached db files usually ship as plain files with a product and the product installation may not necessary modify files under a different installation (SQL Server in this case).

manzoor10 wrote:
By the way how do you manually copy a database from one PC to another

In many cases it's done by:
- creating a backup on the source and then restoring a backup on target or
- detaching a database on source, copy files to target and then attach the files to the target instance
Currently you do the attaching phase every time you connect but it can also be done only once and then you just use the database.

manzoor10 wrote:
Anyways the problem is solved

That's the most important thing.

manzoor10 wrote:
Thanks

You're welcome.

The need to optimize rises from a bad design.My articles[^]

Re: sql connection error

Henry Minute11-Jan-09 10:35

Henry Minute

11-Jan-09 10:35

manzoor10 wrote:
SQL Server does not allow remote connections

I have had this error in the past. It was along time ago but I am pretty sure that I remember the cause.

manzoor10 wrote:
"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DCV_DB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";

This line from your code is a string. To use the '\' character in C# there are two options

1. Convert all the '\' characters in your string to '\\' (C# requires that you 'escape' '\' (amongst other characters) 'escaping' means precede it with the '\' character. This means that you end up with "Data Source=.\\SQLEXPRESS;Attach......." and continue right through the path for the database which would then start "AttachDBFilename=C:\\Program Files\\Microsoft.......................".

2. Precede the entire string with '@' which means I want you to use this string exactly as I have typed it.
Quote from MSDN Help
The advantage of @-quoting is that escape sequences are not processed, which makes it easy to write, for example, a fully qualified file name:

@"c:\Docs\Source\a.txt" // rather than "c:\\Docs\\Source\\a.txt"

Try either of these.

[Mod]
Darn it, beaten to the punch again!
[/Mod]

Henry Minute

If you open a can of worms, any viable solution *MUST* involve a larger can.

George_George11-Jan-09 2:41

11-Jan-09 2:41

Hello everyone,

I tried to install SQL Server enterprise on my Windows Vista x64 Enterprise version, but failed. Seems SQL Server can not be installed on client platform (e.g. Vista)?

I want to setup DB and debug store procedure on my desktop. Anyone knows whether SQL Server can be installed on Vista Enterprise x64 version?

thanks in advance,
George

Wendelius11-Jan-09 3:05

11-Jan-09 3:05

Im version 2008 Enterprise edition can be installed on Windows Server 2003 or 2008, see: http://msdn.microsoft.com/en-us/library/ms143506.aspx#EEx64[^]

You can install Standard or Express on Vista to debug a procedure or perhaps you can use Virtual Server and install Windows Server in that and then install SQL Server Enterprise Edition on the virtual server.

The need to optimize rises from a bad design.My articles[^]

George_George12-Jan-09 0:21

12-Jan-09 0:21

Thanks for your good points, Mika!

regards,
George

Wendelius12-Jan-09 2:26

12-Jan-09 2:26

You're welcome Smile | :)

The need to optimize rises from a bad design.My articles[^]

* Developer Day Scotland 2 - Free community conference
* The Blog of Colin Angus Mackay

Colin Angus Mackay11-Jan-09 3:20

Colin Angus Mackay

11-Jan-09 3:20

George_George wrote:
I tried to install SQL Server enterprise on my Windows Vista x64 Enterprise version, but failed

You should install the Developer Edition on your client platform. It has all the features of Enterprise, but it works on Vista.

Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Please remember that the force of gravity can go up as well as down.

George_George12-Jan-09 0:24

12-Jan-09 0:24

Thanks for your good idea!

regards,
George

Hamid_RT15-Jan-09 2:26

Hamid_RT

15-Jan-09 2:26

See SQL SERVER - 2008 - Hardware and Software Requirements for Installing SQL Server 2008[^] and Installation Notes: SQL Server 2005 on Windows Vista with VS2008[^].

Of one Essence is the human race
thus has Creation put the base
One Limb impacted is sufficient
For all Others to feel the Mace
(Saadi )

George_George15-Jan-09 18:36

is there the sql syntex Limit in MS SQL?

15-Jan-09 18:36

Thanks Hamid,

Good stuff!

regards,
George

neodeaths11-Jan-09 0:44

neodeaths

11-Jan-09 0:44

hi iam trying to use the SQL STATMENT LIMIT in Microsoft SQL

however it keeps saying error

is there another syntex that serve the same purpose?

and also is the LIMIT Syntex works only in mysql?

Re: is there the sql syntex Limit in MS SQL?

Reza Raad11-Jan-09 1:09

Reza Raad

11-Jan-09 1:09

There is not LIMIT on MS_SQL
this is a MySql syntax code
and this means you can fetch rows between two range of results .
You can do this with TOP and ROW_NUMBER() keywords
for more information search for this keywords on MSDN

Human knowledge belongs to the world

how do i make a special sql statment filter?

neodeaths10-Jan-09 22:55

neodeaths

10-Jan-09 22:55

hi iam trying to make a some wat special sql filter

my database is something like this

700
701
702
801
802
803

so i need to uniquely filter out the data by the First Character only
e.g
7
8

will be the end result
is there a way to do this via sql statement or shld i just select the whole thing and do it programmically

Re: how do i make a special sql statment filter? [modified]

Wendelius10-Jan-09 23:10

Re: how do i make a special sql statment filter?

10-Jan-09 23:10

If the data is in numeric format, first convert it to string like:

CONVERT(varchar(50), YourColumn)

After that you can use SUBSTRING function along with DISTINCT on the string:

SELECT DISTINCT SUBSTRING( CONVERT(varchar(50), YourColumn), 1, 1)
FROM TableName
WHERE CONVERT(varchar(50), YourColumn) LIKE '[78]%'

Edited: Added the WHERE clause if needed. Also note that this could be more efficient with an inline view, depending on the table structures and indices.

The need to optimize rises from a bad design.My articles[^]

modified on Sunday, January 11, 2009 5:29 AM

neodeaths11-Jan-09 0:43

neodeaths

11-Jan-09 0:43

thanks nice method

WTL/ATL

manosza10-Jan-09 21:21

manosza

10-Jan-09 21:21

How can I use MSDataGrid in a WTL/ATL project
without using MFC ?
Is there an example in VC++6.0 ?

Thanks,
Manos.

Re: WTL/ATL

Wendelius10-Jan-09 21:58

Updating table based on search critea from two tables.

10-Jan-09 21:58

Why did you decide to post this question on 5 articles and a forum named General Database?

Since your question is C++ related, I'd suggest you post the question only on C++ forum. I believe you would get much better answers from there. Posting the same question several times across the site is considered rude.

The need to optimize rises from a bad design.My articles[^]

Sunset Towers10-Jan-09 1:54

Sunset Towers

10-Jan-09 1:54

I know the following statement is incorrect. I had something going wrong in one set of insert statements and it was inserting the entry I wanted it to insert and then inserting a second entry for the next record that contained no data. Now I need to correct both tables, but the only way to know what to correct in the IncomingRecords table is from data in the Completed table. Any help would be greatly appreciated.

UPDATE IncomingRecords
SET Complete = NULL
WHERE (RecordID = (SELECT IncomingRecords.RecordID FROM Completed INNER JOIN
IncomingRecords ON CompletedCRD.RecordID = IncomingRecords.RecordID
WHERE (Completed.A_firm_name = N'') AND (Completed.A_broker_found = N'broker_fround') AND (IncomingRecords.Complete = N'Complete'))

Re: Updating table based on search critea from two tables.

Wendelius10-Jan-09 2:18

Re: Updating table based on search critea from two tables.

10-Jan-09 2:18

With a quick look the only problem I see is that your select most likely returns several RecordID's so you mest use IN instead of equal. Like:

...
WHERE (RecordID <code>IN </code>(SELECT IncomingRecords.RecordID ...

Also you seem to miss one closing parenthesis in the end.

Was this the problem you were haviong?

The need to optimize rises from a bad design.My articles[^]

Sunset Towers10-Jan-09 2:32

Sunset Towers

10-Jan-09 2:32

Thanks fixed my problem and cleared the records from being completed.

Re: Updating table based on search critea from two tables.

Wendelius10-Jan-09 2:44

Windows PowerShell Failed error while installing SQL Server 2008 Express Advanced !

10-Jan-09 2:44

You're welcome Smile | :)

The need to optimize rises from a bad design.My articles[^]

Mohammad Dayyan10-Jan-09 1:49

Mohammad Dayyan

10-Jan-09 1:49

I am attempting to install "SQL Server 2008 Express with Advanced Services".
I downloaded this file "SQLEXPRADV_x86_ENU.exe" and consistently get an error in the "System Support Rules" window that indicates that the Windows PowerShell Failed.

It doesn't say how it failed or why it failed - it just failed.

How do I get past this problem?

Thank you

Re: Windows PowerShell Failed error while installing SQL Server 2008 Express Advanced !

Wendelius10-Jan-09 2:12