|
|
|
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 November 2007 August 2008 |
Filter by week: 1 2 3 4 5 Updating a database Posted by Charles A. Lackman at 5/28/2004 5:55:15 PM Hello, I have created a connection string to a siebel database and have
been able to connect and retrieve records using ADODB and the dbeng50.exe.
This works pretty good but it will not let me update any data from my .NET
Application. I am using the administrator password and have tried the use...more >>
Linked server Posted by Admin at 5/28/2004 1:18:52 PM I linked to paradox table from MSSQL 2000 enterprise server and I saw all
the table name
but my question is how can I make a select statment to see the data?
...more >>
Active Directory Posted by Robert E. Flaherty at 5/28/2004 11:24:31 AM What is involved in connecting a SQL Server 2000 to Active Directory. My
need is not to register SQL Server but to exchange data.
...more >>
Linked Server Connection Issues... Posted by Greg at 5/27/2004 9:58:49 AM I have the following connectivity issues when querying a
linked server:
Base Server[s]:
SQL Server 2000 (32 and 64-bit) sp3
SQL instances listening on port 1433
Windows Server 2000 and 2003 (32 and 64-bit) (clustered
and stand-alone configurations)
Reside on same subnet
Linked Server:...more >>
spid changes when execting async queries Posted by Peter at 5/27/2004 9:11:03 AM When using ADO I create a connection object and then run several select only queries against that connection object. The queries are executed simultaneoulsy and with async. Behind the scenes, and a simple SELECT @@spid query verfies what I am saying, further connections are opened having differing s...more >>
SQL Server Login Error Posted by SqlJunkies User at 5/27/2004 7:26:17 AM Could you provide explanation of the following error message, and what I need to do to rectify it?
Connection failed:
SQL State: '01000'
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]
ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001...more >>
MS SQL SERVER 7.0 SERVICES Posted by SANJEEV GARG at 5/27/2004 6:22:46 AM WHILE STARTING MS SQL SERVER 7.0 SERVICES, SYSTEM IS
GENERATING ERROR 1067 AND UNABLE TO START. PLS. ADVISE.
REGARDS,
SANJEEV GARG...more >>
Unable to load OLEDB provider dll Posted by Guru at 5/27/2004 12:26:01 AM hi
im started to get the following error message while
executeing query saying that-
"Unable to load SQL Server OLEDB provider resource dll"
Imusing Win2K Professional and SQL 2K SP4.
I intalled MDAC 2.8 also but problem persist.application
was working fine previously..
Can any one give me ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Intermittent SQL Server does not exist or access denied. Posted by Matt Pallatt at 5/26/2004 5:01:37 PM Hi, I have a web application which is taking a fair bit of traffic.
It involves a registration process, and then a series of questions which
must be answered. The SQL server receives upwards of 1,000,000 queries a
day.
Unfortunately on a small number of these queries (~500 a day), the ASP ...more >>
Could not close net-library Posted by gabriel at 5/26/2004 7:43:47 AM Hello,
Since couple of weeks, we got this error in event viewer
and it make the sql server not accept anymore connection
after 2 or 3 days. We need to stop and restart the sql
service.
Error:
Event ID 17052:
Error: 17825, Severity: 18, State: 4
Could not close Net-Library ''.
Eve...more >>
SQL Server does not exist or access denied. Posted by Saint at 5/25/2004 4:31:24 PM I am facing the following problem:
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.
I am using SQL Server2000 (SP3) on Win2000 (SP4).
Any help would be appreciated.
...more >>
Need SQL Server 2000 pre SP4 hotfix for KB818806 Posted by Mary Clark at 5/25/2004 2:51:15 PM Does anyone have this hot fix and if so, are you willing to share it with
us?
Thanks,
Mary Clark
SQL Server DBA
...more >>
connection pooling Posted by djc at 5/25/2004 8:14:54 AM is connection pooling something that can be used after moving tables from
mdb file to sql server 2000 and just relinking the tables via ODBC in the
front end file? Or is this something that must be setup in code?
...more >>
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server Posted by Jonas Back at 5/25/2004 6:24:38 AM We have a problem on a SQL Server 2000 with SP3a and
latest security patch running on Windows 2003.
We have several other SQL-servers aswell but this one
seems to have problems with Windows Authentication. It
worked properly first but then when we changed to Windows
authentication and the...more >>
Help - Loosing my Sanity Posted by Jenn at 5/25/2004 5:11:12 AM We are having a problem with our services (mainly SQL server) in that they loose/forget their passwords. So, even though the service is set to start automatically, it can't do to a logon failure. We must type over the password and then are able to start the service. This is happening on multiple ...more >>
FAQ on SQL Server connect issues? Posted by Earl at 5/24/2004 10:06:31 PM Seems like there are so many different variations and flavors of connect
issues, surely there is a FAQ or a KB that documents all (or most) of them?
...more >>
registering a sql server Posted by chan at 5/24/2004 9:29:45 PM i'm the first time to use sql server 2000 to develop my
final year project.....since i never create any database
using sql server 2000 before....my "sql server group" is
empty.......when i register a server.....a message
prompted out as folling "SqlConnection()is failed or
access denied"....more >>
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server Server Connection. Posted by Grant Reid at 5/24/2004 5:11:23 PM Hello,
I am trying to create an OLE DB connection to MS-SQLSERVER 2000.
I have set the security settings inside Enterprise Manager to allow logins
for both SQL Server and Windows.
Does anybody have any ideas as to what is causing this error?
Regards
Grant Reid
...more >>
creating a database on the server Posted by Scott Baxter at 5/24/2004 10:37:03 AM Is there a way to create a brand new database on the server?
Someone gave me the asp code below, but I haven't gotten it to work yet.
Thanks for any help.
<%
Dim strSQL
Dim cnnTest
strSQL = strSQL & "CREATE TABLE tblTest " & vbCrLf
strSQL = strSQL & "(" & vbCrLf
strSQL = strSQL & "ID...more >>
SQL Connection Problem Posted by BB3 at 5/24/2004 10:26:23 AM Trying to make connection from Visual Basic.net to remote
SQL database via XP Client without success. Varying
flags...from can't locate server to access denied.
Various logons created on SQL server and all fail. I can
access/logon to server via Remote Access but can't
connect from Visual B...more >>
Problems installing/accessing SQL server via web Posted by Donald Wheeler at 5/24/2004 9:51:05 AM Hello
I am doing some development for a client who has an IIS server runnin
webmail on the same box as the SQL server 2000 sp3 install. I am trying to connect t
this box but do not know how to set it up to connect. The IIS for SQL serve
tool lets me add a virtual directory just fine but will no...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |