Re: connection string - Database Discussion Boards

Re: Download Vista Compatiable SQL Server EXPRESS

Wendelius16-Aug-08 21:02

16-Aug-08 21:02

If you're still having this problem, you can also download directly from
http://www.microsoft.com/downloads/details.aspx?FamilyID=31711d5d-725c-4afa-9d65-e4465cdff1e7&displaylang=en[^]

Mika

How to lock an Active Directory user account

AnoopSihag5-Aug-08 1:09

AnoopSihag

5-Aug-08 1:09

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

connection string

NiloofarNoroozi5-Aug-08 0:42

NiloofarNoroozi

5-Aug-08 0:42

When i have to sql sever 2005,How to make connection string?

please help to me

Re: connection string

Ashfield5-Aug-08 1:09

Ashfield

5-Aug-08 1:09

If you can't figure this out you really shouldn't be writing code. Try Google.

Bob
Ashfield Consultants Ltd

Re: connection string

NiloofarNoroozi5-Aug-08 1:27

NiloofarNoroozi

5-Aug-08 1:27

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

Re: connection string

SimulationofSai5-Aug-08 2:10

SimulationofSai

5-Aug-08 2:10

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;"

Re: connection string

NiloofarNoroozi5-Aug-08 10:34

NiloofarNoroozi

5-Aug-08 10:34

thank you very much

Re: connection string

Blue_Boy5-Aug-08 2:52

Blue_Boy

5-Aug-08 2:52

Looking for SQL Server connection strings?[^]

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

Re: connection string

nelsonpaixao6-Aug-08 14:40

nelsonpaixao

6-Aug-08 14:40

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. Laugh | :laugh:

nelsonpaixao@yahoo.com.br

Cannot resolve collation conflict for concatenation operation

slSoftware4-Aug-08 23:17

slSoftware

4-Aug-08 23:17

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

Re: Cannot resolve collation conflict for concatenation operation

Wendelius5-Aug-08 8:47

Wendelius

5-Aug-08 8:47

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

Data Loss from Excel

Syed Shahid Hussain4-Aug-08 21:19

Syed Shahid Hussain

4-Aug-08 21:19

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

Re: Data Loss from Excel

Pavel Klocek5-Aug-08 1:01

Pavel Klocek

5-Aug-08 1:01

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

Oracle Oledb Interface

kodali ranganadh4-Aug-08 21:14

kodali ranganadh

4-Aug-08 21:14

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

Re: Oracle Oledb Interface

Wendelius5-Aug-08 6:25

Wendelius

5-Aug-08 6:25

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

how to open database tables into excel or pdf [modified] using Sql Server 2005

Roney4-Aug-08 20:54

Roney

4-Aug-08 20:54

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

Re: how to open database tables into excel or pdf

Ashfield4-Aug-08 20:57

Ashfield

4-Aug-08 20:57

Doubtful. It would help if yuou told us what type of database though.

Bob
Ashfield Consultants Ltd

Make sorting on multiple columns with diffrent criteria

Gandalf_TheWhite4-Aug-08 20:23

Gandalf_TheWhite

4-Aug-08 20:23

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™ $Shucks | :-\$ ™

Re: Make sorting on multiple columns with diffrent criteria

Blue_Boy4-Aug-08 20:50

Blue_Boy

4-Aug-08 20:50

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."

Re: Make sorting on multiple columns with diffrent criteria

Gandalf_TheWhite4-Aug-08 20:58

Gandalf_TheWhite

4-Aug-08 20:58

This is not working mannn!!!! D'Oh! | :doh:

It affects only one column.
It consider only 1st order not for another.....
there is no efect for 2nd column... Frown | :(

Believe Yourself™ $Shucks | :-\$ ™

Re: Make sorting on multiple columns with diffrent criteria

Blue_Boy4-Aug-08 21:19

Blue_Boy

4-Aug-08 21:19

Check this[^]

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

Re: Make sorting on multiple columns with diffrent criteria

Gandalf_TheWhite4-Aug-08 22:18

Gandalf_TheWhite

4-Aug-08 22:18

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™ $Shucks | :-\$ ™

Re: Make sorting on multiple columns with diffrent criteria

Gandalf_TheWhite5-Aug-08 21:13

Gandalf_TheWhite

5-Aug-08 21:13

Thanks Blue You were correct, I was making mistake at some point.
Actually It is two time sorting.
I m trying on this. If not worked then will ask you.
Thanks for soln. Smile | :)

Believe Yourself™ $Shucks | :-\$ ™

Re: Make sorting on multiple columns with diffrent criteria

Blue_Boy5-Aug-08 21:46

Blue_Boy

5-Aug-08 21:46

Gandalf - The White wrote:
If not worked then will ask you.

You are welcome

Gandalf - The White wrote:
Thanks for soln.

You are welcome

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

Re: Make sorting on multiple columns with diffrent criteria

Ashfield5-Aug-08 0:18

Ashfield

5-Aug-08 0:18

While I don't like to contradict, I have yet to come across a database that doesn't sort as specified. Obviously the records will be sorted by the second column within the order of the first.

SELECT id, lastName, title, age
       from #employee ORDER BY
       title DESC, age ASC;

gives

id lastName title age
3 Pandit Web Designer 24
4 Anchor Web Designer 27
14 Gibson System Administrator 31
13 Lewis System Administrator 32

so lets start at the beginning. What database are you using? Where is your query and the results?

Bob
Ashfield Consultants Ltd

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.