Invalid object name 'db_student.myuser.tbl_studentname'.

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.
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
<blue> wrote in message news:%231E%23aCUmEHA.1672@.TK2MSFTNGP14.phx.gbl...
> 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.
>