why am I getting an empty string

Question

0.00/5 (No votes)

See more:

I was wondering what I am i doing incorrectly in the following code to retrieve a connection string from an .ini file. I keep getting a blank string.
I have my API declared in my global mod.

'Get DB Loaction from INI file
 
Dim strDBConnect As String
 sSection$ = "DB1"
 sEntry$ = "DATABASECONN209"
 sDefault$ = ""
 sRetBuf$ = String$(256, 0) '256 null characters
 iLenBuf% = Len(sRetBuf$)
 sFileName$ = "c:\program files\conn.ini"
 '*
 X = GetPrivateProfileString(sSection$, sEntry$, _
 sDefault$, sRetBuf$, iLenBuf%, sFileName$)
 '*
 sValue$ = Left$(sRetBuf$, X)
 strDBConnect = sValue$ <<---Blank string, no return of connection string.

==========In my .ini file i have the following

[DB1]
 DATABASECONN209="Provider=SQLOLEDB;Data Source=222.34.34.34;Initial Catalog=xxx;User Id=appxxx;Password=@xxxpassword"

Thanks,
Gene

Posted 22-May-14 8:18am

Member 10823890

Updated 22-May-14 8:23am

PIEBALDconsult

v2

Add a Solution

Comments

PIEBALDconsult 22-May-14 14:25pm

Don't you have to pass in the address of sRetBuf$ ?

2 solutions

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)

OriginalGriff · Answer 1 · 2014-05-22T08:26:00

We can't answer that - we don't have access to your computer, or your INI file.

So use the debugger: place a breakpoint on the first line, and follow each line through working out what it should produce before you execute it. Compare that with what did happen, and if they are different work out why.

We can't do it for you - we can't run your program under the same conditions you can, so you will have to do this part yourself!

Maciej Los · Answer 2 · 2014-05-22T08:44:00

Please read comments to this article: GetPrivateProfileString function[^]. You'll find there:

Adam L Wa wrote:
This function will not work if ini file contains only 1 entry
This might be specific to Unicode ini files, but I spent quite some time trying to figure out what I was doing wrong. It turns out I wasn't doing anything wrong, and this function has a bug. My ini file only needed one section and key, e.g.:
[SomeEntry]
Foo=Bar

You can write custom function too, which
1) opens an ini file
2) reads it content line by line
3) proceeds each line with string functions[^], like: Instr[^], Mid[^], etc.

why am I getting an empty string

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0