Hello community!

Recently I uploaded my website on Azure portal. I built my website with Zend Framework 1.12.

My problem comes when i am trying to link my website with my SQL database.

I have already post a question to Stackoverflow stackoverflow.com/questions/20638706/link-zend-framework-1-12-on-azure-with-a-database-on-azure

Can anyone help me to running over with this problem?

Thanks in advance!

Hello,

Please try to using the follwing parameters into application.ini file:

resources.db.adapter = "pdo_mysql"
resources.db.params.host = "Server_Name.database.windows.net" 
resources.db.params.port = 1433 
resources.db.params.username = "login_name"
resources.db.params.password = "password"
resources.db.params.dbname = "Database_name"
resources.db.isDefaultTableAdapter = true

ReferenceGuidelines for Connecting to Windows Azure SQL Database

Regards,
Fanny Liu

I have already tried this, but i received error and my website doesn't load!

This is my whole cone in application.ini file

[production]
phpSettings.display_startup_errors = 1
phpSettings.display_errors = 1
includePaths.library = APPLICATION_PATH "/../library"
bootstrap.path = APPLICATION_PATH "/Bootstrap.php"
bootstrap.class = "Bootstrap"
appnamespace = "Application"
resources.frontController.controllerDirectory = APPLICATION_PATH "/controllers"
resources.frontController.params.displayExceptions = 1
resources.view.encoding = "UTF-8"
resources.view.doctype = "XHTML1_STRICT"
resources.view.contentType = "text/html;charset=utf-8"

resources.view[] = ""


autoloaderNamespaces[] = "Skoch_"

resources.db.adapter="pdo_mysql" resources.db.params.host="Server_Name.database.windows.net" resources.db.params.port=1433 resources.db.params.username="login_name" resources.db.params.password="password" resources.db.params.dbname="Database_name" resources.db.isDefaultTableAdapter= true

resources.layout.layoutPath = APPLICATION_PATH "/layouts/scripts/"
[staging : production]
resources.frontController.params.displayExceptions = 1
[testing : production]
phpSettings.display_startup_errors = 1
phpSettings.display_errors = 1
resources.frontController.params.displayExceptions = 1

[development : production]
phpSettings.display_startup_errors = 1
phpSettings.display_errors = 1
resources.frontController.params.displayExceptions = 1

• Edited by Sociallgreen 23 hours 4 minutes ago

I have already tried this, but i received error and my website doesn't load!

This is my whole cone in application.ini file

[production]
phpSettings.display_startup_errors = 1
phpSettings.display_errors = 1
includePaths.library = APPLICATION_PATH "/../library"
bootstrap.path = APPLICATION_PATH "/Bootstrap.php"
bootstrap.class = "Bootstrap"
appnamespace = "Application"
resources.frontController.controllerDirectory = APPLICATION_PATH "/controllers"
resources.frontController.params.displayExceptions = 1
resources.view.encoding = "UTF-8"
resources.view.doctype = "XHTML1_STRICT"
resources.view.contentType = "text/html;charset=utf-8"

resources.view[] = ""


autoloaderNamespaces[] = "Skoch_"

resources.db.adapter="pdo_mysql" resources.db.params.host="Server_Name.database.windows.net" resources.db.params.port=1433 resources.db.params.username="login_name" resources.db.params.password="password" resources.db.params.dbname="Database_name" resources.db.isDefaultTableAdapter= true

resources.layout.layoutPath = APPLICATION_PATH "/layouts/scripts/"
[staging : production]
resources.frontController.params.displayExceptions = 1
[testing : production]
phpSettings.display_startup_errors = 1
phpSettings.display_errors = 1
resources.frontController.params.displayExceptions = 1

[development : production]
phpSettings.display_startup_errors = 1
phpSettings.display_errors = 1
resources.frontController.params.displayExceptions = 1

• Edited by Sociallgreen 22 hours 50 minutes ago