Automatic DSN 1

[hitechboy78737]

As I understand it, the Application.Startup path is a different value in debug builds and release builds.

I've solved the problem by stripping off the "\bin" and adding "<insert data string here>", knowing that I have to change this when I build a release.

First, do I have this concept right?

Secondly, Couldn't I look at some property to see if the build is release or debug and set the string accordingly? If so, what would this magic property be?

strMagicProp = somenamespace.MagicProperty
if strMagicProp = "debug" then
  <insert debug DSN string>
elseif strMagicProp = "release" then
  <insert release DSN string>
else
     PUNT!
end if

Thanks!
Kevin Howell

 

[neilharris]

Yes you can do it, using conditional compiler directives.

dim strDSN as string = releaseDSNString

#If DEBUG Then
        strDSN = DebugDSNString
#End If

In this example we set the DSN string to the release version by default, then we test for DEBUG mode and if necessary override the default DSN string with out test one.

 

[hitechboy78737]

Bingo! Thanks Neil!