|
|
|
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 |
Filter by week: 1 2 3 4 5 Linked Servers Posted by Christoph Schmitt at 4/30/2004 9:07:51 PM Hi,
i have several questions, because i'm quite new to SQL-Server and Access
Projects. Till now i only worked with Access.MDB's
i created a new access project and have my database on SQL-Server. I see all
tables in my access-project and can work with them.
Now i need data from 1 excel file ...more >>
Can't expand localhost icon... Posted by Homer J. Simpson at 4/30/2004 11:28:48 AM Hi all,
Something that should have been straightforward turned out to be rather
problematic. Thankfully this is only a test machine. SQL Server 2000 Dev
Edition on XP Pro.
I detached a [BLAH] database file with Enterprise Manager, deleted the
corresponding BLAH.MDF/.LDF files, copied newe...more >>
MSDE TCP listen problem Posted by Finn Rasmussen at 4/29/2004 2:01:04 PM I have recently installed a MSDE 2000 (unfortunately with no service pack yet) on a Standard Windows 2003 server. I have used the srvntcn.exe utility to make the MSDE server listen on TCP/IP port 1433. But it will not listen on that port! Or any other TCP/IP port!! There is no information in the ERR...more >>
connection failed when using IP address Posted by dee at 4/29/2004 4:06:04 AM I am trying to connect to MSDE 2000a server over the internet. I have check and open the ports on my router pointing it to my server (1433 & 1434). But I am still not able to connect. (Check log and port is 1433
Does anyone know what I can try or do to resolve this problem (I have all the latest p...more >>
IIS 6.0 with sql backend connectivity Posted by Bahij Nahhas at 4/27/2004 6:47:05 PM Can somebody please send me a link or reference on how to
configure a website using IIS 6.0 to connect to a SQL on
the backend?
Thank you....more >>
still ongoing Posted by Chris Brighton at 4/27/2004 5:51:24 AM i have just been informed we are running MSDE, not the
full SQL server.
i am running the OSQL service that comes with it, and
looking through the information i have found so far. still
if anyone knows what i should be doing it would be greatly
appriciated as i have spent too long on this ...more >>
SQL only allows administrators access Posted by Chris Brighton at 4/27/2004 3:38:09 AM I am running SQL on our network to use a program called
BSquared: Connecting Steps. this program stores
information on a database on the server and uses SQL to
access it.
when running the program on an administrators profile
everything works fine, however when i attempt to run the
progr...more >>
URGENT: MSDE TCP Problem Posted by snehaltiwari NO[at]SPAM yahoo.com at 4/27/2004 3:33:06 AM I have installed MSDE 2000 on an XP Prof. box. I am able to connet to
this instance locally from the server, but when i try to connect to it
from other machines, i get an error stating
Server does not exist or access denied
I have traced this problem to msde not listening on port 1433 on my
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
general network error; no event logged Posted by Mike Doyle at 4/26/2004 2:10:56 PM When running a job under SQLAgent we have intermittently
received the following message:
ConnectionCheckForData (CheckforData()). [SQLSTATE 01000]
(Message 10054) General network error. Check your network
documentation. [SQLSTATE 08S01] (Error 11). The step
failed.
The job had been r...more >>
Disconnect error while running re-indexing job. Posted by clotho42 NO[at]SPAM yahoo.com at 4/26/2004 9:26:59 AM Hi,
I have a 24Gb database with half a dozen indexes against various
tables which is failing during the reindexing task (as part of the
maintenance plan) at least 80% of the time.
The error given in the logs is:
"[Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 0: This server has
been di...more >>
how to query database through proxy Posted by Daniela Tsigarovska at 4/26/2004 1:39:49 AM Hi,
I want to know what is the name of the manager used in
MSSQL Server 2000 that queries a database through a proxy.
The name of that manager in Oracle is Connection manager....more >>
MSDE over firewall Posted by Ed Morra at 4/23/2004 2:39:11 PM Succesfully created a MSDE 2000 rel A backend on 2003
server. I can connect a MS Access project frontend to it
from an XP client on the same LAN segment. I can connect
the same frontend over the internet to this server when
set out in the firewall's DMZ.
And now for my next trick! When I...more >>
How to enable SSL encryption as BOTH client and server Posted by Yuh-MIng Shyy at 4/23/2004 10:45:57 AM We have an application that requires bi-directional data transfer between 2
SQL servers. To ensure the data transfer is encrypted, we
are considering to use SQL server SSL encryption. However, the
problem is for this case, each machine is acting as both client and
server for SSL encryption. So i...more >>
Views from Oracle using linked server Posted by marcus.brodd NO[at]SPAM ibitec.se at 4/23/2004 6:17:11 AM Hi all!
I have a serious problem....(Who doesn´t...;)
I have a SQL Server 2000 and a Oracle 8.1.7 Database. I have set up a
number of views in SQL Server that are populated via a linked server
connection. In almost all cases this works great, but for one view.
The view displays OK, BUT one ...more >>
connection sql server with asp.net Posted by Zalizan at 4/22/2004 8:46:18 PM hello all.....i'm got a little problem here...i hope youu
guys can help me...
ok...first, i'm using asp.net for my web application. when
i run it in my own server, it's ok....got nothing problem
with connection to my database(in the same server)
but...when i'm bring it to my web server wi...more >>
Trusted Connection=Yes Posted by YUNG LIE at 4/22/2004 2:52:46 PM My connection from a web page to my SQL Server was
working when my connection string is:
....Trusted Connection=no; uid=sa; pwd=sapassword;"
It stopped working when I change it to:
....Trusted Connection=yes;"
I get this error message:
Microsoft OLE DB Provider for SQL Server error '80040...more >>
Encryption Not Supported Error Posted by Footix at 4/22/2004 12:16:06 PM When running .Net apps against a local SQL Server (2000, SP3) I get the following error
Connection failed
ConnectionOpen (PreLoginHandshake()
Connection faile
Encryption not supported on SQL Serve
Any help will be greatly appreciated
Thanks...more >>
DTC Error Posted by David Liu at 4/22/2004 12:05:28 PM I have a project with two SQL servers on two seperate
subnet, following distribute query will run on B server.
update [xxx.xxx.xxx.xxx].[abce].[dbo].[abcede] set
uploadstatus='InProgress'
If I include this statement in Transaction Like this way:
Begin Tran
update [xxx.xxx.xxx.xxx].[ab...more >>
Can the port change automatically? Posted by Kris Bilou at 4/21/2004 8:21:26 AM We were having problems with our SQL Server so we rebooted
it and when it came back up it was listening on a
different port.
Does anyone have any idea on how this could happen?
Thanks
Kris Bilou...more >>
MSDE 2000 SP3 Connection Problem Posted by Mark Miles at 4/20/2004 11:41:00 PM I am have a problem which has only just started happening while trying to
connect (locally) to MSDE 2000 (SP3a) which also prevents me from using
VS.NET Server Explorer.
When I try OSQL -E -S mimpc\NetSDK (this use to work) I get the following
error
[Named Pipes]SQL Server does not exist...more >>
Cant connect to MSDE on XPSP1 Posted by Shif Arad at 4/20/2004 10:09:25 PM We are writing a setup program for a customer that requires a MSDE
installation.
Using the following flags for the MSDE setup.exe:
SAPWD = "password" SECURITYMODE=SQL
The setup complete successfully, we are restarting the installed machine
(SQL services restarts as well)
But we cannot connect ...more >>
msde log file full Posted by Marion at 4/20/2004 5:36:04 PM Getting error "msde log file is full, back up the transaction file for the database." I do not know how to clear out the log file for msde? Any help is greatly appreciated.
Thank you very much...more >>
Unable to login server Posted by Marky at 4/20/2004 9:57:33 AM I just added an xpclient to our network. There is a Win
2000 server running win 2000 sql server on the network.
All client machines access the server for database
access, to a Visual Foxpro Application. When i try to
connect to the application i keep getting the following
error:
Unable to...more >>
Viewing Active Directorys from MS SQL 2000 Posted by andrewr NO[at]SPAM hornbill.com at 4/20/2004 9:34:34 AM Hi,
Can anyone offer any advice on exactly what I need to do to make a
remote MS SQL Server connect to and view the contents of my Active
Directory??
I've tried pretty much everything:
MS SQL Analysis Services
3rd Party Pluggin's
ADSI
etc
All with no success so any furth...more >>
Cannoit open user default database Posted by MarkAurit at 4/20/2004 9:31:04 AM When I opened em this morning, I immediate got an "A connection could not be established to (local). Reason: cannot open user default database. Login failed. Please verify that your sql server is running and check the properties ..." dialog box
Yes, its running, and no, I cant check the properties...more >>
Problem when connecting from remote location to SQL Server 2k SP 3 Posted by Luke at 4/20/2004 9:07:18 AM This is when using SA account trying the SQL Query
Analyzer. I get the error Msg 17, Level 16, State 1. I
can locally connect fine on the server itself using SQL
Query Analyzer. I'm using SQL Authentication.
When trying to connect I get:
Unable to connect to server (name of server)
...more >>
Connecting ASP.NET to SQLServer,Somebody,Please!! Posted by Mohammad-Reza at 4/20/2004 5:26:06 AM It is now 3 months that we are trying to connect ASP.NET to a SQLServer located on another system
However we act,we get a fatal error
We need someone to explain the way of connecting to SQLServer step by step from either VisualStudio.NET or FrontPage 2003
Our goal is to retrieve records from SQLS...more >>
Jet ODBC Driver for Text files - Permissions Issue Posted by Arun at 4/19/2004 3:55:23 PM Hi,
I have setup a linked server to a text file uing the MS Jet ODBC driver.
Users that are not sysadmins and local admins on the server that the file
resides get an Jet Initialize error message.
What are the permissions required for SQL Server users to gain access to
this file?
Thanks.
...more >>
SQL remote connection Posted by Lee at 4/19/2004 6:23:53 AM I have a VB application that uses SQL 2000 SP3 as its
DB. The problem I am having is the remote connection
using VB apps running on a XP SP1 Pro. The only way I
have been able to get the VB app to connect to the SQL
remotely is to create a local account on the XP system
with no password....more >>
Connecting through Enterprise Manager Posted by Dave Lugo at 4/19/2004 6:21:15 AM Hi
I am running Win2k Server on an XP machine. I have two
databases which I can run programs on with no problem. I
can connect and run queries through Query Analyzer with
no problem, but when i open Enterprise Manager to access
the Databases, the DB service stops and then I get the
mess...more >>
SQL Mail, MAPI clients and Outlook from Office 2003 Posted by David Lightman Robles at 4/18/2004 9:22:20 PM I have SQL Server 2000 running on a Windows 2000 Server. I have Outlook
(from Office 2000) installed on the server and set a mapi profile for using
SQL mail. This configuration is running ok. I once tried to install Outlook
XP but since it was not a mapi-compliant client that configuration didn't...more >>
can't connect to db/ server Posted by stephen hall at 4/18/2004 1:18:30 AM don't know if this is the right place, but anyway...
trying to connect remotely to a mysql database hosted on windows 2003 remote
server.
Can connect locally but not remotely.
Excluding db server setup is there anything on the server that could be
blocking?
How would I check to ensure po...more >>
connecting to sql server from asp page Posted by Ronny Jones at 4/17/2004 3:06:02 PM Hi
I'm trying to establish a connection to Sql Server from an asp page using a System DSN
I setup the System DSN to use Sql Server authentication; the userid and passwor
were stored with the ODBC configuration utility. Sql Server is configured to used both Windows and Sql Server authentication
...more >>
Can not register SQLServer2000 in Enterprise Manager Posted by Charles at 4/17/2004 12:14:30 PM Hello,
I try to register a remote SQL Server 2000 installed in a W2003, but it
doesn't work. Afer about 5 or 6 seconds, it says: Timeout expired.
In that network , there is not any firewall and port 1433 is open in the
router. What it really surpises me, is that
I can connect via ODBC to a...more >>
Why SqlServer always generates "EXCEPTION_ACCESS_VIOLATION" error? Posted by Neil at 4/17/2004 10:32:46 AM All error message is:
SqlDumpExceptionHandler: Process 26 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
It seldom happened before, but always appeared these days. Can anybody
explain why? Any suggestion will be welcome, thank you!
-...more >>
PacketSize Posted by Paul Wicks at 4/17/2004 7:11:06 AM I am getting the error
"General network error. Check your network documentation.
It occurrs when I write/update to MSDE 2000 using ADO.NET's SqlClient classes. It only occurrs when the record reaches a certain size (around 10K, or so) and only occurs in certain environments. Some XP and som...more >>
Finding connected users Posted by Tanuj Ralhan at 4/17/2004 3:41:04 AM Hi Everybod
How to find about the connected users to the SQL Server....more >>
Connection Problems to SQL 6.5 Posted by Mansoor Azam at 4/16/2004 5:13:57 PM We connect to a SQL 6.5 server (IP for example 202.64.213.11) on WIN NT
using ODBC DSN and / or SQL Client (DB-LIB). Everthing was working fine then
the some XP client machines (192.168.0.1 and 192.168.0.3) started giving
problems. All TCP/IP connections go thru the WIN 2000 multihomed machine
...more >>
DSN vs login authentication Posted by Riccardo Piccini at 4/16/2004 2:15:42 PM Hello everybody!
I've created a DSN from a WIN2K Pro client to connect to a SQL Server 7.0
running on a WIN2K Server with domain controller.
The SQL Server authentication mode on the server machine is "Mixed mode"
Inside the client DSN configuration I've specified that the Authentication
Mode...more >>
Internal Connection Fatal Error - SQL 2000 and ASP VS 2003 Posted by Rich at 4/16/2004 11:24:34 AM We have an ASP.NET 2003 app that accesses a MS SQL 2000 Std. database. =
Randomly it returns this error:
Internal connection fatal error.=20
Description: An unhandled exception occurred during the execution of the =
current web request. Please review the stack trace for more information =
ab...more >>
Linked Server to Oracle 9.2 Posted by Mark Rabau at 4/16/2004 9:06:52 AM Greetings,
My customer is in the process of changing from Oracle
8.0.5 to 9.2.0. In one of there tables there is a field
that is defined as a number with no precision, and no
scale. When I look at the data in the field I find digits
on both sides on the decimal point.
The databases usi...more >>
Can not open database requested. Login fails Posted by tinku at 4/15/2004 6:27:09 PM Hallo:
Trying to connect to database using OLE DB. Gave the
following code:
con.ConnectionString="Provider=sqloledb;"&_
"Data Source=ServerName;Initial Catalog=DatabaseName;"&_
"Integrated Security=sspi;Trusted_Connection=yes;"
con.Open
Getting error message:
Microsoft OLEDB Povider ...more >>
SQL Server does not exist or access denied. Posted by Narasimha Murthy at 4/15/2004 4:14:20 PM Hi,
I have SQL Server 2000 running on server (Windows 2003 server). I am
trying to connect with ASP.Net Web service which is on my development
machine, to which the server responds with "SQL Server does not exist or
access denied". The same connectionstring works fine for a windows form
ap...more >>
Linked servers Posted by Rajah at 4/15/2004 9:03:23 AM Hi,
We linked 2 sql servers and executing stored procedures
between the two servers.
We can able to execute sql statements with 4 part key
from sqlserver1 to sqlserver2 on some databases and
cannot able to do on other databases. All settings and
users are same in all databases.
For ...more >>
connectivity Posted by manoa at 4/15/2004 7:31:27 AM I trying to connect to a SQL DB SP 3 using cisco client
VPN v.4.01. The VPN is connecting to a Cisco PIX515 with
MS IAS as its AAA. On a remote PC running Win XP SP1
logging in with the local builtin administrator account,
I can connect to the SQL after I VPN in. With everything
remaini...more >>
Third Party Software can't connect with SQL Server using TPC/IP Posted by Armando at 4/14/2004 6:13:15 PM Hello all,
I have this really really strange problem with one of the
application we support in Latin America, this is a 3rd
party software for accounting that uses SQL Server for
it's DB handling, we are using SQL Server Client Network
Utility to connect to the SQL, but this morning, the ...more >>
Weird Problem Posted by kpatel5 NO[at]SPAM utk.edu at 4/14/2004 1:48:48 PM I have a weird situation here...
I have a website with asp pages running on windows 2003 server that
updates a database running on a sql 2000 server.(The web site was
developed using visual interdev and has DTCs)
The site works fine when browsed using windows 2000/xp machine. But,
when i br...more >>
PROVIDER=SQLOLEDB connection error Posted by Laura at 4/14/2004 10:40:46 AM I am connecting to my database using PROVIDER=SQLOLEDB;
I am gettting the error of "Requested Operation Requires
an OLE DB Session Object, which is not supported by the
current provider"
I have MDAC 2.8 and SQL 2000.
Has anyone come across this error?
Thanks....more >>
RDS Posted by nahumkl at 4/13/2004 8:29:31 PM I am trying to connect to my SQL server but I keep getting
this message: RDS Failed to execute SQL="SELECT * From
Users WHERE UserID Like "name"', err=-214012889,
Desc="Internet Client Error: Cannot to Server./nRetry?
Can someone help me decipher this and give a solution
Pleae!...more >>
'sp_addlinkedsrvlogin' requires sysadmin account Posted by Mike at 4/13/2004 1:59:58 PM Hi,
I'm using 'sp_addlinkedsrvlogin' in a stored procedure
that pulls data from Oracle into SQLserver2K.
BOL states that only members of the sysadmin and
securityadmin fixed server roles can execute
sp_addlinkedsrvlogin.
How can I get around this such that non-sysadmin users
can use...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |