1
Answer

SqlConnection...Please help!!

fadil1977

fadil1977

20y
1.9k
1
Hi !! I have a code that runs from a different machine and a different site and i am facing a problem that i can not log in to the database.I installed SQL Server on my machine and I created a user "fadila" and SQL Server Authentication and the password is "fadil1977" and the database is "otters" and it is installed as tables and stored procedures but there is not data on these tables. I used the method provided in the code so, i only change the "connStr" in one place rather than in 20 places and my code is as below. Can you please Help me to connect to the database. I Really..Really appreciate it if you help me to solve it as it causeing me a big head-ache and still get the error message "SQL Server does not exist or access denied" .. please help!!!! Friend Shared ReadOnly Property connStr() As String Get Return String.Format( _ "Data Source={0};Initial Catalog=Otters;User ID=fadila;Password=fadil1977", _ DatabaseMachine) End Get End Property
Answers (1)
0
Nilesh Shah

Nilesh Shah

NA 22.3k 214.8k 7y

If not using server on session, then you can use cookies on client side

but I fail to understand why you don't want to use session? it helps in managing user requests in betterway. what you want to achieve by not using session? 

Accepted
2
Nilesh Shah

Nilesh Shah

NA 22.3k 214.8k 7y

if you have memory issues, then instead of storing session in-proc (in memory),you can store the session in database server. this way ur memory will not be occupied by session

if at all you dont want to use session, then you can maintain user data using cookies or using query string

1
Nilesh Shah

Nilesh Shah

NA 22.3k 214.8k 7y

1000 concerent users is nothing, even the sites with millions of concerent users implement sessions

it depends on what resources you have

are you going to host by your own? or on cloud?
 
it will be better if you provide all the info. together while posting question, instead of writing bits and pieces in different replies 
-1
Pradeep Yadav

Pradeep Yadav

NA 1.8k 150.6k 7y
You think it as 1000 concerent users.
 Then.......?
-1
Pradeep Yadav

Pradeep Yadav

NA 1.8k 150.6k 7y
Huge user , memory issue
 
However cookies are not safe.