Hello,

I am getting this error when I run my code, it complies ok.

 System.NullReferenceException: Object reference not set to an instance of an object

---------------------------
Here is my code for my class:
Imports Microsoft.Win32
Imports System.Data

Public Class clsConnectionString
    Public Function GetConnectionString(ByVal strConnID As String) As String

        'define objects
        Dim objRegistryKey As RegistryKey
        Dim objDatabase As Object

        'define variables
        Dim ConnectionStringArea As String = "SOFTWARE\MyApp\"
        Dim strConnectionPath As String = ConnectionStringArea & strConnID

        'set object to string in registry & return string value
        objRegistryKey = Registry.LocalMachine.OpenSubKey(strConnectionPath , False)
        objDatabase = objRegistryKey.GetValue("strConnID")
        Return Convert.ToString(GetConnectionString(objDatabase))

    End Function

End Class

-------------------------------

I get the error on the "RED" line in my code.

Any help with this is greatly appreciated, I been at this now for 2 days and can get anywhere with it.
Thanks in advance,
Mark

It means that in the Software\MyApp\ folder, it can't find "strConnID" key in the registry. I think you need to specify HKey Local Machine\Software\MyApp

Brian

Thanks again Brain,

I think it may have been a typing mistake I my behalf.
The line:
 objRegistryKey = Registry.LocalMachine.OpenSubKey(strConnectionPath , False) lets the program know where the "Software\MyApp" is. My mistake however was there my registry string is called ConnectionSource NOT ConnectionString..

Thanks for your help.

Mark

Does anyone know what to put in the registry for a connection string, what mean is, how do you type it?

Thanks,
Mark

Hey,

Your right, I apologize, I missed that line. Right-click to add a new string value. Enter in the name ConnectionSource, then double-click it and copy/paste your connection string there.

Brian