Hi everybody...
I need connect *django *with *sql anywhere 11 database*, i follow the
instructions on the page "SQL Anywhere Django Driver" from github.
I created the database with this command
C:\>dbinit -z UCA django.db --> (database created successful)
I started the Database Server with command
C:\>dbsrv11 django.db --> (database server started successful)
I created my project with
C:\>django-admin.py startproject mysite (at this point all it's ok)
I edit the file mysite/mysite/settings.py and I changed the DATABASES
setting with this
DATABASES = {
'default': {
'ENGINE': 'sqlany_django',
'NAME': 'django',
'USER': 'dba',
'PASSWORD': 'sql',
'OPTIONS': {'eng': '2638'},
'HOST': 'django',
'PORT': '2638',
}
}
The problem is, when I want sync database using this command
c:/mysite>python manage.py syncdb
I get *"Database server not found*" error.
Please help me, I don't know how resolve this problem
Even I test the connection with a file (test_sqlany.py) this file contents
following code
import sqlanydb
conn = sqlanydb.connect(uid='dba', pwd='sql', eng='django', dbn='django')
curs = conn.cursor()
curs.execute("select 'Hello, world!'")
print "SQL Anywhere says: %s" % curs.fetchone()
curs.close()
conn.close()
I, get get the expected output:
c:\>python test_sqlany.py
SQL Anywhere says: Hello, world!
I have an environment for test with this caracteristics
O.S.: Windows XP
DB Engine: *SQL Anywhere 11 with EBF 3069*
Python 2.7
Django 1.6.1
Setuptools installed
PIP installed
sqlanydb installed
sqlany-django installed
*Sorry my english is very bad :)*
*Here is the complete text about this error*
Traceback (most recent call last):
File "manage.py", line 10, in <module>
execute_from_command_line(sys.argv)
File "C:\Python27\lib\site-packages\django\core\management\__init__.py",
line
399, in execute_from_command_line
utility.execute()
File "C:\Python27\lib\site-packages\django\core\management\__init__.py",
line
392, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "C:\Python27\lib\site-packages\django\core\management\base.py", line
242,
in run_from_argv
self.execute(*args, **options.__dict__)
File "C:\Python27\lib\site-packages\django\core\management\base.py", line
285,
in execute
output = self.handle(*args, **options)
File "C:\Python27\lib\site-packages\django\core\management\base.py", line
415,
in handle
return self.handle_noargs(**options)
File
"C:\Python27\lib\site-packages\django\core\management\commands\syncdb.py"
, line 57, in handle_noargs
cursor = connection.cursor()
File "C:\Python27\lib\site-packages\django\db\backends\__init__.py", line
157,
in cursor
cursor = self.make_debug_cursor(self._cursor())
File "C:\Python27\lib\site-packages\sqlany_django\base.py", line 476, in
_curs
or
self.connection = Database.connect(**kwargs)
File "C:\Python27\lib\site-packages\sqlanydb.py", line 459, in connect
return Connection(args, kwargs)
File "C:\Python27\lib\site-packages\sqlanydb.py", line 508, in __init__
self.handleerror(*error)
File "C:\Python27\lib\site-packages\sqlanydb.py", line 518, in handleerror
eh(self, None, errorclass, errorvalue)
File "C:\Python27\lib\site-packages\sqlanydb.py", line 340, in
standardErrorHa
ndler
raise errorclass(errorvalue)
sqlanydb.OperationalError: *Database server not found*
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/802549f8-586d-4f6e-88e2-b05d230618b0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
