Invalid object name 'db_student.myuser.tbl_studentname'. -- sql server connect

Hari Prasad
9/12/2004 11:04:18 PM

Hi,

First see the spelling of the procedure, the SCORE is spelled as SOCRE..

Recordset1.Source = "db_aia..po_student_socre 'K01',' ',1"

Thanks
Hari
MCDBA

[quoted text, click to view]

<blue>
9/13/2004 11:20:26 AM

HI, i am a newbie of SQL server.
What I got is an error shown as the title in which an ASP file made the SQL
call.

The script is just as follow:
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_cia_STRING
'Recordset1.Source = "SELECT * FROM fund WHERE studentno='k01' and remark
='confirm' ORDER BY date DESC"
Recordset1.Source = "db_aia..po_student_socre 'K01',' ',1"
Recordset1.CursorType = 1
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()

I am sure that the procedure po_student_score exist and have set the execute
permission for the user with username myuser.

How can I solve the problem?
Thank you very much.

sql server connect : Invalid object name 'db_student.myuser.tbl_studentname'.