Thursday, 12 September 2013

How to connect from symfony to SQL Azure database?

How to connect from symfony to SQL Azure database?

I'm having problems connecting Symfony 1.4 with a SQL Azure database.
How to configure databases.yml?
I tried:
#databases.yml
all:
doctrine:
class: sfDoctrineDatabase
#option1
dsn:
sqlsrv:server=tcp:c0yb8ju4aa.database.windows.net,1433;Database=neurodb
#option2
dsn: odbc:DRIVER={SQL
Server};Server=c0yb8ju4aa.database.windows.net;Database=neurodb
#option3
dsn: odbc:Driver={SQL Server Native Client
10.0};Server=tcp:c0yb8ju4aa.database.windows.net,1433;Database=neurodb;Uid=neurodb@c0yb8ju4aa;Pwd=mypass;Encrypt=yes;Connection
Timeout=30;
username: neurodb@c0yb8ju4aa
password: mypass
Option1 says:
Unknown driver sqlsrv
Option2 and Option3 says:
Couldn't locate driver named odbc
Symfony web app is located in an "Azure Website"
Which is the correct way to connect my web app to the database?

No comments:

Post a Comment