How to get full string in sqldatasources

Question

0.00/5 (No votes)

See more:

I am getting the first character of the output where as I need full text in the output terminal.

Output I get:

Data Source - E
Data Source - M

What I have tried:

C++

#define NANODBC_USE_UNICODE 1
#ifdef _MSC_VER
#define _CRT_SECURE_NO_WARNINGS
#endif

#include <windows.h>  
#include <sqltypes.h>  
#include <sqlext.h>  
#include <iostream>
#include <string>
#include <stdio.h>
#include <iomanip> 

using namespace std;

#define BRWS_LEN 1000

int main() {
  

    SQLSMALLINT dsnNameLenReturned;

    SQLCHAR * driverDesc[256];
    SQLCHAR  dsnName[256];
    SQLRETURN retcode;
    SQLSMALLINT driverDescLenReturned;
    SQLUSMALLINT direction;


    // Allocate environment handle
    retcode = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv);
   

    // Set ODBC version
    retcode = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION,
        (void*)SQL_OV_ODBC3, 0);

    retcode = SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);
    
            
            // Get Data source names

            direction = SQL_FETCH_FIRST;

            SQLDataSources(henv,
                direction,
             (SQLWCHAR*)dsnName,
                sizeof(dsnName),
                &dsnNameLenReturned,
               (SQLWCHAR*)driverDesc,
                sizeof(driverDesc),
               &driverDescLenReturned);
            {

                direction = SQL_FETCH_NEXT;
               
                printf("Data Source - %s\n", dsnName);
                printf("Data Source - %s\n", driverDesc);


            }

        }

exit:
    printf("\nComplete.\n");

    if (henv != SQL_NULL_HENV) SQLFreeHandle(SQL_HANDLE_ENV, henv);
    system("pause");
    return 0;
}

Posted 24-Oct-22 17:34pm

Abishek Samuel

Updated 24-Oct-22 21:57pm

OriginalGriff

v2

Add a Solution

2 solutions

Solution 1

I think the problem is the type you have declared this variable as :

C++

SQLCHAR * driverDesc[256];

That is an array of 256 pointers. The prototype says the function wants a single character pointer. Try using

C++

SQLCHAR driverDesc[256];

Posted 24-Oct-22 18:32pm

Rick York

Comments

Abishek Samuel 25-Oct-22 0:59am

I changed it and Tried .Still the same output is produced.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Accepted Answer · 2022-10-24T21:57:00

C++

SQLCHAR * driverDesc[256]; // both of these are character arrays (assuming you fixed driverDesc)
SQLCHAR  dsnName[256];

        SQLDataSources(henv,  // from the below casts I am guessing that this function returns wide characters.
            direction,
         (SQLWCHAR*)dsnName,
            sizeof(dsnName),
            &dsnNameLenReturned,
           (SQLWCHAR*)driverDesc,
            sizeof(driverDesc),
           &driverDescLenReturned);

So you now have two character arrays filled with Unicode characters. So when you try to print them as ASCII you get the results you see. You need to understand that using a cast does not change the original item, it just tells the compiler to ignore the item's declared type, and assume that you the programmer know what you are doing.

So change the definitions to

C++

SQLWCHAR driverDesc[256]; // Define with the correct type
SQLWCHAR  dsnName[256];

And do not use sizeof to get the number of wide characters. That returns the number of bytes, so you need to divide by 2, or use _countof instead.