The problem is that since you did not specify a name for the .table files
you get default (nobody does). default is a hash of the db uri so if you
change it the .table files break. If this is just a change in the name but
the tables are already in the database, the you should enable a
fake_migration
(http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#migrate--fake_migrate)
so that new .table files are created. If this is a new database, you need
to enable migrations (I see they are disabled for you). Make sure you do
not change the database schema until this is resolved else there is no way
for me to tell in which state you db and your .table are.
Massimo
On Monday, 2 February 2015 08:29:23 UTC-6, Omi Chiba wrote:
>
> The below connection statement was working fine and the SQL Servers's
> instance was HELPDESK/HELPDESK.
>
> dbh = DAL("mssql2://username:password@HELPDESK/HS2000CS",
> migrate_enabled=False)
>
> Now, our vendor change the name of instance to HELPDESK/HELPDESK_VM.
>
> I tried,
> dbh = DAL("mssql2://username:password@[HELPDESK/HELPDESK_VM]/HS2000CS",
> migrate_enabled=False)
> dbh = DAL("mssql2://username:password@10.30.6.222/HS2000CS",
> migrate_enabled=False)
>
> SQL Server is in our local network and 10.30.6.222 is the local ip address.
>
> but both doesn't work.
>
> It's in production and I need to fix in a few hours. Please help!
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
