|
|
|
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 ODBC timeout Posted by Danny at 5/31/2004 8:47:38 AM Hello
When I try to run a query from Query Analizer it work
fine also if it employ 2:54 (174 second) for display
result, but if I try to run the same query from SQL
Server Enterprise Manager I have the Error Message
"[Microsoft][ODBC SQL Server Driver] Timeout Expired".
Way the Query work i...more >>
how to set the LockingMode to pessimistic ? Posted by Simouse at 5/28/2004 6:01:46 PM
--
--------------------->Simouse<---------------------
...more >>
MDAC Posted by K.J.B. at 5/28/2004 2:03:15 PM Hi,
I have a problem installing MDAC 2.8 on a client computer. When I perform
the install here is what happens:
Scanning for programs using MDAC. It just hangs here and never finishes the
install.
Any ideas on how to install it?
K.J.B.
...more >>
Insert Oracle Linked Server timestamp error... Posted by bob NO[at]SPAM lifeasbob.com at 5/27/2004 11:00:40 AM I'm trying to insert into an Oracle table, setup via a linked server.
Everything works, but I receive an error during the insert, the
statement and error are below:
INSERT INTO ORALINKSRV..FIN.FILE_XFER_STATUS_DETAIL
(FILE_SEQ_ID,FILE_RETURN_CD,OFFICE_DEPT_ID,FILE_NM,
FILE_PROC_DTTM FILE...more >>
Random errors Posted by Sebastian Piccolotto at 5/26/2004 12:24:44 PM I have a VB6 Dll wich connect with SQL Server through ADO.
The dll is called from ASP pages.
The application works correctly in many servers, but I
have one server that give me several errors.
Sometimes I receive this error:
[Microsoft][ODBC SQL Server Driver]Communication link
failure
...more >>
DB2 Linked Server Error Posted by Dan Avsec at 5/25/2004 9:54:15 PM I have created a linked server to a DB2 database that
resides on an AS400. I can successfully execute a select
statement and return rows just fine. However when I
attempt to run an update statement I receive the following
error:
Server: Msg 7399, Level 16, State 1, Line 1
...more >>
ODBC Connection SQL Server Error Posted by Arnaldo at 5/25/2004 7:31:04 PM Hello, my VB app fails to connects to a SQL Server
Server side inf
SQL Server is installed in a W2000 PC configured for IIS use. It is not a PDC
Client side inf
W2000, no Access app installed
Situation
System DSN created with ODBC config utility works fine and connects succesfully to the se...more >>
odbc error Posted by Sue at 5/24/2004 6:53:49 PM Windows 2000 sp 3, sql 7.0 sp 4. When I try to go into
odbc under Admin tools, I get the following error:
Unable to load sql server odbc driver resource dll. The
application cannot continue.
I am not seeing any error in event viewer.
Thanks...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
connection pooling for access jet connected ODBC tables? Posted by djc at 5/24/2004 4:37:11 PM Is 'connection pooling' available when using an access front end connecting
to sql server 2000 tables via jet connected ODBC (not an access
project/ado)?
If yes, is there any configurable options? if yes where? On client side or
server side or both?
any help is appreciated. Thanks.
...more >>
Counting occurences Posted by M McEvoy at 5/21/2004 9:40:51 PM Hi,
Can anyone tell me how I would produce a table that holds just e.g. the
countries that occur more than once in another table?
This is what I have:
SELECT
city.country, count(*) as count
FROM city
GROUP BY city.country having count > 1;
But this gives me a table with 2 columns whi...more >>
invalid name Posted by india at 5/21/2004 5:41:03 PM When I try to save tables. It gives me an ODBC[Microssoft server] invalid name 'id'. Can you please help with this...more >>
Connecting to Microsoft SQL Server Posted by Chris at 5/21/2004 4:31:02 PM Hi. Im just starting to learn Microsoft Visual Basic .Net, I'm having problem connecting to Microsoft Sql Server for the sample database Northwind. I can see SQL Server Service Manager on my taskbar but not connected. Please help thanks....more >>
ODBC vs OLE DB ??? Posted by Grant Reid at 5/19/2004 8:20:14 PM Here is an except from the book "SQL Server 2000 Weekend Crash Course"
OSQL-A command-line utility used to connect to SQL Server and execute
Transact-SQL statements (covered in Session 8). The results of the executed
commands will be displayed in the DOS console window. OSQL uses the ODBC
(Open ...more >>
Linking SQL and Access 2000 tables Posted by sean at 5/19/2004 7:58:21 AM Hey-
I am new to SQL and have been working on a database in it
that involves a column with html addresses. I have tried
linking an access database to the SQL server DB and it
will link but will not allow me to edit HTML sites into
the SQL database. I was wondering if there is any way I
...more >>
Is it easy to store phots and PDFs in SQL Server? Posted by wawork NO[at]SPAM hotmail.com at 5/18/2004 10:15:44 PM Is it easy to store and retrive photos and PDFs in SQL Server? Is any
programming involved or is it transparent to the user?
Thank You,
Randy K
wawork@hotmail.com...more >>
MSDE Posted by Joanne at 5/17/2004 9:40:09 PM I would appreciate any help, I'm trying to connect a web front-end to an
Access 2000 database using MSDE, and I have it working using Jet but would
like to connect the database using MSDE.
I would appreciate any advice to where I need to edit the code, the code is
as follows: (which is se...more >>
sql odbc links Posted by micke at 5/17/2004 7:44:15 PM This one has been driving me up a wall for about two weeks.
I am new to the SQL enviornment.
My boss comes from a programming background and loves to
create odbc links to our sql db to generate reports and
anaylize data.
We created a MS Access 2000 db with odbc links to SQL on a
...more >>
[Microsoft][ODBC SQL Server Driver] Timeout Expired Posted by DJ at 5/17/2004 1:08:58 PM Hello,
I installed MS SQL Server 2000 Evaluation Edition on
Windows XP Pro PC. I have database on the same PC. When I
am running a query(view) from Query Analyser I
get "[Microsoft][ODBC SQL Server Driver] Timeout Expired"
error message . When I am running the same view on
smaller amount ...more >>
troubleshuting with conect SQL server with Delphi Posted by mystek20 NO[at]SPAM poczta.onet.pl at 5/16/2004 2:09:15 AM In delphi ist DBE Administrator where I have to set few
parametrs. On SQL Server I'm login on windows
autorisacion on administrator. What a parametr I have to
set in delphi 5? ...more >>
unknown token received from SQL Server Posted by Yanjie Ren at 5/13/2004 8:01:57 AM One of my user tried to pull data out of SQL Server into
Excel sheet via Microsoft ODBC SQL Server driver. She got
the following error: ( The data volumn is small with 700
rows. )
[Microsoft][ODBC SQL Server Driver]Unknown token received
from SQL Server.
Has anybody had the same experi...more >>
error 18452 after installaling sp4 e slammer patch on win2000 pro Posted by roberto at 5/11/2004 2:14:32 AM previous win 2000 sp1
what can I do? thanks in advance...more >>
SQL text string too long ??? (from excel to SQL server) Posted by Mara at 5/10/2004 7:44:52 PM Hello everybody
I have a problem when I try to execute a store procedure in a sql server
from a VBA application made in excell, and when the string (SQL sentence) is
more than 255 caracters
simplify my program is like:
SQL_MIS = SQLOpen("DSN=name_of_the_ODBC_conexion")...more >>
nvarchar with ODBC Posted by tomlfish NO[at]SPAM yahoo.com at 5/10/2004 2:28:44 PM Hello. I am developing an application that will integrate with
Microsoft Word to do basic queries against a database. This has
already worked successfully in the field querying a Microsoft Access
database. But now we are migrating the application to SQL Server.
We've discovered that we can n...more >>
SQL 2000 install fails - Driver's SQLAllocHandle on SQL_HANDLE_ENV failed Posted by Terry Catt at 5/8/2004 10:18:45 PM Hi,
I am trying to reinstall SQL 2000 on to a laptop running WIN 2000 Prof (SP4)
During install of SQL 2000, setup aborts and when checking the sqlstp.log
file we get following messages :-
Thanks
Terry
.....
21:54:33 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -...more >>
ADO Recordset.find method Criteria Posted by DB at 5/8/2004 4:31:01 PM Can you use an adodb.recordset.find method to locate a record on an MS SQL 2000 server table? I can't figure out how to specify the criteria correctly and haven't found any good documentation. Ex
Dim tblBusiness As New ADODB.Recordse
'Make an ADO connection to the database
cn.Connection...more >>
What is the Warning 40001- 'serialization failure' Posted by AT at 5/7/2004 5:29:30 AM what does this mean??
thanks
AT...more >>
Sql server does not exist or access denied Posted by dk at 5/4/2004 6:09:12 AM getting this err message:
Application Error: [DBNETLIB][ConnectionOpen
(Connect()).] SQL Server does not exist or
access denied.
This error happens when this connection string is
passed:
GetConnectionString = "Provider=SQLOLEDB;Data
Source=Contracts;" _
& "Initia...more >>
Password Required on Open of Linked Access mdb file Posted by mj at 5/3/2004 4:01:07 PM Any help would be great. I have an mdb file that is linked
to a table on my SQL Server which resides on a corporate
Web Server. I have a non-Windows Authenticated username
and password to the SQL Server database, so I have to
enter the password everytime I open the Access database
that lin...more >>
ODBC call fail/ Record Locked Posted by Crystal at 5/3/2004 6:32:13 AM I am in the process of moving native Access tables over to
SQL Server 7. These tables are updated through code.
Some are updated with SQL statements executed through a db
object and others are updated using DAO.
When I update using SQL, I get "This record is being
modified by another us...more >>
Can't connet to MSDE with Query Analyzer Posted by Sal Young at 5/2/2004 4:00:49 PM I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from
a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/
firewall to connect the two computers and I'm getting the following error:
Unable to connec to server SERVERNAME
Server: Msg 17, Level 16,...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |