Is my connection string right?

Question

1.00/5 (1 vote)

See more:

I'm creating Win32 DLL project in VS 2015.

Using the following code:

C++

hr = pConnection->Open("Server=tcp:xxx.cloudapp.azure.com;Database=db_name;User ID=user_name;Password=psw;Trusted_Connection=False;Encrypt=False;", "", "", adConnectUnspecified);

Is it a correct code? The thing is that it don't work :(

What I have tried:

Checked SQL Server logs - no any authorization errors.
This is DLL, I don't really know how to debug it. Actually I can't debug it. So I don't know what my error exactly. I just know it stops after the string above.

Posted 27-Jun-17 2:02am

Member 13277231

Updated 27-Jun-17 9:21am

Add a Solution

Comments

Richard MacCutchan 27-Jun-17 9:00am

Without some debug information it is difficult to guess what is wrong. Since you created the DLL and you know where it stops you should be able to easily debug it.

Member 13277231 27-Jun-17 9:09am

I don't know but I cannot attach the calling application...
The dll returns just retcode (int). How do I get retcode of the error? I found some examples of erros processing with try/catch https://docs.microsoft.com/en-us/sql/ado/reference/ado-api/execute-requery-and-clear-methods-example-vc
But it's using printf... How can I do the same but with the error code?

Richard MacCutchan 27-Jun-17 10:21am

Surely if it is your code you can look at the part that returns an error code and find out what is going on. No one here can guess what your code does.

ZurdoDev 27-Jun-17 9:27am

https://www.connectionstrings.com/sql-azure/

Member 13277231 27-Jun-17 10:05am

which one should I use? The one which is for .Net?

Richard Deeming 27-Jun-17 13:29pm

"Is it a correct code? The thing is that it don't work :("

You've just answered your own question - if it doesn't work, then it's not correct.

Now you just need to find out why it doesn't work, and what you need to do to fix it. Since we don't have access to your system, or to the code you're trying to call, we can't do that for you.

Member 13277231 27-Jun-17 13:58pm

My connection string:
hr = pConnection->Open("Server=sql.servername.com;Database=db_name;User ID=user_name;Password=psw;Trusted_Connection=True;", "", "", adConnectUnspecified);

And I managed to output the error:

Error
Code = 80004005
Code meaning = U
Source = Microsoft OLE DB Provider for ODBC Drivers
Description = [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

So what exactly does it mean? How do I modify the connection string to get it work?

Richard Deeming 27-Jun-17 14:06pm

It looks like the library you're calling is expecting an ODBC connection string. You should be able to generate one from your Azure portal[^]. Under "SQL Databases", click on "Show database connection strings", select the "ODBC" tab, and copy the connection string.

Get connection information | Connect to Azure SQL Database by using .NET (C#) | Microsoft Docs[^]

Member 13277231 27-Jun-17 15:20pm

No, it is not a real azure. Azure just VPS, it's standalong SQL Server.

Richard Deeming 27-Jun-17 15:25pm

So you need to use a SQL Server ODBC connection string:
Microsoft SQL Server ODBC Driver Connection Strings - ConnectionStrings.com[^]

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)

Member 13277231 · Accepted Answer · 2017-06-27T09:21:00

Solution 1

I think I managed to solve it by adding

Driver={SQL Server};

in the begining of the string:

C++

<pre>hr = pConnection->Open("Driver={SQL Server};Server=sql.servername.com;Database=db_name;User ID=user_name;Password=psw;", "", "", adConnectUnspecified);

Thank you.

Posted 27-Jun-17 9:21am

Member 13277231