PDA

View Full Version : Unable to create an ADO Connection Object



jefftanner
06-11-2004, 11:08 AM
I am having a problem creating an ADO Connection object.

Within the InstallScript MSI, I have added Redistributables MDAC 2.8 and ADO Data Control 6.0

In the following, CreateObject creates NOTHING.


function BOOL FOO()
OBJECT pADOConnObj;
STRING szADOConnObjID;
NUMBER nErr;
begin
bExists = FALSE;

// Create ADO Connection Object to connect to the SQL server

szADOConnObjID = "ADODB.Connection";
set pADOConnObj = CreateObject(szADOConnObjID);
if (IsObject(pADOConnObj)) then
MessageBox("ADODB.Connection created", INFORMATION );
else
MessageBox("ADODB.Connection not created", WARNING );
endif;

set pADOConnObj = NOTHING;

return TRUE;
endif;