Session ID

  • Thread starter Thread starter Grey
  • Start date Start date
G

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
 
If I remember correctly is 32 bit Integer.
It is not guranteed that they are unique especially if Web server is restarted.

Bojidar Alexandrov
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
 
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" <[email protected]> a ecrit dans le message de 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
 
so how to generate a GUID for each DB record
"Patrice" <[email protected]> ¦b¶l¥ó ¤¤¼¶¼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" <[email protected]> a ecrit dans le message de 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
 
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" <[email protected]> a ecrit dans le message de so how to generate a GUID for each DB record
"Patrice" <[email protected]> ¦b¶l¥ó ¤¤¼¶¼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" <[email protected]> a ecrit dans le message de 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
 
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
If I remember correctly is 32 bit Integer.
It is not guranteed that they are unique especially if Web server is restarted.

Bojidar Alexandrov
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
 
Back
Top