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
Joseph A. Koontz