Answer

SqlConnection...Please help!!

fadil1977

20y

1.9k

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)

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

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