Sqldriverconnect is not returning outconnection string

Question

0.00/5 (No votes)

See more:

RETCODE rc1 = SQLDriverConnect(m_hConnect, hWnd, (_TUCHAR*)(LPCTSTR)sConnect, SQL_NTS,szFullConnect, sizeof szFullConnect, &avail, prompt);

In above statement of C++ code szFullConnect is suppose to return connection string
which is utilised in program.But in my code at one place this is coming as garbage
characters .Can anyone help me please to solve the issue.

What I have tried:

I googled lot but can not find concrete help

Posted 3-May-20 21:25pm

adityarao31

Updated 4-May-20 6:48am

Add a Solution

Comments

Richard MacCutchan 4-May-20 4:02am

Since we have no idea what source data is being processed it is impossible to know what actual characters should be returned, and we cannot see what you see. Are you sure you are not just mixing ASCII and Unicode?

adityarao31 4-May-20 4:12am

Actually connection string returned by function is used to connect database

Richard MacCutchan 4-May-20 4:51am

We know that. What we need to know is the actual definition of all the variables that are used in your call to SQLDriverConnect, and the actual data content of any that contain initial data. Please edit your question with this information, and also the characters that you see on return.

1 solution

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)

KarstenK · Answer 1 · 2020-05-04T06:49:00

Solution 1

The most common reason is that you have mismatched the character type in the string parameters.

Use SQLCHAR at all parameters and create or cast them properly. Depending on your compiler settings you may need conversion function. Type cast may not be enough.

btw: two type cast at one parameter is a strong hint that there is something very fishy ;-)

Posted 4-May-20 6:49am

KarstenK

Comments

adityarao31 5-May-20 4:03am

szFullConnect I have defined as SQLCHAR only