By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,943 Members | 1,921 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,943 IT Pros & Developers. It's quick & easy.

Session ID

P: n/a
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
Nov 18 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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
Nov 18 '05 #2

P: n/a
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
Nov 18 '05 #3

P: n/a
so how to generate a GUID for each DB record
"Patrice" <no****@nowhere.com> 在郵件 news:%2****************@TK2MSFTNGP11.phx.gbl 中撰寫...
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
Nov 18 '05 #4

P: n/a
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> 在郵件 news:%2****************@TK2MSFTNGP11.phx.gbl 中撰寫...
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
Nov 18 '05 #5

P: n/a
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
Nov 18 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.