Comments by shakilajannat (Top 3 by date)

shakilajannat 26-Nov-13 5:37am View

<HTML>
<HEAD>
<META http-equiv=Content-Language content=en-us>
<META http-equiv=Content-Type content="text/html; charset=windows-1252">

<title>VB script test</title>
</HEAD>
<BODY style="background-color: rgb(255, 255, 255); text-shadow: 0px -1px 0px rgba(0, 0, 0, 0.35);">

<%
Dim connection, connectionString, theCommand, commandString,numOfCustomer
connectionString = "Driver={Oracle in OraDb11g_Home1};DBQ=biotpl;UID=biotpl;PWD=biotpl;"
Set connection = CreateObject("ADODB.Connection")
Set theCommand = CreateObject("ADODB.Command")
connection.Open connectionString

'const cnstCommand = 1 'Command type - 1 is for standard query
'commandString = "INSERT INTO FP_CUSTOMER_ENROLL (CUST_NO, ENROLL_STATUS, LOGIN_ID, CREATE_BY,CREATE_DATE) VALUES (555,'N',5686,'john@doe.com',sysdate);"
'thecommand.CommandText = commandString
'thecommand.CommandType = cnstCommand
'thecommand.ActiveConnection = connection
'thecommand.Execute
const cnstStoredProcedure = 4 'Command type - 4 is for stored procedure
commandString = "PRC_CHECK_CUSTOMER_INFO1 @pMobileNo, @pErrorMessage"

thecommand.CommandType = cnstStoredProcedure
thecommand.CommandText = commandString
thecommand.Parameters.AddWithValue("@pMobileNo", 140)
thecommand.Parameters.AddWithValue("@pErrorMessage", numOfCustomer)
thecommand.ActiveConnection = connection
thecommand.Execute

%>

</BODY>
</HTML>
while execute this code give me a error
ADODB. Comand argument are wrong type are out of acceptable range or conflict with one another

shakilajannat 28-Aug-13 0:44am View

can u help me again please
1.user give me a xml structure format data..i have to read that file and insert in to database
2.how to transfer xml data though web service
i need all this solution in web service
sry for my english. please help me

shakilajannat 20-Jun-13 2:57am View

<add name="ORADB" providername="OraOLEDB.Oracle" connectionstring="Data Source=( DESCRIPTION = ( ADDRESS_LIST = ( ADDRESS = ( PROTOCOL = TCP )( HOST = {@IP} )( PORT = {1521} ) ) )( CONNECT_DATA = ( SERVER = DEDICATED )( SERVICE_NAME = {@ServiceName } ) ) ); User Id= {@User}; Password =@Pass;">
Give me error Object reference not set to an instance of an object.??