.NETGURU
  Search:  
NamespacesDiscussions.NET v1.1Dot Net Guru's BlogIT Certification
asp'den sql login ?
Messages   Related Types
This message was discovered on ASPFriends.com 'aspngtr' list.


Ergin YAVUZOL
belki pek yeri olmuyabilir ama çaresiz kaldým; belki yardýmcý olanýnýz olur diye düþündüm, rahatsýzlýk verdiðim için özür dilerim.

* webserver üzerinden dsn olarak sqlserver üzerindeki db yi gösterip login methodu olarak sql login seçtim, yarattýðým kullanýcý ve þifresini girdim, dsn'i test ettiðimde problem yok, ayný zamanda test etmek için ultradev trial kurdum connection dan sql'e verdiðim kullanýcý adý ve þifresi ile ulaþtýðýný ve db table larýný getirdiðini gördüm.Fakat problem þu ki, ne yaptýysam browser üzerinden asp ile ulaþmayý baþaramadým.default user olan "sa" yý bile kullansam sonuç deðiþmiyor problem ne olabilir ?

asp'de connect için yazdýðým string:
Recordset1.ActiveConnection = "dsn=vs;database=vs;uid=sa;pwd=;"

hata------------------------------------------------------------------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

Ýlginize teþekkürler.

Ergin YAVUZOL
Reply to this message...
 
    
Ozkan ALTUNER
connection string olarak bir de sunu dener misiniz?
"data source=127.0.0.1;user id=sa;password="

-----Original Message-----
From: Ergin YAVUZOL [mailto:Click here to reveal e-mail address]
Sent: Friday, October 19, 2001 1:36 PM
To: aspngtr
Subject: [aspngtr] asp'den sql login ?

belki pek yeri olmuyabilir ama çaresiz kaldým; belki yardýmcý olanýnýz
olur diye düþündüm, rahatsýzlýk verdiðim için özür dilerim.

* webserver üzerinden dsn olarak sqlserver üzerindeki db yi gösterip
login methodu olarak sql login seçtim, yarattýðým kullanýcý ve þifresini
girdim, dsn'i test ettiðimde problem yok, ayný zamanda test etmek için
ultradev trial kurdum connection dan sql'e verdiðim kullanýcý adý ve
þifresi ile ulaþtýðýný ve db table larýný getirdiðini gördüm.Fakat
problem þu ki, ne yaptýysam browser üzerinden asp ile ulaþmayý
baþaramadým.default user olan "sa" yý bile kullansam sonuç deðiþmiyor
problem ne olabilir ?

asp'de connect için yazdýðým string:
Recordset1.ActiveConnection = "dsn=vs;database=vs;uid=sa;pwd=;"

hata--------------------------------------------------------------------
----------------------------------
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT
AUTHORITY\ANONYMOUS LOGON'.

Ýlginize teþekkürler.

Ergin YAVUZOL

| [aspngtr] member Click here to reveal e-mail address = YOUR ID
| http://www.asplists.com/asplists/aspngtr.asp = JOIN/QUIT
| http://www.asplists.com/search = SEARCH Archives
Reply to this message...
 
    
I s m a i l Codar
<html><div style='background-color:'><DIV>
<P>Enterprice Manager de Console Root tan serverine sað týkla. Properties den security tabýnda Sql Server and Windows seçilimi ondan emin ol.</P>
<P><BR>Ýsmail Codar </P></DIV>Unicom Bilgisayar Hizmetleri
<DIV></DIV>http://www.unicom.com.tr
<DIV></DIV>Click here to reveal e-mail address
<DIV></DIV>icq# 73847094
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>>From: "Ozkan ALTUNER" <Click here to reveal e-mail address>
<DIV></DIV>>Reply-To: "aspngtr" <Click here to reveal e-mail address>
<DIV></DIV>>To: "aspngtr" <Click here to reveal e-mail address>
<DIV></DIV>>Subject: [aspngtr] RE: asp'den sql login ?
<DIV></DIV>>Date: Sun, 21 Oct 2001 22:33:45 +0300
<DIV></DIV>>
<DIV></DIV>>connection string olarak bir de sunu dener misiniz?
<DIV></DIV>>"data source=127.0.0.1;user id=sa;password="
<DIV></DIV>>
<DIV></DIV>>-----Original Message-----
<DIV></DIV>>From: Ergin YAVUZOL [mailto:Click here to reveal e-mail address]
<DIV></DIV>>Sent: Friday, October 19, 2001 1:36 PM
<DIV></DIV>>To: aspngtr
<DIV></DIV>>Subject: [aspngtr] asp'den sql login ?
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>belki pek yeri olmuyabilir ama çaresiz kaldým; belki yardýmcý olanýnýz
<DIV></DIV>>olur diye düþündüm, rahatsýzlýk verdiðim için özür dilerim.
<DIV></DIV>>
<DIV></DIV>>* webserver üzerinden dsn olarak sqlserver üzerindeki db yi gösterip
<DIV></DIV>>login methodu olarak sql login seçtim, yarattýðým kullanýcý ve þifresini
<DIV></DIV>>girdim, dsn'i test ettiðimde problem yok, ayný zamanda test etmek için
<DIV></DIV>>ultradev trial kurdum connection dan sql'e verdiðim kullanýcý adý ve
<DIV></DIV>>þifresi ile ulaþtýðýný ve db table larýný getirdiðini gördüm.Fakat
<DIV></DIV>>problem þu ki, ne yaptýysam browser üzerinden asp ile ulaþmayý
<DIV></DIV>>baþaramadým.default user olan "sa" yý bile kullansam sonuç deðiþmiyor
<DIV></DIV>>problem ne olabilir ?
<DIV></DIV>>
<DIV></DIV>>asp'de connect için yazdýðým string:
<DIV></DIV>>Recordset1.ActiveConnection = "dsn=vs;database=vs;uid=sa;pwd=;"
<DIV></DIV>>
<DIV></DIV>>hata--------------------------------------------------------------------
<DIV></DIV>>----------------------------------
<DIV></DIV>>Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
<DIV></DIV>>[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT
<DIV></DIV>>AUTHORITY\ANONYMOUS LOGON'.
<DIV></DIV>>
<DIV></DIV>>Ýlginize teþekkürler.
<DIV></DIV>>
<DIV></DIV>>Ergin YAVUZOL
<DIV></DIV>>
<DIV></DIV>>| [aspngtr] member Click here to reveal e-mail address = YOUR ID
<DIV></DIV>>| http://www.asplists.com/asplists/aspngtr.asp = JOIN/QUIT
<DIV></DIV>>| http://www.asplists.com/search = SEARCH Archives
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>| [aspngtr] member Click here to reveal e-mail address = YOUR ID
<DIV></DIV>>| http://www.asplists.com/asplists/aspngtr.asp = JOIN/QUIT
<DIV></DIV>>| http://www.asplists.com/search = SEARCH Archives
<DIV></DIV>>
<DIV></DIV></div><br clear=all><hr>Get your FREE download of MSN Explorer at <a href='http://go.msn.com/bql/hmtag_itl_EN.asp'>http://explorer.msn.com</a><br></html>
Reply to this message...
 
 




ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
Ad


Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews
.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT
Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project
FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.
Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials
 
ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
 Copyright © ExamGuru, Inc. 2001-2006
Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification