all groups > sql server msde > december 2004 > threads for december 1 - 7, 2004
Filter by week: 1 2 3 4 5
VB .NET Standard 2003 and MSDE 2000
Posted by Salvador Torres at 12/7/2004 9:43:23 PM
I have a Windows XP Home in a Laptop running VB .NET
Standard 2003, MSDE 2000 and Office Professional 2003.
I've been able to complete all the the exercises (except
of course those regarding IIS) in the Visual Basic .NET
2003 Step by Step book.
I start to follow the exercises in ADO .NET... more >>
How to delete (drop) a database with OSQL
Posted by Richard Fagen at 12/7/2004 5:44:29 PM
Hi,
I imported DBF files into a new SQL server database and I've been
developing a VB.Net application.
Now I would like to delete the current database and re-import a more
current set of DBF files into SQL.
Only problem, I can't seem to find a way to delete the database from
MSDE. I ... more >>
Installation Issues
Posted by GrumpyOldMan at 12/7/2004 2:05:09 PM
I have installed MSDE2000A on both 2000 and XP Pro machines, the install
appears to go fine. After the reboot, the service manager icon is empty,
when I look for the services in the drop down in the Service Manager it is
empty. In the system services screen, I have made sure all three servic... more >>
Unspecified error with MSDE
Posted by Yoyako at 12/7/2004 1:07:07 PM
When I click the property of particular Database in Enterprise manager I saw
the following message:
Internet Explorer Script Error
Line 307
Char 2
Error Unspecified error... more >>
sql server connection from asp.net
Posted by beeyule at 12/7/2004 10:41:10 AM
I am using an asp.net page with vb.net. The following connection in my
web.config file will connect the database to my page no problem:
"Data Source=MIAPPS1;Initial Catalog=MASTER_DB;Integrated Security=SSPI;"
However, when I add the data to the page and try to preview it in the
browser I... more >>
Query Execution Speed
Posted by djwhisky at 12/7/2004 8:59:53 AM
Hi there - i'm hoping someone can help me!
I'm having a problem with a live database that i'm running on MSDE - It
seems to have slowed down quite considerably from the test environment
(even when all the data is the same). The is notably different on one
particular query that takes 1 sec on t... more >>
how to create primary keys on compound fields?
Posted by Richard Fagen at 12/6/2004 5:18:29 PM
Hi everyone,
I am now getting seriously into VB.Net development as a front end to SQL
server. After working about 20 yrs with DBF's and various xBase
programs (dBase, FoxPro, Clipper, etc), I am now convinced VB/SQL is the
way to go :)
I have a few questions:
I've successfully import... more >>
Image Data Type
Posted by Charlie at 12/6/2004 4:18:30 PM
Where can I find information about the IMAGE data Type
for MSDE2000?
Thanks, Charlie... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL server does not exist or Access Denied
Posted by beeyule at 12/5/2004 3:23:02 PM
I'm using Dreamweaver to connect to an SQL server MSDE sp3 with NT
Authenication, everything works perfectly fine when using an asp page with
DSN connection. I installed .NET and created an ASP.NET page and can no
longer connect with the following error:
[DBNETLIB][Connection Open] SQL ... more >>
WMSDE
Posted by Jens Richter at 12/5/2004 2:19:08 PM
Where can I find WMSDE?
... more >>
Enable tcp/ip protocol via registry
Posted by Andrea Moro at 12/3/2004 9:06:43 PM
Well, I need to enable the tcp/ip protocol via registry,
so I added the following value inside the registry
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\GESTP\MSSQLServer\SuperSocketNetLib\Tcp]
"TcpHideFlag"=dword:00000000
"TcpDynamicPorts"="0"
"TcpPort"="1433"
But if I ca... more >>
Setup failed to configure the server MSDE2000 RelA
Posted by jgrob3 NO[at]SPAM hotmail.com at 12/3/2004 4:56:08 PM
I've been trying to install a program that uses the MSDE database as
its backend but haven't been able to get the program to install
properly.
It appears the issue is related to installing MSDE so I downloaded the
latest MSDE 2000 Release A from MS and installed this (although it
does not app... more >>
Help with MSDE 1.0
Posted by Eduardo Martinez at 12/3/2004 10:15:18 AM
Hi everyone!
First I'll expose my problem: I have a crashed disk which I believe had MSDE
1.0 installed (MSSQL7 folder). I had no problems recovering the databases
from backups but there was some DTS's that obviously were in msdb database.
I have the .mdf and .ldf files and I also have a backu... more >>
SQL Express - Number of Users
Posted by David Mathias at 12/3/2004 9:07:03 AM
Has anyone found information about the number of users for SQL Express 2005?
We are considering using it for an app we developed that is currently using
VFP8. We'd like to speed up the app using SQLE, but are concerned about the
number of users.
I can't seem to find anything about the use... more >>
MSDE integration with VB. NET
Posted by Guy at 12/3/2004 1:37:23 AM
I have VB. NET
I want to build SQL databases on my own PC using VB and
MSDE.
No matter how many ways I install it or passwords I use,
I just cannot get read/write access from witihn VB. I
have upsized the Northwind.mdb.
There seems to be a multidude or service packs for MSDE
and nume... more >>
MSDE setup fails to register with MDAC
Posted by SqlJunkies User at 12/2/2004 11:12:23 PM
Hi all-
I am troubleshooting a case where attempting to install MSDE generates an error along the lines of "MSDE setup failed to register wtih MDAC." I have never seen this error before and the two things I've noticed that make this case unique is the computer is running BDE and also has Windows... more >>
Confused
Posted by Guy at 12/2/2004 10:13:26 AM
I have VB. NET
I want to build SQL databases on my own PC using VB and
MSDE.
No matter how many ways I install it or passwords I use,
I just cannot get read/write access from witihn VB. I
have upsized the Northwind.mdb.
There seems to be a multidude or service packs for MSDE
and nume... more >>
Trusted SQL connections
Posted by anonymous NO[at]SPAM discussions.microsoft.com at 12/2/2004 9:21:05 AM
Having just installed my SQL Server Desktop Engine, I
have upsized the Northwind.mdb database onto my
local 'server'.
However, when I connect to it through VB.Net, I only seem
to have read only access to it. Ie. I am unable to create
new views etc.
What am I doing wrong?
I installed... more >>
MSDE Reboot Question (2 parts)
Posted by wardellcastles NO[at]SPAM hotmail.com at 12/2/2004 8:22:17 AM
1) When I install and MSDE instance for the first time on a machine,
the install states that I must reboot the machine. However if I
manually start the instance, then my programs can access that instance
without a reboot.
2) If I uninstall the instance done in 1 above, through the Add/Remove
... more >>
SQL Server and MSDE
Posted by Marathoner at 12/2/2004 4:45:01 AM
I need someone to clear up a few questions I have about MSDE. I have SQL
Server 2000 installed on my machine. Does this mean I also have MSDE
installed or is this a separate installation?
Can you install MSDE on a sever to be accessed by 5 users running a WinForm
application from their ma... more >>
Find an associated user
Posted by constants NO[at]SPAM mix-net.net at 12/1/2004 1:10:48 PM
I am trying to copy a database that is on a Windows 2000 box to one
that is on Windows 2003. Is there a way to export a list of server
login names? I am having problems with one I am trying to create where
on the old server using Teratrax I can see that it is an associated
user Name, but I don't... more >>
Verifying and changing the MSDE System Administrator Password
Posted by Guy at 12/1/2004 9:42:29 AM
I am trying to configure my MSDE so that I can connect to
the local instamce that it creates. I can see it on the
server manager, but cannot get through via Access (2002-
project) or VB>NET>
Looking through the installation documentation,
http://support.microsoft.com/?kbid=322336
Th... more >>
MSDE icon not in systray
Posted by bcb963 at 12/1/2004 6:25:04 AM
Hi,
I've just reinstalled MSDE release A on my machine. When I boot up the icon
in the systray is not there but it shows that it is running in task manager
does anyone know why tis is happening at what I can do to have the icon back
in the systray??
Thanks... more >>
SQL Server Desktop Engine
Posted by Guy at 12/1/2004 6:05:53 AM
I have my SQL Server Service Manager happily running a
local instance, but I seem to be unable to connect to it
using VB.NET or Access 2002.
Could there be some kind of access privilege issue?
... more >>
SQL Server Desktop Engine
Posted by Guy at 12/1/2004 3:28:15 AM
I have just had VB .NET installed along with the MS SQL
Server 2000 Desktop Engine and have got myself a little
confused.
Apparently MSDE was supposed to have set up a SQL Server
instance on my PC when it installed but when I look in
the list on the SQL Server Service Manager it only li... more >>
|