Visual C++ :: Getting Indexes Information From SQL Server?

Jan 6, 2014

Trying to get table indexes information in SQL Server 2012 I identified a strange situation for one scenarion.I have a table that contains two indexes referenced to some fields: Field_1 and Field_3 mapped over int, null columns (the number means the existing field order into the table designed few years ago...).

I am trying to get information about these indexes like this:

Code:
nRetCode = ::SQLStatistics(hstmtAux, NULL, 0, NULL, 0, (TCHAR*)(LPCTSTR)strTempTable, SQL_NTS, SQL_INDEX_ALL, SQL_ENSURE);
if (nRetCode == SQL_SUCCESS || nRetCode == SQL_SUCCESS_WITH_INFO)
{
nRetCode = ::SQLBindCol(hstmtAux, 4, SQL_C_SHORT, &swNonUnique, sizeof(SWORD), &cbNonUnique);
nRetCode = ::SQLBindCol(hstmtAux, 5, SQL_CHAR, szIdxQualif, sizeof(CHAR) * 130, &cbIdxQualif);
nRetCode = ::SQLBindCol(hstmtAux, 6, SQL_C_CHAR, szIdxName, sizeof(CHAR) * 130, &cbIdxName);
nRetCode = ::SQLBindCol(hstmtAux, 7, SQL_C_SHORT, &swType, sizeof(SWORD), &cbType);
nRetCode = ::SQLBindCol(hstmtAux, 8, SQL_C_SHORT, &swSeqInIdx, sizeof(SWORD), &cbSeqInIdx);
nRetCode = ::SQLBindCol(hstmtAux, 9, SQL_C_CHAR, szIdxColName, sizeof(CHAR) * 130, &cbIdxColName);

[code]....

Becasuse SQLExtendedFetch() is deprecated I used SQLFetchScroll() but the behavior is the same from my interest point of view.

Usally, I get the right information about indexes but in one situation I encounte a strange behavior. It's about having a clustered index into a scenario.
When Field_1 is Non-Unique, Non-Clustered and Field_3 is Clusted index I get the right information.

But if the index Field_1 is Clustered and the Field_3 is Non-Unique, Non-Clustered I get no information about Field_1 index (eg. szIdxName and szIdxColName are "" and their length is -1 that means SQL_NULL_DATA). So, I have no Index information. Within while loop, with the next iteration I get correct information about the second index Field_3.

I'm not sure whether the problem is with SQLStatistics, the bindings or SQLFetchScroll (they all always return SQL_SUCCESS). It looks like a problem with the driver when the first index is clustered.

View 6 Replies


ADVERTISEMENT

Visual C++ :: Retrieve IP Information On Any Windows

Sep 23, 2012

I used to retrieve IP and NIC information by querying windows registry. Now I'm trying to use GetAdapterAddresses() API. Using GetAdapterAddresses() to get IP is not that easy, I need to dig a long deep as I check some examples so far, anyways my question is: Calling this API will return success on all versions of Windows ie: 32bits & 64bits ?

Though Microsoft has not opened any source, where this API is actually retrieving Windows IP information.?. Is it reading Registry or some windows file.

View 6 Replies View Related

Visual C++ :: ActiveX For Video Server

Jan 13, 2015

I would like to know in which way is the best to make ActiveX control for video. ActiveX control will need at least show picture and be able to go back in past, change resulation of picture and similar. How complex it is to do something like that? Is MFC best way to make it? Is there somewhere similar code?

View 2 Replies View Related

C++ :: Get Matrix Indexes From The Value

Oct 17, 2013

I have a 3x3x3 matrix with values hanging from 1 to 27.

The order is this: Code: m[0][0][0] = 1;
m[0][0][1] = 2;
m[0][0][2] = 3;
m[0][1][0] = 4;
m[0][1][1] = 5;
m[0][1][2] = 6;
.
.
.
m[1][0][0] = 10;
m[1][0][1] = 11;
m[1][0][2] = 12;
.
.
.
m[2][2][0] = 25;
m[2][2][1] = 26;
m[2][2][2] = 27;

Is there an easy way to compute the indexes given the value? For example, I know that the first index can be found by dividing the value by 9.0: Code: const int firstIndex = ceil(value / 9.0) - 1; What about the second and the third indexes? I couldn't find a pattern in the numbers, and I didn't want to iterate through the matrix (the indexes will be calculated many times).

The other option is to create arrays where the values will be indexes and the matrix indexes will be the values. I'm not sure if it is the best way though

View 6 Replies View Related

Visual C++ :: Creating A Virtual Mini Server?

Jul 28, 2014

Is it possible to create a virtual mini server (like IIS) that takes http request? I have a toolbar that queries an DLL using http request, and then that DLL stores some arguments in some XML file, which is read by an anti-malware.

Now every customer can't have an IIS server installed. Most of the end users uses Windows XP home edition. So is there a way i can create a virtual mini server that can be used in these PCs for placing http request?

View 14 Replies View Related

Visual C++ :: Does Not Contain Debug Information - Press OK To Continue

Sep 18, 2012

i changed my code from release to debug mode. when i try to debug it shows a dialog box that '... does not contain debug information press ok to continue"..

View 8 Replies View Related

Visual C++ :: Replacement Of NtQuery System Information On Win X64

Apr 4, 2014

I am struggling to find a replacement of NtQuerySystemInformation call for 64-bit Windows OS, like on Windows Server 2008 (64-bit). Need getting overall CPU utilization (average) over all CPU cores?

Code:
#include "StdAfx.h"
#include "CpuMuninNodePlugin.h"
#define SystemBasicInformation 0
#define SystemPerformanceInformation 2
#define SystemTimeInformation 3

[Code] ....

View 6 Replies View Related

Visual C++ :: Dump Information To Console Or Output Window?

Feb 6, 2014

I used to use OutputDebugString, and not using it now because it only allows to strings to be outputted, are there any methods that I can dump virtually anything to the console?

cout << thing << endl;

But what if I am not start running the program from the command prompt?

View 2 Replies View Related

Visual C++ :: How To Insert And Read Image From Database (SQL Server) Using MFC

Jan 25, 2015

How to insert and read images to/from database (sql server) using MFC ?

View 5 Replies View Related

Visual C++ :: Winsock - Accepting Multiple Clients On A Server?

Jun 16, 2013

My problem is that I've created a Client and Server program in which they communicate. The Client is an SDL Application that allows you to play as a movable character IF YOU ARE CONNECTED TO THE SERVER. If not, You're unable to play. THIS WORKS!

However, Only one client is able to play on my server?? Anyone elses' window freezes and they are not allowed to play (As if not connected to the server). Here is my server code.

Code:
#include <iostream>
#include <winsock2.h>
#include <vector>
#include <process.h>
#include "Included/pthread.h"
#define MAX_THREADS 5
bool gamerunning = true;

[Code] ....

I'm having troubles allowing more than one client to play on the server.

View 2 Replies View Related

Visual C++ :: Program That Get Information From DAT File - Unresolved Ecternals

Mar 10, 2014

I am writing a program that grabs information from a .dat file. I have the code all structured up, but I get these 2 errors that does not make any sense to me on how to fix the program.

errors (2):

Code:
Error1error LNK2019: unresolved external symbol "void __cdecl swap(class std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > *,class std::basic_string<char,struct std::char_traits<char>,
class std::allocator<char> > *)"

[Code] ....

Error2error LNK1120: 1 unresolved externalsC:UsersMomDesktopDriveQuarter 2C++ProjectsDynamicDeptPayrollDebugDynamicDeptPayroll.exeDynamicDeptPayroll
.dat file contents:

Code:
Fogarty Bob 1 40 10.25
Smith John 2 38 8.72
Jones Mary 2 28 6.25
Arrmen William 1 15 8.22
Lavey Betty 1 32 15.00
source contents:

Code:
#include <iostream>
#include <string>
#include <fstream>
using namespace std;
//PROTOTYPES
void sort(int n);
void swap(string *p1, string *p2);

[Code] ....

View 2 Replies View Related

C++ :: Storing Integers At Odd And Even Indexes In Array

Mar 4, 2013

here is my problem given below Input values (say 10) from user in array, if the value is even then place at even index else at odd index. Then how could i solve this problem?

View 2 Replies View Related

Visual C++ :: Application Which Stores Information About People Along With Task List

Dec 19, 2012

Basically the question is to develop an application that allows: Create an application which stores information about people, along with a task list.

The user should be able to Store people's information

Name,
Age,
Telephone number,
Address

-Retrieve information by entering name
- Remove a person's record by entering their name
-Return records for all people, sorted according to an information type other than age
-Enter a task which needs doing, a priority entered for its urgency
-View highest priority task on the list
-User should be able to remove highest priority item on the list

How to develop this application on a console command line interface style or any other style.

View 2 Replies View Related

Visual C++ :: Change HTTP Request Server Response - Proxy?

Nov 19, 2013

Is there anyway to make when browser request some file from server than browser to load another file. Example:

I open [URL] ....

So now the browser send http request to load image [URL] ....

so when browser want to load that image to load this image [URL] ....

I do this now with [URL] ....

I think this can be done with Wininet.dll and WinHTTP.dll

View 3 Replies View Related

C++ :: Save The Indexes Of Multi-dimensional Arrays

Apr 8, 2014

I am working on the game of fifteen.Yes this is home work. I was wondering if it is possible to save the indexes of an element in a two dim array. I need to find the position of the space in the two dim array save it, find the position of the tile which is passed in as an int and swap the two if they are adjacent. Here is my code

Edit: I can do this by saving i and j in separate int variables but is there a more elegant way of doing this

int board[MAX][MAX];
void init();
void swap(int* lhs, int* rhs);

[Code].....

View 3 Replies View Related

Visual C++ :: How To Retrieve Remote Desktop User Domain Name On Win2008 Server

Oct 9, 2012

How can I do this??

Suppose I have Win2008server and many users from defferent domains log in, so every user has its own session.

How can I obtain from the session the domain name of the user who logged in to server??

View 1 Replies View Related

C++ :: Tree Arrays Of Same Even Lengths And Adds Values At Odd Indexes

Oct 22, 2013

I am trying a program with that takes tree arrays of same even lengths and adds the values at odd indexes and save at even index of 3rd array and voice versa........

what will be the logic i have tried it a lot of time not worked................

View 3 Replies View Related

C++ :: Loop Through Indexes In Guess Array And Assign M Randomly

Jan 19, 2013

Just run a loop through each of the indexes in the guessarray and assign 'M' to them randomly.

View 2 Replies View Related

C++ :: How To Program A Hash Map System Where Each Key Have Multiple Values Under Indexes

Nov 13, 2013

How difficult would it be to program a hash-map system where each "key" can have multiple values under indexes?

For example: "Word" -> 45(index 0) , 67(index 1) , 12(index 2). What could I start with to program this or where could I find a pre-made system that does this?

View 14 Replies View Related

Visual C++ :: Excel Automation - Window Doesn't Come To Foreground In Windows Server 2008

Feb 10, 2014

We have a C++ 5.0 app that does something like this:

Creates the excel dispatch, exports the data, etc...
...
then calls these functions:

xlsApp.SetDisplayAlerts(TRUE);
xlsApp.SetVisible(TRUE);
xlsApp.SetUserControl(TRUE);

This has always worked to display the excel spreadsheet in the foreground, most recently on Windows Server 2003.

Now, testing on Windows Server 2008, the excel spreadsheet is created, but in the background. How to force it to the foreground?

View 2 Replies View Related

Visual C++ :: Search Function - Ask User To Input Name And Brings Out Line From TXT File Containing Information

Dec 8, 2013

How to get this thing to work. All i need to do is ask user to input a name and then it brings out the line from the .txt file containing the information.

For example in my case I'm doing a member search function I'm required to ask user to input the name of the customer and then print out all the details (which consumes 1 text line in the .txt file)

Here is the code, This is the write to text file method (100% working)

Code:
cout << "Customer Name: ";
cin >> name;
// ...
ofstream myfile("customer.txt", ios::app);

[Code] .....

View 3 Replies View Related

C :: Accept Information Of 5 Students And Display Information Of First 3 Students - Unable To Get Output

Aug 15, 2013

Code to accept the information of 5 students and display the information of first 3 students......

Code:
#include<stdio.h>
main() {
struct stud {
char name[20];
int rollno;
float per;
char grade;

[Code] ....

View 6 Replies View Related

C++ :: Connecting To SMS Server?

Nov 11, 2013

I'm currently in the middle of designing a program for some project. one part of the program is to send reminding SMS messages to the employees.

I have already subscribed to a SMS provider that has SMS integration - API. But now I'm wondering how will I be able connect to the SMS server and be able to send messages?

View 1 Replies View Related

C++ :: How To Get Information About Printer

May 21, 2014

The problem is when i run this program and program is stop working but the output is out.

#include <iostream>
#define _WIN32_WINNT 0x0500
#include <windows.h>
#include <conio.h>
using namespace std;
void EnumeratePrinters(DWORD flags);

[Code] ....

View 6 Replies View Related

C++ :: Reading Information Off The Web?

Sep 9, 2013

I am building a program that will read from a particular web page. I have written it so that it will parse the page correctly, but I can only do it for a downloaded page right now. I would like for it to work simply with the URL.

I have seen things about "screen scraping", though I don't quite understand what it does - I think it's more for just parsing it, which I can already do.

If it is possible to automatically download that file, that is fine as well.

If it matters at all, the pages I am reading from are stories on Fanfiction.net.

View 1 Replies View Related

C++ :: Downloading File From Web Server?

Jul 4, 2014

I cant seem to get it to write out the correct size to the .gif file,the original is 3kb but the new one i write to finishs with 1kb.

Code:
cout << "Connected"<< endl;
std::string sendbuffer = "GET /apache_pb.gif HTTP/1.1
"
"Host: 192.168.1.4
";
// std::string buffer2 = "GET /apache_pb.gif HTTP/1.1
Host: 192.168.1.4

[Code] ......

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved