UFL won't register

[jibberski]

I am able to complile this DLL but unable to register it using: regsvr32 "c:\...\2.5\bin\CRUFLTest.dll"

Receive the error: Entry point not found

Wrote the code in .Net and have Crystal 10 OEM for Timberline

References include
system
system.data
system.XML

Public Class CRUFLTest

Const strConnection As String = "Server=Server;User ID=sa;Password=;database=DB; Connection Reset=FALSE; Connect Timeout=600;"

 Dim cnn As OleDb.OleDbConnection = New OleDb.OleDbConnection
 Dim cmd As OleDb.OleDbCommand = New OleDb.OleDbCommand

   Public Function SqlDBConn(ByVal SqlText As String)
        cnn.ConnectionString = strConnection
        cnn.Open()
        cmd.Connection = cnn
        cmd.CommandText = SqlText
        cmd.Execute()
        cnn.Close()
   End Function
End Class

I suspect I am missing references.

Thanks for your help!

 

[chelseatech]

I found it easier to write my UFL in Visual Basic 6, as that is more COM compliant that VB.Net.

I also found a problem when I migrated my one of my UFLs from Cr8.5 to 9/10 and I think you have the same problem I had.

Every Function in the UFL must return a valid Crystal Data Type.

Change your function declaration to...
Public Function SqlDBConn(ByVal SqlText As String) as string

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm