>Text of the error message: Connectivity Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'duediligence'.
The fact that the error is coming from SQL Server (the [SQL SERVER] in the error message indicates this) makes me believe that your query is trying to access a table that doesn't exists or you're trying to call a stored procedure that doesn't exist.
You can use the SQL Profiler to find out what is being sent to SQL Server.
BTW, I noticed that you're logging in as SA. This is a bad decision, even during development. Use the same login that you would expect the application to be using after deployment.
-Mike
>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