|
|
|
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 SQL Server access problems over Terminal Services Posted by Craig Pilkington at 10/28/2003 8:27:58 AM Ok, here we go >>>
We have a strange problem - We have 2 Servers, Server1 is
a Terminal Server and Server 2 is a SQL server. We also
have a piece of VB
software that derives information from our SQL databases.
This is how it is all set-up and how it SHOULD work >
- Terminal Servic...more >>
Change number to text linking a SQL Server 2K table to Access97 Posted by JD at 10/28/2003 8:10:28 AM Linking a SQL Server 2000 table using ODBC into Access 97
database cause a change from number to text for those
fields in the SQL Table defined as numeric with length of
9 precision 17 and scale 2.
Thanks in advance...more >>
ODBC Error Code = 40001[Microsoft][ODBC ....(Process ID 70) Posted by Thomas_S at 10/28/2003 7:28:58 AM ODBC Error Code = 40001[Microsoft][ODBC SQL Server Driver]
[SQL Server]Transaction (Process ID 70) was deadlocked on
lock resources with another process and has been chosen as
the deadlock victim. Rerun the transaction.
We are using a program called E-Automate that runs off of
a Windows 200...more >>
ODBC Timeout error Posted by Vincent at 10/28/2003 1:56:33 AM Need help ....
why does this error appears ?
Page Cannot be Displayed
Error Type
Microsoft OLE DB Provider for PDBC Drivers (0x80040E31)
[Microsoft][ODBC SQL Server Driver] Timeout expired
/login/login_body.asp,line 457
Is it the system connection between the SQL server and the
Web...more >>
SQL Server ODBC Connection string format for TCP/IP connection Posted by Andrew Chalk at 10/27/2003 2:40:42 PM I am trying to make an ODBC connection to a remote SQL Server 2000 server
over TCP/IP. I get a "dialog failed" error when I call SQLDriverConnect()
with the following syntax:
"DRIVER={SQL
Server};SERVER=192.168.0.2;DATABASE=Fred;Trusted_Connection=Yes"
can anyone tell me the syntax error?
...more >>
When and How Do I Use Desktop Engine Posted by Mark Mokris at 10/27/2003 10:34:38 AM We have a SQL Server 2000 database. I naively purchased
VB .net standard thinking that I can write a couple
Windows Forms applications, connecting to the database
through ODBC. When I try to set up a data connection
object to our SQL Server database in the visual
environment I get a mess...more >>
Data Insert Problems Posted by Dazed and Confused at 10/26/2003 1:22:20 PM [crossposted from sqlserver.msde]
Greetings
I am running a merge replication MSDE database with SP3
installed (on all computers). I am having a problem
inserting new records into certain tables at the
subscriber database - not in all tables, only in specific
ones. The error message I g...more >>
?Jet DB is needed to read Excel through ADO.Net/OLEDB Posted by glennf at 10/24/2003 2:27:22 PM Contractor built a .Net app (ASP.Net/VB.net) app for us.
One function reads an Excel spreadsheet. This
function "works on their machine", but not in our Server
environment - unable to read the file. Other DB related
functionality works. Found a message somewhere indicating
that for Exc...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
ODBC and stored procedure Posted by Ionut Ceausu at 10/23/2003 5:59:18 PM Let's suppose we have an stored procedure that make an insert in a
table. That insert fail (primary key constrain). This stored procedure is
called from C using ODBC with
hr = SQLExecuteDirect(hstmt,L"{call MyProc }",SQL_NTS)
If the insert from MyProc fail, i will obtain an hr != S_OK (an...more >>
Connecting to Multiple databases in a single DSN Posted by Ken at 10/23/2003 2:51:27 PM Is it possible to have one ODBC client configuration
connecting to multiple databases?
I am trying to port an application to SQL Server and reuse
the references to the multiple databases:
e.g.
strQuery = "Select db1.table1.*,db2.table2.* from
db1.table1 (inner join db1.table1.field1 o...more >>
Where to find latest ODBC drivers. Posted by Stressed at 10/23/2003 1:07:31 PM Hi,
Does anybody know where to find the latest ODBC drivers, for use by SQL
server
now MDAC doesn't ship with them.
We have had some DTS errors, which have been tracked down to an out of date
odbcbcp.dll (which we should be able fix with a re-install of sql server
client tools).
As the...more >>
Connecting to SQL Server Posted by Laurent at 10/23/2003 7:38:08 AM I have a website which uses a SQL Server database (version
7 I think).
I have two database files a 'mdf' and a 'ldf'.
This is the asp code that connects to it
---
Application("Conn_ConnectionString") = "DSN=km" 'local
sql = "SELECT * FROM AdminUser"
set rsPass = server.CreateObject(...more >>
Strange but interesting ODBC error Posted by Gio Bacareza at 10/22/2003 8:50:41 PM In setting up System DSN using TCP/IP at port 1433 (SQL authentication) I
get this error:
SQLState: "HYT00"
SQLServerError: 0
[Microsoft][ODBC SQL Server Driver] Timeout Expired.
However, when I click next again, I can connect.
Strange thing is what causes this behaviour to happen: not o...more >>
SQL 7 --> SQL 8, trigger issue Posted by Lisa Pearlson at 10/22/2003 8:35:12 PM Hi,
We have backed up our database that was developed for SQL 7, and uses some
triggers and stored procedures.
It then was restored on SQL 8.
For some reason, triggers or stored procedures are not called for all users
who log in (Via NT authentication).
Everything works fine for the admini...more >>
Access SQL Server problem Posted by Mike Brown at 10/22/2003 8:34:15 PM I have a sporadic problem with an Access-SQL connection.
Occasionally, I will get an SQL Server error of "invalid locator
de-referenced #7143."
I can't even find the slightest hint that anyone has ever recieved this
error before.
I am using Access 2000 SP3 and SQL Small Business version 2000.
...more >>
ODBC error Posted by George Spiliadis at 10/22/2003 1:54:04 PM Anybody knows what this error can be about?
"ODBC error: [Microsoft] [ODBC SQL Server] [sql server]
The conversion of a char data type to a datetime data type
resulted in a out-of-range datetime value"
Thanks...more >>
Connecting to Access database on another computer Posted by Jag Kitchens at 10/22/2003 11:59:47 AM If I do the following, it works...
EXEC sp_addlinkedserver @server = test ,
@srvproduct = 'Jet 4.0',
@provider = 'Microsoft.Jet.OLEDB.4.0',
-- @datasrc = 'i:\test Database\Data\test.mdb',
@datasrc = 'd:apps\test Database\...more >>
Connection broken error Posted by jose at 10/22/2003 10:55:14 AM hi,
I have a application that has many stored procedure running
fine on a Win 2000 sp3 / SQL 7 sp3 server.
Recently i created a new proc. and when i run it the=20
system always abort the execution and shows the message:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]
ConnectionRead (Wrappe...more >>
Create DSN programmatically cannot set Port (VBA) Posted by Debbie at 10/22/2003 10:29:43 AM Hello,
I have tried for the past three days to find all of the
possible attributes for SQL Server ODBC, most specifically
how to 'uncheck' the "Dynamically determine port" option
and set the port number to 1435.
Here is what I have so far,
Const IMO_DSN_name = "EAOPS"
Const IMO_Server_...more >>
ODBC Configuration Error Posted by Dan Baker at 10/22/2003 7:04:45 AM While I am trying to add a DSN Entry on the SYSTEM DSN tab
in the ODBC Data Source Administrator, receive the
following error message "The setup rotuines for the sql
server odbc driver could not be loaded due to system error
code 126". Can anyone help me on this.
Thanks,
Dan Baker...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |