|
|
|
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 |
slow ODBC connection Via VPN Posted by jets at 12/20/2006 3:45:56 PM I have a custom third party shipping solution that interfaces with SQL
server. It connects with ODBC via a VPN to the SQL server. The
connection seams real slow to me, but maybe I am asking for to much?
The round trip from request of the client PC to the server and back
with the fields populated...more >>
Can SQLPutData be used against varchar(max)? Posted by KM at 12/19/2006 8:37:00 PM Hi,
I am trying to insert data into varchar(max) via ODBC.
When I try to insert data. I am getting following error. Is SQLPutData
supported for varchar(max)?
1394-1e4c ENTER SQLPutData
HSTMT 36665B40
PTR 0x37CDFF80
SQLLEN 20
...more >>
For/Next loop to process INSERT INTO statement Posted by Doctorjones_md at 12/19/2006 11:48:52 AM I reposted this because I was unable to achieve desired results from
previous recommendations.
Previous Post:
===================
I have the following code which does the following:
1. Deletes all rows having a value of "0" in column C
2. Uploads the data in Row 2 to my SQL Server
Wh...more >>
Problem with way to access all recordsets returned by sp_spaceused using ODBC APIs on C++ Posted by Ashutosh at 12/13/2006 4:49:14 AM Hi all,
I have a problem executing a sp_spaceused on a database.
Please execute sp_spaceused on your local database so that further
discussion will be more easier to understand.
The code snippet is as follows :
SQLCHAR database_size[15];
SQLCHAR unused[15];
...more >>
Help I am getting an error when I run my insert statement Posted by Tescumeh at 12/11/2006 12:16:20 PM Please help I am getting the same error no matter how I change my
quotes.
Microsoft OLE DB Provider for SQL Server error '80040e14'
Incorrect syntax near the keyword 'Plan'.
conn.Execute("INSERT INTO jmiles.Plan([startdate],[finishdate],
[revfinish],[responsible],[action],[title],[dept],[au...more >>
Messed up SQL 2000 - Error Code 193 Posted by Rosman Computing at 12/10/2006 12:28:02 AM Somehow my SQL Server 2000 installation got messed up and refuses to run. I
narrowed it down, I believe, to a problem of the DLL drivers for SQL Server
being out of sync with the location the Registry had for them.
When I now attempt to create a SQL Server ODBC connection, I get:
"The setup ro...more >>
Having trouble of Creating OLE DB Connection on Windows 2003 64bit with SQL 64bit using BI Studio 2003 Posted by Ken J. Zheng at 12/7/2006 3:14:31 PM Here comes the problem.
1. We have a new server installed with Windows 2003 64bit Enterprise
edition plus SQL 64bit Enterprise edition.
2. We need to use Business Intelligence Studio to create a SSIS project
which will retrieve data from a Oracle database server. Inject them into
Sql databas...more >>
|
Don't see what you're looking for? Search DevelopmentNow.com.
| home · blog · groups | Questions? Comments? Contact the dn |