|
|
|
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 |
Access add record button grayed Posted by ijazbof at 7/25/2007 2:46:00 PM Hi:
I have an MS ACCESS App that acts as a Front-End and SQL Server 2000 as
Back-End. I have the problem that dependent tables in the E-R model can't add
records, the add new record button is grayed, however the independent table
and catalog table have no problems, all tables have PK defin...more >>
Link Server to SQL2000 from SQL2005 64bit Posted by David at 7/23/2007 9:26:05 AM Hello All,
I setup a link to my SQL2000, everything seem fine except when I try to
query the SQL 2000 database. I get the following error:
OLE DB provider "SQLNCLI" for linked server "ces012" returned message
"Unspecified error".
OLE DB provider "SQLNCLI" for linked server "ces012" returned...more >>
Performance problems moving from ODBC dBase DSN to ODBC SqlServer DSN. Posted by CharlesC at 7/19/2007 2:20:57 PM Hello,
I imported dbf files (dbase) into an msde database.
I see the tables with the data in the msde database. The data is identical.
The only change made to the code is in the DSN assignment in the Recordset's
GetDefaultConnect(),
return _T("ODBC;DSN=themsde").
Both DSN's are ODBC, t...more >>
ODBC Driver for Access and AS/400 Posted by antmorano NO[at]SPAM gmail.com at 7/19/2007 12:00:00 AM Good Morning All:
I am trying to find an ODBC driver for Microsoft Access that will
allow me to connect to our IBM AS/400 system. All inpout would be
appreciated.
-Anthony Morano
Pension Fund Intern
...more >>
ODBC Driver to Connect With IBM AS/400 System Posted by antmorano NO[at]SPAM gmail.com at 7/19/2007 12:00:00 AM Good Morning All:
I am trying to find an ODBC Driver that will connect my current
Microsoft Access Databas with our IBM AS/400 System. We have the
driver in Excel, but I don't believe it is the same driver for
Access. Any input would be greatly appreciated.
-Anthony Morano
Pension Fund I...more >>
MSSQL ODBC problem Posted by zwi at 7/19/2007 12:00:00 AM Hello everyone,
I have big problem with the speed of the ODBC connection.
Speed of the connectino depends of user which starts application.
For examle:
Main user (which usualy works on this computer) of computer open
application - connection is very very slow.
New user opens application...more >>
Error: connection is busy with results for another hstmt Posted by Jason Griffith at 7/16/2007 3:08:28 PM Good Afternoon. I have a Crystal report that accesses a sql 2000 server. When I run the report twice with the same parrameters. I get the following error:
crystal reports connection is busy with results for another hstmt
As I understand it, this has to do with multiple record sets, and some...more >>
BCP - BULK INSERT - Memory mapped files Posted by Srini at 7/10/2007 3:16:01 PM Hi,
I have an application server which receives several thousand events per
second. And it needs to store that data in an SQL server running on a
separate server connected thru network to the application server. I would
like to know the fastest and the efficient way to store the data in to ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Using T-SQL Print with ODBC Posted by seijin NO[at]SPAM gmail.com at 7/10/2007 7:57:43 AM Is it possible to return messages from T-SQL using ODBC?
For example, I'm running the following basic example from Wikipedia on
T-SQL...
DECLARE @Counter INT
SET @Counter = 10
WHILE @Counter > 0
BEGIN
PRINT 'The count is ' + CONVERT(VARCHAR(10), @Counter)
SET @Counter = @Counter - ...more >>
[Fwd: Tryiing to write to excel destination] Posted by doofy at 7/5/2007 2:40:23 PM Ok, I'm desperate so I"m forwarding this to a couple of other groups
besides microsoft.public.sqlserver.programming....more >>
Record Locking with SQL Server tables and Access db Client Posted by anneo at 7/2/2007 12:02:46 PM I have a situation where I have linked tables from SQL Server in
Access 2000 using ODBC.
I am using these tables via a complex query as the record source for a
form.
When a user starts to edit a record via the form, we need the record
locked, so that if another user (on another PC) attempts t...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |