all groups > sql server msde > july 2004 > threads for july 22 - 28, 2004
Filter by week: 1 2 3 4 5
how can I confirm msde sp3a upgrade information
Posted by peter at 7/28/2004 10:00:09 PM
I would need to know if the MSDE SP3a is aleady Upgraded.
I didn't search registy and Enterprise Manager(other PC)
Thank for your help... more >>
MTBF
Posted by Paul at 7/28/2004 8:15:34 PM
Hi,
I am looking for some statistics for MSDE. In particular, I am looking for
information that would catain items such as Mean Time Between Failure.
Can anyone point me to a resource for this?
Thank you,
Paul
... more >>
SET CONSTRAINTS ALL DEFERRED not working
Posted by Jens Neuhalfen at 7/28/2004 6:44:37 PM
Hi group,
this just drives me mad: I need my msde (the 7.0 version) to deferr
foreign-key checking until commit time.
The problem is this: I need to delete some rows in different tables
from my middle tier. I do not know which rows in which table are
delted beforhand so sorting the state... more >>
DisableNetAccess
Posted by Lance Johnson at 7/28/2004 1:36:38 PM
Windows98 machine and when installing MSDE we (our customer) gets an error
on DisableNetAccess. I have no idea what they should do and I can't find
anything in google with the word disablenetaccess so I'm hoping somebody out
there has some info. Below is the relevant info from the log file when... more >>
SQL Express 2005 beta - OleDB/ADO works, ODBC / dbExpress - impossible
Posted by LigH at 7/28/2004 11:25:35 AM
Dear Microsoft develpers and users,
creating an ADO connection using the connection builder is no big problem
(once I found out how to use it): Select the provider "SQL Native Client",
use as data source ".\SQLExpress", define the rest - and your connection
string will look like "Provider=SQLN... more >>
Please Help with Access Sql connection
Posted by Al at 7/28/2004 7:31:16 AM
I have an access FE linked to SQL backend. I am just
testing the connection of another workstation to the
server. when I linked another workstation to the server
everything went smooth, however only one table that when I
tried to open I got the following message:
"ODBC--Connection to 'CRF_B... more >>
MSDE Deplyment using BootStrap - Instance created
Posted by jazztol NO[at]SPAM hotmail.com at 7/28/2004 4:56:42 AM
Hello,
I am using the boor strap to deploy MSDE with my application.
after deployment i cannot choose the server from the service manager
because it is not there ( localhost ) and also the instance is not created.
Can someone help ?
Thanks
Haim Toledano... more >>
MSDE and SQL Express '05
Posted by Wayne P. at 7/28/2004 3:39:34 AM
I been trying to read the posts to answer this, but I don't see a
straightforward answer.
Can MSDE and SQL Express '05 co-exist on the same machine?
Thanks,
Wayne P.
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Password not Added after Installation
Posted by Shahzard at 7/27/2004 10:44:11 PM
Hi,
I recently installed MSDE 2000, by giving the following to
setup parameters in the Command Prompt:
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\> D:\MSDE2000\Setup.Exe SAPWD="apple" SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0 /L*v C:\MSDELog.txt... more >>
Answer: Access creates DB in MSDE in SQL Server Authentication mod
Posted by Lou Arnold at 7/27/2004 10:09:02 PM
I've confirmed that MS Access will create an ADP project in MSDE only if the server is set to Mixed (SQL Server and Windows) authentication mode. Trials in Windows Authentication mode failed. This is still hard to believe, I know, but its a reality.
To all those who tried to help, my sincere than... more >>
Primary Keys
Posted by June Macleod at 7/27/2004 2:35:44 PM
I have managed to confuse myself as to when and how you can set up Primary
Keys on an MSDE database.
Are Primary Keys only used when you are connected to an MS Access project or
can they be used in other places.
I come from an MS Access background and am familure with the use of Primary
Key... more >>
UPDATE Image Column to NULL
Posted by Michael Mieney at 7/27/2004 11:11:04 AM
Am using SQL 2000.
Am storing data in image columns, created with NULLS allowed. Requirement
has come across to revert (in some user-selected cases) the column back to
no data. Have been using the presence of the NULL to check for the absence
of the data and this has been successful. Have d... more >>
replication from MSDE 2000 to SQL Server 2000
Posted by Hifni at 7/27/2004 5:59:24 AM
hi,
There is a computer which have been installed MSDE 2000
(Assueme this as "MiniDB"). This should be the Publisher
as in my Architecture. The Main Server which is a MS SQL
Server 2000 would be the Subscriber(assume that the name
is "MainServer"). I want to replicate the data from
my "Min... more >>
sqlmangr.exe Error
Posted by Oleg at 7/27/2004 12:21:37 AM
I have problem on my w2k server post SP4,MSDE SP3 .
I start sqlmangr.exe, and do any mouse click on the form
and it disappears.
Actually, I don't even need to click! Just moving the
mouse over the form causes it to disappear sometimes
without an error message or anything,
but usually I get... more >>
IDENTITY_INSERT Problems
Posted by drs at 7/26/2004 4:02:38 PM
Hi, I am having a problem with IDENTITY_INSERT command with MSDE 2000 (ADO
2.8). (lines below with >>> are code lines. I am using Python, but the
syntax should be about the same as VBScript)
First, I create an ADO Connection and create my table.
>>> c = win32com.client.Dispatch('ADO... more >>
DB bloat from images: Access vs. MSDE
Posted by Yair Sageev at 7/26/2004 2:52:02 PM
Hi,
I'm in the process of upsizing my access database to MSDE. When you embed
images in an access DB, the database bloats out of control. I'm wondering
if the same problem occurs in MSDE when you embed images.
Thanks in advance.
... more >>
MAX() and DATEDIFF() question
Posted by BCM at 7/26/2004 8:02:11 AM
I've written some software that listens to meters on a specified port and
writes XML files when any of those meters "speak." There are some 200 of
them, and each is programmed to "speak" at 10 second intervals, so there's a
fair amount of traffic.
Now what I've been asked to do is write a reco... more >>
User rights when installing MSDE 2000A
Posted by Carolina at 7/26/2004 3:08:20 AM
Hello,
Is it possible to install MSDE 2000A with local admin
rights and then run it with poweruser rights? Or do I
have to have local admin rights when I run it as well?
Now I have tried to install it with an account that have
local admin rights and after that I tried to run it with
ano... more >>
MSDE 2000A EULA / SBS 2003 Web Edition
Posted by Martin Feuersteiner at 7/23/2004 7:19:29 PM
Hi. I'm a bit confused and wonder whether someone of you can give me some
more information on this.
The EULA for MSDE 2000A states that you cannot use MSDE for hosting
services. Does anyone know what this mean?
I'm running an ASP.Net application and would like to use MSDE as the backend
datab... more >>
MSDE 2000 Install Problem
Posted by Jason Stamp at 7/23/2004 10:52:14 AM
Hi
I am trying to install MSDE 2000 sp3 on a Windows XP that has had a previous
installation in the past. The previous installation has been removed, but
when I try installing MSDE again from the command prompt, it starts to set
up the gives me an error saying installation failed.
I have de... more >>
Building SQL Query to fill a treeview control with Year->Month->Day nodes
Posted by MJB at 7/23/2004 9:54:34 AM
Hello,
I have load dates for each row in my database table. I'm trying to build a
query that will give me all of the unique years, then all of the unique
months for that year, then finally all of the unique days for that month.
I'm trying to load a treeview control with the results ... more >>
Cannot see MSDE Sever on network
Posted by adriatik at 7/23/2004 1:44:03 AM
Hi everyone.
I have installed MSDE on Win 200 Pro. everything works fine when i try to connect on the local maschine, but when i try to get a connection from another computer, then
he cannot find the server, when i look with enterprise menager the same thing.
have any idea?
... more >>
exporting desktop MSDE to remote server Sql
Posted by Bob K. at 7/22/2004 11:26:24 PM
What is the best tool for doing this? I have been using MSDE to create a
portal app on my desktop and now want to move the data from the MSDE db
locally to the remote server db. I can export the MSDE data but need a way
to get it to the remote sever and import it. Enterprise Manager seems to... more >>
Cannot connect to Sql Server 2005 Express. Any idea why ?
Posted by Ing. Rajesh Kumar at 7/22/2004 10:56:27 PM
Hi everybody
I have a system with :
WinXP Pro, MSDE 2000, Framework 2.0 beta. On top of it i installed SqlServer
2005 Beta with Mixed Mode. I am using Query Analyzer and Enterperise Manager
from SQLServer 2000 to connect to it (manual says I can) but with no
success. I tried to log on with wind... more >>
MSDE or SQL-SERVER ??? help
Posted by Artmic at 7/22/2004 5:08:01 PM
Hello can someone help me out, i need to know if i buy the 5 User Cal license of MS-SQL server, does that mean that only 5 people on the network or through the web can access the database? Is that true?
How can i use the SQL Server in the following way:
2-4 users running on a local area networ... more >>
DDL statement is not allowed
Posted by eslalinde at 7/22/2004 1:57:01 PM
hey, i have a small bussines with share point and msde2000, when i try to create a table in the servername\sharepoint, i get this DDL statement is not allowed, can anyone help wiht that
thanks... more >>
Pubic Chat: SQL Server 2005 Beta 2, What's New
Posted by Stephen Dybing [MSFT] at 7/22/2004 11:19:59 AM
Join members of the Microsoft development team as they chat about what's new
in SQL Server 2005 Beta 2. One major new feature that's been announced in
Beta 2 is data encryption. Come chat about other new features and changes
that exist in this highly anticipated beta of the next version of SQL... more >>
problem running MS SQL Web Data Admin
Posted by vl at 7/22/2004 12:04:41 AM
Hi:
My client machine is XP Pro with SP1 with IIS 5.1 My server machine is
Windows 2000 server SP4 with IIS 5.0. Server has the latest MSDE 2000(SP3a,
in mixed mode) as well as MS SQL Web Data Admin (webadmin) installed on it.
I can use webadmin on the server to access data in MSDE using windo... more >>
|