Session ID

[Grey]

How long of the SessionID created as I need to store in Access DB, is it possible? Can I use it as unique identifier for creating a record in DB as primary key??

Million Thanks

[Bojidar Alexandrov]

If I remember correctly is 32 bit Integer.
It is not guranteed that they are unique especially if Web server is restarted.

Bojidar Alexandrov
"Grey" <er*****@i-cable.com> wrote in message news:eh*************@TK2MSFTNGP11.phx.gbl...
How long of the SessionID created as I need to store in Access DB, is it possible? Can I use it as unique identifier for creating a record in DB as primary key??

Million Thanks

[Patrice]

As there is no relation between these, I would just use an auto increment number or a guid as usual. If tomorrow, you want to use the same technique to create several records, you'll have anyway a problem.

Patrice
"Grey" <er*****@i-cable.com> a ecrit dans le message de news:eh*************@TK2MSFTNGP11.phx.gbl...
How long of the SessionID created as I need to store in Access DB, is it possible? Can I use it as unique identifier for creating a record in DB as primary key??

Million Thanks

[Grey]

so how to generate a GUID for each DB record
"Patrice" <no****@nowhere.com> ¦b¶l¥ó news:%2****************@TK2MSFTNGP11.phx.gbl ¤¤¼¶¼g...
As there is no relation between these, I would just use an auto increment number or a guid as usual. If tomorrow, you want to use the same technique to create several records, you'll have anyway a problem.

Patrice
"Grey" <er*****@i-cable.com> a ecrit dans le message de news:eh*************@TK2MSFTNGP11.phx.gbl...
How long of the SessionID created as I need to store in Access DB, is it possible? Can I use it as unique identifier for creating a record in DB as primary key??

Million Thanks

[Patrice]

In the Access DB when choosing an autonum or a numeric field, you have the "replication number" option that is a GUID (possibly autogenerated for "autonum"). You can also create a GUID using .NET and System.Guid.NewGuid. Note that a GUID is not directly printable. You have to convert it to a string.

Patrice

"Grey" <er*****@i-cable.com> a ecrit dans le message de news:O0**************@TK2MSFTNGP12.phx.gbl...
so how to generate a GUID for each DB record
"Patrice" <no****@nowhere.com> ¦b¶l¥ó news:%2****************@TK2MSFTNGP11.phx.gbl ¤¤¼¶¼g...
As there is no relation between these, I would just use an auto increment number or a guid as usual. If tomorrow, you want to use the same technique to create several records, you'll have anyway a problem.

Patrice
"Grey" <er*****@i-cable.com> a ecrit dans le message de news:eh*************@TK2MSFTNGP11.phx.gbl...
How long of the SessionID created as I need to store in Access DB, is it possible? Can I use it as unique identifier for creating a record in DB as primary key??

Million Thanks

[Alvin Bruney [MVP]]

session id's are guaranteed for the application. please note that certain circumstances cause session id's to be re-used. In that case they won't be regenerated and may appear to be non-unique entities. No guarantee is made about uniqueness across webserver boundaries.

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
"Bojidar Alexandrov" <bo**@kodar.net> wrote in message news:uw**************@tk2msftngp13.phx.gbl...
If I remember correctly is 32 bit Integer.
It is not guranteed that they are unique especially if Web server is restarted.

Bojidar Alexandrov
"Grey" <er*****@i-cable.com> wrote in message news:eh*************@TK2MSFTNGP11.phx.gbl...
How long of the SessionID created as I need to store in Access DB, is it possible? Can I use it as unique identifier for creating a record in DB as primary key??

Million Thanks