What is a "Foreword" to a blog?
asp
Hello Guest
  
  • Login
• Register…
• Start blog
  • Who, Where, When
• What can I do?
• What to Read?
  • Polls
• Avatars
• Interests
  • Cities and Countries
• Random blog
• Users search
  • Search
• Games
• Tests
• QAIX
  • Сообщества
• Talxy Chat
• Horoscope
• Online
 
Зарегистрируйся!

QAIX > ASP web-programming > asp 16 September 2008 07:38:28

  Recent blog posts: 
  Forums:   
  Discuss: 
  Recent forum topics: 
  Recent forum comments:
  Moderators:

asp

Test 16 September 2008 07:38:28
 Vendor software set password field as binary in sql server 2000

I would like to write asp to check the user name and password

how can i check and match that field?

it shows errors when match with binary field

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]The text, ntext, and image
data types cannot be compared or sorted, except when using IS NULL or LIKE
operator.


Add comment
Guest 21 January 2005 05:05:31 permanent link ]
 Hello,

First you need to make sure the password is not encrypted in the database
from the Vendor. To authenticate the password, you cannot use a Select
Query like "select * from table where name='..' and password='...'"
directly. You can get the password by user name first, like "select
password from table where name='..'". And then convert the binary data into
a string and compare with user input in your ASP code.

Luke

Add comment
Test 21 January 2005 09:28:09 permanent link ]
 wowow
thanks for your idea

1. check with vendor
2. change binary to string
"[MSFT]" <lukezhan@online.mi­crosoft.com> wrote in message
news:BLt4121$EHA.13­92@cpmsftngxa10.phx.­gbl...> Hello,>
First you need to make sure the password is not encrypted in the database> from the Vendor. To authenticate the password, you cannot use a Select> Query like "select * from table where name='..' and password='...'"> directly. You can get the password by user name first, like "select> password from table where name='..'". And then convert the binary data
into> a string and compare with user input in your ASP code.>
Luke>


Add comment
Guest 24 January 2005 05:35:03 permanent link ]
 Thank you for the update.

Luke

Add comment
Guest 12 December 2006 10:53:02 permanent link ]
 hello there... i'm just thinking about the windows api with asp.. is it
posible to attach or put the windows api code inside the asp? because i
want to retrieve a client computer name. so i decided to use the
windows api, is it possible? can somebody give me sample?

another question, how can i retrieve a client computer name using
serverVariable? coz i'm using that string in registration form.. i want
automatically call or get the computer name...

thanks in advance...

Add comment
Guest 12 December 2006 14:32:11 permanent link ]
 can somebody give a simple control/example using windows API with asp
or asp.net?? or somebody can tell me anything regarding with the
relationship between windows api to asp?

thanks in advance


best regards,

francis fajardo

Add comment
Bob Barrows 12 December 2006 14:47:00 permanent link ]
 iskofajardo@yahoo.co­m wrote:
can somebody give a simple control/example using windows API with asp
or asp.net?? or somebody can tell me anything regarding with the
relationship between windows api to asp?
ASP and ASP.Net are quite different technologies so it is unlikely you will
get hel with it in a classic ASP newsgroup such as this. I would suggest
microsoft.public.do­tnet.framework.aspne­t.

With classic ASP, there is no way to directly use API functions from script
technology. You have to build a "wrapper" dll, perhaps using VB6, to do
this. Google should provide you with examples.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


Add comment
Patrice 12 December 2006 15:04:10 permanent link ]
 You can't call an API directly from an ASP page. You could create a wrapper
DLL to call this API.

But keep also in mind that the ASP code runs server side.

Here it looks like you want to get the client computer name. The best you
can easily do would be to use the REMOTE_HOST server variables to get its
name or IP (likely IP).

Try :
http://www.w3school­s.com/asp/coll_serve­rvariables.asp

Else you could perhaps use a scripting object suhc as :
http://www.winguide­s.com/scripting/refe­rence.php?id=127 but i('s likely
you'll have to alter the security settings as this is likely not supposed to
be available to all websites you are visiting.

If this is because you want the application to be available from partiuclar
computers this is AFAIK quite difficult. The best you could easily do would
be to make sure that only a single account can use the application from a
single computer at a time (i.e. not possible to open multiple sessions under
the same account). Also what if the user changes its computer...

--
Patrice

<iskofajardo@yahoo.­com> a Иcrit dans le message de news:
1165909982.774650.2­41420@n67g2000cwd.go­oglegroups.com...
hello there... i'm just thinking about the windows api with asp.. is it
posible to attach or put the windows api code inside the asp? because i
want to retrieve a client computer name. so i decided to use the
windows api, is it possible? can somebody give me sample?
another question, how can i retrieve a client computer name using
serverVariable? coz i'm using that string in registration form.. i want
automatically call or get the computer name...
thanks in advance...


Add comment
Guest 12 December 2006 16:16:45 permanent link ]
 thank you so much for the information Patrice...

coz before i thought that the code of windows api can also call
directly to the asp..

Patrice wrote:
You can't call an API directly from an ASP page. You could create a wrapper
DLL to call this API.
But keep also in mind that the ASP code runs server side.
Here it looks like you want to get the client computer name. The best you
can easily do would be to use the REMOTE_HOST server variables to get its
name or IP (likely IP).
Try :
Else you could perhaps use a scripting object suhc as :
you'll have to alter the security settings as this is likely not supposed to
be available to all websites you are visiting.
If this is because you want the application to be available from partiuclar
computers this is AFAIK quite difficult. The best you could easily do would
be to make sure that only a single account can use the application from a
single computer at a time (i.e. not possible to open multiple sessions under
the same account). Also what if the user changes its computer...
--
Patrice
<iskofajardo@yahoo.­com> a crit dans le message de news:
1165909982.774650.2­41420@n67g2000cwd.go­oglegroups.com...
hello there... i'm just thinking about the windows api with asp.. is it
posible to attach or put the windows api code inside the asp? because i
want to retrieve a client computer name. so i decided to use the
windows api, is it possible? can somebody give me sample?
another question, how can i retrieve a client computer name using
serverVariable? coz i'm using that string in registration form.. i want
automatically call or get the computer name...
thanks in advance...

Add comment
Guest 12 December 2006 16:23:29 permanent link ]
 how can i create a wrapper DLL, coz i really don't try it even before.


Patrice wrote:
You can't call an API directly from an ASP page. You could create a wrapper
DLL to call this API.
But keep also in mind that the ASP code runs server side.
Here it looks like you want to get the client computer name. The best you
can easily do would be to use the REMOTE_HOST server variables to get its
name or IP (likely IP).
Try :
Else you could perhaps use a scripting object suhc as :
you'll have to alter the security settings as this is likely not supposed to
be available to all websites you are visiting.
If this is because you want the application to be available from partiuclar
computers this is AFAIK quite difficult. The best you could easily do would
be to make sure that only a single account can use the application from a
single computer at a time (i.e. not possible to open multiple sessions under
the same account). Also what if the user changes its computer...
--
Patrice
<iskofajardo@yahoo.­com> a crit dans le message de news:
1165909982.774650.2­41420@n67g2000cwd.go­oglegroups.com...
hello there... i'm just thinking about the windows api with asp.. is it
posible to attach or put the windows api code inside the asp? because i
want to retrieve a client computer name. so i decided to use the
windows api, is it possible? can somebody give me sample?
another question, how can i retrieve a client computer name using
serverVariable? coz i'm using that string in registration form.. i want
automatically call or get the computer name...
thanks in advance...

Add comment
Patrice 13 December 2006 11:57:22 permanent link ]
 IMO this approach won't work anyway. Keep in mind that as I said the ASP
page runs SERVER SIDE i.e. you'll get the name of the server if this code
runs from the ASP page. This code should run CLIENT SIDE but the user will
have to accept your ActiveX control etc...

I saw in another thread that the goal is that you want to create
automatically a user name upon registration. If this is in your company you
could just use integrated authentication so that the web site automatically
knows who is the user (uisng Request.ServerVaria­bles("AUTH_USER")).

If not it won't work anyway as you could have multiple users having the same
computer name for example (beside the difficulty that likely not worth). See
around and you'll see that you have no web site using this info to create a
user name.

Generaly it is done by using some information entered by the user (email,
some calculation based upon the user lastname and firstname etc...). In some
cases it is just a "random" username (for example some random letters
followed by some random numbers).

--
Patrice

<iskofajardo@yahoo.­com> a Иcrit dans le message de news:
1165929809.578329.2­87070@l12g2000cwl.go­oglegroups.com...
how can i create a wrapper DLL, coz i really don't try it even before.


Patrice wrote:
You can't call an API directly from an ASP page. You could create a
wrapper
DLL to call this API.
But keep also in mind that the ASP code runs server side.
Here it looks like you want to get the client computer name. The best you
can easily do would be to use the REMOTE_HOST server variables to get its
name or IP (likely IP).
Try :
Else you could perhaps use a scripting object suhc as :
you'll have to alter the security settings as this is likely not supposed
to
be available to all websites you are visiting.
If this is because you want the application to be available from
partiuclar
computers this is AFAIK quite difficult. The best you could easily do
would
be to make sure that only a single account can use the application from a
single computer at a time (i.e. not possible to open multiple sessions
under
the same account). Also what if the user changes its computer...
--
Patrice
<iskofajardo@yahoo.­com> a Иcrit dans le message de news:
1165909982.774650.2­41420@n67g2000cwd.go­oglegroups.com...
hello there... i'm just thinking about the windows api with asp.. is it
posible to attach or put the windows api code inside the asp? because i
want to retrieve a client computer name. so i decided to use the
windows api, is it possible? can somebody give me sample?
another question, how can i retrieve a client computer name using
serverVariable? coz i'm using that string in registration form.. i want
automatically call or get the computer name...
thanks in advance...


Add comment
Guest 13 December 2006 13:24:57 permanent link ]
 ok... thanx for the information again...

can i asked another question? ok, do you have any sample contol which
is using Windows API code with ASP? or even in ASP.NET?

coz i only try to use the Windows API code inside the Visual Basic6.0
in getting the computer name. where can i use Wimdows API, as a CLIENTS
SIDE or a SERVER SIDE?


Patrice wrote:
IMO this approach won't work anyway. Keep in mind that as I said the ASP
page runs SERVER SIDE i.e. you'll get the name of the server if this code
runs from the ASP page. This code should run CLIENT SIDE but the user will
have to accept your ActiveX control etc...
I saw in another thread that the goal is that you want to create
automatically a user name upon registration. If this is in your company you
could just use integrated authentication so that the web site automatically
knows who is the user (uisng Request.ServerVaria­bles("AUTH_USER")).
If not it won't work anyway as you could have multiple users having the same
computer name for example (beside the difficulty that likely not worth). See
around and you'll see that you have no web site using this info to create a
user name.
Generaly it is done by using some information entered by the user (email,
some calculation based upon the user lastname and firstname etc...). In some
cases it is just a "random" username (for example some random letters
followed by some random numbers).
--
Patrice
<iskofajardo@yahoo.­com> a crit dans le message de news:
1165929809.578329.2­87070@l12g2000cwl.go­oglegroups.com...
how can i create a wrapper DLL, coz i really don't try it even before.
Patrice wrote:
You can't call an API directly from an ASP page. You could create a
wrapper
DLL to call this API.
But keep also in mind that the ASP code runs server side.
Here it looks like you want to get the client computer name. The best you
can easily do would be to use the REMOTE_HOST server variables to get its
name or IP (likely IP).
Try :
Else you could perhaps use a scripting object suhc as :
you'll have to alter the security settings as this is likely not supposed
to
be available to all websites you are visiting.
If this is because you want the application to be available from
partiuclar
computers this is AFAIK quite difficult. The best you could easily do
would
be to make sure that only a single account can use the application from a
single computer at a time (i.e. not possible to open multiple sessions
under
the same account). Also what if the user changes its computer...
--
Patrice
<iskofajardo@yahoo.­com> a crit dans le message de news:
1165909982.774650.2­41420@n67g2000cwd.go­oglegroups.com...
hello there... i'm just thinking about the windows api with asp.. is it
posible to attach or put the windows api code inside the asp? because i
want to retrieve a client computer name. so i decided to use the
windows api, is it possible? can somebody give me sample?
another question, how can i retrieve a client computer name using
serverVariable? coz i'm using that string in registration form.. i want
automatically call or get the computer name...
thanks in advance...

Add comment
Patrice 13 December 2006 15:52:09 permanent link ]
 As said earlier if you really want to, you could reuse the WScript.Network
object (but not sure it will run client side with default security settings)
:
http://www.winguide­s.com/scripting/refe­rence.php?id=127

FYI, how to create an ActiveX DLL. For example with VB 5 :
http://support.micr­osoft.com/kb/193998/­en-us (VB could then use the Declare
statement to call a Windows API call).

Should be fine technically but I still suggest to double check the trade off
between your needs and usability...

--
Patrice

<iskofajardo@yahoo.­com> a Иcrit dans le message de news:
1166005496.888911.5­2020@j72g2000cwa.goo­glegroups.com...
ok... thanx for the information again...

can i asked another question? ok, do you have any sample contol which
is using Windows API code with ASP? or even in ASP.NET?

coz i only try to use the Windows API code inside the Visual Basic6.0
in getting the computer name. where can i use Wimdows API, as a CLIENTS
SIDE or a SERVER SIDE?


Patrice wrote:
IMO this approach won't work anyway. Keep in mind that as I said the ASP
page runs SERVER SIDE i.e. you'll get the name of the server if this code
runs from the ASP page. This code should run CLIENT SIDE but the user will
have to accept your ActiveX control etc...
I saw in another thread that the goal is that you want to create
automatically a user name upon registration. If this is in your company
you
could just use integrated authentication so that the web site
automatically
knows who is the user (uisng Request.ServerVaria­bles("AUTH_USER")).
If not it won't work anyway as you could have multiple users having the
same
computer name for example (beside the difficulty that likely not worth).
See
around and you'll see that you have no web site using this info to create
a
user name.
Generaly it is done by using some information entered by the user (email,
some calculation based upon the user lastname and firstname etc...). In
some
cases it is just a "random" username (for example some random letters
followed by some random numbers).
--
Patrice
<iskofajardo@yahoo.­com> a Иcrit dans le message de news:
1165929809.578329.2­87070@l12g2000cwl.go­oglegroups.com...
how can i create a wrapper DLL, coz i really don't try it even before.
Patrice wrote:
You can't call an API directly from an ASP page. You could create a
wrapper
DLL to call this API.
But keep also in mind that the ASP code runs server side.
Here it looks like you want to get the client computer name. The best
you
can easily do would be to use the REMOTE_HOST server variables to get
its
name or IP (likely IP).
Try :
Else you could perhaps use a scripting object suhc as :
you'll have to alter the security settings as this is likely not
supposed
to
be available to all websites you are visiting.
If this is because you want the application to be available from
partiuclar
computers this is AFAIK quite difficult. The best you could easily do
would
be to make sure that only a single account can use the application from
a
single computer at a time (i.e. not possible to open multiple sessions
under
the same account). Also what if the user changes its computer...
--
Patrice
<iskofajardo@yahoo.­com> a Иcrit dans le message de news:
1165909982.774650.2­41420@n67g2000cwd.go­oglegroups.com...
hello there... i'm just thinking about the windows api with asp.. is
it
posible to attach or put the windows api code inside the asp? because
i
want to retrieve a client computer name. so i decided to use the
windows api, is it possible? can somebody give me sample?
another question, how can i retrieve a client computer name using
serverVariable? coz i'm using that string in registration form.. i
want
automatically call or get the computer name...
thanks in advance...


Add comment
Bullschmidt 16 September 2008 07:38:28 permanent link ]
 And here's a similar handy reference:

Visual Basic Scripting Edition VBScript Language Reference
http://msdn.microso­ft.com/en-us/library­/d1wf56tt(VS.85).asp­x

Best regards,
J. Paul Schmidt, Freelance Web and Database Developer
http://www.Bullschm­idt.com
Access Database Sample, Web Database Sample, ASP Design Tips

*** Sent via Developersdex http://www.develope­rsdex.com ***
Add comment
 

Add new comment

As:
Login:  Password:  
 
 
  
 
Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.


QAIX > ASP web-programming > asp 16 September 2008 07:38:28

see also:
[EJB/JBoss] - Re: ejb and java web…
[Nukes User] - Re: Problem with the RSS…
[Management, JMX/JBoss] - Response Time…
пройди тесты:
see also:
Special Offer and Best Free Gift for…
How to watch E-book, DVD on iPod and…
Free Ping of death tool, coded by…

  Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:
If you would like to report an abuse of our service, such as a spam message, please .