Hi all,

I have been on UT for the last few days working through CA and DE classes and reading all of the realated threads. The CABuilder by Mark McCasland has been great (and so has his help). So, this is a big thanks for all of that help!!!

Now, I am thinking there is one small thing missing, but not sure... I understand that I now have to handle all of my connections.

The CaClass (from the CABuilder) I am using has properties set:

DataSource = 'glo_numMyHandle'
DataSourceType = 'ODBC'

The DEClass has the above CA object in it. The DEClass has properties set:

DataSource = 'glo_numMyHandle'
DataSourceType = 'ODBC'

So, I created a blank form. In myform.load() I have the following code:

I set the properties of MyForm:

DEClass = 'myCABulderDataTest'
DEClassLibrary = 'C:\_CATest.vcx'

*-- myform.load()
PUBLIC glo_chrMyDSN, glo_numMyHandle
glo_chrMyDSN = 'DSN=MyDataDSN'
glo_numMyHandle =SQLSTRINGCONNECT(glo_chrMyDSN)

When I run the form, it is coming up with 'alias not found'. Using AERROR(), the error is 'Connection Handle Invalid'. However, checking on the value of 'glo_numMyHandle', it is a one. Can someone help here as I don't know where this error is coming from.

TIA

Ric