ini files for constants

[Steffen.Schmidt]

Hi,

I would like to use an ini-file for some database information (like user, database name etc.). Want I want to do is when I build the SQL connection string to the database to take this information out of the ini-file just like the use of language resource files.

Example:
"Provider=MSDAORA.1;Password=" + ResStr("ORACLE"; "Password") + ";User ID=" + ResStr("ORACLE"; "User") + ";Data Source=" + ResStr("ORACLE"; "Database") + ";Persist Security Info=True"

To get this one working I have to place the ini-file into the language directory. As this has nothing to do with language I would like to have it in some other directory.
Any suggestions???

Best regards
Steffen

[Watermann]

hi Steffen,

the only thing 'bout that I could find is this thread.
sorry, but perhaps someone else knows a way though this...

greets!

[RayFarmer]

Hi,

There was an example on NI website, a few years ago, for a sequence file using the DLL adapter step type calling a windows kernel32.dll to read data from an INI. I have had a look on the NI website, but unfortunately I haven't been able to find the example.

It makes calls to functions such as GetPrivateSectionName() and GetPrivateProfileString().

I may still have that example, but it may take some digging on CD's, to find it.

Regards
Ray Farmer

[Steffen.Schmidt]

Hi Ray,

I'll appreciate it very much if you could find the example!

Regards
Steffen

[RayFarmer]

Hi,

Attached is an example, its not the one I obtained from the NI website, I'm still looking for that. This one I must have developed while trying things out.

Hope it helps

Regards
Ray Farmer

reason for edit: forget to attach example

Message Edited by Ray Farmer on 06-22-2005 09:54 PM

[RayFarmer]

Hi,

Found the example.

Regards
Ray Farmer