all groups > sql server connect > april 2004 > threads for april 22 - 28, 2004
Filter by week: 1 2 3 4 5
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 >>
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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|