djhenderson / pyodbc

Automatically exported from code.google.com/p/pyodbc
MIT No Attribution
0 stars 0 forks source link

Cannot connect to MS SQL database from Mac OS/X #123

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. I built pyodbc using the zipped source and instructions from Google Code.
2. I try to use pyodbc.connect() to create a new connection.

What is the expected output? What do you see instead?
I expect to get a new connection object. Instead I get the error:
pyodbc.Error: ('00000', '[00000] [iODBC][Driver Manager]dlopen({SQL Server}, 
6): image not found (0) (SQLDriverConnectW)')

What version of the product are you using? On what operating system?
pyodbc 2.1.8
Python 2.6.1
Microsoft SQL Server 2008
Mac OS/X 10.6.4

Please provide any additional information below.
I have tried all of the driver strings for MS SQL Server listed in the Wiki. Is 
there something I'm missing here?

Original issue reported on code.google.com by n...@merket.org on 30 Sep 2010 at 9:47

GoogleCodeExporter commented 9 years ago
You'll need an ODBC driver for SQL Server. If you don't have such a driver (and 
if you don't know whether you have, you probably don't), you'll probably want 
to get FreeTDS. Check out this post:

http://lists.ibiblio.org/pipermail/freetds/2009q2/024684.html

Original comment by s...@mitre.org on 17 Nov 2010 at 7:55

GoogleCodeExporter commented 9 years ago

Original comment by mkleehammer on 21 Nov 2010 at 5:22