I want to connect a SQL Server DB through C++/VC++ coding. Any help links / sample code / regarding stuff then pls mail to sudarshanmca@gmail.com. Thanks in advance. Regards

Regards SG

+ return NULL if any one of the field contains NULL value. Otherwise both more or less returns same results. :)

Regards SG

Hi, You are doing division and multiplication through only int datatype only. Do type-casting of one of the variables or value. say (price * ((100-10) / 10.0)) Hope this shud work 4 U... :)

Regards SG

Hi, #include "....." is to include the files which are in your current working directory. For eg. if you have created some file which needs to be included in another cpp / c file for using a function or any member the you can use this option. if u have created a file a.cpp having some generalize function and you want to use this function in every other .cpp program then you can include this source code file in other source code using #include "a.cpp" #include <.....> is generally for dev/project Include folders which contains built-in .h files or any other files. :)

Regards SG (sgg245@yahoo.co.in)

I have created a HTTP URL and now I want to send a HTTPRequest using C++ / VC++. How to achieve this? Thanks in advance. sgg245 :-D :) :-D

Regards SG (sgg245@yahoo.co.in)

Thanks very much. I anticipated something like we used to do in VB status bar panels... Anyways, again thanks for ur help... so kind of u...:-D

Regards SG (sgg245@yahoo.co.in)

Thanks so much. Its working. But stil a prob. This is when the application start it detects if the CAPSLOCK is ON then I can display certain msg or so... But I want whenever CAPSLOCK button is pressed then it should update the status of the panel in the status bar. If CAPSLOCK is ON then status bar panel should show ON. If CAPSLOCK is toggled i.e. OFF then status bar panel should show OFF. Something like this... Thanks in Advance...;):);)

Regards SG (sgg245@yahoo.co.in)

Ur question is very un-clear.. it doesnt suggest wat u r trying to do and wat is the problem.. better write ur prob in points rather to use single sentence, like wat u r doing, wat u want to do and wat the problem is

Regards SG (sgg245@yahoo.co.in)

I m using a status bar in the form. In one of the panels of the status bar, I just want set the status of the CAPSLOCK & NUMLOCK, the same way it can be done in VB. But in VB the panel properties has different display value, so it was easy. How this can be achieved in C#???:confused: Thanks in advance...:)

Regards SG (sgg245@yahoo.co.in)

On my OS regional setting is Chinese(PRC). I hav a MFC dialog. One of the control is of ControlType "CEdit". This control is restricted to take numeric inputs (ES_NUMBER) only and that too of 2 digits (using SetLimitText(2)) only. While running the application, when I enter a single digit it automatically gets twice. For instance if I enter 5 it gets converted to 55 and so on... So in that case I cannot enter 2 digits as max limit of the control is set to 2. Plz help... Thanks in advance...

Regards SG div>

Go to Configuration Manager for SQL Server 2005. Check if Shared Memory, Named Pipes & TCp/IP for the instance are enabled or not. Hopefully this should resolve ur error.

Regards SG (sgg245@yahoo.co.in)

The datatype of the column should be DATETIME... Use the following type query:: select convert(varchar(10), c6, 108) from t1 In this query, Column 'c6' is of DATETIME type and this query will give you only time part of the column and over this you can use DATEDIFF() function...

Regards SG (sgg245@yahoo.co.in)

DATEDIFF() function accepts two DATETIME values and a date portion (minute, hour, day, month, and so on) as parameters. DATEDIFF() determines the difference between the two date values passed, expressed in the date portion specified

Regards SG (sgg245@yahoo.co.in)

Do u want that field values should be displayed in Title Case rather than entirely lowercase / UPPERCASE?? Please clarify!!:)

Regards SG (sgg245@yahoo.co.in)

I have a central db as publisher on SQL Server 2005, which has SUPERVISOR user having sysadmin rights. And created another client db with subscriber user (not having sysadmin rights on the publisher SQL Server 2005), say U1, on SQL Express 2005 instance. As subscriber is the owner of db of subscriber db, so has sysadmin rights on the SQL Express 2005. Done all the pre-requisite for merge replication. When I try to replicate between the publisher db & subscriber db with subscriber user, it gives error "The Publisher failed to allocate a new set of identity ranges for the subscription. This can occur when a publisher or a republishing Subscriber has run out of identity ranges to allocate to its own subscriber or when an identity column data type does not support an additional identity range allocation. If a republishing subscriber has run out of identity ranges, synchronize the republishing subscriber to obtain more identity ranges before restarting the synchronization. if a publisher runs out of identity....." Although, if the subscriber user is created as sysadmin on the publisher i.e. SQL Server 2005 then the synchronization works perfectly and synchronizes the data. :confused::confused: I would like to know why SYSADMIN right is needed to be given to the subscriber user at the publisher i.e. SQL Server 2005 instance??? Regards

Regards SG (sgg245@yahoo.co.in)

Tell me what is the type of column for which you are doing pattern-matching?? If the datatype of the column is nchar then it will return 0 records. Bcoz then its Unicode pattern - matching... :)

Regards SG (sgg245@yahoo.co.in)

It should work perfectly. I dont see any reason for this query not working. I have tried a similar query as: select c1, c5 from t1 where c5 like 'R%' and this returns all the records for which c5 columns has values starting with 'R'. Juz try it again. Otherwise provide table records and structure... Letz see whats the probs??

Regards SG (sgg245@yahoo.co.in)

I have a central db as publisher on SQL Server 2005, which has SUPERVISOR user having sysadmin rights. And created another client db with subscriber user (not having sysadmin rights on the publisher SQL Server 2005), say U1, on SQL Express 2005 instance. As subscriber is the owner of db of subscriber db, so has sysadmin rights on the SQL Express 2005. Done all the pre-requisite for merge replication. When I try to replicate between the publisher db & subscriber db with subscriber user, it gives error "The Publisher failed to allocate a new set of identity ranges for the subscription. This can occur when a publisher or a republishing Subscriber has run out of identity ranges to allocate to its own subscriber or when an identity column data type does not support an additional identity range allocation. If a republishing subscriber has run out of identity ranges, synchronize the republishing subscriber to obtain more identity ranges before restarting the synchronization. if a publisher runs out of identity....." Although, if the subscriber user is created as sysadmin on the publisher i.e. SQL Server 2005 then the synchronization works perfectly and synchronizes the data. :confused::confused: I would like to know why SYSADMIN right is needed to be given to the subscriber user at the publisher i.e. SQL Server 2005 instance???:confused::confused: Regards SG (sgg245@yahoo.co.in)

Hi, Can anybody help me to get Icon details like its name, target path, working directory whenever it is double-clicked to run the application. This is be using Windows API or in C#. I have already used IShellLink Interface but its been hard-coded for icon name. Suppose the user changes desktop icon name then also coding should be able to change its working directory. This can be done if I can check the existence of the icon. Regards.

Hi, Can anybody help me to get Icon details like its name, target path, working directory whenever it is double-clicked to run the application. This is be using Windows API or in C#. I have already used IShellLink Interface but its been hard-coded for icon name. Suppose the user changes desktop icon name then also coding should be able to change its working directory. This can be done if I can check the existence of the icon. Regards. Chilly