all groups > sql server odbc > november 2003 > threads for november 22 - 28, 2003
Filter by week: 1 2 3 4 5
How to return a value from Stored Procedure?
Posted by Venkat at 11/28/2003 11:09:31 AM
Hi,
I am calling a stored procedure from my java script app and trying to use
the returned value later on in my app.
Here is the javascript code.
var connObj = Server.CreateObject("ADODB.connection");
connObj.Open("DRIVER={ SQL Server }; SERVER = 9.1.2.1;
DATABASE=TEST","sa","xyz");
var... more >>
ODBC error and strange log entries
Posted by Dale Wilson at 11/27/2003 5:40:38 PM
I am getting the following error
ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure
everytime I try to add a new field to a table in any database on my server.
I can do queries, I can add new tables. I just can't edit the structure of
an existing one. I am using versio... more >>
Helppppp... Writing in CPP and calling a stored procedure in SQL server and...
Posted by amazingwolf NO[at]SPAM hotmail.com at 11/27/2003 1:42:04 AM
I have this Stored proc in SQL server, which works perfectly when
being run via Query Analyzer. The Stored proc is simple, just runs on
a table and updates some fields in it. When calling the same Stored
proc, with the same data, the Stored proc seems to run partly and then
stop for no reason. T... more >>
Can't see a particular table in a database
Posted by CQMMAN at 11/26/2003 4:22:54 PM
Hello,
I am trying to get info from a SQL7 database via ODBC. I can connect and
view the vast majority of tables, but one particular table (ceninfo_data)
does not appear.
In SQL Enterprise manager, I have taken a look at the permissions on the
table and public can select from it.
What am... more >>
Orbiting the AS400
Posted by Rog at 11/26/2003 3:05:07 PM
I need to link to tables in an AS400 on a customer site. They use IBM CA and
have the latest 5.2 version. (IBM CA includes both ODBC and OLE DB drivers).
I tried configuring the IBM OLE DB for AS400 driver using both graphical and
sp_addlinkedserver, but with no success. The best I can get is a... more >>
ODBC error
Posted by seugster NO[at]SPAM hotmail.com at 11/26/2003 1:44:56 AM
Hello all
We're running a web application on a SilverStream application server
(3.5.3) which connects to 4 databases on a MS SQL Server 6.5 (SP5a)
over ODBC (03.70.06.90).
Quite often the application server looses the connection to his DB's.
The web application doesn't answer anymore!
We get... more >>
SQL 2000 ODBC output to Internet explorer.
Posted by Nichola Harvey at 11/25/2003 1:48:09 PM
Hi Group, I wondered if anyone can assist me with an
issue I currently have. I would like to export the
contents of one table that to internet explorer, the
query would need to repeat once every five minutes.
Dependant on the results I would also like to colour
format the output (Green for... more >>
problem of Shrinking the Transaction Log in the SQL
Posted by Rafael at 11/25/2003 4:56:51 AM
Hi, My name is Rafael from Hilroy Technologies
email: oz@ozbooks.com; HilroyTechnoologies@yahoo.com
We need some help in resolving a problem of Shrinking the
Transaction Log in the SQL Transaction Log.
Our OS is Microsoft 2000 Advance Server
The setup was configured to grow 20% without l... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Excel sheetinformation in SQL server 7.0
Posted by Frank Westerbeke at 11/24/2003 2:16:37 PM
I would like to update a SQL table with information entered in a spreadsheet
..
Can anyone tell me where to start.
Frank
... more >>
IIS Logging
Posted by Bubba at 11/24/2003 1:12:25 PM
We are currently logging IIS data to an SQL server. The
amount of data has reached 14 GB. When we were logging to
the IIS server as regular log files for the same period
of time (roughly one month the log files were not more
than 2 gb. There has been no real increase in traffic to
our serv... more >>
|