Can not connect to SQL Backend with GMW_LoadBDE 1

[Hap007]

Ric

I was wondering if anyone could help with what should be simple problem, but I can not seem to get the thing to work.

I am trying to Connect to a GoldMine SQL Database using GMW_LoadBDE call.
This works fine when loading a dbase backend, but I get error -6 when trying to connect to SQL backend, even
though I call GMW_SetSQLUserPass first.

What do I pass to the GMW_LoadBDE for the SQL Database name?
I have tried the BDE alias, the SQL Database. I am confused and the manual offers no help.

Thanks,
Hap

------------------------------------------------------------
FYI The API defintions I am using: ---------------------------------------------------------
'DLL intialization functions
Public Declare Function GMW_LoadBDE Lib "GM6S32.dll" (ByVal strSysDir As String, _
ByVal strGoldDir As String, _
ByVal strCommonDir As String, _
ByVal strUser As String, _
ByVal strPassword As String) As Long

Public Declare Function GMW_UnloadBDE Lib "GM6S32.dll" () As Long

Public Declare Function GMW_Login Lib "GM6S32.dll" (ByVal strUser As String, _
ByVal strPassword As String, _
ByVal strSQLUser As String, _
ByVal strSQLPassword As String) As Long

Public Declare Function GMW_Logout Lib "GM6S32.dll" () As Long

Public Declare Function GMW_MULogin Lib "GM6S32.dll" (ByVal strUser As String, _
ByVal strPassword As String, _
ByVal strSQLUser As String, _
ByVal strSQLPassword As String, _
ByVal strCommonDir As String) As Long

Public Declare Function GMW_MULogout Lib "GM6S32.dll" (ByVal nSessionID As Long) As Long

Public Declare Function GMW_MUBeginSession Lib "GM6S32.dll" (ByVal nSessionID As Long) As Long

Public Declare Function GMW_SetSQLUserPass Lib "GM6S32.dll" (ByVal strUserName As String, _
ByVal strPassword As String) As Long
-end----------------------------------------------------------------------------------------------------------------------


Access Developer

http://www.fcs-software.com/fcsaccessdev.html

-
Specializing in Access based Add-on Solutions for the Developer

 

[richardy]

You need to set the database:


'strCommonDir=MSSQL: MSSQL_GM: DBO:


Regards,

Richard.
PRIOR Analytics UK
http:://

http://www.prior-analytics.com

 

[Hap007]

Richard,

That did the trick, star to you.

Thanks,
Hap


Access Developer

http://www.fcs-software.com/fcsaccessdev.html

-
Specializing in Access based Add-on Solutions for the Developer