My favorites
▼
|
Sign in
pyodbc
Python ODBC library
Project Home
Downloads
Wiki
READ-ONLY: This project has been
archived
. For more information see
this post
.
Search
Search within:
All issues
Open issues
New issues
Issues to verify
for
Advanced search
Search tips
Subscriptions
Issue
69
attachment: sh_session.txt
(1.3 KB)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
adrian@darkstar:~/packages/unixODBC-2.2.14$ isql --version
unixODBC 2.2.14
adrian@darkstar:~/packages/unixODBC-2.2.14$ isql pikantBlue pikantBlue
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> SELECT CURRENT_TIMESTAMP;
+-----------+
| |
+-----------+
| 2009-08-27|
+-----------+
SQLRowCount returns 1
1 rows fetched
SQL> quit
adrian@darkstar:~/packages/unixODBC-2.2.14$ python
Python 2.6.2 (r262:71600, May 19 2009, 02:23:26)
[GCC 4.3.3] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import pyodbc
>>> cnx = pyodbc.connect('DSN=pikantBlue;UID=pikantBlue;PWD=')
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
pyodbc.Error: ('0', '[0] [nxDC (202) (SQLDriverConnectW)')
>>> cnx = pyodbc.connect('DSN=pikantBlue;UID=pikantBlue')
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
pyodbc.Error: ('0', '[0] [nxDC (202) (SQLDriverConnectW)')
>>> print pyodbc.version
2.1.6-beta0
>>> quit()
adrian@darkstar:~/packages/unixODBC-2.2.14$ isql -V
Powered by
Google Project Hosting