Groupware with OLE DB

Groupware works quite well with the hyperfile c/s. However, what if I want to implement it using SQL Server?

A couple of problems:-
1. The groupware files gets stored as HF classic when i enable it
2. Since these files doesnt show in the analysis, i cant change the type

Is there any easy way to overcome this?

The only reason why I started using this is because of the LDAP integration, up to now I used my own login algo, but if GW handles LDAP then it will save me a lot of time.

Have the EXE as a share (to share the HF groupware) is a no-go area.

Ben,

you have to import the (structure of the) gpw-files into your analysis, manually. Then you can do whatever you want. I'm using sql-server/oledb/gpw without any problem.
So far I haven't used the LDAP option.

Note that you have to use GpwOpenConnection (or gpwOpenLDAPSession). See the help for more info.

Arie

Hi

I have configured SQL Server to run with Groupware by adding to my project initialisation code I call gpwOpenConnection.

If I remember correctly, this created the GWP tables and then I added them to my analysis. Here's an extract of my code:

IF gpwOpenConnection(gpcnxGPWConnection,gpsParamUserID,gpsParamPassword,gpsParamServer,gpsParamDatabase,hOledbSQLServer) = False THEN
Error(ErrorInfo())
Open(WIN_Setup)
ELSE
HCreationIfNotFound(User_Details)
// The files of User Groupware are automatically created
// if the user has rights on Sql Server.
nRes is int = gpwOpen()
// if the login failed
IF nRes <> gpwOk THEN
SWITCH nRes
CASE gpwError
Error("Error initializing the groupware.", ErrorInfo())
CASE gpwUnknownUser
Error("Unknown user.")
CASE gpwInvalidPassword
Error("Wrong password.")
END
EndProgram()
END

// Use the same connection for all the data files
HChangeConnection("*",gpcnxGPWConnection)

END



Hope that helps.

Jonathan

Cheers guys. Hopefully this will ease the LDAP integration a bit!