CODEWITHSUNDEEP
sql-serverdjangopython-3.xdjango-models
Rohit Khadatkar
Rohit Khadatkar

Reputation: 31

inspectdb command but it's not working

I want to use existing mssql database. I use inspectdb command but it's not working

This is my database configuration:

DATABASES = {
    'default': {
    'NAME': 'xxxx',
    'ENGINE': 'sqlserver_ado',
    'HOST': '102.35.140.54\SQLEXPRESS',
    'USER': 'xxxx',
    'PASSWORD': 'xxxxx',
    'PORT' : '1434',
    'OPTIONS': {
        'provider': 'SQLNCLI11',
              }
}
}

I fired python manage.py inspectdb and get error.

D:\Python_Workspace\oracle>python manage.py migrate
Traceback (most recent call last):
  File "manage.py", line 22, in <module>
    execute_from_command_line(sys.argv)
  File "C:\Python35\lib\site-packages\django\core\management\__init__.py", line 367, in execute_from_command_line
    utility.execute()
  File "C:\Python35\lib\site-packages\django\core\management\__init__.py", line 359, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "C:\Python35\lib\site-packages\django\core\management\base.py", line 294, in run_from_argv
    self.execute(*args, **cmd_options)
  File "C:\Python35\lib\site-packages\django\core\management\base.py", line 345, in execute
    output = self.handle(*args, **options)
  File "C:\Python35\lib\site-packages\django\core\management\commands\migrate.py", line 83, in handle
    executor = MigrationExecutor(connection, self.migration_progress_callback)
  File "C:\Python35\lib\site-packages\django\db\migrations\executor.py", line 20, in __init__
    self.loader = MigrationLoader(self.connection)
  File "C:\Python35\lib\site-packages\django\db\migrations\loader.py", line 52, in __init__
    self.build_graph()
  File "C:\Python35\lib\site-packages\django\db\migrations\loader.py", line 203, in build_graph
    self.applied_migrations = recorder.applied_migrations()
  File "C:\Python35\lib\site-packages\django\db\migrations\recorder.py", line 65, in applied_migrations
    self.ensure_schema()
  File "C:\Python35\lib\site-packages\django\db\migrations\recorder.py", line 52, in ensure_schema
    if self.Migration._meta.db_table in self.connection.introspection.table_names(self.connection.cursor()):
  File "C:\Python35\lib\site-packages\django\db\backends\base\base.py", line 231, in cursor
    cursor = self.make_debug_cursor(self._cursor())
  File "C:\Python35\lib\site-packages\django\db\backends\base\base.py", line 204, in _cursor
    self.ensure_connection()
  File "C:\Python35\lib\site-packages\django\db\backends\base\base.py", line 199, in ensure_connection
    self.connect()
  File "C:\Python35\lib\site-packages\django\db\backends\base\base.py", line 170, in connect
    conn_params = self.get_connection_params()
  File "C:\Python35\lib\site-packages\sqlserver_ado\base.py", line 225, in get_connection_params
    'connection_string': make_connection_string(settings_dict),
  File "C:\Python35\lib\site-packages\sqlserver_ado\base.py", line 56, in make_connection_string
    raise ImproperlyConfigured("When using DATABASE PORT, DATABASE HOST must be an IP address.")
django.core.exceptions.ImproperlyConfigured: When using DATABASE PORT, DATABASE HOST must be an IP address.

Upvotes: 1

Views: 1463

Answers (1)

Prakhar Trivedi
Prakhar Trivedi

Reputation: 8526

The problem is in your Database setting in settings.py file.Its a typo error.

Define DB settings like this :

DATABASES = {
    'default': {
    'NAME': 'xxxx',
    'ENGINE': 'sqlserver_ado',
    'HOST': '102.35.140.54',
    'USER': 'xxxx',
    'PASSWORD': 'xxxxx',
    'PORT' : '1434',
    'OPTIONS': {
        'provider': 'SQLNCLI11',
              }
        }
}

For better practices,use just IP address in HOST as 'HOST': '102.35.140.54'.

Upvotes: 1

Related Questions