Groups | Blog | Home


Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
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 >>



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 >>


DevelopmentNow Blog