|
I am working on Windows 2000 professional. I have installed MSDE 2000 and also SQL server 2000 (Client components only).
But when i go through the Enterprise Manager of SQL Server, it is not identifying any server. It is displaying something like:
Server is not found or Access denied. Connection Open
when i tried to run in command prompt also (C:/>osql ....) it is saying connection open error.
can anyone please help?
thank you
|
|
|
|
|
|
I have checked from Administrative Tools -> Services, that sQL server service is running.
still i have this problem.
Can you tell me whether i need to install service pack SP3a in addition with MSDE 2000?
|
|
|
|
|
BSRK wrote:
Can you tell me whether i need to install service pack SP3a in addition with MSDE 2000?
Installing Service Pack 3a is generally a good idea anyway because, IIRC, it contains the security fix for the Slammer worm.
BSRK wrote:
I have checked from Administrative Tools -> Services, that sQL server service is running.
So, are you attempting to log in using the correct credentials? Have you typed the user name and password correctly? Did you set it to use Windows Authentication? and if yes, are you trying to connect using the same account that it was installed with (or with an account that has been granted access)?
Do you want to know more?
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums Upcoming talk:
SELECT UserName, Password FROM Users
-- Getting unauthorised access to a SQL Server, and how to prevent it.
|
|
|
|
|
|
|
MSDE and Enterprise manager work fine together. There is a grey area when it comes to the licencing of the software. But there is no technical reason why Enterprise Manager can't see your MSDE database.
Michael
CP Blog [^] Development Blog [^]
|
|
|
|
|
A new installation of MSDE is configured in Windows Authentication mode. You must use a trusted connection (e.g. osql -E) to connect to it. If you want to be able to supply a username and password you will need to reconfigure for mixed mode.
If you downloaded MSDE recently, you will have MSDE Release A. If you accept the default install parameters, this version of MSDE disables all networking protocols. You can only access it from the machine it's installed on, using the Shared Memory protocol. Follow the instructions in KB 814130[^] to re-enable network access.
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
Please tell me how to connect to a MySql Database and also explain the classpath requisites.
|
|
|
|
|
|
Hello all,
I have 4 tables the first table contain IDs from the other 3 tables. I need to Select the names from the other tables by the IDs in the first table
1- tbl
1|2|4
2- tbl
1|manager
3-tbl
2|Desgined
4-tble
4|Computer
please help
Thanks
hay
|
|
|
|
|
|
Thanks Colin ,
It is working but it give me duplicate recorder is there is a way to avoid duplicate.
Thanks for your time.
hay
|
|
|
|
|
|
I need to update a field so the values change from all upper case to title case. Can anyone please point me to a sql script example of how to do this. Thanks,
Jason W.
|
|
|
|
|
Hi,
U can use...............
UPDATE Customer
SET
C_Name = LOWER(C_Name)
I hope this will help u..........:->
Regards,
Ritesh
|
|
|
|
|
Thanks for the try, but that won't work. Lower gives the following results:
Select lower('TEST')<br />
---- <br />
test
The following would work if there was only one word:
Select upper(left('TEST',1)) + lower(substring('TEST', 2, len('TEST')))<br />
----- <br />
Test
Problem is when you have more then one word such as:
DECLARE @TEST as varchar(50)<br />
SET @TEST = 'TEST TEST TEST'<br />
Select upper(left(@TEST,1)) + lower(substring(@TEST, 2, len(@TEST)))<br />
--------------------------------------------------- <br />
Test test test
The results I want are
---------------------------------------------------
Test Test Test
Any idea on how to output this format?
Thanks again.
Jason W.
|
|
|
|
|
Hi,
In that case u have to write ur own logic...........
Here is my idea.............
1>Loop through ur string and separate our the substring till u get Space.
2>Then apply ur logic which u shown for this word and append it with @Result.
3>COntinue with ur loop till u get Next substring(word) use step 2 and append it to the @Result with Space
4>Continue till the length of Entire String......................
u might be having better logic...................:->
Regards,
Ritesh
|
|
|
|
|
Hello!
Is it posible to export DataGrid (not DataSet!) to Excel? If it is, how?
I can't find any exapamle on net...
|
|
|
|
|
Well I mean I can't find any example for Win DataGrid. So is it posible to export
data from Win DataGrid to excel?
|
|
|
|
|
Hi, Is there any way of getting table & field name from an SQL database
Need to extract field& table name from VB
|
|
|
|
|
Hi,
U can get the Name of all the Tables in ur current DB using
SELECT name,xtype FROM sysobjects WHERE xtype = 'U' AND name 'dtproperties'
And u can get the list of all the Columns with there Table name using
SELECT so.name TableName,sc.name ColumnName FROM syscolumns sc
INNER JOIN sysobjects so on sc.id = so.id
WHERE so.xtype = 'U' AND so.name <> 'dtproperties'
Hope this will help u.....................:->
Regards,
Ritesh
|
|
|
|
|
You can also get a wealth of information using the OleDbConnection 's GetOleDbSchemaTable method.
The most exciting phrase to hear in science, the one that heralds the most discoveries, is not 'Eureka!' ('I found it!') but 'That's funny...’
|
|
|
|
|
Hi, my computer have sql server and install service pack 3. I also have vb.net. Now I want to uninstall sql server service pack 3 and install sql server service pack 3a. Because I want to install sql server reporting services. But I don't is it possible to uninstall sql server 2000 service pack 3. Does any one know is it possible or not??? If it is possible, how could I do that?
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|