Can you send me your database.yml config file?

I tried to test symfony with MSSQL too, but I can't even connect to the MSSQL server. I always receive the error:

"[wrapped: connect failed [Native Error: ] [User Info: Array]]"

This is my database.yml file:

all:
  propel:
    class:          sfPropelDatabase
    param:
      dsn:          [url]mssql://sa@servername/Northwind[/url]

The strange thing is that I can connect with another php code snippet that uses adodb:

<?php
$db = new COM("ADODB.Connection");
$dsn = "DRIVER={SQL Server}; SERVER={servername};UID={sa};PWD={}; DATABASE={Northwind}";
$db->Open($dsn);
$rs = $db->Execute("SELECT * FROM categories");

while (!$rs->EOF)
{
   echo $rs->Fields['categoryName']->Value."<BR>";
   $rs->MoveNext();
}
?>

impiastro

Welcome both, to the forum. (By the way, if you could wrap your yml in [code] tags, and your php in [php] tags, it makes things much more readable - more here).

I've not used MS SQL with symfony, but there is a Creole driver for it, so I should think it would work. Also, there is an ODBC driver, if you would rather access it that way.

impiastro, your standalone snippet is going through ODBC, not the native MS SQL calls. Try the calls here to get a fair comparison.

xyzzy, it sounds like you have connected successfully, so you are part way there. I'd suggest that you check that your primary key is marked as such in your schema. Also, ensure that you haven't inadvertently reset the value of your key in the Propel object it belongs to.

halfer

The configuration I was using:

The databases.yml has this:

all:
  propel:
    class:          sfPropelDatabase
    param:
      dsn:          mssql://blah:blah@localhost/blah

and propel.ini has this (I had to change database name/type after finding that whatever was specified in doc for SQL Server was wrong):

propel.database            = mssql
propel.database.createUrl  = mssql://blah:blah@localhost/
propel.database.url        = mssql://blah:blah@localhost/blah

I never got past problem with update mentioned in original post and had to give up on using symfony due to time constraints but hopefully I'll get back to it one of these days and will try suggestions given in response to your post (thanks for those to whoever made them). One problem in my case is that I can only access the SQL Server database via stored procedures so most of the benefits of Symfony O/R mapping wouldn't be available to me.

xyzzy

I still think it's an issue with your primary key. Could you post your yaml or xml schema, for just this table, in [code] tags?

Meanwhile, symfony's ORM is okay, but it's not the major benefit, to my mind - the best thing is the way it separates an app out into logical layers. It is possible to refactor code files to have 100-200 lines, depending on ones preference, and this keeps things very neat and maintainable indeed.

You can incidentally extend your data layer to access stored procedures (using raw sql) and return the results from the most appropriate part of your model.

halfer

Report message to a moderator

Here's the definition from schema.yml:

weblog_comment:
  _attributes: { phpName: Comment }
  id:
  post_id:
  author:      varchar(255)
  email:       varchar(255)
  body:        longvarchar
  created_at:

So you're right that there's no indication that the id field is the primary key, but I checked the configuration that seemed to work with MySQL and it was the same there, so maybe this is a SQL Server glitch? Or maybe this isn't the snippet of interest?

xyzzy

Not necessarily. It may be that MySQL allows its PKs to be overwritten, and MSSQL does not. Check the documentation on yaml schemas, ensure that your PK is labelled as a PK, and then try again. I suspect that will ensure it works with both db platforms.

documented on: 29 October 2006, halfer