Database

Comprare two column headings

6-Aug-08 7:07

Ok,

Most of the settings can be configured during silent installation. The key is TEMPLATE.INI-file. Have a look at this article http://msdn.microsoft.com/en-us/library/ms144259.aspx[^].

I don't remember if all of the things you wanted to do are possible. For example login creation may not be possible, but you can always use a custom command line script, which first runs install and configuration and then use (for example) OSQL to create login silently.

Hope this helps,

Mika

DFlat4Now5-Aug-08 6:24

DFlat4Now

5-Aug-08 6:24

I have one table and the columns are exactly as they should be. I am sent new data that needs to match the columns headings of this first table exactly. How do I create a sql query (it's really in Access) that does a quick compare and show me any differences or how the new violates the standard?

Re: Comprare two column headings

DerekFL5-Aug-08 7:02

DerekFL

5-Aug-08 7:02

By violates do you mean violates a foreign key?

Re: Comprare two column headings

DFlat4Now5-Aug-08 8:30

DFlat4Now

5-Aug-08 8:30

There are no keys. I simply want to check the column headings with a table we know is correct with the new incoming table. How does the new table (if at all) differ from the standard (I know the columns are right) table.

How to convert variant_t data type to char* or char array or const char* or CString data type?

yklim5-Aug-08 6:03

yklim

5-Aug-08 6:03

I use ado _RecordsetPtr to get an item from oracle database using GetValue()to read a field named Source which is of varchar2(10) datatype.

variant_t vtSource = rst->Fields->GetItem("SOURCE")->GetValue();

Can anyone show me sample code on how to convert vtSource which is of variant_t data type to char* or char array or const char* or CString data type?

Output Parameter value

ThangamSundar5-Aug-08 2:40

ThangamSundar

5-Aug-08 2:40

How to get the output parameter value

Re: Output Parameter value

Blue_Boy5-Aug-08 2:51

Blue_Boy

5-Aug-08 2:51

Check this google result.[^]

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

Re: Output Parameter value

John_Adams5-Aug-08 19:12

John_Adams

5-Aug-08 19:12

Hi,

Please go take a look at the following article of Microsoft.
http://support.microsoft.com/kb/262499[^]

Hope this helps Smile | :)

Regards,
John Adams
ComponentOne LLC

Download Vista Compatiable SQL Server EXPRESS

sunil goyalG5-Aug-08 1:12

sunil goyalG

5-Aug-08 1:12

hi all,
can any body help me to find the SQL Server Express which is compatible to Vista. If yes then Please provide the link So i can download the SQL Server

Blue_Boy5-Aug-08 3:06

Blue_Boy

5-Aug-08 3:06

Download Express 1.9 Vista Compatible [^]

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

sunil goyalG5-Aug-08 5:37

sunil goyalG

5-Aug-08 5:37

Are you sure that the link,Provide by you is For SQL Express(Compatible with vista) Big Grin | :-D

Wendelius5-Aug-08 7:33

5-Aug-08 7:33

Hi,

The registration and download page can be found here http://www.microsoft.com/sql/editions/express/default.mspx[^]

Mika

sunil goyalG7-Aug-08 5:35

sunil goyalG

7-Aug-08 5:35

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

Wendelius7-Aug-08 6:29

7-Aug-08 6:29

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

Wendelius16-Aug-08 21:02

How to lock an Active Directory user account

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

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

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

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

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

NiloofarNoroozi5-Aug-08 10:34

NiloofarNoroozi

5-Aug-08 10:34

thank you very much

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

Cannot resolve collation conflict for concatenation operation

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

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