difference between table relations and foreign keys?

I've bought a book about ASP.NET with SQL Server 2000.
In one chapter, they talk about setting relations between tables, and in
another, about setting foreign keys.
But I can't understand the difference, as the purpose seems to be the same:
navigating from a parent table to a child one, and vice-versa.
Am I missing something?
Thanks!
HenriUnless you can show more detailed context, I think they are talking about
the exact same thing. A relationship is a bit more abstract; a foreign key
represents the implementation-specific way that a child row is connected to
a parent row.
http://www.aspfaq.com/
(Reverse address to reply.)
"Henri" <hmfireball@.hotmail.com> wrote in message
news:%23nSPik0TEHA.3828@.TK2MSFTNGP09.phx.gbl...
> I've bought a book about ASP.NET with SQL Server 2000.
> In one chapter, they talk about setting relations between tables, and in
> another, about setting foreign keys.
> But I can't understand the difference, as the purpose seems to be the
> same:
> navigating from a parent table to a child one, and vice-versa.
> Am I missing something?
> Thanks!
> Henri
>
>|||Actually, the first chapter is about the DataRelation class, and
DataTable.ChildRelations(String) and DataRow.GetChildRows(DataRelation).
The second chapter is about ForeignKeyConstraint Class
The only difference I see is that a foreign key allows to define cascade
update and delete rules.
Actually, ASP.NET permits to define many things like indexes, primary keys,
relations, etc. but I thought that this had to be done on SQL Server, not
from ASP.NET.
That's why I'm a bit lost :-)
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> a crit dans le messag
e de
news:ORWb%23o0TEHA.2416@.TK2MSFTNGP12.phx.gbl...
> Unless you can show more detailed context, I think they are talking about
> the exact same thing. A relationship is a bit more abstract; a foreign
key
> represents the implementation-specific way that a child row is connected
to
> a parent row.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Henri" <hmfireball@.hotmail.com> wrote in message
> news:%23nSPik0TEHA.3828@.TK2MSFTNGP09.phx.gbl...
>
>|||What you are reading about is Data Sets in ADO.Net. The
relations and constraints you define in a data set are
different and separate from relations and constraints in the
database. In ADO.Net, you can create something similar to a
database - tables (data tables), relationships (using the
DataRelation class), constraints (such as with the
ForeignKeyConstraint class). It's not the same thing as the
database you may be accessing for the data in the data sets.
For ADO.Net, you can find more information on how relations
and constraints work together, differently in .Net Framework
documentation. Check the remarks section of the definition
of the DataRelation class.
-Sue
On Fri, 11 Jun 2004 03:40:00 +0200, "Henri"
<hmfireball@.hotmail.com> wrote:

>Actually, the first chapter is about the DataRelation class, and
>DataTable.ChildRelations(String) and DataRow.GetChildRows(DataRelation).
>The second chapter is about ForeignKeyConstraint Class
>The only difference I see is that a foreign key allows to define cascade
>update and delete rules.
>Actually, ASP.NET permits to define many things like indexes, primary keys,
>relations, etc. but I thought that this had to be done on SQL Server, not
>from ASP.NET.
>That's why I'm a bit lost :-)
>
>"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> a crit dans le messa
ge de
>news:ORWb%23o0TEHA.2416@.TK2MSFTNGP12.phx.gbl...
>key
>to
>|||Hi,
Within ADO.Net, a Foreign Key Constaint is a subtype of the Data Relation. T
he FKC in ADO.Net behaves in a similar manner to a FKC within SQL Server, bu
t it is a constraint on the Data Set, not the database, which can be an impo
rtant consideration.
A Data Relation has additonal functionality that is not provided by the FKC,
( I think one is providing the Child Rows in the Data Set to a particular M
aster row.) I suggest you have a look at the class definitions and examine t
he different methods and pr
operties each suppiles

difference between table relations and foreign keys?

I've bought a book about ASP.NET with SQL Server 2000.
In one chapter, they talk about setting relations between tables, and in
another, about setting foreign keys.
But I can't understand the difference, as the purpose seems to be the same:
navigating from a parent table to a child one, and vice-versa.
Am I missing something?
Thanks!
HenriUnless you can show more detailed context, I think they are talking about
the exact same thing. A relationship is a bit more abstract; a foreign key
represents the implementation-specific way that a child row is connected to
a parent row.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Henri" <hmfireball@.hotmail.com> wrote in message
news:%23nSPik0TEHA.3828@.TK2MSFTNGP09.phx.gbl...
> I've bought a book about ASP.NET with SQL Server 2000.
> In one chapter, they talk about setting relations between tables, and in
> another, about setting foreign keys.
> But I can't understand the difference, as the purpose seems to be the
> same:
> navigating from a parent table to a child one, and vice-versa.
> Am I missing something?
> Thanks!
> Henri
>
>|||Actually, the first chapter is about the DataRelation class, and
DataTable.ChildRelations(String) and DataRow.GetChildRows(DataRelation).
The second chapter is about ForeignKeyConstraint Class
The only difference I see is that a foreign key allows to define cascade
update and delete rules.
Actually, ASP.NET permits to define many things like indexes, primary keys,
relations, etc. but I thought that this had to be done on SQL Server, not
from ASP.NET.
That's why I'm a bit lost :-)
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> a écrit dans le message de
news:ORWb%23o0TEHA.2416@.TK2MSFTNGP12.phx.gbl...
> Unless you can show more detailed context, I think they are talking about
> the exact same thing. A relationship is a bit more abstract; a foreign
key
> represents the implementation-specific way that a child row is connected
to
> a parent row.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Henri" <hmfireball@.hotmail.com> wrote in message
> news:%23nSPik0TEHA.3828@.TK2MSFTNGP09.phx.gbl...
> > I've bought a book about ASP.NET with SQL Server 2000.
> > In one chapter, they talk about setting relations between tables, and in
> > another, about setting foreign keys.
> > But I can't understand the difference, as the purpose seems to be the
> > same:
> > navigating from a parent table to a child one, and vice-versa.
> > Am I missing something?
> > Thanks!
> > Henri
> >
> >
> >
>
>|||What you are reading about is Data Sets in ADO.Net. The
relations and constraints you define in a data set are
different and separate from relations and constraints in the
database. In ADO.Net, you can create something similar to a
database - tables (data tables), relationships (using the
DataRelation class), constraints (such as with the
ForeignKeyConstraint class). It's not the same thing as the
database you may be accessing for the data in the data sets.
For ADO.Net, you can find more information on how relations
and constraints work together, differently in .Net Framework
documentation. Check the remarks section of the definition
of the DataRelation class.
-Sue
On Fri, 11 Jun 2004 03:40:00 +0200, "Henri"
<hmfireball@.hotmail.com> wrote:
>Actually, the first chapter is about the DataRelation class, and
>DataTable.ChildRelations(String) and DataRow.GetChildRows(DataRelation).
>The second chapter is about ForeignKeyConstraint Class
>The only difference I see is that a foreign key allows to define cascade
>update and delete rules.
>Actually, ASP.NET permits to define many things like indexes, primary keys,
>relations, etc. but I thought that this had to be done on SQL Server, not
>from ASP.NET.
>That's why I'm a bit lost :-)
>
>"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> a écrit dans le message de
>news:ORWb%23o0TEHA.2416@.TK2MSFTNGP12.phx.gbl...
>> Unless you can show more detailed context, I think they are talking about
>> the exact same thing. A relationship is a bit more abstract; a foreign
>key
>> represents the implementation-specific way that a child row is connected
>to
>> a parent row.
>> --
>> http://www.aspfaq.com/
>> (Reverse address to reply.)
>>
>>
>> "Henri" <hmfireball@.hotmail.com> wrote in message
>> news:%23nSPik0TEHA.3828@.TK2MSFTNGP09.phx.gbl...
>> > I've bought a book about ASP.NET with SQL Server 2000.
>> > In one chapter, they talk about setting relations between tables, and in
>> > another, about setting foreign keys.
>> > But I can't understand the difference, as the purpose seems to be the
>> > same:
>> > navigating from a parent table to a child one, and vice-versa.
>> > Am I missing something?
>> > Thanks!
>> > Henri
>> >
>> >
>> >
>>
>|||Hi
Within ADO.Net, a Foreign Key Constaint is a subtype of the Data Relation. The FKC in ADO.Net behaves in a similar manner to a FKC within SQL Server, but it is a constraint on the Data Set, not the database, which can be an important consideration
A Data Relation has additonal functionality that is not provided by the FKC, ( I think one is providing the Child Rows in the Data Set to a particular Master row.) I suggest you have a look at the class definitions and examine the different methods and properties each suppiles|||Thanks for your help to both of you :-)
Just one last question:
If I define constraints and relations(diagrams) within SQL Server, can
ADO.NET retrieve them, so that I can use them without having to redefine
them when declaring the DataSet?
I'm currently checking the.NET doc and might find the answer by myself, but
if you know it, thank you for telling me :-)
Henri
"Henri" <hmfireball@.hotmail.com> a écrit dans le message de
news:%23nSPik0TEHA.3828@.TK2MSFTNGP09.phx.gbl...
> I've bought a book about ASP.NET with SQL Server 2000.
> In one chapter, they talk about setting relations between tables, and in
> another, about setting foreign keys.
> But I can't understand the difference, as the purpose seems to be the
same:
> navigating from a parent table to a child one, and vice-versa.
> Am I missing something?
> Thanks!
> Henri
>
>|||AFAIK, not by itself. I'd be surprised if there weren't utilities available out there to generate this stuff
for you, though.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Henri" <hmfireball@.hotmail.com> wrote in message news:uvGyEt5TEHA.3420@.TK2MSFTNGP09.phx.gbl...
> Thanks for your help to both of you :-)
> Just one last question:
> If I define constraints and relations(diagrams) within SQL Server, can
> ADO.NET retrieve them, so that I can use them without having to redefine
> them when declaring the DataSet?
> I'm currently checking the.NET doc and might find the answer by myself, but
> if you know it, thank you for telling me :-)
> Henri
> "Henri" <hmfireball@.hotmail.com> a écrit dans le message de
> news:%23nSPik0TEHA.3828@.TK2MSFTNGP09.phx.gbl...
> > I've bought a book about ASP.NET with SQL Server 2000.
> > In one chapter, they talk about setting relations between tables, and in
> > another, about setting foreign keys.
> > But I can't understand the difference, as the purpose seems to be the
> same:
> > navigating from a parent table to a child one, and vice-versa.
> > Am I missing something?
> > Thanks!
> > Henri
> >
> >
> >
> >
>
>|||Thanks :)
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> a écrit
dans le message de news:eljMa15TEHA.1012@.TK2MSFTNGP09.phx.gbl...
> AFAIK, not by itself. I'd be surprised if there weren't utilities
available out there to generate this stuff
> for you, though.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Henri" <hmfireball@.hotmail.com> wrote in message
news:uvGyEt5TEHA.3420@.TK2MSFTNGP09.phx.gbl...
> > Thanks for your help to both of you :-)
> > Just one last question:
> > If I define constraints and relations(diagrams) within SQL Server, can
> > ADO.NET retrieve them, so that I can use them without having to redefine
> > them when declaring the DataSet?
> > I'm currently checking the.NET doc and might find the answer by myself,
but
> > if you know it, thank you for telling me :-)
> > Henri
> >
> > "Henri" <hmfireball@.hotmail.com> a écrit dans le message de
> > news:%23nSPik0TEHA.3828@.TK2MSFTNGP09.phx.gbl...
> > > I've bought a book about ASP.NET with SQL Server 2000.
> > > In one chapter, they talk about setting relations between tables, and
in
> > > another, about setting foreign keys.
> > > But I can't understand the difference, as the purpose seems to be the
> > same:
> > > navigating from a parent table to a child one, and vice-versa.
> > > Am I missing something?
> > > Thanks!
> > > Henri
> > >
> > >
> > >
> > >
> >
> >
> >
> >
>
>

difference between table relations and foreign keys?

I've bought a book about ASP.NET with SQL Server 2000.
In one chapter, they talk about setting relations between tables, and in
another, about setting foreign keys.
But I can't understand the difference, as the purpose seems to be the same:
navigating from a parent table to a child one, and vice-versa.
Am I missing something?
Thanks!
Henri
Unless you can show more detailed context, I think they are talking about
the exact same thing. A relationship is a bit more abstract; a foreign key
represents the implementation-specific way that a child row is connected to
a parent row.
http://www.aspfaq.com/
(Reverse address to reply.)
"Henri" <hmfireball@.hotmail.com> wrote in message
news:%23nSPik0TEHA.3828@.TK2MSFTNGP09.phx.gbl...
> I've bought a book about ASP.NET with SQL Server 2000.
> In one chapter, they talk about setting relations between tables, and in
> another, about setting foreign keys.
> But I can't understand the difference, as the purpose seems to be the
> same:
> navigating from a parent table to a child one, and vice-versa.
> Am I missing something?
> Thanks!
> Henri
>
>
|||Actually, the first chapter is about the DataRelation class, and
DataTable.ChildRelations(String) and DataRow.GetChildRows(DataRelation).
The second chapter is about ForeignKeyConstraint Class
The only difference I see is that a foreign key allows to define cascade
update and delete rules.
Actually, ASP.NET permits to define many things like indexes, primary keys,
relations, etc. but I thought that this had to be done on SQL Server, not
from ASP.NET.
That's why I'm a bit lost :-)
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> a crit dans le message de
news:ORWb%23o0TEHA.2416@.TK2MSFTNGP12.phx.gbl...
> Unless you can show more detailed context, I think they are talking about
> the exact same thing. A relationship is a bit more abstract; a foreign
key
> represents the implementation-specific way that a child row is connected
to
> a parent row.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Henri" <hmfireball@.hotmail.com> wrote in message
> news:%23nSPik0TEHA.3828@.TK2MSFTNGP09.phx.gbl...
>
>
|||What you are reading about is Data Sets in ADO.Net. The
relations and constraints you define in a data set are
different and separate from relations and constraints in the
database. In ADO.Net, you can create something similar to a
database - tables (data tables), relationships (using the
DataRelation class), constraints (such as with the
ForeignKeyConstraint class). It's not the same thing as the
database you may be accessing for the data in the data sets.
For ADO.Net, you can find more information on how relations
and constraints work together, differently in .Net Framework
documentation. Check the remarks section of the definition
of the DataRelation class.
-Sue
On Fri, 11 Jun 2004 03:40:00 +0200, "Henri"
<hmfireball@.hotmail.com> wrote:

>Actually, the first chapter is about the DataRelation class, and
>DataTable.ChildRelations(String) and DataRow.GetChildRows(DataRelation).
>The second chapter is about ForeignKeyConstraint Class
>The only difference I see is that a foreign key allows to define cascade
>update and delete rules.
>Actually, ASP.NET permits to define many things like indexes, primary keys,
>relations, etc. but I thought that this had to be done on SQL Server, not
>from ASP.NET.
>That's why I'm a bit lost :-)
>
>"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> a crit dans le message de
>news:ORWb%23o0TEHA.2416@.TK2MSFTNGP12.phx.gbl...
>key
>to
>
|||Hi,
Within ADO.Net, a Foreign Key Constaint is a subtype of the Data Relation. The FKC in ADO.Net behaves in a similar manner to a FKC within SQL Server, but it is a constraint on the Data Set, not the database, which can be an important consideration.
A Data Relation has additonal functionality that is not provided by the FKC, ( I think one is providing the Child Rows in the Data Set to a particular Master row.) I suggest you have a look at the class definitions and examine the different methods and pr
operties each suppiles

difference between SQL standard Edition and Enterprise Edition

Hi, there,

We are running SQL 2000 & SP4 with our ASP.NET application, now we plan to upgrade to Enterprise Edition due to the huge diffirence in price. Can any one of u give an brief introduction of the difference between these two, and what is the advantages of enterprise edition?

Any suggestion will greately appreciated.

Shermaine

There's a good comparison of the various versions of SQL Server here:-

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

|||

shermaine wrote:

now we plan to upgrade to Enterprise Edition due to the huge diffirence in price.

That seems logical.

Did anyone get this error on a backup job?!

Additional information --> Job Owner: SA

In my DB Backup JOB my first step is to map a network path like this
NET USE Z:\\SERVER2\DADOS /user somebody 234567

I got this Error --> Executed as user: MYSERVER\SYSTEM. System error 1312 has occurred. A specified logon session does not exist. It may already have been terminated. Process Exit Code 2. The step failed.

In step 2 i copy all my *.bak files from yesterday to the drive mapped on dir BACKUP in SERVER2.

COPY "C:\BACKUP\*.BAK" "Z:\BACKUP\"

I got this Error --> Executed as user: MYSERVER\SYSTEM. ...annot find the path specified. C:\BACKUP\db_200511030200.BAK The system cannot find the path specified. C:\BACKUP\CFG_db_200511030225.BAK The system cannot find the path specified. C:\BACKUP\STRUCTAL_db_200511030225.BAK The system cannot find the path specified. C:\BACKUP\STRUCTEN_db_200511030225.BAK The system cannot find the path specified.

step 3 i delete all files in MYSERVER C:\BACKUP\*.BAK

This step is OK

step 4 i execute my database maintenance plan

the .bak file are generated and put in "C:\BACKUPS" in MYSERVER

This step is OK

Thanks for all help.First you need to resolve the 1312 error. It may be caused by some sort of delay that occurred between a network connection request initiated by NET USE and the actuaql attempt to map the drive. While on the topic, why do you need to map the drive to begin with?

Second, you need to make sure that the step is executed successfully before moving on. You need to either check for errorlevel or take the step out of the batch and put it by itself into a separate step within the job, and then allow continuation OnSuccess.

Diagram in Yukon

Where can I find the diagram in SQL Server 2005? I installed the beta 2 version but i cannot find the diagram. Another thing is: how can i embed .net codes inside stored procedure or SQL Server 2005?

Thanks
Lou BelaroBeta 2 is very old and does not contain the database diagram tool. It is, however, in the most recent version of SQL Server 2005 (June CTP), which you can get from http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/ctp.mspx.

To use .NET code inside stored procedures, functions, triggers, etc. you need to create an assembly in SQL Server. Please see the following topics in SQL Server Books Online for additional information.

CREATE ASSEMBLY
Creating CLR Stored Procedures
CLR Programmability Samples|||I'll replace my current version.

Thanks alot,
Lou

Development Tools

Are there any tools (other than Visual Studio.NET) that will allow me to
build SQL Reporting Services Reports? I just want to build some simple
reports and don't need (or want) to install the Visual Studio.NET.SQL Server 2005 will include a new tool called "Report Builder" that is
intended for end-users. It doesn't depend on VS.
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"John" <John@.discussions.microsoft.com> wrote in message
news:43A3C15E-9042-4204-BB90-CFA8A0BE86EA@.microsoft.com...
> Are there any tools (other than Visual Studio.NET) that will allow me to
> build SQL Reporting Services Reports? I just want to build some simple
> reports and don't need (or want) to install the Visual Studio.NET.

Development tool choice for SQL Server

Is VB.net the most logical choice of a RAD tool to use with MS SQL Server? Is VB.net strictly for web apps or can you use it to create projects that run as executables off the server?
JustStartinOutwe use java and websphere|||VB.NET can be used for web applications or for building executables or DLLs (actually you are creating DLLs when building .NET web apps anyway). The .NET development tools, which include VB.NET, C#, and others, are not RAD tools but will allow you to develop using RAD methodology. Depending on your programming background, you may find C# easier to use than VB.NET. It is syntaxically similar to C, c++ and Java.

HTH
Tim|||I find C# infinitely easier to read and code than VB.

also there are certain useful keywords in C# that have no equivalent (i think) in VB (like using and yield).|||I think Access is about the quickest for simple apps. It has very good support for SQL Server. We have a comprehensive app in Access that uses VB 6 in the code-behind.

The developer wrote an entire purchasing and inventory system in 4 months, from inception to implementation. It has about 20 menu items and uses Stored Procedures for all SQL Server access. It's fairly stable and very fast, however requires installation at each workstation. He could have done it in half that time except for a very complex (Dynamic SQL) interface into our existing Sales Order system.

VB.Net, as with all the .NET languages, compiles into a Common Language. As mentioned, the C# language has more complete support of the .NET platform and enjoys wider support and programmer base, but the end result of VB.NET and C#.NET are identical.

In my opinion, the only reason for VB.NET is to provide an easy learning curve for all the VB 6 developers. It's C# with a VB6 like syntax, what's the point, just use C#. (note: C#, although modeled after C++, is far less complex to use, and in truth was modeled after Java)

With .NET, you can create console applications, web applications, desktop applications (the traditional forms based program that gets installed on each desktop), and others. Usage of any require the .NET Platform to be installed. However; using a web page that's implemented by ASP.NET does not require anything special, just a browser. The programmer may have to work out differences with particular browsers (example: Netscape is notorious from straying from the standards, nearly as bad as IE) but they DO NOT require the .NET platform to function.

ASP.NET is the programmer's platform for Microsoft's next generation of IIS (web server) and is implemented using .NET. It's a pretty amazing platform. I'm only starting to use it but after 4 years of using ASP, there's simply no comparison. In ASP.NET, you write your forms, database access, etc similarly to a desktop appliation then ASP.NET actually converts stuff to HTML and manages the web sessions. According to the forword in my ASP.NET book (by APress) MySpace.com (who gets over a billion hits a day) recently converted from ColdFusion to ASP.NET and that's saying a lot.

(Regarding Access) As with most simple platforms, there's a point of diminishing returns where it's actually more difficult due to the complexity of what you're trying to achieve. So if you don't have a well seasoned Access developer, and your task is very complex, I'd not suggest Access. For a fairly simple series of screens (like master file maintenance, creating test data, etc), it's nice.

For reporting, I use Crystal Reports (and it serves up nicely on our web server, with license-free report distribution) and (combined with SQL Server's backend RAD SQL development tools) it is the most productive environment I've ever experienced. I can satisfy nearly any permanent reporting request in under 1 day, and often in 1 or 2 hours. Maintenance is also a dream. Factory workorders, invoices, sales analysis, Purchasing history, etc etc.|||Actually this system is currently written in Access and I was looking to do a rewrite using something more sophisticated and robust and that is why I was looking at choosing some newer technology. Our Access applications around here all have the same unprofessional look.|||Well access like VB is a FAT client.

We chose java because it's thin and uses servlets

No, I don't know Java...front-end development....ewwwwwww|||Actually this system is currently written in Access and I was looking to do a rewrite using something more sophisticated and robust and that is why I was looking at choosing some newer technology. Our Access applications around here all have the same unprofessional look.
They're all pretty equally capable of offering an unprofessional look and feel.

Don't confuse the front-end look-n-feel with back-end capability. They all use the same SQL Server.

Java and .NET are pretty similar, however .NET is more suited to the Windows platform. .NET allows for a "thin client" (ASP.NET combined with language of choice, VB.NET, C#.NET, etc) and "fat client" (Windows Forms app combined with .NET language of choice).

Going to either is a total rewrite, and even re-design. The database table layout and screens can likely stay (mostly) the same, but it's a non-trivial task. If you just want prettier screens, you could get a better Access programmer to just move things around and add some navagation capability.

Suggest re-posting your question in the language support forums. I don't think the database guys care too much about how the front-end is implemented.|||No, I don't know Java...front-end development....ewwwwwww

java isn't strictly a front-end language - plenty of server apps have been implemented in java. you can build a RDBMS with it even :)

http://sourceforge.net/projects/daffodildb|||Thanks Vich, but I don't want to give my job away to a 'better access programmer'. (ha, ha) I would like to learn something new to get my skills back sharp and to help me stay marketable should I ever want to leave here. At this job I have plenty of flexibility (and spare time) and I essentially work by myself (as far as development goes). Now is a good time for self-development.|||Thanks Vich, but I don't want to give my job away to a 'better access programmer'. (ha, ha) I would like to learn something new to get my skills back sharp and to help me stay marketable should I ever want to leave here. At this job I have plenty of flexibility (and spare time) and I essentially work by myself (as far as development goes). Now is a good time for self-development.

Fine, then ascend to mount olympus and become a dba|||since you are working on Access, VB.Net seems a logical tool of choice.
I come from VB background but i've managed(at last!) to work equally comfortable on Vb.Net & C#.

As far as the app is a desktop one it should fairly easy to wsitch between the 2. But i think to create a Web App you will need to put few extra hours in learning and implemntation.|||I use Access as a front end MDB with an SQL 2005 back end. I have also played with the ADP form of Access front end. I am moving to VB.Net due to getting a timeout error on a key part of the application which is just impossible to solve. But I am finding the move very difficult as it is a rather steep learning curve.

If you are going to use the Express Edition note that it is only configured to use the wizards with the express version of SQL 2005.

Developing WAP using ASP.NET and Web Services

Hi all,

I would like to develop WAP using ASP.NET which can connect to the Database( MS SQL Server ). Is it possible to do it? I try to find the tutorial but I cannot find it.

Another thing I want to ask is can I connect the WAP to the web services that I create using ASP.NET, anyone can tell me how to do it.

Thanks, Regards.

REDWAP is something that is sent to and displayed on the client. ASP.NET and Web Services are server side technologies. You can certainly have your ASP.NET application call out to a Web service, and then send the results to your WAP device.

Developing Microsoft SQL Server CE 2.0 Merge Replication Using .NET Compact Framework

We are developing Microsoft SQL Server CE 2.0 Merge Replication Using .NET Compact Framework. There is need of sinhronizations between SQL 2005 Mobile Edition witch resides on Barcode terminal (Windows CE) and SQL 2005 Developer Edition (on Windows XP). Everything is done by the book. There is few lines of code that we are using:
public bool Replicate()
{ bool ret = true;
SqlCeReplication repl = null;
try {
// Instantiate and configure
SqlCeReplication object repl = new SqlCeReplication();
string dbFile = ........
repl.InternetUrl = this.InternetUrl;
repl.InternetLogin = this.InternetLogin;
repl.InternetPassword = this.InternetPassword;
repl.Publisher = this.Publisher;
repl.PublisherDatabase = this.PublisherDatabase;
repl.PublisherLogin = this.PublisherLogin;
repl.PublisherPassword = this.PublisherPassword;
repl.Publication = this.Publication;
repl.Subscriber = this.Subscriber;
repl.SubscriberConnectionString ="Data Source=" +dbFile;
if (!System.IO.File.Exists(dbFile))
{ repl.AddSubscription(AddOption.CreateDatabase);
}
repl.Synchronize();
}
IIS is configured, but in log on the server we've got this error:
2007/08/09 15:33:02 Hr=80004005 ACK:Error for DistributorSessionID = 58 2007/08/09 15:33:02 Hr=80004005 The SQL statement failed to execute. [,,,SQL statement,,] 28560 Please give us posible solution of this problem, we have searched on forums but with no result. p.s. I'ts urgentWe are developing Microsoft SQL Server CE 2.0 Merge Replication Using .NET Compact Framework. There is need of sinhronizations between SQL 2005 Mobile Edition witch resides on Barcode terminal (Windows CE) and SQL 2005 Developer Edition (on Windows XP). Everything is done by the book. There is few lines of code that we are using:
public bool Replicate()
{ bool ret = true;
SqlCeReplication repl = null;
try {
// Instantiate and configure
SqlCeReplication object repl = new SqlCeReplication();
string dbFile = ........
repl.InternetUrl = this.InternetUrl;
repl.InternetLogin = this.InternetLogin;
repl.InternetPassword = this.InternetPassword;
repl.Publisher = this.Publisher;
repl.PublisherDatabase = this.PublisherDatabase;
repl.PublisherLogin = this.PublisherLogin;
repl.PublisherPassword = this.PublisherPassword;
repl.Publication = this.Publication;
repl.Subscriber = this.Subscriber;
repl.SubscriberConnectionString ="Data Source=" +dbFile;
if (!System.IO.File.Exists(dbFile))
{ repl.AddSubscription(AddOption.CreateDatabase);
}
repl.Synchronize();
}
IIS is configured, but in log on the server we've got this error:
2007/08/09 15:33:02 Hr=80004005 ACK:Error for DistributorSessionID = 58 2007/08/09 15:33:02 Hr=80004005 The SQL statement failed to execute. [,,,SQL statement,,] 28560 Please give us posible solution of this problem, we have searched on forums but with no result. p.s. I'ts urgent|||

i hope this will be usefull

Public Shared Function CreateDatabase(ByVal strUserName As String, ByVal strPassword As String) As Boolean
Dim strPublisher, strPublisherDataBase, strPublication As String
Dim strDistributor, strInternetURL As String
Dim strSubscriberDatabasePassword As String
Dim strSubscriberDatabasePath As String
Try
Dim rmReplication As New System.Resources.ResourceManager( _
"RoadRunner.Replication", _
System.Reflection.Assembly.GetExecutingAssembly())
' Assign the resource manager values to data members
strPublication = rmReplication.GetString("Publication")
strPublisher = rmReplication.GetString("Publisher")
strPublisherDataBase = rmReplication.GetString("PublisherDatabase")
strDistributor = rmReplication.GetString("Distributor")
strInternetURL = rmReplication.GetString("InternetUrl")
strSubscriberDatabasePassword = rmReplication.GetString("SubscriberDatabasePassword")
strSubscriberDatabasePath = rmReplication.GetString("SubscriberDatabasePath")

Catch ex As Exception

' MessageBox.Show(ex.Message)
LogFile.AddEntry(ex.Message)
Cursor.Current = Cursors.Default
' if any error occured while reading from resource file, exit function
Return False

End Try
' Declare replication object
Dim replicate As SqlServerCe.SqlCeReplication

Try
' 1: Instantiate replication option
replicate = New SqlServerCe.SqlCeReplication

'***********************************************************
' SQL server 2000 machine name and database for replication
'***********************************************************
replicate.Publisher = strPublisher
replicate.PublisherDatabase = strPublisherDataBase
'**********************************************************
' Publisher server info
'**********************************************************
replicate.Publication = strPublication
replicate.PublisherLogin = strUserName
replicate.PublisherPassword = strPassword
replicate.PublisherSecurityMode = SqlServerCe.SecurityType.NTAuthentication
'**********************************************************
' Distributor server info
'**********************************************************
replicate.Distributor = strDistributor
replicate.DistributorLogin = strUserName
replicate.DistributorPassword = strPassword
replicate.DistributorSecurityMode = SqlServerCe.SecurityType.NTAuthentication
'***********************************************************
' Set subscriber info for salesman and db on PDA
'***********************************************************
replicate.Subscriber = "BTCHH"
replicate.SubscriberConnectionString = "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;" _
& "Data Source=" & strSubscriberDatabasePath _
& ";Password=" & strSubscriberDatabasePassword
'***********************************************************
' IIS server info
'***********************************************************
replicate.InternetUrl = strInternetURL
replicate.InternetLogin = strUserName
replicate.InternetPassword = strPassword
' if database doesn't exist then create it
If System.IO.File.Exists(strSubscriberDatabasePath) = False Then
Try
replicate.AddSubscription(SqlServerCe.AddOption.CreateDatabase)

replicate.Synchronize()
Return True
Catch ex As SqlServerCe.SqlCeException
System.IO.File.Delete(strSubscriberDatabasePath)
ReplicationOperationErrors(ex)
Cursor.Current = Cursors.Default
Return False
End Try
End If

Try
' BuildObject.Compact(strSubscriberDatabasePath)
replicate.ReinitializeSubscription(True)
replicate.Synchronize()
'BuildObject.Dispose()

Catch ex As SqlServerCe.SqlCeException

replicate.Dispose()
MsgBox(ex.Message)
End Try

Return True
Catch ex As SqlServerCe.SqlCeException
ReplicationOperationErrors(ex)
Cursor.Current = Cursors.Default
Return False
Finally
'BuildObject.Dispose()
replicate.Dispose()
End Try
End Function

Developing Microsoft SQL Server CE 2.0 Merge Replication Using .NET Compact Framework

We are developing Microsoft SQL Server CE 2.0 Merge Replication Using .NET Compact Framework. There is need of sinhronizations between SQL 2005 Mobile Edition witch resides on Barcode terminal (Windows CE) and SQL 2005 Developer Edition (on Windows XP). Everything is done by the book. There is few lines of code that we are using:
public bool Replicate()
{ bool ret = true;
SqlCeReplication repl = null;
try {
// Instantiate and configure
SqlCeReplication object repl = new SqlCeReplication();
string dbFile = ........
repl.InternetUrl = this.InternetUrl;
repl.InternetLogin = this.InternetLogin;
repl.InternetPassword = this.InternetPassword;
repl.Publisher = this.Publisher;
repl.PublisherDatabase = this.PublisherDatabase;
repl.PublisherLogin = this.PublisherLogin;
repl.PublisherPassword = this.PublisherPassword;
repl.Publication = this.Publication;
repl.Subscriber = this.Subscriber;
repl.SubscriberConnectionString ="Data Source=" +dbFile;
if (!System.IO.File.Exists(dbFile))
{ repl.AddSubscription(AddOption.CreateDatabase);
}
repl.Synchronize();
}
IIS is configured, but in log on the server we've got this error:
2007/08/09 15:33:02 Hr=80004005 ACK:Error for DistributorSessionID = 58 2007/08/09 15:33:02 Hr=80004005 The SQL statement failed to execute. [,,,SQL statement,,] 28560 Please give us posible solution of this problem, we have searched on forums but with no result. p.s. I'ts urgentWe are developing Microsoft SQL Server CE 2.0 Merge Replication Using .NET Compact Framework. There is need of sinhronizations between SQL 2005 Mobile Edition witch resides on Barcode terminal (Windows CE) and SQL 2005 Developer Edition (on Windows XP). Everything is done by the book. There is few lines of code that we are using:
public bool Replicate()
{ bool ret = true;
SqlCeReplication repl = null;
try {
// Instantiate and configure
SqlCeReplication object repl = new SqlCeReplication();
string dbFile = ........
repl.InternetUrl = this.InternetUrl;
repl.InternetLogin = this.InternetLogin;
repl.InternetPassword = this.InternetPassword;
repl.Publisher = this.Publisher;
repl.PublisherDatabase = this.PublisherDatabase;
repl.PublisherLogin = this.PublisherLogin;
repl.PublisherPassword = this.PublisherPassword;
repl.Publication = this.Publication;
repl.Subscriber = this.Subscriber;
repl.SubscriberConnectionString ="Data Source=" +dbFile;
if (!System.IO.File.Exists(dbFile))
{ repl.AddSubscription(AddOption.CreateDatabase);
}
repl.Synchronize();
}
IIS is configured, but in log on the server we've got this error:
2007/08/09 15:33:02 Hr=80004005 ACK:Error for DistributorSessionID = 58 2007/08/09 15:33:02 Hr=80004005 The SQL statement failed to execute. [,,,SQL statement,,] 28560 Please give us posible solution of this problem, we have searched on forums but with no result. p.s. I'ts urgent|||

i hope this will be usefull

Public Shared Function CreateDatabase(ByVal strUserName As String, ByVal strPassword As String) As Boolean
Dim strPublisher, strPublisherDataBase, strPublication As String
Dim strDistributor, strInternetURL As String
Dim strSubscriberDatabasePassword As String
Dim strSubscriberDatabasePath As String
Try
Dim rmReplication As New System.Resources.ResourceManager( _
"RoadRunner.Replication", _
System.Reflection.Assembly.GetExecutingAssembly())
' Assign the resource manager values to data members
strPublication = rmReplication.GetString("Publication")
strPublisher = rmReplication.GetString("Publisher")
strPublisherDataBase = rmReplication.GetString("PublisherDatabase")
strDistributor = rmReplication.GetString("Distributor")
strInternetURL = rmReplication.GetString("InternetUrl")
strSubscriberDatabasePassword = rmReplication.GetString("SubscriberDatabasePassword")
strSubscriberDatabasePath = rmReplication.GetString("SubscriberDatabasePath")

Catch ex As Exception

' MessageBox.Show(ex.Message)
LogFile.AddEntry(ex.Message)
Cursor.Current = Cursors.Default
' if any error occured while reading from resource file, exit function
Return False

End Try
' Declare replication object
Dim replicate As SqlServerCe.SqlCeReplication

Try
' 1: Instantiate replication option
replicate = New SqlServerCe.SqlCeReplication

'***********************************************************
' SQL server 2000 machine name and database for replication
'***********************************************************
replicate.Publisher = strPublisher
replicate.PublisherDatabase = strPublisherDataBase
'**********************************************************
' Publisher server info
'**********************************************************
replicate.Publication = strPublication
replicate.PublisherLogin = strUserName
replicate.PublisherPassword = strPassword
replicate.PublisherSecurityMode = SqlServerCe.SecurityType.NTAuthentication
'**********************************************************
' Distributor server info
'**********************************************************
replicate.Distributor = strDistributor
replicate.DistributorLogin = strUserName
replicate.DistributorPassword = strPassword
replicate.DistributorSecurityMode = SqlServerCe.SecurityType.NTAuthentication
'***********************************************************
' Set subscriber info for salesman and db on PDA
'***********************************************************
replicate.Subscriber = "BTCHH"
replicate.SubscriberConnectionString = "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;" _
& "Data Source=" & strSubscriberDatabasePath _
& ";Password=" & strSubscriberDatabasePassword
'***********************************************************
' IIS server info
'***********************************************************
replicate.InternetUrl = strInternetURL
replicate.InternetLogin = strUserName
replicate.InternetPassword = strPassword
' if database doesn't exist then create it
If System.IO.File.Exists(strSubscriberDatabasePath) = False Then
Try
replicate.AddSubscription(SqlServerCe.AddOption.CreateDatabase)

replicate.Synchronize()
Return True
Catch ex As SqlServerCe.SqlCeException
System.IO.File.Delete(strSubscriberDatabasePath)
ReplicationOperationErrors(ex)
Cursor.Current = Cursors.Default
Return False
End Try
End If

Try
' BuildObject.Compact(strSubscriberDatabasePath)
replicate.ReinitializeSubscription(True)
replicate.Synchronize()
'BuildObject.Dispose()

Catch ex As SqlServerCe.SqlCeException

replicate.Dispose()
MsgBox(ex.Message)
End Try

Return True
Catch ex As SqlServerCe.SqlCeException
ReplicationOperationErrors(ex)
Cursor.Current = Cursors.Default
Return False
Finally
'BuildObject.Dispose()
replicate.Dispose()
End Try
End Function

Developing app that will use SQL Server Express on back end...

Hi...

I have the full version of SQL Server installed on my machine and am developing an app using BI DTS packages, VB.Net, SQL SPs, etc.. I will need to deploy this app w/SQL Server Express (SSE).

-Do I have to install SSE on my development machine for the purpose of creating the install package of my application? I am afraid that if I do install SSE on my machine, it may mess up my installation of the full version of SQL Server... will it?

-Can you point me to a link with information about how to do the development with the full version of SS, and create the installation package using the SSE?

Thanks for your help.

Steph
You cannot deployment SQL Server 2005 Integration Services packages in SQL Server Express because the runtime now comes with the server license. In SQL Server 2000 the DTS package comes with the runtime that changed in 2005. Hope this helps.|||Thanks for the response.

The way I posed my question was misleading. I'm sorry about that. I shouldn't even have mentioned the DTS packages.

The big picture of the app is this:

- Data resides in a datamart at a central office. The central office will be running the full SQL Server 2005 version (this is where the DTS packages reside and run).

- Satellite (very small) offices need to download updated information relating to them from the central office. I'm thinking of having these satellite offices run SQL Express.

I'm developing the code to update the satellite office data from the central office data. On my development system, I am running the full version of SQL Server 2005. Should I also install SQL Express on my development system ? Will it mess up my full SQL Server 2005 installation?

Thanks,

Steph
|||It is tricky but here is how you could do it legally create Asp.net application run it from your main office SQL Server create a job to execute the many versions of the package make your small offices destination. It will take more work but the alternative solution may cost you more hardware SQL Server Express can be a subscriber in replication so you can push the data with replication. You could always talk to your local Microsoft SQL Server contact person, in some areas there is regional contact person. Hope this helps

Developing a SQL server DB (noob question)

I'm beginning development on a medium/ sized in-house web based system. Well moving from asp/mysql to asp.net/sql server. Re-doing DB design as well.

My question is does it make sense for me to develop the SQL DB in Visual Studio 2005 pro, and then later move it to a real SQL server? Or basically what is the best and/or most practical way to do this development. Any other IDE's out there?

Thanks

I'd just use SQL Server from the outset. I find Entreprise Manager cumbersome to use, so I just use it to create the database, then create an Access adp file as my main interface to create tables, views and stored procedures. adp files give you the speed and functionality of Access when manipulating SQL Server DB's. I do go back to Entreprise Manager to do things like create table relationships.

|||

So you're basically suggesting developing the DB using the Access IDE, correct? I fail to see how that would be beneficial, Access has different data types than SQL server. When using an ADP file would Access then know the correct column types? Also, how would that ease the development of my web application?

Does anyone else agree with the above comment? The lack of responses makes me feel like everyone else thinks that is the best answer.

|||

With an adp file, you are essentially using the interface of Access to manage your SQL Database. It is still a full SQL Server database; it is not an mdb with native Access types. This means that the datatypes available and field options are all from SQL Server, (e.g. you have VARCHAR instead of Text, etc). You can also do things that create Stored Procedures. It has most of the functionality of Entreprise Manager for creating and maintaining your database.

Reasons I like adp files over Entreprise Manager:

1. adp files allow you to build forms for basic data entry / editing

2. Entreprise Manager Stored Procedure windows are modal. If you are writing a procedure and need to look up a field name in a table, you have to close the window (which you can't do with partially written syntax) first. with an adp the Procedure window can be minimized or tiled.

3. adp files allow you to sort and filter tables in datasheet view. Entreprise Manager doesn't.

4. Speed. adp files are faster for looking up data.

adp files do lack some features, such as the ability to build relationships or triggers. For this use Entreprise Manager.

Developer Edition Install

Hi, folks.
I've just reached the end of my frustration with trying to learn MSDE with no interface (in addition to ASP.NET), so I'm going to install 2K Developer Edition. However, I'd like to know if it's safe install it on top of MSDE. I'm currently running XP Pr
o, VS.NET, IIS 5.x, so I'm afraid that if I have uninstall MSDE that I'll break a bunch things that I've painstakingly configured. ;-)
Advice?
TIA,
Bob
What have you painstakingly configured? You might be able to easily =
configure these within SQL Server Developer Edition. =20
The other option: install the Developer Edition of SQL Server as a named =
instance. That will allow you to keep MSDE installed as well as give =
you the ability to use SQL Server (Developer Edition) on your computer.
--=20
Keith
"WebGuyBob" <anonymous@.discussions.microsoft.com> wrote in message =
news:1BD19D74-8A5A-4F9C-8FD6-D013309B7A45@.microsoft.com...
> Hi, folks.
>=20
> I've just reached the end of my frustration with trying to learn MSDE =
with no interface (in addition to ASP.NET), so I'm going to install 2K =
Developer Edition. However, I'd like to know if it's safe install it on =
top of MSDE. I'm currently running XP Pro, VS.NET, IIS 5.x, so I'm =
afraid that if I have uninstall MSDE that I'll break a bunch things that =
I've painstakingly configured. ;-)
>=20
> Advice?
>=20
> TIA,
>=20
> Bob
|||Keith,
The configuration statement actually refers to the installation and configuration of IIS and VS.NET. I feared that when I installed MSDE, it dug its hooks into those applications (inherent in many MS apps) and that uninstalling MSDE would "break" things.
I would prefer to have only one DB application on my machine. With that said, since it appears from your comments, because SQL2k DevEd does not install "on top" of MSDE, I will attempt to uninstall it and then install SQL2k DevEd.
I have developed any databases yet, but either VS.NET, MSDE, or the .NET SDK installed various sample databases. I was hoping to use those to learn from. If those happen to get deleted resulting from the uninstall, at least I've found a place where I ca
n get updated ones.
Any parting words of wisdom before I do the uninstall of MSDE and install of SQL2k DevEd?
Thanks,
Bob
|||The many "sample" databases should still exist -- in mdf and ldf form. =
Hopefully you will be able to use sp_attach_db to attach those databases =
to SQL Server Developer Edition.
Words of wisdom: Just do it.
Good luck. Post back if you have any questions along the way. There =
are many helpful people in the newsgroups that should be able to provide =
assistance should you need it.
--=20
Keith
"WebGuyBob" <anonymous@.discussions.microsoft.com> wrote in message =
news:4A5D898D-9A17-4C87-8554-AF6EFBF0F4DB@.microsoft.com...
> Keith,
>=20
> The configuration statement actually refers to the installation and =
configuration of IIS and VS.NET. I feared that when I installed MSDE, =
it dug its hooks into those applications (inherent in many MS apps) and =
that uninstalling MSDE would "break" things.
>=20
> I would prefer to have only one DB application on my machine. With =
that said, since it appears from your comments, because SQL2k DevEd does =
not install "on top" of MSDE, I will attempt to uninstall it and then =
install SQL2k DevEd.
>=20
> I have developed any databases yet, but either VS.NET, MSDE, or the =
..NET SDK installed various sample databases. I was hoping to use those =
to learn from. If those happen to get deleted resulting from the =
uninstall, at least I've found a place where I can get updated ones.
>=20
> Any parting words of wisdom before I do the uninstall of MSDE and =
install of SQL2k DevEd?
>=20
> Thanks,
>=20
> Bob
|||Or you could run the pubsinst.sql scripts from another sql server standard
install.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Developer Edition Install

Hi, folks
I've just reached the end of my frustration with trying to learn MSDE with no interface (in addition to ASP.NET), so I'm going to install 2K Developer Edition. However, I'd like to know if it's safe install it on top of MSDE. I'm currently running XP Pro, VS.NET, IIS 5.x, so I'm afraid that if I have uninstall MSDE that I'll break a bunch things that I've painstakingly configured. ;-
Advice
TIA
BobWhat have you painstakingly configured? You might be able to easily =configure these within SQL Server Developer Edition.
The other option: install the Developer Edition of SQL Server as a named =instance. That will allow you to keep MSDE installed as well as give =you the ability to use SQL Server (Developer Edition) on your computer.
-- Keith
"WebGuyBob" <anonymous@.discussions.microsoft.com> wrote in message =news:1BD19D74-8A5A-4F9C-8FD6-D013309B7A45@.microsoft.com...
> Hi, folks.
> > I've just reached the end of my frustration with trying to learn MSDE =with no interface (in addition to ASP.NET), so I'm going to install 2K =Developer Edition. However, I'd like to know if it's safe install it on =top of MSDE. I'm currently running XP Pro, VS.NET, IIS 5.x, so I'm =afraid that if I have uninstall MSDE that I'll break a bunch things that =I've painstakingly configured. ;-)
> > Advice?
> > TIA,
> > Bob|||Keith
The configuration statement actually refers to the installation and configuration of IIS and VS.NET. I feared that when I installed MSDE, it dug its hooks into those applications (inherent in many MS apps) and that uninstalling MSDE would "break" things
I would prefer to have only one DB application on my machine. With that said, since it appears from your comments, because SQL2k DevEd does not install "on top" of MSDE, I will attempt to uninstall it and then install SQL2k DevEd
I have developed any databases yet, but either VS.NET, MSDE, or the .NET SDK installed various sample databases. I was hoping to use those to learn from. If those happen to get deleted resulting from the uninstall, at least I've found a place where I can get updated ones
Any parting words of wisdom before I do the uninstall of MSDE and install of SQL2k DevEd
Thanks
Bob|||The many "sample" databases should still exist -- in mdf and ldf form. =Hopefully you will be able to use sp_attach_db to attach those databases =to SQL Server Developer Edition.
Words of wisdom: Just do it.
Good luck. Post back if you have any questions along the way. There =are many helpful people in the newsgroups that should be able to provide =assistance should you need it.
-- Keith
"WebGuyBob" <anonymous@.discussions.microsoft.com> wrote in message =news:4A5D898D-9A17-4C87-8554-AF6EFBF0F4DB@.microsoft.com...
> Keith,
> > The configuration statement actually refers to the installation and =configuration of IIS and VS.NET. I feared that when I installed MSDE, =it dug its hooks into those applications (inherent in many MS apps) and =that uninstalling MSDE would "break" things.
> > I would prefer to have only one DB application on my machine. With =that said, since it appears from your comments, because SQL2k DevEd does =not install "on top" of MSDE, I will attempt to uninstall it and then =install SQL2k DevEd.
> > I have developed any databases yet, but either VS.NET, MSDE, or the =.NET SDK installed various sample databases. I was hoping to use those =to learn from. If those happen to get deleted resulting from the =uninstall, at least I've found a place where I can get updated ones.
> > Any parting words of wisdom before I do the uninstall of MSDE and =install of SQL2k DevEd?
> > Thanks,
> > Bob|||Or you could run the pubsinst.sql scripts from another sql server standard
install.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Developer Edition Install

Hi, folks.
I've just reached the end of my frustration with trying to learn MSDE with n
o interface (in addition to ASP.NET), so I'm going to install 2K Developer E
dition. However, I'd like to know if it's safe install it on top of MSDE.
I'm currently running XP Pr
o, VS.NET, IIS 5.x, so I'm afraid that if I have uninstall MSDE that I'll br
eak a bunch things that I've painstakingly configured. ;-)
Advice?
TIA,
BobWhat have you painstakingly configured? You might be able to easily =
configure these within SQL Server Developer Edition. =20
The other option: install the Developer Edition of SQL Server as a named =
instance. That will allow you to keep MSDE installed as well as give =
you the ability to use SQL Server (Developer Edition) on your computer.
--=20
Keith
"WebGuyBob" <anonymous@.discussions.microsoft.com> wrote in message =
news:1BD19D74-8A5A-4F9C-8FD6-D013309B7A45@.microsoft.com...
> Hi, folks.
>=20
> I've just reached the end of my frustration with trying to learn MSDE =
with no interface (in addition to ASP.NET), so I'm going to install 2K =
Developer Edition. However, I'd like to know if it's safe install it on =
top of MSDE. I'm currently running XP Pro, VS.NET, IIS 5.x, so I'm =
afraid that if I have uninstall MSDE that I'll break a bunch things that =
I've painstakingly configured. ;-)
>=20
> Advice?
>=20
> TIA,
>=20
> Bob|||Keith,
The configuration statement actually refers to the installation and configur
ation of IIS and VS.NET. I feared that when I installed MSDE, it dug its ho
oks into those applications (inherent in many MS apps) and that uninstalling
MSDE would "break" things.
I would prefer to have only one DB application on my machine. With that sai
d, since it appears from your comments, because SQL2k DevEd does not install
"on top" of MSDE, I will attempt to uninstall it and then install SQL2k Dev
Ed.
I have developed any databases yet, but either VS.NET, MSDE, or the .NET SDK
installed various sample databases. I was hoping to use those to learn fro
m. If those happen to get deleted resulting from the uninstall, at least I'
ve found a place where I ca
n get updated ones.
Any parting words of wisdom before I do the uninstall of MSDE and install of
SQL2k DevEd?
Thanks,
Bob|||The many "sample" databases should still exist -- in mdf and ldf form. =
Hopefully you will be able to use sp_attach_db to attach those databases =
to SQL Server Developer Edition.
Words of wisdom: Just do it.
Good luck. Post back if you have any questions along the way. There =
are many helpful people in the newsgroups that should be able to provide =
assistance should you need it.
--=20
Keith
"WebGuyBob" <anonymous@.discussions.microsoft.com> wrote in message =
news:4A5D898D-9A17-4C87-8554-AF6EFBF0F4DB@.microsoft.com...
> Keith,
>=20
> The configuration statement actually refers to the installation and =
configuration of IIS and VS.NET. I feared that when I installed MSDE, =
it dug its hooks into those applications (inherent in many MS apps) and =
that uninstalling MSDE would "break" things.
>=20
> I would prefer to have only one DB application on my machine. With =
that said, since it appears from your comments, because SQL2k DevEd does =
not install "on top" of MSDE, I will attempt to uninstall it and then =
install SQL2k DevEd.
>=20
> I have developed any databases yet, but either VS.NET, MSDE, or the =
.NET SDK installed various sample databases. I was hoping to use those =
to learn from. If those happen to get deleted resulting from the =
uninstall, at least I've found a place where I can get updated ones.
>=20
> Any parting words of wisdom before I do the uninstall of MSDE and =
install of SQL2k DevEd?
>=20
> Thanks,
>=20
> Bob|||Or you could run the pubsinst.sql scripts from another sql server standard
install.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Developer Edition & Windows Server 2003 Small Business Server

I have Small Business Server 2003 and am teaching myself VB.Net. I purchased
the package Visual Basic Step By Step and put it on the server hoping to ac
cess the SQL Server on the server PC. But VB Step by Step won't recognize th
e SQL Server that came with
Small Business Server 2003. If I purchased the Developer's Edition of SQL Se
rver, could I put it on my server or would I have to move VB to my desktop P
C, put SQL Server DE on the desktop machine and work from there?
SteveC"jn316sc" <jn316sc@.discussions.microsoft.com> wrote in message
news:6750BF87-F6EE-4134-A50D-AE9CD88D6F26@.microsoft.com...
> I have Small Business Server 2003 and am teaching myself VB.Net. I
purchased the package Visual Basic Step By Step and put it on the server
hoping to access the SQL Server on the server PC. But VB Step by Step won't
recognize the SQL Server that came with Small Business Server 2003. If I
purchased the Developer's Edition of SQL Server, could I put it on my server
or would I have to move VB to my desktop PC, put SQL Server DE on the
desktop machine and work from there?
> SteveC
VB.NET can see your SBS SQL Server on the local machine as well as across
the network. How are you trying to access the SQL Server? My initial guess
is that you are probably having a security issue.
Try opening a new windows application.
Open the Form
Drag & Drop a SQLConnection Object and follow the wizard.
While in the wizard, use the Trusted Connection option.
HTH
Rick Sawtell
MCT, MCSD, MCDBA

Developer Edition & Windows Server 2003 Small Business Server

I have Small Business Server 2003 and am teaching myself VB.Net. I purchased the package Visual Basic Step By Step and put it on the server hoping to access the SQL Server on the server PC. But VB Step by Step won't recognize the SQL Server that came with
Small Business Server 2003. If I purchased the Developer's Edition of SQL Server, could I put it on my server or would I have to move VB to my desktop PC, put SQL Server DE on the desktop machine and work from there?
SteveC
"jn316sc" <jn316sc@.discussions.microsoft.com> wrote in message
news:6750BF87-F6EE-4134-A50D-AE9CD88D6F26@.microsoft.com...
> I have Small Business Server 2003 and am teaching myself VB.Net. I
purchased the package Visual Basic Step By Step and put it on the server
hoping to access the SQL Server on the server PC. But VB Step by Step won't
recognize the SQL Server that came with Small Business Server 2003. If I
purchased the Developer's Edition of SQL Server, could I put it on my server
or would I have to move VB to my desktop PC, put SQL Server DE on the
desktop machine and work from there?
> SteveC
VB.NET can see your SBS SQL Server on the local machine as well as across
the network. How are you trying to access the SQL Server? My initial guess
is that you are probably having a security issue.
Try opening a new windows application.
Open the Form
Drag & Drop a SQLConnection Object and follow the wizard.
While in the wizard, use the Trusted Connection option.
HTH
Rick Sawtell
MCT, MCSD, MCDBA

Developer Edition & Windows Server 2003 Small Business Server

I have Small Business Server 2003 and am teaching myself VB.Net. I purchased the package Visual Basic Step By Step and put it on the server hoping to access the SQL Server on the server PC. But VB Step by Step won't recognize the SQL Server that came with Small Business Server 2003. If I purchased the Developer's Edition of SQL Server, could I put it on my server or would I have to move VB to my desktop PC, put SQL Server DE on the desktop machine and work from there?
SteveC"jn316sc" <jn316sc@.discussions.microsoft.com> wrote in message
news:6750BF87-F6EE-4134-A50D-AE9CD88D6F26@.microsoft.com...
> I have Small Business Server 2003 and am teaching myself VB.Net. I
purchased the package Visual Basic Step By Step and put it on the server
hoping to access the SQL Server on the server PC. But VB Step by Step won't
recognize the SQL Server that came with Small Business Server 2003. If I
purchased the Developer's Edition of SQL Server, could I put it on my server
or would I have to move VB to my desktop PC, put SQL Server DE on the
desktop machine and work from there?
> SteveC
VB.NET can see your SBS SQL Server on the local machine as well as across
the network. How are you trying to access the SQL Server? My initial guess
is that you are probably having a security issue.
Try opening a new windows application.
Open the Form
Drag & Drop a SQLConnection Object and follow the wizard.
While in the wizard, use the Trusted Connection option.
HTH
Rick Sawtell
MCT, MCSD, MCDBA

Developer cant handle dates

Do I have to convert dates for a .NET developer so they can capture ms?
Or is there a method they are suppose to be using
I had to remove my modified date check to check for data collisions because they can't pass back microseconds.
What's the dealDepending on which of the .NET languages is being used, and in most of them which data type is being used, temporal data can be stored to the day, second, or true millisecond (which is actually more precise than SQL Server can store).

The short answer becomes something like: If you want absolute portability, convert and send them text (character) data. If they are using C#, C++, or VB then they just have to choose the correct data type. Most of the other .NET languages can store times to millieconds, but depending on the language that can be a pain in the patoot.

-PatP|||This dodges the obvious bullet about most developers not being able to even get a date, much less handle one! ;)

-PatP|||i thought this was a craigslist post.|||OK, CONVERT it is

And why is sql server limited in th MS category?

Something about clock speed?