MSDE And Windows 98.
Jul 20, 2005
Hi,
I try to connect to MSDE using software writing in C#. When I test this
software in Win XP it works properly but when I try on Win 98 it crash.
Situation:
1. Win XP, MSDE, connecting to local server and to server on Win 98
machine (works), this server hasn't instance name set (default),
2. Win 98, MSDE, connecting local show me error with connection
parameter (I got message "Invalid connection" when I use SqlConnection
component from C# or "..Instance name.." when I use OleDbConnection
component), this server has instance name e.g. MyName, when I connect to
this server from machine with win XP it works properly.
--
*Best regards,*
Klaudiusz Bryja
View 3 Replies
ADVERTISEMENT
Mar 11, 2004
Hello to everyone.
I'm looking for an help :(
I'ved installed MSDE on a Windows 2000 Pro with this option in Setup.ini :
INSTANCENAME=msde
SECURITYMODE=SQL
SAPWD=<mypassword>
All goes good, and at the end of install process, i restart pc.
When restarting, i logged in , and the icon of MSDE was in the System Tray.
Strange thing, is that the circle in the icon have no red square or green arrow inside, but is empty.
I open the window of MSDE and at Server and Service, was 2 empty fields.
I filled on SERVER with the IP address of my pc
Service Field, continue to be blank :(
When i try to start the MSDE, it tells to me that there's no selected service, so the MSDE can't start.
Have someone some ideas on how to solve this?
Thanks to everyone for help!
View 1 Replies
View Related
Jun 28, 2004
I am developing a windows application that will run on every client station. This application will refer to a database located on a server station. Can I use MSDE for such application and if so how many remote concurrent connection can be open simultaneously?
Eric
View 1 Replies
View Related
Oct 3, 2005
Hi,
Got a problem with network access for MSDE on Win2003 SBS. I have tried all the usual stuff (SVRNETCN, firewall check) to get windows to open the port for network access, but I am having no luck.
Thought it maybe something to do with win2003 "increased" security.. so check the IPSec policy but nothing looks like it is assigned, plus I could also be checking the wrong policy.
As you can probably tell I know only little bits about server, policies and everything that goes with it (I normally work with the lovely pre setup database) but guess its time I should learn.
So with my small and probably dangerous knowledge can someone please let me know if I am looking in the right area for allowing port 1433 to open for MSDE? If I am how to I edit the policy to allow something to run accross the network?
Basic Server Stats
O/S: Windows 2003 Small Business Server Standard (all updates +sp)
NIC: One gigabit (know win2003 recommends 2)
Hardware: Hugly over the minimum spec!!
MSDE: 3* instances (2 pre installed - SBSMonitoring, SharePoint and 1 user defined that needs sharing)
Thanks so much for any help, background information on group policies and alike would be nice to know as well, but don't worry too much about that!
View 1 Replies
View Related
Nov 29, 2002
I try to install MSDE as a new instance (SQL2) on my computer with Windows 2000 Professional, but a problem occurs and instalaltion does not complete successfully. I am an administrator of the computer. The application log contains the following errors descriptions:
"The SYSTEMCurrentControlSetServicesMSSQL$SQL2Perfo rmance key could not be opened or accessed in order to install counter strings.The Win32 status returned by the call is in the Record Data as DWORD 0. " and
"Installing the performance counter strings for MSSQL$SQL2 failed. The Error code is DWORD 0 of the Record Data. "
Have someone experienced a similar problem?
View 1 Replies
View Related
May 30, 2006
Installation of MSDE 2000 fails on 64-bit Windows Vista (Build 5308).
The error message is "Setup failed to configure the server.Please refer the error logs for more information". No error log can be found on the machine at the time of installation. Please let me know if anyone else has encountered this problem?
Is it possible to install MSDE 2000 on 64-bit Windows Vista(Build 5308)?
Thanks in advance.
View 4 Replies
View Related
May 23, 2006
I am trying to install MSDE 2.8 on this OS. When I try to install, I receive the following error: Fatal error setup This setup does not support installing on this operating system
Any ideas?
View 4 Replies
View Related
Nov 27, 2006
Hi,
I would like to know is it possible to installing sql 2005 express edition on windows xp with limited account. I tried to install it. After installing, the service can not start. Is there any thing that I misconfigured?
Thanks for reading and answering my post.
View 3 Replies
View Related
Jan 25, 2007
Currently a server running 2003 small business operating system has MSDE 2000 and Microsoft##SSEE.
A memory problem exists with SQL consuming over 50% of RAM. Total RAM is 4GB.
There is a SQL 2000 patch for this type of problem. However, it calls for SQL to be upgraded to SP4.
Problem:
Can this MSDE 2000 be upgraded with SP4 and have memory patch applied with Microsoft##SSEE also on this box?
Please let me know. Thank you.
View 3 Replies
View Related
Jun 6, 2005
Hello,
I'm not sure if it's the setup I did wrong, but I can't seem to get my
text datatype in my database to store more than 900 characters.
I'm trying to setup a news database for my website, which will populate
the information into a datagrid. To test, I manually added a news
item in the database through the visual studio 2003 gui. I
immediately noticed a problem as the I was getting an error after a
long news item saying:
"The value you entered is not consistent with the data type or length of the column, or over grid buffer limit."
I couldn't find anthing to set the buffer limit and the datatype is
"text" filled with simple text in the column. As a further test,
I
simply entered 12334567890123... up to 900 characters and still
recevied the error.
I would appreciate someone leading me in the right direction on this one.
Thanks a lot.
View 1 Replies
View Related
May 27, 2000
I am trying to change the computer name of a machine running MSDE but I get an error when SQL Server starts. With regular SQL when I change the name of a computer I re-run setup and setup fixes this problem. MSDE can only be installed from unattended mode so I can’t rerun setup and fix the problem.
My question is "How do I change the name of a computer running MSDE with out reinstalling MSDE"
View 1 Replies
View Related
Mar 27, 2001
We currently have the problem, that all our machines are produced with the
same name and afterwards the name is changed. So we have the problem that
the checksum key for the MSDE isn't valid anymore. As MSDE can only be installed
from unattended mode so I can’t rerun setup and fix the problem. Does anyone
know a solution for this problem ?? A program recalculating the cheksum ??
regards,
Manfred
View 3 Replies
View Related
Mar 9, 2005
I'm not sure if this is the correct forum for this this question but I'll give it a shot.
The only db development that I have ever done is in MS Access. I have a project at work that is being accomplished in VB and I need a db engine to use as the back end. Visual studio came with a copy of MSDE. Is this tool worth using or should I invest in mySQL? Are there any advantages to using MSDE over mySQL?
View 4 Replies
View Related
Dec 12, 2007
Is it Possible adding Windows (activi directry users) from SQL Server which is running Windows authotication.?
View 4 Replies
View Related
Jun 23, 2006
I am attempting to write a Windows service that watches a database for uploaded files to import. When a new file is found, the corresponding SSIS package is run from the file system with variables passed through. I started development as a Windows app and copied the functionality to a service.
The app runs fine. The service does not. I get a "Failure" each time a package is executed. Everything is identical behind the scenes with the obvious exceptions that OnStart and OnStop handlers are buttons in the app. I added a script task at the beginning of one of the SSIS packages to notify me that it is even running at all. It doesn't even hit that initial task.
Again, the app will run all packages just fine. The data is imported and the results return as "Success."
The following is the code executing the package. Any help is appreciated. I've been banging my head on this one for a few days now. (Is there a tag to format a code sample?)
Dim pkgLocation As String
Dim pkg As New Package
Dim app As New Application
Dim pkgResults As DTSExecResult
pkgLocation = sPackageFolder & PackageName & ".dtsx"
pkg = app.LoadPackage(pkgLocation, Nothing)
Dim vars As Variables = pkg.Variables
vars("ImportId").Value = ImportId
vars("ProductionServer").Value = ProductionServer
vars("ProductionDatabase").Value = ProductionDatabase
vars("SourceFileName").Value = FileName
vars("SourceFilePath").Value = FilePath
pkgResults = pkg.Execute()
View 3 Replies
View Related
Apr 14, 2008
Long story short -
Have two C# applications - one WinForms desktop app, the other a WinForms smart device app. Both use SQL Server Compact CE 3.5 to store data locally. Both work just fine.
Now the desktop app needs to open and update the .SDF file that is stored on the Windows Mobile device. (Device will be docked via USB.)
What format would the path to the .SDF look like that the WinForms application would need to specify in order to open it?
Thanks for reading.
View 3 Replies
View Related
Mar 26, 2008
Hallo there,
I just upgraded from Windows XP Pro to Windows Vista Bussiness and tried to reinstall SQL Server 2005 Developers Edition. After the installation i downloaded (using microsoft windows update) and installed all the service packs for sql and vista available.
My problem is when i open sql server management studio and try to connect to my default instance using windows authentication and database engine, an 18456 error occurs.
I enabled all the protocols and all the ports
I disabled windows firewall and antivirus (eset nod32)
I installed all service packs available
I have also installed Visual Studio 2005 without installing sqlexpress
But nothing happens!
Please i am very desperate, any information will be gratefully accepted.
This is my installation Information
Code Snippet
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840)
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 7.0.6001.18000
Microsoft .NET Framework 2.0.50727.1434
Operating System 6.0.6001
Thank you in advance,
Patonios
View 3 Replies
View Related
Jul 20, 2005
Hi all,I have a Windows 2003 server, which is also a terminal server forapplication, with sql 2000 installed. My company has developed anapplication that uses SQL 2000 as its database. The application is aclient/server one. In each client computer there's a link to theapplication on the server. There is no problem with Windows 98,Windows 2000 pro, Windows xp pro clients, but the windows 95 onescannot log in to the database. The log of the application shows thefollowing error:connection error -2147467259. Cannot open database requested in login'database name'. Login fails.Till a week ago the application was running on a Windows 2000 serverwith SQL 2000 install and the W95 clients had no problem connecting tothe database, so my guess is the error has something to do withWindows 2003 server, but what'causing the error?I tried to install a newer version of MDAC (MDAC 2.5, the last versionof MDAC you can install on W95)but with no success. By the way W95clients have no problem accessing shared folder on the Windows 2003server.Any idea?ThanksMarino
View 1 Replies
View Related
Apr 17, 2008
Does any one come across any difficulty in the following migration?
OS: Wondows Server 2K
DB: SQL Server 2K Standard Edition
Migrating to
OS: Wondows Server 2K3
DB: SQL Server 2K Standard Edition
Thank you,
Gish
View 4 Replies
View Related
Jul 12, 2006
How can I Port Driver and OAL code of Windows CE 5.0 to Windows CE 4.2?
If anybody have idea about this, kindly give me suggestions.
View 1 Replies
View Related
May 25, 2001
We just moved the back end of an Access db to an SQL server and upgraded to Access 2000. A strange problem has arisen. The execution of a query in a certain function seems to be causing the function to prematurely terminate (that is, the query does not complete, and the function does not execute beyond the execution of the query). This error occurs only on workstations loaded with Windows 98. Windows 2000 users are unaffected, and the function runs uninterrupted. The query in question contains date parameters. On the SQL server, dates are enclosed in single quotes (')'s, whereas in Access they are enclosed in pound signs (#)'s. When a query is sent by Access to the SQL server, it is filtered through a program that converts the Access format to SQL-friendly code. Our theory is that this process fails to occur on the machines running Windows 98. Does anyone know why this is occuring?
View 2 Replies
View Related
Oct 12, 2004
We have an installation of MS SQL Server (MSDE actually) runnning on a group of Windows 2k machines. Due to IT constraints at the customer site, we are using Windows authentication, but it is all done with local user accounts, not domain accounts.
We have the same user account witht he same password locally created on each machine. This works fine with all the Win2K machines (not the best solution, but under the client's insane IT department, it's all we were allowed to do).
The problem is that we tried to add an XP machine. While we can connect to a DB running on a 2K machine from the XP workstation, the XP system will not accept connections from the 2K systems. We have done a little research and think we have found out why- the 2K systems are sending usernames for authentication, but the XP is looking for the UID- which is different on every system.
We cannot go to SQL authentication, and we cannot use Domain authentication. Is there a way to change XP to authenticate from username instead of UID?
Thanks!
Jed
View 1 Replies
View Related
Nov 15, 2003
I looking for some guidance here. I have database which has exceeded the 2 gig limit. I deleted some old tables in an attempt to acquire some space. This worked out. However when I look at the size of my *.mdf it still appears in excess of the 2 gigs . I know this isn't true since I deleted 500 megs of stuff. How do i reclaim the space (get the file size to report correctly) or do I need to even worry about it.
Andy
View 2 Replies
View Related
Nov 18, 2003
Hi
I have visual studio .net and i recently installed MSDE specific for visual studio.
The name of my server is FRANKNETSDK.
String strConnection ="server=FRANK\NETSDK;database=Northwind;integrated security=true";
SqlConnection objConnection = new SqlConnection(strConnection);
objConnection.Open();
objConnection.Close();
I created an instance which is NETSDK
I created a password
I don't know why my server choose the name FRANK i was expecting local.
I have to use FRANKNETSDK or else i can't get my server to Start.
This is the error: Login failed for user 'FRANKASPNET'.
[SqlException: Login failed for user 'FRANKASPNET'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
sqlconnect.WebForm1.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootsqlconnectwebform1.aspx.cs:27
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
Any help would greatly be appreciated.
View 1 Replies
View Related
Nov 22, 2003
Hi
For quite some time nowI have been trying to give user rights to my MSDE , needless to say the fruits of my labor have turned up very little success.
So far i have tried using the osql commands to grant user access to my database. I have run the stored procedures(sp_grantlogin ,sp_grantdbaccess ) but to little avail!
So now i have taken a new approach i installed the Enterprise Manager. I have just a minor problem with this new strategy , i don't know how to use it!!
This is what i have prensently installed on my system: Visual studio.Net ,Microsoft SQL(MSDE)
and finally the Enterprise Manager.
My Servername is FRANK.
I have created an instance which is NetSDK (FRANKNETSDK)
My SAPWD is Kildare
I have Mixed Mode
Can anyone please tell me how i can use the Enterprise Manager to grant access to MSDE.
I am sure you have all realized from all these insipid post that i have no experience.
So please be explicit in all your details.
My email roti@videotron.ca
Thank you
Frank
View 3 Replies
View Related
Jan 17, 2004
Having Problem connecting to Database with WebMatrix
When I try to ADD Database in WebMatrix through Sql Connection & enter USERNAME & PASSWORD it fails. Is there a way to create New USERNAME & PASSWORD? Perhaps through
the Command Line Prompt?
Any Help/Advice TIA
Tristen
View 1 Replies
View Related
Jan 31, 2004
I have never done anything with databases, so I am a newbie. My goal is to install an ASP.NET forum, but I need MSDE installed. I downloaded MSDE from the Microsoft website. When I run the setup.exe file, I get an error. It says:
A strong SA password is required for security reasons. Please use SAPWD switch to supply
same. Refer to readme for more details. Setup will now exit.
I looked at the documentation but could not find anything usefull, what do I have to do to install it. Thanks in advance for responses.
View 2 Replies
View Related
Mar 19, 2004
How does MSDE handle data mangement? Does it come with sql analyser or some sort of database manager?
Thanks.
View 5 Replies
View Related
Aug 25, 2004
Hi,
I am newbie in ASP.NET and MSDE arena. I understand that MSDE has no GUI and I need to have MSDE tools to work with it. I have already installed ASP.NET 1.1 and Microsoft.NET SDK 1.1 and MSDE in my Windown Professional 2000 PC and I have run and tested for .aspx and its working perfectly. But I want to use MSDE to create some database driven web applications.
Could you please help me how I can do that? BTW, I installed Microsoft SQL Web Data Administrator and its giving me SQLWebAdminStart.exe Application error and asking for debugging while opening the program. I am stranded what to do now?
I really appreciate your help.
regards,
Peter-Toronto
(Linux, PHP, MySQL)
View 1 Replies
View Related
Sep 6, 2004
I just installed MSDE off of disk that came with teach yourself asp.net in 24 hours. To get the program started you must go to run and type cmd and wait for the C prompt. I get this far, but I can't get a C prompt. It always comes up C:sql2ksp3> How do I get a C prompt from here. I know it must be something easy that I am just overlooking or forgot.
Thanks
Del Dobbs
View 1 Replies
View Related
Feb 27, 2005
Hi ,
I m trying to install MSDE database at my machine to Test my queries and page so i can upload them. I did changed the Path and added osql. and all that things. Its still giving me an error. Which is
" Server Error in '/QuickStart/aspplus/samples/grocertogo/VB' Application.
SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. "
not sure what exactly to do. Also if have SQL server runing on remote machine is there any other way i can check my pages. Any help wikk be greatfull. Many thanx in advance
KHan
View 4 Replies
View Related
Mar 4, 2005
Hi all,
I have a web application that uses SQL Server. I have 6 clients that all use the same SQL Server database structure.
I know have a new client who is using MSDE as there Database. The Database should have the same table structures as the SQL ones.
So my questions are this:
1. I have a backup of the new clients data. How do I attach it to SQL Server?
2. Does MSDE have stored procedures?
3. Can I write stored procedures in a SQL Database, that reference tables in an MSDE database.
4. Can someone point me in a direction, that can walk me through this?
Thanks
Scott
View 5 Replies
View Related
Apr 2, 2005
Hi,
Well i want to ask, Is this true that
We can use the MSDE on commercial basis for a limited usagage with out paying.
The limited usage means that may be upto 20 - 25 concurent users can be use the Engine at a time.
thx for the comments
View 1 Replies
View Related
