Thank you for the quick reply. Yes, I actually have been trying to play around with a few variations, such as not including db_schema, not having quotes, etc, but always end up with the same error. I will also try that DBIC list if I don't get any answers here. Thank you!
On Tue, Sep 11, 2012 at 12:01 PM, Lukas Thiemeier <spamcatc...@thiemeier.net> 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 finding any tables. Anyone have an idea >> of what I might be missing? >> >> I substituted the real ip address, database name, username, and >> password but you get the idea. >> >> This is the command I run: >> >> script\qa_utility_create.pl model DB DBIC::Schema QA_Utility::Schema >> create=static "db_schema=DatabaseName" "dbi:ODBC:Driver={sql >> server};Server=1.1.1.1,1433;Database=DatabaseName" username password >> >> When I run this, I get the below error: >> >> exists "C:\strawberry\perl\site\bin\QA_Utility\lib\QA_Utility\Model" >> exists "C:\strawberry\perl\site\bin\QA_Utility\t" >> Dumping manual schema for QA_Utility::Schema to directory >> C:\strawberry\perl\site\bin\QA_Utility\lib ... >> Schema dump completed. >> WARNING: No tables found, did you forget to specify db_schema? >> exists "C:\strawberry\perl\site\bin\QA_Utility\lib\QA_Utility\Model\DB.pm" >> >> I wanted to quickly get a simple CRUD web app for our existing >> database using perl but I'm starting to think this is not going to >> happen with SQL server? >> > > Hi, > > I think this is more a DBIx::Class issue than a Catalyst issue. I am not > really sure about what I am going write next, but give it a try. Maybe > it helps: > > 1. > If I understand the docs right, specifying a db_schema is only required > if you want to load more than one schema. See > https://metacpan.org/module/DBIx::Class::Schema::Loader#KNOWN-ISSUES > and > https://metacpan.org/module/DBIx::Class::Schema::Loader::Base#db_schema > > Since you specified a database in your dsn, did you try to omit the > db_schema option? > > 2. > I never worked with ODBC, and I am not working on windows. But: > If I try to do the same as you on Unix, using dbi:mysql, I get the same > error as you. If I omit the quotes around "db_schema=..." everything > works fine. I get my schema files created correctly, even if I do not > specify the databasename within the dsn. > > So, try to use > db_schema=DatabaseName > instead of > "db_schema=DatabaseName" > > As I stated before, this answer is more guessing than knowledge. If it > doesn't help, you will have to wait for a more "professional" answer. > > If nobody can help you here, you might try asking the DBIC list, or via > irc in #dbix-class. > > I hope I could help. And if my answer is rubbish, just ignore me :) > > Cheers, lukast > > _______________________________________________ > List: Catalyst@lists.scsys.co.uk > Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst > Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/ > Dev site: http://dev.catalyst.perl.org/ -- Derek Wrobel 425-243-3355 _______________________________________________ List: Catalyst@lists.scsys.co.uk Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/ Dev site: http://dev.catalyst.perl.org/