Connecting to SQL Server

2019-07-03 Thread John Burke
Trying to connect to SQL Server from Django DATABASES = { 'default': { 'ENGINE': 'sql_server.pyodbc', 'NAME': 'dbname', 'HOST': 'hostname', 'PORT': '', 'USER': 'user', 'PASSWORD': 'password', 'OPTIONS': { 'driver': 'ODBC Drive

Connecting to SQL Server

2019-07-03 Thread John Burke
Getting the following error: File "...\venv\lib\site-packages\sql_server\pyodbc\base.py", line 362, in init_connection_state val = cursor.execute('SELECT SYSDATETIME()').fetchone()[0] ValueError: hour must be in 0..23 -- You received this message because you are subscribed to the Google G

Re: Connecting to SQL Server

2019-07-04 Thread John Burke
; jordan.mckes...@epiccharterschools.org > > <http://facebook.com/epiccharterschools> <https://twitter.com/epiccharter> > <https://www.instagram.com/epiccharterschools/> > <https://www.youtube.com/user/EpicCharterSchools> > > > > >

Re: Connecting to SQL Server

2019-07-04 Thread John Burke
For this particular instance, I don't need the port number. On Thu, Jul 4, 2019 at 11:47 AM Joe Reitman wrote: > Don't you need to assign a port number? > > On Wednesday, July 3, 2019 at 6:52:35 PM UTC-5, John Burke wrote: >> >> Trying to connect to SQL Ser