.sqlserver.newusers/post14419113.aspx ================================================= Is it possible to determine through the registry which edition of SQL Server 2000 has been installed - Enterprise, Standard, Personal, Developer, Evalulation, Windows CE, Desktop (MSDE)? I know it's possible using 'SELECT SERVERPROPERTY('edition')' in QueryAnalyzer but what about the registry? Thanks! ================================================== No, but you can use registry key below to differentiate between MSDE and other sql editions: For a named instance: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<Instance Name>\Setup For a default instance: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup If one
Will the MS JDBC driver work with MSDE 2000? LarryHi , There are no known issues of incompatibilty between jdbc and msde. So i think you can use jdbc drivers with msde. Girish Sundaram This posting is provided "AS IS" with no warranties, and confers no rights.
to be directly accessed via strong ACLs permissions but if the sysadmin wants to move the datafiles to another server, you can not prevent that SQL Server does not provide a database level protection like Access but then Access's database level "protection" isn't worth much anyway because it's a trivial matter to circumvent it (certainly upto Access 2000 and AFAIK for all versions). The point is that many Access users may not be smart enough to do it. More people who support SQL Server will be. In SQL Server 2005 you can encrypt your data in the database.hi David, :D I did not intend to identify Access protection as a good replacement for security management only to point out the difference between Access and SQL Server :D
seems to hang. Is there any flags in the installation that must be present or something similar with MSDE for this to work? Larshi Lars, please have a look at http://www.perfectxml.com/articles/xml/importxmlsql.asp for further XML related import articles..thank you, interesting links, but unfortunately i hadn't tested enough before posting here. sorry about that. my SQLXMLBULKLOADLib code did work with msde, but the performance was really bad (the xml file i tested with was something like 40 mb, so i think some "performance brake" in msde kicked in) and i didn't see it finish until i left it going over night. so to anyone using SQLXMLBULKLOADLib with really big xml files and msde: split the files into smaller pieces before doing bulk loads! lars
HI! I'd like turn off remote network access for a user group in the user manager. Are users of this group still capable of accessing the MSDE while working on the local machine? What does local access mean? Can they access the MSDE via TCP to 127.0.0.1? Or must they access the MSDE through a named pipe? Ciao, Michael.
How would I access an MSDE database on a win2k server over the internet?a) The server must have an official address for the internet, no internal IP like 192.168.x.x b) the server must be reachable from outside, not blocked by a firewall c) that's all, use the ip like you do in the internal network The only part: so you are totally unsecured, everybody can connect (or try to hack your sa password), the traffic runs unencrypted over the internet, even the login is unencrypted! Easy to find for a profi hacker. Use SSH or VPN to encrypt the traffic or configure the firewall from the server that only defined IP addresses can connect (which does not encrypt the data you are sending). Helmut
Did you read the upsizing whitepaper? It tells you why the wizard skips tables, which it does for a myriad of reasons. I'd definitely follow Greg's recommendation to purchase the Developer edition to familiarize yourself with SQL Server. You can use it to develop a solution which you then deploy using MSDE (the license agreement prohibits using the Dev edition on a production server). Access/MSDE alone do not have the capability to develop applications and neither are much use in learning SQL Server.Hi William, I'd strongly suggest you get a copy of the developer edition of sql server. It's about $49 USD and provides a whole raft of tools that will be useful to you. You might have more luck using SQL Enterprise Manager to import your tables, etc. from your
by the OS claiming for additional memory, if it's the case, else it will maintain that memory in order to cache pages and execution plans under OS pressure, SQL Server will try having the Lazy Writer releasing resources, but you are not granted that this will occur, even if SQL Server will always try to leave some memory for other OS needs, usually between 4 and 10mb of RAM so, on SQL Server dedicated servers, you usually see memory usage climbing to the top and staying there for long time, becouse of SQL Server tends to keep pages read from disk in memory to increase further and successive access to those pages, as long as query plans and so on on a heavy loaded server, if you add web server duty, you will have resources contentions for sure I strongly advice you for
the above two sites, please try to answer the following questions: 1. What's the difference between these two MSDE 2000? 2. Which one to use for development? (VB.NET) 3. Which one to re-distribute with my custom application? I was thinking that I have to use the 70MB MSDE file. BUT after comparing the dates, I'm a bit confused. The 70MB file is older &displaylang=en the final result, after installation, is actually the same both install MSDE at the 3a service pack level.. but there's both a technical and an EULA difference.. MSDE Web Release A can only install fresh instances of MSDE 2000, while the other package can both install new fresh instances and upgrad existing instance at the service pack 3a level as regard the EULA, the second package must
can someone please help me find any documents on this question or answer the question please. Rayhi Ray, you can install SQL Server 7.0 and MSDE 2000 on the same pc the SQL Server 7.0 server will be the default instance as the 7.0 version had no concept of named instances, where the MSDE 2000 instance will be a named instance.. just a caveat MSDE 2000 will install MDAC 2.6 at least (sp4 installs 2.8 sp1) and all COM objects like SQL-DMO, SQL-NS ant the like will be upgraded at 2000 version, where the client tools like Enterprise Manager, Query Analyzer, Profiler and so on will remain at 7.0 level as MSDE does not provide them hope EM will still work
will always try to leave some memory for other OS needs, usually between 4 and 10mb of RAM so, on SQL Server dedicated servers, you usually see memory usage climbing to the top and stayng there for long time, becouse of SQL Server tends to keep pages read from disk in memory to increase further and successive access to those pages, as long as query plans and so on on a heavy loaded server, if you add web server duty, you will have resource contentions for sure right? as many as you installed and started -- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface)is or place? are but workloads two 1gb
quot; (BPool) and the "memory to leave" (MemToLeave) regions. (I'm excluding use of AWE in order to provide easy understanding and because MSDE does not admit it).. so the BPool is the primary region SQL Server uses for it's internal matter, while MemToLeave consists of the virtual memory space within the 1gb user mode address space and the memory not used try to leave some memory for other OS needs, usually between 4 and 10mb of RAM so, on SQL Server dedicated servers, you usually see memory usage climbing to the top and staying there for long time, becouse of SQL Server tends to keep pages read from disk in memory to increase further and successive access to those pages, as long as query plans and so on but on "inactive"
how to i can connect the access database and the msde server? i try whit the "odbc databases" function of access 2000 but not work sql state 01000 errore di sqlserver 10060 impossibile effettuare la connessione sql state 08001 errore di sqlserver 17 sorry for my english ;( IgnazioChi Ignazio, 10060 is a timeout problem. Make sure that you don't have firewall issues between the client and server. Even personal firewalls on the Server will block this traffic by default.before it worked,but to the unexpected one it did not work more. I have changed the name of the pc and all now it works. why happens this? my name of the pc are "locked" on msde sever? as I can unlock it?hi Ignazio, as regard MSDE by it self, there's no problem at all this
application has a database backend in SQL2000. The clients server is likely to have between 25 and 40 users accessing the application. There will be no SQL development or amendments needed on the client server. We will however need to replicate the data back to our HQ. Will MSDE cover the Licensing requirements Many Thanks in advance of your helpHi Carl, Unless the clients are all likely to be hitting the web app constantly and you can live with the 2G database limit, I think it should be fine. HTH,Carl, Remeber that the limit for simultaneous connections is 25. The database starts to lag at 8. 's Bruno app constantly and should be fine. being shipped to a database backend in 25 and 40 users on the client HQ.Hi Bruno, There is no 25 simultaneous connection limit
Are there any known issues with installing MSDE 2000 on a computer that already has Access 2000 installed?No. Many people have been running Access and SQL Server on the same computer for years. As long as you meet the minimum hardware and memory requirements you should be fine.
number obviously depends on the application code quality, access type, data nature and design, activities on it, .The confusion comes from "concurrent queries" versus "concurrent users". The workload governor operates off the former while users are typically looking to configure based on the latter. The workload governor allows essentially 480 (sub-second) database queries or other (e.g., update) operations per minute without degradation. You can ballpark what this means in terms of transactions. Assume a simple transaction has perhaps 5 queries. A mid-level has perhaps 20, and a complex transaction has about 40. So you can support between 10 and 100 transactions per minute with MSDE with no degradation. OLTP leans towards the simple
have this problem: I've installed on my machine both SQLServer and MSDE. SQLServer has a instance (the default one (local)). MSDE has a instance with a name specified by the setup of my .net application (called 'myinstance'). My C# application uese the following connection string to access its database: --- public const string STRINGA_CONNESSIONE_DB = "packet size=4096;integrated security=no;User Id=sa;Password=pwd; data source=(local)\\myinstance;Network Library=dbmssocn; persist security info=True;initial catalog=mydb";hi Pierluigi, try specifying only 1 backslash, like ..; data source=(local)\myinstance; ..isn't the \\ 'cause it's c#?hi Tim, oooppppssss :)Hi Andrea and Tim and thanks for replying me. After a whole working day, maybe, I&
Hi, I am looking for an embeddable database and I am choosing between MS Access and MSDE. Is encryption built in MSDE? Does MSDE encrypt database files? What is the encryption algorithm and key size? How is the password secured? SoniaNo, there is no standard encryption with MSDE. However you can use 3rd part tool such as www.xpcrypt.com
on the same computer, seems like i have some trouble accessing 2005 in the right way from VS 2003, and if not - any recommandations around management software for MSDE? Arne Rasmussenhi, SQLExpress and MSDE can coexist on the same computer.. as regard VS2003, the built-in designers probably can not properly work against SQL Server 2005 metadata as it has been relased later for MSDE management tools, you can perhaps have a look at a free prj of mine, DbaMgr2k, at the link following my sign., or http://www.microsoft.com/sql/partners/msde.mspx or http://sqlserver2000.databases.aspfaq.com/how-do-i-manage-sql-server/msde.html for SQLExpress management tools, please have a look at the "official" one provided my Microsoft at http://www.microsoft.com/downloads
on either of these servers! TIAhi, no, you can just directly install MSDE Rel A (sp3a level) and upgrade to sp4 via http://www.microsoft.com/sql/downloads/2000/sp4.mspx MSDE package (or directly install MSDE at the sp4 level but currently it's not clear to me if general users not owning a "required" SQL Server license as per http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp are eligile for direct sp4 use just a note, Microsoft representatives already exposed a refresh of MSDE Rel A updated at sp4 level will be made available ) yes, you can install MSDE on both servers, and even provide a replication paht between the 2 MSDE instances, as MSDE supports merge and snapshot replication (http://msdn.microsoft.com/library/default.asp?url=/library
Hi all, I have to write a program which i compatible with both access and msde; is there a way of writing the following SQL query so that it works in both access and msde? This works in access SELECT Count(1) as TheNumber, Format([DataAndTimeOfEvent],'Short Date') AS OnThisDay but not in msde, whereas various cast, floor and dateadd functions from msde don't work in access. Is there a way to write a query compatible with both systems? Thanks in advance, Jameshi James, AFAIK, not.. JET engine supports VBA functions, where SQL Server only (:D fortunately) supports Transact-SQL syntax..
from the external network) there's a snapgear that redirects traffic between 10.x.x.x network (internal) and 172.16.x.x (external) network the snapgear has 10.100.214.250 and 172.16.2.250 ip so i need to access my msde as 172.16.2.250\sqlinstance, so i need to forward the ports used i can't figure out which more ports i need to open. My msde listens on 1433, and i can telnet 172.16.2.250 on 1433 from the external net and i get the usual connect to msde screen (all blank with the cursor blining) so a part of the connection works but if i try to access with enterprise manager or sqlqueryanalyzer it says the sqlserver doesn't exist or access denied. I use windows and sql security, and i use the correct accounts, because rom the 10.x.x.x net i can connect just fine
Hello, We will soon be moving some distributed apps written in VB 6 from MS Access to MSDE. I was wondering if someone could point me to sources of information that would give us some guidelines, helpful hints, things to consider, etc. Any help you could provide would be greatly appreciated. Thanks! GeneI discuss the issues in my Hitchhiker's Guide (6th Edition). You can also consult "From Access to SQL Server" (Apress).
I can no longer access my MSDE database for maintenance purposes. It will not allow a login: [Shared Memory]SQL Server does not exist or access denied. [Shared Memory]ConnectionOpen (Connect()). and I cannot run any maintenance to shrink the Db. Steve Zatkoff [email protected]
Steve, even if a particular database has exceeded the file size limitation, you should be able to connect to that instance.. the "typical" causes of such an exception are listed in http://support.microsoft.com/default.aspx?scid=kb;en-us;328306&Product=sql if you succesfully connected to the instance, you should be able to "delete" from the database what exception are you reported with, accessing the db?
Manager connects just fine. Does XP Home and MSDE combo have some reason for failing to publish port 1443? What do I need to do to get 1443 up and running else I have wasted 20 days of an overseas consulting trip. I did a default install. Any help is greatly appreciated. Mica PS. I also posted to sqlserver.setup the same question as I didn't know which group to post to.Hi Check the MSDE is running. If XP SP2 is installed, open the port. http://www.microsoft.com/sql/techinfo/administration/2000/security/winxpsp2faq.asp MikeMike, Thanks..Found info about resolving the problem but not how "In cases where your application needs to use TCP/IP or named pipes to access the network, we recommend that you set up access on an as needed basis. We also recommend
think my book might help -- ____________________________________ William (Bill) Vaughn Author, Mentor, Consultant Microsoft MVP INETA Speaker www.betav.com/blog/billva www.betav.com Please reply only to the newsgroup so that others can benefit. This posting is provided "AS IS" with no warranties, and confers no rights. __________________________________ Visit www.hitchhikerguides.net to get more information on my latest book: Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) Between now and Nov. 6th 2006 you can sign up for a substantial discount. Look for the "Early Bird" discount checkbox on the registration form Thank both of you for the help. I believe you helped me find the information I need. By the way, I started to
as long as you have a sensible database schema designed to eliminate concurrency conflicts. Remember to code your FE to fetch only needed data.Thanks a lot Mary for your detailed explanation. It was very helpful. I still wonder whether there is "ANY" method to secure the transfered data between MS Access and MSDE against snooping? Sam the back end, the Access Server back store static should be OK with sensible database Remember to codeYou'd probably have to write it yourself, and it wouldn't be worth the effort. Bear in mind that Access is a desktop database, which means that it's local on everyone's machine (or accessible on a network share). So you'd need to also have the key to decrypt the data stored locally as well so that
will handle images just fine. Of course, images tend to be quite large, so naturally your database will swell proportionately. FWIW, SQL Server 7.0 & 2000 are more efficient with images than 6.5 and earlier. Russell FieldsThere is a well-known problem with Access 2002 and previous that if you add, say, a 500KB jpeg image it will increase the size of your Access file by 20 MB. That is what I mean by out-of-control. I'm wondering if MSDE suffers from the same problem or if a 500K jpeg will take up 500K of space in the DB. Where can you determine the size of your MSDE database? Is it stored in a file somewhere or can I query it in an ADP or command line statement for it? embed wonderingI, for one, do not recommend storing BLOBs (IMAGE/TEXT) data in a SQL Server (or
Hello. I have a SQL Server 2000 Database set up on our network. We want to run a process on another machine. This machine has MSDE Installed on it. I have created a new entry in the Linked Server options of the MSDE Machine to our SQL Server. However, on trying to query the SQL Server 2000 tables from the MSDE Database, I get this error: Error 7302: Could not create an instance of OLE DB Provider 'SQLOLEDB' I have checked the MDAC_TYP using the MDAC_TYP Checker, and both the SQL Server and MSDE Machines have the same version running. I have pinged the SQL Server from the MSDE Server and they can both see each other. Any suggestions you might have would be greatly appreciated!! Thanking you in advance, m00nm0nkey!!Pinging the servers does not prove anything other than
Hi All I am using VB6 and MSDE 2000 I previously used Access 2000 and used the following ado sql to create a temp table in access (Invoice table contains Invoice data such as Invoice number, date etc. Idetail table contains details of the invoice individual items e.g product code, Invoice Number etc) The link is the Invoice Number field in each table (Master/Detail) sql = "SELECT idetail.qty, idetail.prod_code, invoice.inv_date, idetail.price INTO idetailtemp IN '" & App.path & "\data\tramcarstemp.mdb' FROM idetail inner join [invoice] on idetail.inv_num = invoice.inv_num where invoice.inv_date between #" & Format(DT1.Value, "m-d-yyyy") & "# and #" & Format(DT2.Value, "m-d-yyyy") & "#" cn.execute
with other users. I have given all users db_owner role. My server is MSDE 2000. I use the following code to import a spreadsheet. docmd.transferspreadsheet acImport, acSpreadsheetTypeExcel97, "dbo.DL_Funding_Data", "theFilename.xls", True When I use an adp from Access 2000, this code executes successfully for all users. When I use an adp from access 2003, this code gets error 3078 and will only work if I remove the "dbo." from the name of the table. thanks for any help, JerryAs I recall (and it's been a few years) the syntax required for specifying SQL Server objects changed between A2000 and 2003. In 2000 you had to use the full syntax, ownername.objectname and 2003 is more lenient. Since many people didn't bother implementing
have bad surprise to find they was retired on 23 December. Because I have no backup of the SQL Server and MSDE Deployment Toolkit version 1.1 and I need it, please everyone that has of copy of it to help me. I have MSDN Membership, so I am legally entitled to use these tools. Please, respond at private address [email protected]
Please, don't send directly message with attachment, it's possible to solve meanwhile. Thank you, Renato Aranghelovici1) if you have a membership, don't you have them on CD somewhere? Or a product that happens to include them? 2) is
, but am not exactly sure how that will work. When the main database is updated from the satellite laptops, new records are identified by a field having been set in this table and modified records are identified in the same fashion. VB code does all of the updating. So, in MSDE, what sort of field do I use to generate this unique key, like Access does the auto number field. I've heard that IDENTITY fields aren't that great to use in SQL Server. I'm assuming, if I use replication, that it will be merge replication. And, having that in mind, how do I handle this Report ID field on the laptops and then with the main database too. Because, while out in the field, the laptops will likely be generating their own Report ID but there has to be concurrancy. How do I make
cope with 20, 50 or even more users. All depends on how the data is accessed. I have being using MSDE in a 25-use office with quite heavy data access since MSDE1.0 (SQL Server 7) and never hit the MSDE "Slow down" point. 3. Almost everything in database you designed on SQL Server can be used directly on MSDE, except something that does not come with MSDE, like English Query, Reporting Services. You can design a database in either SQL Server, or MSDE, including tables, Views, Stored Procedures and detach the database from one and attched to the other wothout any change. WinForm inthere A couple of things. (a) there is no limit on concurrent access. The limit is on concurrent WORKLOAD. A connection does not automatically mean work, so you can definitely have a lot
profit reports for 3 different sales divisions. We have a "SQL server group" in our division but internally we can not rapidly develop applications due to inexperience and overworked resources. For example, if a SQL server application is proposed it rarely gets beyond the discussion phase with finger pointing on requirements and debates about not duplication data between the AS400's and SQL. I need to get away from DB2 and Access and I think we will eventually figure out what we are doing. I want to create a front end using .net connected to MSDE where I develop the schema that would make sense when it is moved to SQL server. I am not a dba so I really just want to create the basic design. Question : Does this approach make sense? What is the best way to prototype
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 Step by Step book and I have my first problem because it needs MSDE for handling SQL DBs, but after downloading it and several hours installing, configuring and testing it, finally I could access the sample databases. My questions now are: 1) How can I create a SQL DB that I can use in my development environment while I build an application? 2) After finishing my application what are the steps to generate a CD that includes my application with the DB. I already know how to generate a Deployment project, but not with the DB. Is it possible only to copy the DB files to