Re: Not finding GUID value after migration sql 2005 to 2000

--CELKO--

>My application takes that value and uses that as a parameter for an SQL query to retrieve the user's data, which works fine on my 2005 server but breaks on the 2000 server. <<

This might be one reason that web apps are using email addresses to
identify users, and implement on LAMP instead?

Jun 27 '08 #1

Subscribe Reply

1878

Zark3

On 17 jun, 17:40, --CELKO-- <jcelko...@eart hlink.netwrote:

This might be one reason that web apps are using email addresses to
identify users, and implement on LAMP instead?

If I would've written the main application, I certainly would have.
Unfortunately, I'm just writing a reporting plugin that needs to use
the login session of the root web, so I'm stuck on getting this to
work with the guids instead of being able to change the login
scheme. :(

Thanks though,
Chris

Jun 27 '08 #2

Tony Rogerson

This might be one reason that web apps are using email addresses to

identify users, and implement on LAMP instead?

Yet again you think "only the database".

Yes, the application front end will take an email address from the user as a
login, but once logged in it uses a guid; but the great majority of people
use a GUID for the application plumbing - even the Microsoft session state
stuff.

Have you ever signed up for google services or ebay or paypal? The email
confirmation url you receive is GUID centric.

--
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]
http://sqlserverfaq.com
[UK SQL User Community]

Jun 27 '08 #3

Tony Rogerson

identify users, and implement on LAMP instead?

Why are you selling LAMP so much? The statistics say you are wrong on that
as well.

Let's see....

You give inaccurate and often dam right dangerous advice on MICROSOFT SQL
SERVER
You are now selling LAMP
You fail to recognise the ETL, Data Mining, Reporting and Cube (BI) tools
that ship with the product
You spend 99.9% of your time on MICROSOFT SQL SERVER instead of spreading
your standards gospel on the Oracle and DB2 and Sybase groups

It almost appears you are being paid by a Microsoft competitor or are just
so anti Microsoft you think you'd play some games with the people using the
product.

--
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]
http://sqlserverfaq.com
[UK SQL User Community]

Jun 27 '08 #4

Similar topics

1369

Migration Tools For 2005 Express

by: Bungle | last post by:

Hi everyone Does anyone know or has anyone heard of any migration tools which are/might be available for converting SQL Server 2000 databases to SQL Server 2005 Express? I'm guessing it is probably a bit early but it was worth a shot! Thanks Dave

Microsoft SQL Server

34831

Guid.Empty

by: Rene | last post by:

I am using the Guid.Empty value ("00000000-0000-0000-0000-000000000000") to represent a special meaning. The problem is that I don't know if there is a chance that a command like "Guid.NewGuid()"would generate a Guid.Empty value could this be possible or is the "00000000-0000-0000-0000-000000000000" Guid reserved or something like that? Thank you.

C# / C Sharp

21950

How to create a Guid Constant.

by: ESPNSTI | last post by:

Hi, I'd like to create a Guid constant and the following doesn't work (Cannot implicitly convert type 'string' to 'System.Guid') : public const Guid MyGuid = "{ccae2079-2ebc-4200-879d-866fc82e6afa}"; Ideas? Thanks,

C# / C Sharp

20983

Getting a unique ID in SQL Server - other than a GUID

by: Brad Eck | last post by:

In Access, newID returns a unique for the table. In SQL Server, newid() returns a GUID - unique in the world. I do not need or desire that complexity. Is there a way to get a simple unique int on the table in SQL Server? Brad Eck http://www.sitesdynamic.com http://www.basketsetcetera.com *** Sent via Developersdex http://www.developersdex.com ***

Microsoft SQL Server

6493

System.Guid

by: Michael Primeaux | last post by:

I have a simple .NET 2.0 web service created with VS.NET 2005 with a single web method with the following signature: void HelloWorld(Guid parameter1); When calling this method I receive the following error: System.IndexOutOfRangeException: Index was outside the bounds of the array. at System.Web.Services.Protocols.HttpServerType..ctor(Type type) at System.Web.Services.Protocols.HttpServerProtocol.Initialize()

.NET Framework

18992

Default value of a GUID field?!

by: Leon_Amirreza | last post by:

I have a column named "ID" and its type is "uniqueidentifier" in SQL Server 2005 Express. this column is the primary key and its default value is "newid()" in SQL Server. I have generated a DataSet in C# that has this column but its default value is DBNull what can I do to make the default value be the return value of this function ( or I want the Id be generated by default in the DataSet)? System.Guid.NewGuid()

.NET Framework

16178

C# RSS feed generator & building the guid element

by: Troll | last post by:

Windows XP Pro VS 2005 & C# (I'm fairly new to C# but have doing VB.Net going on 2yrs and VB6 for 5yrs.) I'm using C# to build a custom RSS generator. I'm having trouble building the guid element for each item node in my feed. Some items do not have the "link" node because the description element is the content. So using the "link" as the guid will not work in my case, as some sites suggest and as feedvalidator.org complains when I do not...

.NET Framework

5715

Problem with System.Guid and duplicate key

by: Jeff | last post by:

ASP.NET 2.0 This problem occur using the basic version of SQL Server 2005 which get installed when installing Visual Studio 2005! I have inserted a record in the Test table. But when I try to insert a second record I get this error: {"Violation of PRIMARY KEY constraint 'PK_Test'. Cannot insert duplicate key in object 'dbo.Test'.

ASP.NET

5303

Returning guid from inserted row in SQL server 2005

by: Steve | last post by:

Hi All Can someone help get the rowGUID value after an insert I am using VB.net 2005 and SQL server Express 2005 The column GUID is an uniqueidentifier column with default value (newsequentialid()) The following is my current function which is clumsy to say the least

Visual Basic .NET

8851

Problem With Comparison Operator <=> in G++

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

C / C++

8528

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

7356

AI Job Threat for Devs

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

Career Advice

5649

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

4175

Trying to create a lan-to-lan vpn between two differents networks

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

Networking - Hardware / Configuration

4335

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2752

transfer the data from one system to another through ip address

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

C# / C Sharp

1976

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1737

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General