[Catalyst] Catalyst - Creating DB dump - Getting “No tables found, did you forget to specify db_schema?” on MS SQL Server connection

2012-09-11 Thread Derek W
I'm trying to create a Catalyst project connecting to an existing MS SQL Server database. I got the correct connection string and it's authenticating, but it's not finding any tables. Anyone have an idea of what I might be missing? I substituted the real ip address, database name, username, and pa

Re: [Catalyst] Catalyst - Creating DB dump - Getting “No tables found, did you forget to specify db_schema?” on MS SQL Server connection

2012-09-11 Thread Derek W
2012 at 12:01 PM, Lukas Thiemeier wrote: > On 09/11/2012 07:56 PM, Derek W wrote: >> I'm trying to create a Catalyst project connecting to an existing MS >> SQL Server database. I got the correct connection string and it's >> authenticating, but it's not find

[Catalyst] Using Catalyst on MS SQL DB that has tables with no primary keys

2012-09-14 Thread Derek W
I seem to be going down a road that is unproductive...I was asked to make a web app to make simple CRUD changes to a few tables on our system (backend). I thought this would be simple, they want it created in Perl, so I searched for any nice frameworks that could accomplish this. I found Catalyst

Re: [Catalyst] Using Catalyst on MS SQL DB that has tables with no primary keys

2012-09-14 Thread Derek W
, Sep 14, 2012 at 11:43 AM, Derek W wrote: >> >> The problem is our database structure here. The 3 tables I need to >> use do not have any relationships set. There is no primary keys on >> these tables. I had to manually code the relationships between the >> tabl

Re: [Catalyst] Using Catalyst on MS SQL DB that has tables with no primary keys

2012-09-14 Thread Derek W
Ah, you meant just on Catalyst side, to tell it that the id column is the primary. I didn't think of that. Thanks! I'll give that a shot. On Fri, Sep 14, 2012 at 11:40 AM, Robert Wohlfarth wrote: > On Fri, Sep 14, 2012 at 1:31 PM, Derek W wrote: >> >> Thanks, I fi

[Catalyst] Help following instructions - FormFu issues

2012-09-20 Thread Derek W
Hi All, I am following the instructions from this tutorial: http://search.cpan.org/~zarquon/Catalyst-Manual-5.9004/lib/Catalyst/Manual/Tutorial/09_AdvancedCRUD/09_FormFu.pod But am using my own database. I have a MS SQL database with 3 tables (no primary keys) linked as follows: Table: Groups C