|
|
sir,
perhaps this version is not compatible with VISTA since when i run this, this system prompt me that this product has known comaptibility issue .Please suggest
|
|
|
|
|
Did you download SQL Express 2005 and not MSDE. MSDE is not compatible with Vista. For example I have SQL Server 2005 downloaded from there and I'm running it on Vista.
Also, are you sure that you don't have any earlier Beta or CTP versions of SQL Server 2005 or .NET framework 2.0? These are not compatible with the product version.
Here's another link directly to download page and information about installation.
http://www.microsoft.com/express/sql/download/default.aspx[^]
Mika
|
|
|
|
|
|
I have an IMS project which authenticate user against the AD. Now, I want that if user enter the wrong password 3 timesm his account get the lock .
to lock user i am using
objDirectEntry.Properties["LockOutTime"].Value = 1;
objDirectEntry.CommitChanges();
if i set any value rather than 0 to objDirectEntry.Properties["LockOutTime"] , it throw exception.
Anoop Sihag
|
|
|
|
|
When i have to sql sever 2005,How to make connection string?
please help to me
|
|
|
|
|
If you can't figure this out you really shouldn't be writing code. Try Google.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I have 2 instance.
i used this:
Driver={SQL Native Client};Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=yes;
but i have a problem yet.
my eroor:
recognize escape sequence
help me please
|
|
|
|
|
I guess you're coding in C#.
Try
connstring = @"Driver={SQL Native Client};Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=yes;";<br />
<br />
or<br />
<br />
"Driver={SQL Native Client};Server=myServerName\\theInstanceName;Database=myDataBase;Trusted_Connection=yes;"
|
|
|
|
|
|
|
Hi, download bob tubor learning videos from microsoft(c#+sql).
Search something like absolute beginners lessons, download as most as you can, they are free and very helpful.
nelsonpaixao@yahoo.com.br
|
|
|
|
|
Hi All
Im using sql 2000, when im execute the Stored Procedure its gives Cannot resolve collation conflict for concatenation operation but this occur not my local database, when im execute in different server this will occur, my sp is as follows and error comes when im update the table
CREATE procedure dbo.CreateMyTest
(
@ID int output,
@Text varchar(50)=null,
@Description varchar(50)=null
)
as
begin
insert into MyTest
(
Mt_Text,
Mt_Description
)
values
(
@Text,
@Description
)
select @ID = @@identity
end
declare @Timestamp timestamp
select @Timestamp= DateModified from MyTest where Mt_ID=@ID
--Select top 10 cast(Mt_ID as varchar) + master.dbo.fn_varbintohexstr(@Timestamp) from MyTest
update MyTest
set Mt_UniqueText=cast(Mt_ID as varchar) + master.dbo.fn_varbintohexstr(@Timestamp)
where Mt_ID=@ID
Thx
|
|
|
|
|
Hi,
I would guess that your master databes uses different collation than your database. To solve this try to use COLLATE keyword in update statement.
Mika
|
|
|
|
|
Hello
I'm reading an excel file, Now the problem is that when reading it make some cells blanks.
THe reason is that if the first column value is of type text ("0.98ad") then it'll show only data like this format
or when it is numeric (0.8) then it shows only numeric values.
Any idea about it?
Thanks
Syed Shahid Hussain
|
|
|
|
|
The Excel driver determines type of a the column by scanning first few rows. Later it ignores all data not matching this type. I don't now a workaround for this other that preparing the excel file before (convert all data in the workbook to strings) or use an application code to import data (automating Excel or using a component like Aspose.Cells)
Pavel
|
|
|
|
|
Hi.
I am having oracle 9i client in W3k Server, and i like to connect Oracle 7.3 DB server, While connecting from PL/SQL it is showing some error like
ORA-03134: Connections to this server version are no longer supported
But same time i am able to connect from TOAD Software ..
is there any way to open OLEDB connection to that server?
actually i need to move my customer data from Oracle server to SQL server in scheduled manner, for this, i installed Oracle Client 9.2 and SQL server 2k5 Std edition.. While selecting datasource from inport/export wizard as a oracleclient i am getting "OraOledbpus.dll could not be found"
Remaining all .... TOAD is connecting .. that y i am getting confusion .. how is TOAD able to connect .. to the server if .. orcale client is not supporting ? more offen toad is also using same oracle home .
Regards
ranganad kodali ...
Kodali
|
|
|
|
|
Hi,
I would guess that you have multiple Oracle homes installed. The one that TOAD uses is different than the one that OLEDB uses. Check:
- your PATH environment variable to see which home is the first in search order
- your registry settings under HKEY_LOCALMACHINE/Software/Oracle
- ORACE_HOME environment variable
These should give you a clear picture, what client versions are installed. Oracle 7 client uses a different approach in selecting active home than newer clients and this can be confusing sometimes.
Hope this helps,
Mika
|
|
|
|
|
Hi all,
I maintained my database into back up(ex:name.bak),that back up database i do want to read in excel or xml or pdf any format .Is it possible ,if yes what is the steps for it plz help with a quick valuable response.
modified on Wednesday, September 24, 2008 5:20 AM
|
|
|
|
|
Doubtful. It would help if yuou told us what type of database though.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I have six columns.
I want to perform sorting on two columns.
For 1st column I want to perform Ascending and for another column descending.
Believe Yourself™ ™
|
|
|
|
|
select * from TableName order by Column1 asc,Column2 desc
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
This is not working mannn!!!!
It affects only one column.
It consider only 1st order not for another.....
there is no efect for 2nd column...
Believe Yourself™ ™
|
|
|
|
|
Check this[^]
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
Hi Blue
I have already checked this one this states the same as you told early.
This is not working mannn... it takes for 1st order only.
Believe Yourself™ ™
|
|
|
|