My problem, in a nutshell, is that I can get this line of code to work and return a cursor in a PRG, but cannot make it work in a business object that I create through the framework:

gnConnHandle = SQLSTRINGCONNECT("Driver=SQL Server;Server=CCBLOANDATA\DEVELOPMENT;UID=SA;PWD=SQLDEV;Database=loanrev")


I tried to achieve that same result by following along with the example in The Mere Mortals Framework Developer Guide, Version 7.0, dated 3/8/02, pages 83-89. The chapter is titled "Creating Business Objects Step-by-Step."

I tailored it to my own application, doing the following:


1) On the Data Access Edit Form, I modified the getsqlstring Data Access Method to read:

LPARAMETERS taParms
*
RETURN "SELECT * FROM duediligence"


2) In the Remote Connection Class box, I typed:

asqlconnection

I also tried using the default. In both cases, asqlconnection was instantiated.


3) So I provided these properties in the asqlconnection object:

cconnectstring: Driver=SQL Server;Server=CCBLOANDATA\DEVELOPMENT;UID=SA;PWD=SQLDEV;Database=Loanrev

cdatabase: loanrev

cdatasource: Development Files

cpassword: SQLDEV

csqlserver: CCBLOANDATA\DEVELOPMENT

cuserid: SA

4) Prior to executing these lines of code, I included AERROR() code in ospt_test.execsql to display the error it produced:

DO SetX
oDueDiligence = CREATEOBJECT('DueDiligence')
? oDueDiligence.Requery()

5) AERROR() produced the following:

Number of the error: 1526
Text of the error message: Connectivity Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'duediligence'.

Please let me know what I am doing wrong.

Thanks very much,
Joe Koontz