I am brand new to .NET. For that matter, so is my whole corporation, hence this dumb question. How can I set-up MSDE or SQL Server Desktop to work with VS.NET and the various development languages. Only one person here has any access to the MS SQL packages and getting him to due anything is like trying to give a wolverine a root canal! They have made me the project lead for all future development in .NET (the guy they had on it quit last week and I was chosen because I can read C++ and VB code).
Specifically, I followed the installation procedures that came with .NET Architect; however, there appears to be no active server (desktop version) running when MSDE loads up. I probably screwed it up during installation; however, I can't find any of the sample database or any tools to create my own. Any ideas?
Please give a newbie a hand!
Thanks
--
Kenneth A. Jinks, Jr.
Lead Project Software Engineer
LabCorp CPG - LCM Development
Huntsville, AL
2  1510 
In news: 10************* *************** **...icrosof t.com,
jinksk <ji****@discuss ions.microsoft. com> wrote: ....How can I set-up MSDE or SQL
Server Desktop to work with VS.NET .....
Specifically, I followed the installation procedures that came
with .NET Architect; however, there appears to be no active server
(desktop version) running when MSDE loads up. I probably screwed it
up during installation; however, I can't find any of the sample
database or any tools to create my own. Any ideas?
Please give a newbie a hand!
Hi Jinksk,
Others will have more details but MSDE does not come with a "front end" GUI
tool to administer it. There are third-party tools or you can use the
command line interface. If you get the Developer edition of SQL Server
(About $50, see http://www.microsoft.com/sql/howtobuy/development.asp) you
can get an idea of how useful the Enterprise Manager and Query Analyzer are.
As far as I know for a production environment you would need a full version
of SQL Server in order to use the GUI tools, but I'm not a licensing expert.
You can post questions to any of the SQL Server newsgroups, especially
microsoft.publi c.sqlserver.msd e, when you have questions like this. MSDE is
all the same no matter whether you installed it with VS.NET or Visual FoxPro
or Office or whatever.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP ci************* *@mvps.org www.cindywinegarden.com
I haven't installed MSDE by itself for quite a while and I'm not sure
whether the sample DBs come with it. In any case, the sample DBs are just
SQL script text files and if you email me offline I can send them to you.
I don't work with MSDE all that much so you will probably get better help in
the MSDE newsgroup, but I went to http://groups.google.com and put in the
exact text of the error message in quotes (SQL Server does not exist or
access denied") and came up with quite a few leads, including the following
KB article, "Potential causes of the "SQL Server Does Not Exist or Access
Denied" error message" (support.micros oft.com/default.aspx?kb id=328306)
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP ci************* *@mvps.org www.cindywinegarden.com
"jinksk" <ji****@discuss ions.microsoft. com> wrote in message
news:46******** *************** ***********@mic rosoft.com... Cindy;
The "front-ends" I can live without. It's when I try to load the
Sample Database apps (like Dunwamish). I get a "Microsoft SQL Server Login"
dialog with the error message: "[DBNETLIB][ConnectionOpen (Connect()).] SQL
Server does not exist or access denied."
Also, where can I find the other sample databases (PUBS in particular)
since all of the examples and tutorials are based on them? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Niyazi |
last post by:
Hi,
We have and IBM AS400 and I belive the reional setting is Turkish. The IBM
Client-Access for Windows that install in our PC (WIN XP SP2) set to Turkish
characters.
Now my PC has English (US) regional setting and I am not having any problem
to connect.
But If I change my PC Regional setting to Turkish all of my VB.NET code is
|
by: fleemo17 |
last post by:
My organization is developing a set of "standards" for websites built
inhouse. The first question that comes to mind is what would be a good
standard default size for <p> text? 12 point? Which begs the
question, what unit of measurement should we use for specifying font
sizes, points or ems?
Thanks.
-Fleemo
|
by: Erik Hendrix |
last post by:
Hi,
I have a question here regarding setting the prefetch size. So far we took
the rule that for OLTP, prefetchsize = extent size and for DSS prefetchsize
= extent size * number.
However, especially due to the "Skip Scans" for indexes I started to
question this. It looks to me that for reading a index DB2 will or do a
synchronous read or he will have to scan the whole index and thus prefetch
the data correct? If this is so, then it...
|
by: Shravan |
last post by:
Hi,
I have a Windows Forms Custom DataGrid, which is put in a
usercontrol, which on setting DataSource is setting focus
to grid. The call stack for setting the focus is as
follows. This is not happened always whenever DataSource
is set, only called sometimes, in a series of setting
DataSource, I could get this setting focus only one time .
Can anybody help me how to stop this one.
system.windows.forms.dll!
|
by: junlia |
last post by:
Hi All,
I am working on a project that acts as a bridge. It does some checking with
post xml data, and then redirects the request to an appropriate page.
However, we find that depends on the browser cache setting (and OS), the
program behaves differently.
This is how it should work:
1. The client program opens a webbrowser control, using navigate2 method to
post xml data to my aspx pages, eg abc.aspx
| | |
by: Dachshund Digital |
last post by:
I know there must be a way to do this... in .NET 2.0?
I have a situation where I know the name of the setting, and want to
pass it into a function, and set or get the corresponding setting.
The following is find, but a pain if you have lots of settings to do in
one go...
My.Setting.Dachshund=1000
Dim theSetting As Integer=My.Setting.Dachshund
|
by: Ronald S. Cook |
last post by:
In a .NET Windows app, if I set somehting like the title of the form to
"MyApp" at run-time, will that make the app run slightly slower than if I
had set the title at design-time?
Thanks,
Ron
|
by: Academic |
last post by:
What are the different effects of the following two statements:
C1.Cursor = Cursors.WaitCursor
C1.Cursor.Current = Cursors.WaitCursor
I believe the first replaces the entire C1.Cursor object with a new one
while the second only replaces the Current object of C1.Cursor, but I can't
|
by: metaperl |
last post by:
I would like to check the setting of this variable in our MS-SQL 2000
database. Also, is there info on what the default value of this
variable is?
|
by: Andrus |
last post by:
..NET 2 Winforms application.
How to create new setting and set it default value in userSettings section
of app.config file or overwrite existing setting value ?
I found code below in this list which modifies Application setting section
but how to add new item to userSettings ?
Andrus.
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
