Komentar

It should work properly if your database connection info is correct.

I’m sorry for that question,
Yeah I already use connectionstring, but its not running
🙁

Do not use ConnectionString, use connectionstring instead!

Of course you need to adjust your database connection in localhost. That’s the stupid question you ask!

I try it already but not running, do I need to adjust the
Data Source in localhost ?

Just try it, then you will know whether it is correct or not.

// Database Connecting event
function Database_Connecting(&$info) {
    // Example:
    //var_dump($info);
    if (ew_CurrentUserIP () == "127.0.0.1"  || ew_CurrentUserIP () == ":: 1"  || ew_CurrentHost () == "localhost" ) { // testing on local PC  
        $info["ConnectionString"]= "Provider=SQLNCLI10;Persist Security Info=False;Data Source=localhost;Initial Catalog=mydbname;User Id=sa;Password=saww"; 
    } else { // database connection settings for the computer server
        $info["ConnectionString"]= "Provider=SQLNCLI10;Persist Security Info=False;Data Source=test2;Initial Catalog=mydbname;User Id=sa;Password=saww"; 
   }
}

is this correct ?

Hi,

I’m little confused, I’m just a beginner do you have any sample for this so that I have any reference and guide.

Thank you, for your help

Much appreciated

Of course it won’t work. You have to learn and understand the logic in the Database_Connecting server event.

In other words, you have to handle the connectionstring for the localhost connection and for the remote connection.

Do not get confused about my comment that told you about do not mix about the MySQL and SQL Server connection above.

All you have to do is to handle the SQL Server connection, one for the localhost server, and the other for the remote server.

I use that only, but I don’t know why is not running 🙁

/ Database Connecting event
function Database_Connecting(&$info) {
	// Example:
	//var_dump($info);
	$info["connectionstring"] = "Provider = SQLNCLI10; Persist Security Info = False; Data Source = test2; Initial Catalog = mydbtable; User Id = sa; Password = saww"; 
}

I answer your question by asking you a question: “What do you think?” 🙂

Hi,

Thank you for your help, just want to know if I need to use if and else or just this one

$info["connectionstring"] = "Provider = SQLNCLI10; Persist Security Info = False; Data Source = localhost; Initial Catalog = namaDatabase; User Id = sa; Password = xxxx"; // ADO connection string, adjust to the conditions in your server 

only?

Thank you 🙂

Saya sebutkan di komentar saya sebelumnya dengan istilah tidak jelas, karena variable di URL menggunakan recperpage, tapi Anda menggunakan variable GET yang bernama week.

Ya jelas gak nyambunglah.