Archived Months
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


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 >>



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 >>


DevelopmentNow Blog