all groups > sql server msde > march 2006 > threads for march 29 - 31, 2006
Filter by week: 1 2 3 4 5
Need help setting up RDA
Posted by Phillip N Rounds at 3/31/2006 4:02:20 PM
I'm trying to use RDA to exchange data between a CF 2.0 app and SQL Server
2005 ( Developer Edition ), and I guess I really don't know what I'm doing.
SQL Server 2005 is up and running.
I've installed SQL CE ( 3.0 ) on my development machine.
I've configured IIS ( 5.1 ) for RDA as follows... more >>
Connecting To Remote MSDE With Server Management Studio
Posted by virgin69 NO[at]SPAM gmail.com at 3/31/2006 11:20:38 AM
Hello,
I am having issues connecting to an MSDE instance on a remote machine
using MSSQL 9's Server Management Studio.
I am also have issues connecting to a remote instance of MSSQL v7 using
Server Management Studio. Later, I will have to connect to MSSQL v8.
If there is a step-by-step ... more >>
Can MS SQL Server 2005 Express Installed On Windows XP Embedded ?
Posted by Jeff Phang at 3/31/2006 12:00:00 AM
Hi,
Appreciate if any friends here can do me a favour by telling me whether MS
SQL Server 2005 Express can be installed on Windows XP Embedded ?
I have run the SQL setup file and while the setup process was trying to
start the SQL database service, the Setup screen prompted "The SQL server
... more >>
Why is it getting slow?
Posted by Paul Pedersen at 3/30/2006 11:41:00 PM
I have a small (12 MB) database. I don't think it's full, but in any case
it's set to grow without limit as necessary.
It is accessed only by MSDE on the same machine, and then only by one
application, via ODBC.
Everything was working until about a month ago, when it became very slow.
Ev... more >>
How to use Windows Authentication for MSDE connections ?
Posted by Sagaert Johan at 3/30/2006 12:00:00 AM
Hi
From the local PC windows authentication seems to work, but from remote pc's
te client seems to logon as guest.
Do i need to install MSDE on a windows server edition to get the windows
authentication working ?
SQL Authentication works from remote machines, but becorse the password is... more >>
weekday Problem (falscher Wochentag)
Posted by Raymond Geering at 3/30/2006 12:00:00 AM
Hallo,
Beim Umschreiben einer Abfrage von Access XP auf SQL (bzw. MSDE)
bin ich auf ein interessantes Problem gestossen.
Gem. Access Hilfe ist die T-SQL Funktion für Weekday
DATEPART(dw,x)
Nur gibt mir in Access für heute (Donnerstag)
weekday(now) -> 5
und SQL
DATEPART(dw,GETDATE()) ... more >>
can't upgrade msde sp4
Posted by ak9408 at 3/29/2006 5:20:02 PM
i'm trying to upgrade to sp4 using the following command:
<setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=username
UPGRADEPWD=password /L*v C:\MSDELog.log>
it starts, then stops, without giving me an error.
Please help!!... more >>
Icon Tray SQL
Posted by Bob Day at 3/29/2006 1:02:49 PM
In the icon tray is the SQL icon with a green arrow that briefly shows a red
dot to the lower right of the arrow. All programs that use SQL work fine.
I am just wondering what the red dot means? It is like a heart beat to show
it is acitive? Or does it indicate an issue?
Bob Day
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
MSDE Backup Size increases
Posted by ABB at 3/29/2006 8:39:02 AM
Our clients are using MSDE. Our VB application provides simple full backup
feature usng DMO. We have noticed that their recent backup size goes to 2GB.
to investigate, When backup taken from enterprise manager it is 60 MB. What
could be the rerasons?. The clients are doing hundered of inserts... more >>
|