|
|
|
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 Database connections Posted by Gilgamesh at 1/14/2004 12:58:21 PM Hi there,
I need to find out how many database connections are openned by the existing
system when connecting to a SQL Server 2000. I tried using PerfMon and I
couldn't find any counter to monitor the ODBC connections on the server.
Does anybody know how to tackle this one?
Thanks,
Gilgamesh...more >>
Shared Memory Posted by news.microsoft.com at 1/14/2004 8:32:10 AM Can someone tell me what the Shared Memory option is used for when one runs
the SQL client network utility. Start->Rin Cliconfg
There's an option for shared memory protocol. I would like a good technical
description of this option. When to use it and when one doesn't need to use
it.
Many ...more >>
Linked Table Posted by Igloo at 1/14/2004 3:46:08 AM Hi all
is it possible to have a linked table in sql 2000 in the tables section of enterprise manager - the same painless way its done in access
Many thank
IG...more >>
URGENT: How to pass CDBException Posted by Lisa Pearlson at 1/13/2004 10:49:47 PM Hi,
I want a function to open a database and if a CDBException parameter is
provided, it will return any exception in this parameter.
BOOL CDBConnectionDlg::OpenDatabase(CDatabase *pDatabase, LPCTSTR lpszDSN,
CDBException* dbe)
{
ASSERT( pDatabase );
try
{
pDatabase->OpenEx(l...more >>
CDatabase::OpenEx( "ODBC; ...") question Posted by Lisa Pearlson at 1/13/2004 6:13:57 PM CDatabase::GetConnect() returns "ODBC; ..."
However, CDatabase::OpenEx() may not include "ODBC;". It will fail to
connect if it has that prefix.
So you can not simply do:
{
CDatabase a, b;
a.OpenEx("..."); // assume this connects fine.
// try another connection to the same.
...more >>
How to install SQL 2000 ODBC driver only? Posted by Phillip at 1/13/2004 1:06:54 PM I have a Windows 2000 server that needs to connect to a
Windows 2000/SQL 2000 box via ODBC but I can't install the
latest MDAC. Is it possible to install only the MS SQL
2000 ODBC driver from CD? ... and How do I do it.
Thanks...more >>
ODBC driver error Posted by TomT at 1/11/2004 10:44:41 PM I am all of a sudden getting this error message on a
system, when trying to connect to sql server data:
Unable to load SQL Server ODBC driver resource DLL. The
application cannot continue.
I've reinstalled mdac (2.6 and 2.8), but this has not
helped. I need to get this system up and runn...more >>
Linking to ODBC tables from SQLServer 2000 Posted by andyb at 1/11/2004 3:36:57 AM I am an Access guy and I'm just stepping on eof my
solutions up to sqlserver 2000.
Linking and seting up referential integrity to other
datasources via ODBC in access is easy. SO far in SQL
server I've found how to link to a DSN (and now Im aware
of DSN-less connections but dont know how to...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
sql parser-table name Posted by Arrun S at 1/10/2004 3:06:05 AM H
I need to get the table name(s) and the column name(s) present in a query before it is executed against the database. Are there any built-in functions (in SQL Server or in C#)? I came to know about "ODBC minimum SQL Grammar" from MSDN. Anyone knows whether it'll serve my problem
TIA
Arrun S...more >>
Problem accessing SQL-Server with Access (#deleted -fields) Posted by Jean Paul at 1/9/2004 2:51:55 PM Hello,
I try to make a connection with a SQL Database table from within Microsoft
Access and when I display the data in a grid or in a form I get '#deleted'
in the feelds. When I make a repport from the same table in the same Access
database I get the correct data. There is only one database...more >>
Deadlock, Rerun the transaction Posted by Bharathi at 1/9/2004 1:49:13 PM I always get the following error, when someone is trying
to to access our live site, the database recoirds are
more, how to get away with this problem.
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Transaction
(Process...more >>
ADODB connection from inside EXCEL Posted by Ken Jones at 1/9/2004 9:03:31 AM I posted before, but it did not appear. Anyhow, I found
the answer -- sort of.
The problem is that I have two "identical" machines
running identical EXCEL spread sheet. One can do an
ADODB connection and the other can not. I could not
figure out what was different until I installed SQL ...more >>
ASP, AS400 (iSeries), and stored procedures. Posted by (ryadex NO[at]SPAM hotmail.com) at 1/9/2004 9:02:31 AM Does anyone have any info on how to call a stored procedure with asp classic? Is it possible? I'm running client access v5r2.
**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchab...more >>
Can I connect without server? Posted by Jon at 1/8/2004 6:17:03 PM Hi,
I have a customers program on my system - Omin 7 as at
http://www.omnis.net/products/omnis7/ - so I can pull the data into an
Access Database. I'd like to do this work at my place not theirs!
Is there anyway I can set up an ODBC connection so that I can read the
files. The .dsn file re...more >>
DTS Package - AS400 data load to SQL Server Posted by Adam Mietus at 1/8/2004 2:26:08 PM I'm trying to convert numeric dates on the AS400 to smalldatetime in
SQL. I'm able to customize to match format but when I save the
tranformation I get the following error. I don't know why they sould
let you customize the field if you cant convert. Any ideas?
"Error Description: Tranformat...more >>
Test from new account Posted by LordmorganOfOrris NO[at]SPAM hotmail.Com at 1/8/2004 6:21:22 AM Just seeing if I can get in from work...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |