|
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.
|
|
|
|
|
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?
|
|
|
|
|
How to get the output parameter value
|
|
|
|
|
Check this google result.[^]
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
|
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
|
|
|
|
|
|
Are you sure that the link,Provide by you is For SQL Express(Compatible with vista)
|
|
|
|
|
|
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
|
|
|
|