|
|
|
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 |
Read Failure General SQL Error Posted by IGLC at 1/31/2006 12:00:00 AM I am using Delphi 5 Enterprise version and SQL Server 2000. So, I use the
odbc bridge. SQL Client connects through TCP/IP(not named pipes). My
application works alright, but sometimes, the clients get this Error Read
Failure General SQL Error [Microsoft][ODBC SQL Server Driver]Communication
Lin...more >>
Creating ODBC link within SELECT statement Posted by Preacher Man at 1/30/2006 4:43:57 PM Is this possible. To explain myself, here is my situation. I created an
Excel Spreadsheet that uses an ODBC link to a SQL database. In order for
anyone to use this file on their PC, that same ODBC link must be setup. Is
their some code I can use within a Select Statement that will allow me...more >>
add linked server problem Posted by Jamie at 1/25/2006 4:13:07 PM Hi, there,
I have two SQL Server 2000, which are SQLA -- with SAN connected; SQLB --
just a bald SQL Server.
I want to set up linked server from SQLA , so I can run query like "select *
from SQLB.dbname.dbo.tablename". The command I use is
sp_addlinkedserver @server = 'SQLB'
After ...more >>
avoid an ODBC bug Posted by Imre Ament at 1/24/2006 6:28:03 AM Hi!
I have to manage a program what can copy data from MS Access to SQL server
(2000 and 2005).
I work with C++ and DAO 3.6.
I have a bug from the SQL server ODBC driver : "Invalid locator
de-referenced" during copy BLOB columns.
The columns bigger than 250K (I found Article ID : 245714).
...more >>
Creating a windows Authentication DSN Posted by Chris at 1/23/2006 11:24:02 AM Can this code be changed to use the windows Authentication instead of the
SQL Server login?
http://www.mvps.org/access/tables/tbl0014.htm
...more >>
Linking Excel and SQL Posted by Preacher Man at 1/23/2006 10:25:23 AM I would like to link an Excel Spreadsheet to my SQL 2K Database. Where do I
need to start?
For example. I would like to have a cell in Excel that gives me the sum of
Sales Orders in my SQL Database. I would also like for this to be able to
change according to a date field in excel that c...more >>
ODBC Data Source to a linked SQL Server Posted by listrecv NO[at]SPAM gmail.com at 1/22/2006 6:29:33 AM I'd like to set up an ODBC Data Source to a table in a linked SQL
Server, via
my local SQL Server.
When I use the ODBC Data Sources program to set up the ODBC DSN, it
only
shows databases in the local SQL Server, not in the linked one. If I
try typing it in: [NAMEOFLINKEDSERVER].databasenam...more >>
Insert command not affecting the table but is recognized by profil Posted by Neo at 1/20/2006 9:00:02 AM I've been trying to add a simple record to SQL Server 2000 and it is not
recognizing the insert statement. The SQL profiler is picking up the command
from the application, but it is not updating the table with the new record.
If there are any suggestions, it would be appreciated.
Here is my c...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
ODBC SQL 2005 and Named Instance - won't connect Posted by Michael MacGregor at 1/13/2006 10:52:56 AM We have two instances of SQL 2005 installed, with static TCP/IP ports, one
instance on one IP address, port 1433 and the other instance on a different
IP address, port 1433.
Try to create an ODBC System DSN using SQL Native Client and it won't
connect.
If we do the same thing but using a d...more >>
key violation, general sql error, connectin busy with another hstmt Posted by Doug Stephens at 1/12/2006 12:37:00 PM We are getting this error periodically in a large app we are converting
from Access to SQL Server 2000. It uses BDE and ODBC for data access
and TTable/TQuery as well as TwwTable/TwwQuery components (from
woll2woll) under Delphi 6. It appears to happen when we are executing
TQuery.Open.
From ...more >>
Can't connect using 'localhost' but '127.0.0.1' works Posted by Patrick Burleson at 1/12/2006 12:31:19 PM I'm trying to connect to SQL Server using the string 'localhost', but I
always get a timeout error using either Query Analyzer or ADO. But if I
change the string to 127.0.0.1, it works.
A 'nslookup localhost' returns 127.0.0.1. If I run 'telnet localhost
1433', it connects. Any idea why I migh...more >>
Can Classic ASP Interact with SQL Server 2005? Posted by Ken Sturgeon at 1/12/2006 9:01:24 AM Forgive me if this is not the most appropriate group to pose this question.
I have a classic ASP app that is currently connecting to a SQL Server 2000
database using MDAC 2.8. Can a classic ASP application using MDAC 2.8
connect to and interact with SQL Server 2005? What issues might I encoun...more >>
help on insert a record on sql server with identity column as key Posted by Hongyu Sun at 1/11/2006 3:58:14 PM Hi, All:
Please help. I use sql server as back end and Access 2003 as front end
(everything is DAO).
A table on SQL server has an identity column as the key.
We have trouble on adding records to this table using the following SQL.
strSQL = "INSERT INTO myTableOnSQLServer (A, B, C, D, E...more >>
ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor stat Posted by Shan at 1/11/2006 8:45:02 AM I am trying to rename a column name and it gives me the following error. Can
any body help please. Thanks
'MR_STRANS_051005' table
- Unable to rename column from 'ATTR4' to 'GST_AMT'.
ODBC error: [Microsoft][ODBC SQL Server Driver]Invalid cursor state...more >>
SQL_NEED_DATA During ODBC Query Posted by Reuven Nisser at 1/9/2006 1:05:58 PM Hello,
I am using MFC 6.0 CRecordset to access data inside an SQL Server table
TEMPORARY_DATA. The table contains also a BLOB field.
The query I am using is:
SELECT * FROM TEMPORARY_DATA WHERE
TD_DESTINATION_ID='05101' AND TD_PLAN_DATE < {ts '2006-01-09 00:00:00'}
AND TD_PLAN_DATE >= {ts '...more >>
SQL_NEED_DATA During ODBC Query Posted by Reuven Nisser at 1/9/2006 1:05:38 PM Hello,
I am using MFC 6.0 CRecordset to access data inside an SQL Server table
TEMPORARY_DATA. The table contains also a BLOB field.
The query I am using is:
SELECT * FROM TEMPORARY_DATA WHERE
TD_DESTINATION_ID='05101' AND TD_PLAN_DATE < {ts '2006-01-09 00:00:00'}
AND TD_PLAN_DATE >= {ts '...more >>
ODBC Timeout expired error Posted by bjornhenrikformo NO[at]SPAM gmail.com at 1/5/2006 2:59:45 AM Some of my clients cannot access an application, and it seems there is
a communication issue(?). The application server is a bit slow, the
database server (MS SQL Server 2000, SQL SP4) is brand new and fast.
Users that have the problem are behind a firewall that allows
everything from the client...more >>
Excel DBCC Error Posted by Garth Keesler at 1/2/2006 7:16:03 AM Forgive me for cross-posting but this involves ODBC as well.
I'm getting "User 'Test1' does not have permission to run DBCC TRACEON."
when trying to connect Excel to SQL Server 2005 using an ODBC System
DSN. I've discovered that this is due to Excel or, more appropriately
MSQuery, attemptin...more >>
"SQL Native Client" / "SQL Server" drivers Posted by Coder23 at 1/2/2006 12:49:02 AM When creating a system DSN via the ODBC Admistrator dialog....
What is the differecne between "SQL Native Client" and "SQL Server" drivers
listed in the "Create New Data Source" drivers list?
How do they differ?...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |