[kumar_rajeev47]

HELLO SIR
BASICALLY I TEST THE CONNECTION AND IT IS OK.
MY CONNECTION NAME IS RAJCONNECITON THEN SELECT IT AND RIGHT CLICK THERE AND SELECT A SQLEDITOR TEHRE.THEN THE MAKE A TABLE IN PUBS DATABASE.THE TABLE NAME IS aut.WHEN I SELECT IT AND EXECUTE IT IT SHOWS ME THE TABLE AND THERE COLUMN NAME.
THE COLUMN NAME IS user_name and password.

IN THE SQLEDITOR WHEN I INSERT THE VALUES.IT SHOWS ME THE VALUE BUT THROUGH JSP PROGRAM IT GIVES ME THE ERROR:
INVALID OBJECT NAME:aut why?

NOTE:I HAVE CREATED A TABLE aut through SQLEDITOR.PL TELL ME.

[Haris Peco]

kumar_rajeev47 ,

You have to reference table with catalog (database) and username in jsp.For example, if your user (schema) is dbo

pubs.dbo.aut

If you add database in URL (e.g. ….:1434/pubs) and if your username is dbo, then you can access to table with only ‘aut’

Regards,

[Author]

Posts