|
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.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
Thanks for your good points, Mika!
regards,
George
|
|
|
|
|
You're welcome
|
|
|
|
|
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.
|
|
|
|
|
Thanks for your good idea!
regards,
George
|
|
|
|
|
|
Thanks Hamid,
Good stuff!
regards,
George
|
|
|
|
|
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?
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
modified on Sunday, January 11, 2009 5:29 AM
|
|
|
|
|
|
How can I use MSDataGrid in a WTL/ATL project
without using MFC ?
Is there an example in VC++6.0 ?
Thanks,
Manos.
|
|
|
|
|
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.
|
|
|
|
|
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'))
|
|
|
|
|
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?
|
|
|
|
|
Thanks fixed my problem and cleared the records from being completed.
|
|
|
|
|
You're welcome
|
|
|
|
|
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
|
|
|
|
|
You must install PowerShell first. This is described in the download page:
InstructionsNote: You must have administrative rights on the computer to install SQL Server Express.
We recommended that you read the Release Notes and Readme before installing SQL Server Express with Advance Services.
Step 1: Download and install Microsoft .Net Framework 3.5 SP1.
Step 2: Download and install Windows Installer 4.5.
Step 3: Download and install Windows PowerShell 1.0. ...
Refer to http://www.microsoft.com/downloads/details.aspx?FamilyId=B5D1B8C3-FDA5-4508-B0D0-1311D670E336&displaylang=en[^]
|
|
|
|
|
Step 1 : I've done it.
Step 2 : I've done it.
Step 3 : I must do it
|
|
|
|
|
It'll help
|
|
|
|
|
Oh no, Windows PowerShell 1.0 English-Language Installation Package for Windows XP (KB926139) needs Validation
|
|
|
|