Connection failed: SQLState: â??S1T00â??
Mon, 29 Oct 2007 08:11:00 -0700
In some computers, just a few in thousands, appears the following message
when try to login in SQL.
Connection failed:
SQLState: â??S1T00â??
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver]Timeout expired
I am using a ODBC string to connect to DB. This happened in two computers,
one with Windows ...
|
Slow MS Access 2003 application When accessing SQL Server 2005
Sun, 28 Oct 2007 19:55:19 -0700
An update on this issue, I am still experiencing this slowness problem. I
have tried from executing the maintenance processes, to checking the codes
of the MS Access 2003 application.
One new thing that we found is that if we access the MS Access application
from one of the workstations via remote desktop, ...
|
Relationship between odbc driver with .net data provider
Fri, 26 Oct 2007 17:44:33 +0500
i just want to ask quite basic question that what when data is commuicated
between DB and application , where odbc driver plays its role, if we use
.net provider for odbc or u can place this question as whats the relation
between .net provider and odbc driver?
Its quite simple question ur answer is highly appr ...
|
Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server is unavailable.
Wed, 24 Oct 2007 19:39:40 -0700
Unable to start TSQL Debugging. Could not attach to SQL Server Process on
'srvname'. The RPC server is unavailable.
I get this error when I try to run a SQL Server Project with a CLR stored
Procedure in it. The target DB is SQL Server 2005 and im using VS 2005. I
simply create a new SQL Server Project which ...
|
MS-Access and SQL 2005 Application Roles
Wed, 24 Oct 2007 09:19:01 -0700
I have created an Application Role with DEFAULT_SCHEMA=dbo.
From MS-Access, I retrieve the AR password and execute sp_setapprole as
follows:
qd.Connect = strODBCConnect
qd.ReturnsRecords = False
qd.SQL = "exec sp_setapprole 'MyAppName','" & strAppRolePWD & "';"
qd.Execute
Fine until now...but whe ...
|
Performance get bad if not using "Use Ansi Nulls, Spaces, ..." in
Wed, 24 Oct 2007 07:04:00 -0700
I Want to select from an MSSQL-Server datatbase and realised, that if i do
not use the flag mentioned above, the select takes much longer
I'v got 2 tables with indices:
create table XXX (S1 varchar (30) NOT NULL PRIMARY KEY, S2 int NOT NULL)
create unique index Idx_X1 on XXX (S2)
create table YYY (S1 varc ...
|
important
Sat, 20 Oct 2007 20:48:31 -0700
Hi all,
We are doing a survey to collect information on middleware usage
and some features of the middleware. Through the survey data as one
source of
information, we can do research on middleware, and software
engineering trend analysis and prediction.
Please take out some minutes to fill in this survey. Pl ...
|
|
|
error: odbc in vista (with asp)
Sat, 20 Oct 2007 08:47:28 -0700
i dont connect db (sql server 2005) in vista. why?
i have a cod in asp and no conect database.
the error is:
"Microsoft SQL Native Client Version 09.00.3042
Running connectivity tests...
Attempting connection
[Microsoft][SQL Native Client]TCP Provider: No connection could be
made because the target m ...
|
error: odbc in vista
Sat, 20 Oct 2007 08:21:58 -0700
i dont connect db (sql server 2005) in vista. why?
i have a cod in asp and no conect database.
the error is:
"Microsoft SQL Native Client Version 09.00.3042
Running connectivity tests...
Attempting connection
[Microsoft][SQL Native Client]TCP Provider: No connection could be
made because the target m ...
|
variations
Wed, 17 Oct 2007 14:48:24 -0400
Is there somewhere I can get a handle on the common 'problems' found using
odbc to interface with an sql server 2005 database?
I need to program a database layer, and I know there are idiosyncracies
between various drivers, and I'd like to figure out if any of them can
be handled via some configuration to reduc ...
|
