Go Back   Velocity Reviews > General Computer Discussion > Software
User Name
Password
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread
Old 05-22-2008, 01:59 PM   #1
Default enterprisedb package execution


hi to all this is rams i am using enterprisedb as back end here i found a problem

with package execution that is package stored procedures having output parameters r not executed through the vb dotnet application It does not recogize the output parameters

i submit my code and error below
Imports EnterpriseDB.EDBClient

Dim cn As New EDBConnection("server=192.168.10.129;user id=enterprisedb;password=spsoft;database=spruce;po rt=5444")
Dim cmd As New EDBCommand
cn.Open()
cmd.Connection = cn
query = "public.class_admin4.add_student(_sno,_sname,: p_class,_city)"
cmd.CommandText = query
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add(New EDBParameter("p_sno", EDBTypes.EDBDbType.Integer)).Value = 1
cmd.Parameters.Add(New EDBParameter("p_sname", EDBTypes.EDBDbType.Varchar)).Value = "rams"
cmd.Parameters.Add(New EDBParameter("p_class", EDBTypes.EDBDbType.Varchar)).Value = "xxx"
cmd.Parameters.Add(New EDBParameter("p_city", EDBTypes.EDBDbType.Varchar)).Value = "hyd"
cmd.Prepare()
cmd.ExecuteNonQuery()
MessageBox.Show("stored procedure is executed")
cn.Close()

error is

public.class_admin4.add_student(Integer) does not exists

regards

rams


kanchuparthi.rams
kanchuparthi.rams is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Complete package of DVD solutions mikeriv Software 0 03-28-2007 02:33 PM
Complete package of DVD solutions abcz_video@yahoo.com DVD Video 0 12-08-2006 03:36 PM
The Practice Test Package Development: A New Service on the Certification Market David Johnson A+ Certification 0 01-19-2005 10:52 AM
HellBoy package not Widescreen???? Chris DVD Video 2 11-03-2004 07:59 PM
PC Package deals? jkl A+ Certification 0 10-28-2004 05:12 PM




SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46