|
|
|
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 Change query (ODBC driver), change query result Posted by Andy at 2/7/2004 9:24:48 AM Hello
Situation: Application->ODBC->MSSQL2K
I need to change some queries (replace) between ODBC and MSSQL on the fly,
or, in the other words transparently to application modify some query before
they executed by SQL server.
Another Q.
There is the query: SELECT COUNT(A) FROM B WHERE B.A='C'...more >>
SQLOLEDB Error 7302 Posted by Jeff Czypinski at 2/7/2004 8:45:46 AM Upgraded a server to MS SQL SP3a and Windows Server 2003.
Now when in SQL Enterprise Manager and I try to access a
linked server from this upgraded server I get the
following error:
Error 7302: Could not create an instance of OLE DB
provider 'SQLOLEDB'. OLE DB error trace [Non-interfac...more >>
Mouse over linked Sequel2000 tables Posted by Bill S at 2/7/2004 3:43:36 AM Has anyone ever had problems with linked Sequel2000 tables in Access? I =
have one database that keeps shutting down when you place the mouse over =
a linked Sequle2000 table. The only thing I have noticed is it is only =
on one machine. Other machines open the same database and have no =
pro...more >>
Access data update problem Posted by Don at 2/6/2004 2:40:42 PM I have developed an Access 2002 fornt end for an SQL
database. When an form is run, it opens a limited set of
data that is updatable - the sql table is updated directly
from the access table, query or form. This works fine on
our intranet. When accessed from the internet, however, I
am ...more >>
SQL statement to list table indexes? Posted by Sloan Thrasher at 2/5/2004 1:04:45 AM Hi all!
Is there a way to get a list of indexes via a SQL statement? I'm working on
a DB documentor, and am able to retrieve almost everything else about the
definitions, but I haven't been able to get a list of indexes.
Thanks!
Sloan
...more >>
DB Restore Posted by Uhway at 2/4/2004 9:05:04 PM What's the best way to restore or create a copy of production db (15 GB) on
development server and also another copy on same sql server with different
name.
The copies need to be refreshed on a monthly basis.
1. For doing above things what's best and can some one post sctips or TSQL
stateme...more >>
[Microsoft][ODBC SQL Server Driver] Invalid Descriptor Index Posted by Sameer Motwani at 2/4/2004 5:02:22 PM Hi,
I am using MFC ODBC classes in my VC++ application for database accesss (on
a SQL Server/Access Database).
Some times after opening a Recordset (containing bound columns generated
using the ClassWizard) I have to use the
CRecordset::GetFieldValue( LPCTSTR lpszName, CDBVariant& varValue, sh...more >>
Permission Denied error Posted by Taishi at 2/4/2004 1:30:41 PM Windows Pro
VS.Net
..Net Framework
ASP.NET
My 1st time using Web Forms in .Net
1st time using SQL
I am receiving the following error:
System.Data.SqlClient.SqlException: CREATE DATABASE permission denied in
database 'master'. Could not attach database 'pubs' to file 'D:\Program
Files\Micr...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Protocol error in TDS Stream Posted by Ryan at 2/2/2004 4:46:07 AM I have sql server 6.5 with sp5a on windows 2000 sp3. I am trying to upgrade to sql 2000. I have no problems untill I try and export the data from one of the tables and then I get the following error
[Microsoft][ODBC SQL Server Driver] Protocol error in TDS Strea
According to the web site, microso...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |