| Groups | Blog | Home |
|
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 |
Filter by week: 1 2 3 4 5 MDAC Component Checker Posted by Stewart Rogers at 6/7/2004 6:54:21 PM I am on a win 2003 server and have run the component
checker and found 2 errors. The files obdcbcp.dll and
sqlsrv32.dll have mismatch errors. There errors say
expecting version 2000.85.1022.0; but the problem is that
I have 2000.85.1025.0
How can I fix this?
Thanks in advance,
Ste...more >>
cant delete odbc tracing file.. Posted by Rea Peleg at 6/7/2004 12:18:14 PM Hi all
I can not delete the odbc manager tracing file.
Even after disabling tracing (in the odbc manager)
i get a windows massage saing another program is using the odbc tracing
file...
Can i stop the odbc manager service??
What other programs may be using this log?
There is no other runing p...more >>
Timeout error when cycling through records and updating some of them. Posted by clintonb NO[at]SPAM fflax.net at 6/7/2004 9:29:04 AM I have a Visual C++ program that reads through a set of records and
updates some of them.
Here is some pseudocode:
Open the recordset;
while not EOF
{
if ( some condition )
update the record;
Move to Next Record;
}
I am using the MFC libary classes CRecordset and CDatabas...more >>
tracing odbc errors Posted by Rea Peleg at 6/7/2004 9:17:30 AM Hi all
I need some guiding to best practices for tracing odbc errors.
I'm using a propriatary odbc driver (for a tabula rdbms server) which i
suspect does not pass some errors to sqlsserver (where i run a job which
includes a connection
using such driver).
Are there any generic tracing methods...more >>
INVALID OBJECT NAME Error Posted by Jaspreet at 6/5/2004 5:26:02 AM Hi All
I am using ASP and SQL Server 2000 for an application. The problem that i am facing is that I get INVALID OBJECT NAME error. to be precise...
"Error Type
Microsoft OLE DB Provider for SQL Server (0x80040E37
Invalid object name '<table name>'
the application runs for some days without a...more >>
Sql Linked Server Posted by Andre at 6/4/2004 4:01:03 PM Hi, I’m using SQL server 2000 with sp3a. I have Oracle 9i Drivers installed (also tried 7.3 and 8i). I’m trying to run a query joining my SQL tables with Oracle 9i server. I used the DTS Query builder to build my statement. Every time I run the query I get a time out. If I change the where stat...more >>
Unicode in SQL queries Posted by Silvio Lopes de Oliveira at 6/4/2004 3:38:46 PM Hello,
I use Unicode in my program to enter data in Chinese into a nvarchar field.
When inserting or updating records, my application does not use Unicode
escape sequences but rather the Unicode characters themselves. Thus, my app
may have SQL statements like:
UPDATE table SET field1 = ...more >>
Recordset opens as read-only -- WHY?? Posted by Silvio Lopes de Oliveira at 6/4/2004 9:10:00 AM Hello,
I have a C++ / MFC app which uses CDatabase and CRecordset to connect to a
ODBC data source for a SQL Server 7 database. The application worked
properly with a MySQL database, but after swapping it for SQL Server
problems emerged. In particular, any calls to CRecordset::AddNew() and
CR...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Connecting to Oracle Server Posted by Alex at 6/4/2004 3:53:40 AM Please can someone help.
I have a DTS job that uses datapump to extract data from
an Oracle Server to my SQL Server. When executing the DTS
direcly from Enterprise manager there is no problem. When
running it from a Command screen using dtsrun there is no
problem.
The problem occurs wh...more >>
Performance issues for Linked Server to ORACLE using OLE DB Posted by Rochelle at 6/3/2004 10:38:32 PM Hi - I have real performance issues on a Linked Server
connection from SQL Server 2000 to an ORACLE 9i DB setup
using OLE DB. A query that should take milliseconds is
taking an unacceptable 45 seconds. As this is the deciding
factor on whether we go ORACLE or SQL Server for a
solution, I w...more >>
ODBC Driver development Posted by Arthur van Rossum at 6/3/2004 3:57:00 PM Hi everybody,
I want to develop an ODBC driver to connect a normal windows application to
a middleware product.
I can't find any examples or hints with regard to ODBC driver development.
Here are the questions:
- Does anybody have experience with ODBC driver development?
- Can anybody prov...more >>
SQL Connectivity Problem Posted by kismet110 NO[at]SPAM yahoo.co.uk at 6/2/2004 4:40:29 AM I wonder if any of you good people can help?
I am running a SQL2K client on Win2K Pro. No matter which SQL2K
instance I try to connect to (using Named Pipes) I get the following
error:
"Client unable to establish connection NP_PROV: The system cannot find
the file specified."
If I switch...more >>
DOS ODBC Driver Posted by Rob Willis at 6/1/2004 1:44:14 AM Does anyone know of an ODBC driver that can be used from
DOS? ie not from a DOS window, but from a system booted
into DOS 6.22?
Wanting to read a SQL or Access Database after making a
network connection from DOS.
Thanks,
Rob...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |