473,699 Members | 2,474 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Executing an MS SQL stored procedure from a java servlet

I'm trying to use a servlet to process a form, then send that data to
an SQL server stored procedure. I'm using the WebLogic 8 App. server.
I am able to retrieve database information, so I know my application
server can talk to the database.
I've determined the failure occurs when the the following statement is
executed: cstmt.execute() ; (due to the failure of println statements
placed afterwards). I get the following error after trying to execute
the stored procedure call:
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored
procedure 'insertTheForm'

The username and password i'm using to connect is a Windows user with
admin rights. It is also associated with the Odbc connection--and of
course is a database user..with full rights. I have executable
permissions on the stored procedure set up as well. I did a microsoft
recommended registry fix as well (for a previous
error:http://support.microsoft.com/default...en-us;Q238971).
Am I missing something? I posted my servlet code below.

Thanks for any help!
Dinesh

formHandlingSer vlet.class

-------------------------
package showme;
/*
* formHandlingSer vlet.java
*
* Created on July 6, 2003, 7:01 PM
*/
import javax.servlet.* ;
import javax.servlet.h ttp.*;
import java.io.*;
import java.sql.*;
import java.text.DateF ormat;
/**
*
* @author Administrator
*/
public class formHandlingSer vlet extends HttpServlet {

private static final String email1 = "email";
private static final String password1 = "password1" ;
private static final String password2 = "password2" ;
private static final String displayname = "displaynam e";

Connection dbConn = null;

// create a persistent conneciton to the SQL server

public void init() throws ServletExceptio n
{
String jdbcDriver = "sun.jdbc.odbc. JdbcOdbcDriver" ;
String dbURL = "jdbc:odbc:Con2 ";
String usernameDbConn = "dinesh";
String passwordDbConn = "werty6969" ;

try
{
Class.forName(j dbcDriver).newI nstance();
dbConn = DriverManager.g etConnection(db URL, usernameDbConn,
passwordDbConn) ;
}
catch (ClassNotFoundE xception e)
{
throw new UnavailableExce ption("jdbc driver not found:" + dbURL);
}
catch (SQLException e)
{
throw new UnavailableExce ption("error: " + e);
}
catch (Exception e)
{
throw new UnavailableExce ption("error: " +e);
}
}

public void doPost(HttpServ letRequest request, HttpServletResp onse
response) throws ServletExceptio n, IOException
{
response.setCon tentType("text/plain");
PrintWriter out = response.getWri ter();

//extract parameter information from register.jsp

String email1 = request.getPara meter("email1") ;
String password1 = request.getPara meter("password 1");
String password2 = request.getPara meter("password 2");
String displayname = request.getPara meter("displayn ame");

try
{
//make a callable statement for a stored procedure.
//It has four parameters

CallableStateme nt cstmt = dbConn.prepareC all(
"{call insertTheForm(? , ?, ?, ?)}");

//set the values of the stored procedure's input parameters

out.println("ca lling stored procedure . . .");
cstmt.setString (1, email1);
cstmt.setString (2, password1);
cstmt.setString (3, password2);
cstmt.setString (4, displayname);
//now that the input parameters are set, we can proceed to execute the
insertTheForm stored procedure

cstmt.execute() ;
out.println("st ored procedure executed");
}

catch (SQLException e)
{
throw new UnavailableExce ption("error: " + e);

}
}

}
Jul 20 '05 #1
3 22134


dinesh wrote:
Hi Joseph its nice to get a reply from a BEA employee..I will check out the
bea groups. Well, yes I am able to execute the query from the MS query
analyzer. I am also able to perform a table read from a servlet, I run into
problems when trying to insert data. I tried to use the ms jdbc and
implement it as instructed by bea edocs. here is my error:
formHandlingSer vlet.java [79:1] cannot resolve symbol
symbol : variable conn
location: class showme.formHand lingServlet
CallableStateme nt cstmt = conn.prepareCal l(
The source need some work. You define a connection object in a try block.
That's the full scope of the object (ie: no one sees it outside the try block).
Don't create a connection in init(). Just do it in the post() right before you're
going to use it, and close it in a finally block:

Connect ion conn = null; // outside try block

try {
...
conn = d.connect(...);
... do all jdbc ...
} catch (Exception e) {
...
} finally {
try { conn.close();} catch (Exception (ignore){}
}

Joe Weinstrein

^
source
-------
package showme;
/*
* formHandlingSer vlet.java
*
* Created on July 6, 2003, 7:01 PM
*/
import javax.servlet.* ;
import javax.servlet.h ttp.*;
import java.io.*;
import java.sql.*;
import java.text.DateF ormat;
import java.util.*;

/**
*
* @author Administrator
*/
public class formHandlingSer vlet extends HttpServlet {

private static final String email1 = "email";
private static final String password1 = "password1" ;
private static final String password2 = "password2" ;
private static final String displayname = "displaynam e";

// create a persistent conneciton to the SQL server

public void init() throws ServletExceptio n
{

Properties props = new Properties();
props.put("user ", "dinesh");
props.put("pass word", "xyxyxyxy6969") ;
props.put("db", "users");
props.put("serv er", "COMPAQSERVER") ;

try
{

Driver myDriver = (java.sql.Drive r)Class.forName
("weblogic.jdbc .mssqlserver4.D river").newInst ance();
Connection conn = myDriver.connec t("jdbc:weblogi c:mssqlserver4" ,
props);

}
catch (ClassNotFoundE xception e)
{
//throw new UnavailableExce ption("jdbc driver not found:" +
dbURL);
}
catch (SQLException e)
{
throw new UnavailableExce ption("error: " + e);
}
catch (Exception e)
{
throw new UnavailableExce ption("error: " +e);
}
}

public void doPost(HttpServ letRequest request, HttpServletResp onse
response) throws ServletExceptio n, IOException
{
response.setCon tentType("text/plain");
PrintWriter out = response.getWri ter();

//extract parameter information from register.jsp

String email1 = request.getPara meter("email1") ;
String password1 = request.getPara meter("password 1");
String password2 = request.getPara meter("password 2");
String displayname = request.getPara meter("displayn ame");

try
{
//make a callable statement for a stored procedure.
//It has four parameters

CallableStateme nt cstmt = conn.prepareCal l(
"{call dbo.insertTheFo rm(?, ?, ?, ?)}");

//set the values of the stored procedure's input parameters

out.println("ca lling stored procedure . . .");
cstmt.setString (1, email1);
cstmt.setString (2, password1);
cstmt.setString (3, password2);
cstmt.setString (4, displayname);
//now that the input parameters are set, we can proceed to
execute the insertTheForm stored procedure

cstmt.execute() ;
out.println("st ored procedure executed");
out.close();
}

catch (SQLException e)
{
throw new UnavailableExce ption("error: " + e);

}
}

}

"Joseph Weinstein" <jo************ *@bea.com.remov e_this> wrote in message
news:3F******** *******@bea.com .remove_this...


dinesh prasad wrote:
I'm trying to use a servlet to process a form, then send that data to
an SQL server stored procedure. I'm using the WebLogic 8 App. server.
I am able to retrieve database information, so I know my application
server can talk to the database.


Hi! Two or three things:
1 - We don't support the use of the jdbc-odbc bridge because it's flakey

and
not threadsafe. You should download and use MS's own type-4 jdbc driver.
2 - Can you execute this stored procedure from a commandline MS DBMS

client
when you log in with the same user? I ask this, because this user's

default database
context might not be in the database where the procedure is.
3 - You can get quick weblogic-specific help in our support newsgroups,

which
you can find under the support page at www.bea.com.

Joe Weinstein at BEA

I've determined the failure occurs when the the following statement is
executed: cstmt.execute() ; (due to the failure of println statements
placed afterwards). I get the following error after trying to execute
the stored procedure call:
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored
procedure 'insertTheForm'

The username and password i'm using to connect is a Windows user with
admin rights. It is also associated with the Odbc connection--and of
course is a database user..with full rights. I have executable
permissions on the stored procedure set up as well. I did a microsoft
recommended registry fix as well (for a previous
error:http://support.microsoft.com/default...en-us;Q238971).
Am I missing something? I posted my servlet code below.

Thanks for any help!
Dinesh

formHandlingSer vlet.class

-------------------------
package showme;
/*
* formHandlingSer vlet.java
*
* Created on July 6, 2003, 7:01 PM
*/
import javax.servlet.* ;
import javax.servlet.h ttp.*;
import java.io.*;
import java.sql.*;
import java.text.DateF ormat;

/**
*
* @author Administrator
*/
public class formHandlingSer vlet extends HttpServlet {

private static final String email1 = "email";
private static final String password1 = "password1" ;
private static final String password2 = "password2" ;
private static final String displayname = "displaynam e";

Connection dbConn = null;

// create a persistent conneciton to the SQL server

public void init() throws ServletExceptio n
{
String jdbcDriver = "sun.jdbc.odbc. JdbcOdbcDriver" ;
String dbURL = "jdbc:odbc:Con2 ";
String usernameDbConn = "dinesh";
String passwordDbConn = "werty6969" ;

try
{
Class.forName(j dbcDriver).newI nstance();
dbConn = DriverManager.g etConnection(db URL, usernameDbConn,
passwordDbConn) ;
}
catch (ClassNotFoundE xception e)
{
throw new UnavailableExce ption("jdbc driver not found:" + dbURL);
}
catch (SQLException e)
{
throw new UnavailableExce ption("error: " + e);
}
catch (Exception e)
{
throw new UnavailableExce ption("error: " +e);
}
}

public void doPost(HttpServ letRequest request, HttpServletResp onse
response) throws ServletExceptio n, IOException
{
response.setCon tentType("text/plain");
PrintWriter out = response.getWri ter();

//extract parameter information from register.jsp

String email1 = request.getPara meter("email1") ;
String password1 = request.getPara meter("password 1");
String password2 = request.getPara meter("password 2");
String displayname = request.getPara meter("displayn ame");

try
{
//make a callable statement for a stored procedure.
//It has four parameters

CallableStateme nt cstmt = dbConn.prepareC all(
"{call insertTheForm(? , ?, ?, ?)}");

//set the values of the stored procedure's input parameters

out.println("ca lling stored procedure . . .");
cstmt.setString (1, email1);
cstmt.setString (2, password1);
cstmt.setString (3, password2);
cstmt.setString (4, displayname);
//now that the input parameters are set, we can proceed to execute the
insertTheForm stored procedure

cstmt.execute() ;
out.println("st ored procedure executed");
}

catch (SQLException e)
{
throw new UnavailableExce ption("error: " + e);

}
}

}


Jul 20 '05 #2
ok, great I have it working now, thanks Joe!!

Dinesh

"Joseph Weinstein" <jo************ *@bea.com.remov e_this> wrote in message
news:3F******** ******@bea.com. remove_this...


dinesh wrote:
Hi Joseph its nice to get a reply from a BEA employee..I will check out the bea groups. Well, yes I am able to execute the query from the MS query
analyzer. I am also able to perform a table read from a servlet, I run into problems when trying to insert data. I tried to use the ms jdbc and
implement it as instructed by bea edocs. here is my error:
formHandlingSer vlet.java [79:1] cannot resolve symbol
symbol : variable conn
location: class showme.formHand lingServlet
CallableStateme nt cstmt = conn.prepareCal l(
The source need some work. You define a connection object in a try block.
That's the full scope of the object (ie: no one sees it outside the try

block). Don't create a connection in init(). Just do it in the post() right before you're going to use it, and close it in a finally block:

Connect ion conn = null; // outside try block

try {
...
conn = d.connect(...);
... do all jdbc ...
} catch (Exception e) {
...
} finally {
try { conn.close();} catch (Exception (ignore){}
}

Joe Weinstrein

^
source
-------
package showme;
/*
* formHandlingSer vlet.java
*
* Created on July 6, 2003, 7:01 PM
*/
import javax.servlet.* ;
import javax.servlet.h ttp.*;
import java.io.*;
import java.sql.*;
import java.text.DateF ormat;
import java.util.*;

/**
*
* @author Administrator
*/
public class formHandlingSer vlet extends HttpServlet {

private static final String email1 = "email";
private static final String password1 = "password1" ;
private static final String password2 = "password2" ;
private static final String displayname = "displaynam e";

// create a persistent conneciton to the SQL server

public void init() throws ServletExceptio n
{

Properties props = new Properties();
props.put("user ", "dinesh");
props.put("pass word", "xyxyxyxy6969") ;
props.put("db", "users");
props.put("serv er", "COMPAQSERVER") ;

try
{

Driver myDriver = (java.sql.Drive r)Class.forName
("weblogic.jdbc .mssqlserver4.D river").newInst ance();
Connection conn = myDriver.connec t("jdbc:weblogi c:mssqlserver4" , props);

}
catch (ClassNotFoundE xception e)
{
//throw new UnavailableExce ption("jdbc driver not found:" + dbURL);
}
catch (SQLException e)
{
throw new UnavailableExce ption("error: " + e);
}
catch (Exception e)
{
throw new UnavailableExce ption("error: " +e);
}
}

public void doPost(HttpServ letRequest request, HttpServletResp onse
response) throws ServletExceptio n, IOException
{
response.setCon tentType("text/plain");
PrintWriter out = response.getWri ter();

//extract parameter information from register.jsp

String email1 = request.getPara meter("email1") ;
String password1 = request.getPara meter("password 1");
String password2 = request.getPara meter("password 2");
String displayname = request.getPara meter("displayn ame");

try
{
//make a callable statement for a stored procedure.
//It has four parameters

CallableStateme nt cstmt = conn.prepareCal l(
"{call dbo.insertTheFo rm(?, ?, ?, ?)}");

//set the values of the stored procedure's input parameters

out.println("ca lling stored procedure . . .");
cstmt.setString (1, email1);
cstmt.setString (2, password1);
cstmt.setString (3, password2);
cstmt.setString (4, displayname);
//now that the input parameters are set, we can proceed to
execute the insertTheForm stored procedure

cstmt.execute() ;
out.println("st ored procedure executed");
out.close();
}

catch (SQLException e)
{
throw new UnavailableExce ption("error: " + e);

}
}

}

"Joseph Weinstein" <jo************ *@bea.com.remov e_this> wrote in message news:3F******** *******@bea.com .remove_this...


dinesh prasad wrote:

> I'm trying to use a servlet to process a form, then send that data to > an SQL server stored procedure. I'm using the WebLogic 8 App. server. > I am able to retrieve database information, so I know my application
> server can talk to the database.

Hi! Two or three things:
1 - We don't support the use of the jdbc-odbc bridge because it's flakey
and
not threadsafe. You should download and use MS's own type-4 jdbc
driver. 2 - Can you execute this stored procedure from a commandline MS DBMS

client
when you log in with the same user? I ask this, because this user's

default database
context might not be in the database where the procedure is.
3 - You can get quick weblogic-specific help in our support newsgroups, which
you can find under the support page at www.bea.com.

Joe Weinstein at BEA

>
> I've determined the failure occurs when the the following statement

is > executed: cstmt.execute() ; (due to the failure of println statements
> placed afterwards). I get the following error after trying to execute > the stored procedure call:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored
> procedure 'insertTheForm'
>
> The username and password i'm using to connect is a Windows user with > admin rights. It is also associated with the Odbc connection--and of
> course is a database user..with full rights. I have executable
> permissions on the stored procedure set up as well. I did a microsoft > recommended registry fix as well (for a previous
> error:http://support.microsoft.com/default...en-us;Q238971). > Am I missing something? I posted my servlet code below.
>
> Thanks for any help!
> Dinesh
>
> formHandlingSer vlet.class
>
> -------------------------
> package showme;
> /*
> * formHandlingSer vlet.java
> *
> * Created on July 6, 2003, 7:01 PM
> */
> import javax.servlet.* ;
> import javax.servlet.h ttp.*;
> import java.io.*;
> import java.sql.*;
> import java.text.DateF ormat;
>
> /**
> *
> * @author Administrator
> */
> public class formHandlingSer vlet extends HttpServlet {
>
> private static final String email1 = "email";
> private static final String password1 = "password1" ;
> private static final String password2 = "password2" ;
> private static final String displayname = "displaynam e";
>
> Connection dbConn = null;
>
> // create a persistent conneciton to the SQL server
>
> public void init() throws ServletExceptio n
> {
> String jdbcDriver = "sun.jdbc.odbc. JdbcOdbcDriver" ;
> String dbURL = "jdbc:odbc:Con2 ";
> String usernameDbConn = "dinesh";
> String passwordDbConn = "werty6969" ;
>
> try
> {
> Class.forName(j dbcDriver).newI nstance();
> dbConn = DriverManager.g etConnection(db URL, usernameDbConn,
> passwordDbConn) ;
> }
> catch (ClassNotFoundE xception e)
> {
> throw new UnavailableExce ption("jdbc driver not found:" + dbURL);
> }
> catch (SQLException e)
> {
> throw new UnavailableExce ption("error: " + e);
> }
> catch (Exception e)
> {
> throw new UnavailableExce ption("error: " +e);
> }
> }
>
> public void doPost(HttpServ letRequest request, HttpServletResp onse
> response) throws ServletExceptio n, IOException
> {
> response.setCon tentType("text/plain");
> PrintWriter out = response.getWri ter();
>
> //extract parameter information from register.jsp
>
> String email1 = request.getPara meter("email1") ;
> String password1 = request.getPara meter("password 1");
> String password2 = request.getPara meter("password 2");
> String displayname = request.getPara meter("displayn ame");
>
> try
> {
> //make a callable statement for a stored procedure.
> //It has four parameters
>
> CallableStateme nt cstmt = dbConn.prepareC all(
> "{call insertTheForm(? , ?, ?, ?)}");
>
> //set the values of the stored procedure's input parameters
>
> out.println("ca lling stored procedure . . .");
> cstmt.setString (1, email1);
> cstmt.setString (2, password1);
> cstmt.setString (3, password2);
> cstmt.setString (4, displayname);
> //now that the input parameters are set, we can proceed to execute the > insertTheForm stored procedure
>
> cstmt.execute() ;
> out.println("st ored procedure executed");
> }
>
> catch (SQLException e)
> {
> throw new UnavailableExce ption("error: " + e);
>
> }
> }
>
> }

Jul 20 '05 #3
gour_sanjeev
1 New Member
I'm trying to use a servlet to process a form, then send that data to
an SQL server stored procedure. I'm using the WebLogic 8 App. server.
I am able to retrieve database information, so I know my application
server can talk to the database.
I've determined the failure occurs when the the following statement is
executed: cstmt.execute() ; (due to the failure of println statements
placed afterwards). I get the following error after trying to execute
the stored procedure call:
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored
procedure 'insertTheForm'

The username and password i'm using to connect is a Windows user with
admin rights. It is also associated with the Odbc connection--and of
course is a database user..with full rights. I have executable
permissions on the stored procedure set up as well. I did a microsoft
recommended registry fix as well (for a previous
error:http://support.microsoft.com/default...en-us;Q238971).
Am I missing something? I posted my servlet code below.

Thanks for any help!
Dinesh

formHandlingSer vlet.class

-------------------------
package showme;
/*
* formHandlingSer vlet.java
*
* Created on July 6, 2003, 7:01 PM
*/
import javax.servlet.* ;
import javax.servlet.h ttp.*;
import java.io.*;
import java.sql.*;
import java.text.DateF ormat;


/**
*
* @author Administrator
*/
public class formHandlingSer vlet extends HttpServlet {

private static final String email1 = "email";
private static final String password1 = "password1" ;
private static final String password2 = "password2" ;
private static final String displayname = "displaynam e";

Connection dbConn = null;

// create a persistent conneciton to the SQL server

public void init() throws ServletExceptio n
{
String jdbcDriver = "sun.jdbc.odbc. JdbcOdbcDriver" ;
String dbURL = "jdbc:odbc:Con2 ";
String usernameDbConn = "dinesh";
String passwordDbConn = "werty6969" ;

try
{
Class.forName(j dbcDriver).newI nstance();
dbConn = DriverManager.g etConnection(db URL, usernameDbConn,
passwordDbConn) ;
}
catch (ClassNotFoundE xception e)
{
throw new UnavailableExce ption("jdbc driver not found:" + dbURL);
}
catch (SQLException e)
{
throw new UnavailableExce ption("error: " + e);
}
catch (Exception e)
{
throw new UnavailableExce ption("error: " +e);
}
}

public void doPost(HttpServ letRequest request, HttpServletResp onse
response) throws ServletExceptio n, IOException
{
response.setCon tentType("text/plain");
PrintWriter out = response.getWri ter();

//extract parameter information from register.jsp

String email1 = request.getPara meter("email1") ;
String password1 = request.getPara meter("password 1");
String password2 = request.getPara meter("password 2");
String displayname = request.getPara meter("displayn ame");

try
{
//make a callable statement for a stored procedure.
//It has four parameters

CallableStateme nt cstmt = dbConn.prepareC all(
"{call insertTheForm(? , ?, ?, ?)}");

//set the values of the stored procedure's input parameters

out.println("ca lling stored procedure . . .");
cstmt.setString (1, email1);
cstmt.setString (2, password1);
cstmt.setString (3, password2);
cstmt.setString (4, displayname);
//now that the input parameters are set, we can proceed to execute the
insertTheForm stored procedure

cstmt.execute() ;
out.println("st ored procedure executed");
}

catch (SQLException e)
{
throw new UnavailableExce ption("error: " + e);

}
}



}

Hi,
You cannot call MS SQL Server stored procedure using the "call" verb. You need to use "exec" verb. CallableStateme nt cstmt = dbConn.prepareC all(
"{exec insertTheForm(? , ?, ?, ?)}");

Hope it helps you.
Sanjeev.
Jun 30 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
7037
by: Subodh | last post by:
HI, I need to run same kind of transactions (basically deleting records) in a loop but I have only 1 hour in a day to run my procedure. So I need to set a timer in a SP so that SP terminates after one hour and then rest of the transactions will be done next day. Can anybody suggest as how to check execution time in a stored procedure? The execution of the SP will be scheduled every night. If u need any further info pls ask.
1
3148
by: rvdw | last post by:
Hi All, I've a serious problem with executing stored procedures (SQL2000) from an Access db (version 97). After executing a stored procedure , msaccess hangs. The whole call to the procedure is running fine, but immediatly after this msaccess hangs, when the focus goes back to the calling form ? Has anyone any idea what i can test or look at. Thanks a lot !!!!!!
1
1505
by: Belee | last post by:
I am developing a c# program VS 2003 and I have created my own stored procedure to insert data into 3 tables The following is the stored procedure, the code and the error message from visual studio ide The following the stored procedure CREATE PROCEDURE dbo.NewControlAndNormalAccoun @AccountNo numeric(18) @AccountName nvarchar(50) @AccountType char(16)
1
12176
by: Ville Huovinen | last post by:
Platform: Windows 2003 Server (MS SQL Server 2003 SP3) Language: C# Problem: My stored procedures times out randomly, some proces works fine when using them from C#, and some generate SqlException which states that the server has timed out. The problem isn't in server, neither in stored procedures because they work fine in Sql Server's enterprise manager, but when calling from code they are slow and take about 60 seconds before...
1
1118
by: Prabhat | last post by:
Hi All, How Do I set a DTS so that after the DTS is executed - The DTS will Execute a Stored procedure? Or Which TASK I have to use for that and How Do I Set that? Thanks Prabhat
1
1565
by: rraw | last post by:
hi!! i want to view a set of record in datagrid.i am using store procedure i am able to execute the stored procedure . the only problem is getting those records/data on a datagrid need help.
2
1472
by: staeri | last post by:
When I execute a stored procedure with the following code it takes forever and result in a timeout or a hang: Sub TransformData() Dim myConnection As New SqlConnection(ConnectionString) Dim myCommand As New SqlCommand("spImport_amount_transform", myConnection) myCommand.CommandType = CommandType.StoredProcedure myCommand.CommandTimeout = 3600
2
7276
by: drolfe | last post by:
See below the code for details about the scenario. ------------------------------------------------------------------------------------ Public WithEvents conADS As New SqlConnection("Data Source=server;Initial Catalog=db;Persist Security Info=True;User ID=username;Password=password;Connection Timeout=0;") Public runBoardPostings As New SqlCommand("EXEC . @PREV2_PERIOD_START = @prev2Begin, @PREV2_PERIOD_END = @prev2End,...
0
1160
by: Krandor | last post by:
I am trying to execute the code below. When I execute the exact same code in the Query Analyzer, I get 6 records so there are records to be found. But when I try to do it through ASP, I get Error Number 3704: ADODB.Recordset error '800a0e78' Operation is not allowed when the object is closed. I used the same connection string to execute other stored procedures with this user id without problem in this database. For some reason it is...
2
2175
by: hanuman308 | last post by:
hi there i have written follwing SP to add two columns in my table (passing tablename as parameter) create procedure sp_addCol @tablename varchar (50) as DECLARE @tsql_TZ varchar (200) SET @tsql_TZ = 'ALTER TABLE ADD timezone varchar (5)' DECLARE @tsql_EXP varchar (200)
0
8701
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9185
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8892
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7772
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5879
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4387
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4636
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2359
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2015
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.