Installing pymssql

f1crazed f1crazed at gmail.com
Mon Aug 23 22:43:58 CEST 2010


Hello,

I am new to the python world.  I'm trying the install the pymssql
package and have been unsuccessful.  I am running Win7 x64.  Here is
the output I get when I try to build the pymssql package:

running build
running build_ext
cythoning _mssql.pyx to _mssql.c
building '_mssql' extension
creating build
creating build\temp.win-amd64-2.6
creating build\temp.win-amd64-2.6\Release
C:\Program Files (x86)\Microsoft Visual Studio 9.0\VC\BIN
\amd64\cl.exe /c /nologo /Ox /MD /W3 /GS- /DNDEBUG -Iwin32\free
tds\include -IC:\Python26\include -IC:\Python26\PC /Tc_mssql.c /Fobuild
\temp.win-amd64-2.6\Release\_mssql.obj -DMSDBLIB
_mssql.c
_mssql.c(643) : warning C4244: 'function' : conversion from
'Py_ssize_t' to 'long', possible loss of data
_mssql.c(663) : warning C4244: 'function' : conversion from
'Py_ssize_t' to 'long', possible loss of data
_mssql.c(685) : warning C4244: 'function' : conversion from
'Py_ssize_t' to 'long', possible loss of data
_mssql.c(712) : warning C4244: 'function' : conversion from
'Py_ssize_t' to 'long', possible loss of data
_mssql.c(6192) : warning C4244: '=' : conversion from 'Py_ssize_t' to
'int', possible loss of data
_mssql.c(9967) : warning C4267: '=' : conversion from 'size_t' to
'int', possible loss of data
c:\pythonmods\pymssql-1.9.908\_mssql.c(4652) : warning C4700:
uninitialized local variable '__pyx_v_dbcol' used
creating build\lib.win-amd64-2.6
C:\Program Files (x86)\Microsoft Visual Studio 9.0\VC\BIN
\amd64\link.exe /DLL /nologo /INCREMENTAL:NO /LIBPATH:win32\fre
etds\lib /LIBPATH:C:\Python26\libs /LIBPATH:C:\Python26\PCbuild\amd64
msvcrt.lib kernel32.lib user32.lib gdi32.lib winsp
ool.lib ws2_32.lib comdlg32.lib advapi32.lib shell32.lib ole32.lib
oleaut32.lib uuid.lib odbc32.lib odbccp32.lib libTDS.
lib dblib.lib /EXPORT:init_mssql build\temp.win-amd64-2.6\Release
\_mssql.obj /OUT:build\lib.win-amd64-2.6\_mssql.pyd /IM
PLIB:build\temp.win-amd64-2.6\Release\_mssql.lib /MANIFESTFILE:build
\temp.win-amd64-2.6\Release\_mssql.pyd.manifest
_mssql.obj : warning LNK4197: export 'init_mssql' specified multiple
times; using first specification
   Creating library build\temp.win-amd64-2.6\Release\_mssql.lib and
object build\temp.win-amd64-2.6\Release\_mssql.exp
_mssql.obj : error LNK2019: unresolved external symbol dbsqlexec
referenced in function __pyx_f_6_mssql_db_sqlexec
_mssql.obj : error LNK2019: unresolved external symbol dbadata
referenced in function __pyx_f_6_mssql_get_data
_mssql.obj : error LNK2019: unresolved external symbol dbdata
referenced in function __pyx_f_6_mssql_get_data
_mssql.obj : error LNK2019: unresolved external symbol dbalttype
referenced in function __pyx_f_6_mssql_get_type
_mssql.obj : error LNK2019: unresolved external symbol dbcoltype
referenced in function __pyx_f_6_mssql_get_type
_mssql.obj : error LNK2019: unresolved external symbol dbadlen
referenced in function __pyx_f_6_mssql_get_length
_mssql.obj : error LNK2019: unresolved external symbol dbdatlen
referenced in function __pyx_f_6_mssql_get_length
_mssql.obj : error LNK2019: unresolved external symbol dbcancel
referenced in function __pyx_f_6_mssql_db_cancel
_mssql.obj : error LNK2019: unresolved external symbol dbtds
referenced in function __pyx_pf_6_mssql_15MSSQLConnection_1
1tds_version___get__
_mssql.obj : error LNK2019: unresolved external symbol dbclose
referenced in function __pyx_pf_6_mssql_15MSSQLConnection
_close
_mssql.obj : error LNK2019: unresolved external symbol dbuse
referenced in function __pyx_pf_6_mssql_15MSSQLConnection_s
elect_db
_mssql.obj : error LNK2019: unresolved external symbol dbgetmaxprocs
referenced in function __pyx_pf_6_mssql_get_max_con
nections
_mssql.obj : error LNK2019: unresolved external symbol dbcount
referenced in function __pyx_f_6_mssql_15MSSQLConnection_
execute_scalar
_mssql.obj : error LNK2019: unresolved external symbol dbnextrow
referenced in function __pyx_f_6_mssql_15MSSQLConnectio
n_execute_scalar
_mssql.obj : error LNK2019: unresolved external symbol dbsettime
referenced in function __pyx_pf_6_mssql_15MSSQLConnecti
on_13query_timeout___set__
_mssql.obj : error LNK2019: unresolved external symbol dbcmd
referenced in function __pyx_pf_6_mssql_15MSSQLConnection__
_init__
_mssql.obj : error LNK2019: unresolved external symbol dbloginfree
referenced in function __pyx_pf_6_mssql_15MSSQLConnec
tion___init__
_mssql.obj : error LNK2019: unresolved external symbol tdsdbopen
referenced in function __pyx_pf_6_mssql_15MSSQLConnecti
on___init__
_mssql.obj : error LNK2019: unresolved external symbol dbsetlogintime
referenced in function __pyx_pf_6_mssql_15MSSQLCon
nection___init__
_mssql.obj : error LNK2019: unresolved external symbol dbsetlname
referenced in function __pyx_pf_6_mssql_15MSSQLConnect
ion___init__
_mssql.obj : error LNK2019: unresolved external symbol dblogin
referenced in function __pyx_pf_6_mssql_15MSSQLConnection
___init__
_mssql.obj : error LNK2019: unresolved external symbol dbdatecrack
referenced in function __pyx_f_6_mssql_15MSSQLConnect
ion_convert_db_value
_mssql.obj : error LNK2019: unresolved external symbol dbconvert
referenced in function __pyx_f_6_mssql_15MSSQLConnectio
n_convert_db_value
_mssql.obj : error LNK2019: unresolved external symbol dbresults
referenced in function __pyx_f_6_mssql_15MSSQLConnectio
n_execute_non_query
_mssql.obj : error LNK2019: unresolved external symbol dbrpcinit
referenced in function __pyx_pf_6_mssql_20MSSQLStoredPr
ocedure___init__
_mssql.obj : error LNK2019: unresolved external symbol dbrpcparam
referenced in function __pyx_pf_6_mssql_20MSSQLStoredP
rocedure_bind
_mssql.obj : error LNK2019: unresolved external symbol dbretstatus
referenced in function __pyx_pf_6_mssql_20MSSQLStored
Procedure_execute
_mssql.obj : error LNK2019: unresolved external symbol dbretdata
referenced in function __pyx_pf_6_mssql_20MSSQLStoredPr
ocedure_execute
_mssql.obj : error LNK2019: unresolved external symbol dbretlen
referenced in function __pyx_pf_6_mssql_20MSSQLStoredPro
cedure_execute
_mssql.obj : error LNK2019: unresolved external symbol dbretname
referenced in function __pyx_pf_6_mssql_20MSSQLStoredPr
ocedure_execute
_mssql.obj : error LNK2019: unresolved external symbol dbrettype
referenced in function __pyx_pf_6_mssql_20MSSQLStoredPr
ocedure_execute
_mssql.obj : error LNK2019: unresolved external symbol dbnumrets
referenced in function __pyx_pf_6_mssql_20MSSQLStoredPr
ocedure_execute
_mssql.obj : error LNK2019: unresolved external symbol dbsqlok
referenced in function __pyx_pf_6_mssql_20MSSQLStoredProc
edure_execute
_mssql.obj : error LNK2019: unresolved external symbol dbrpcsend
referenced in function __pyx_pf_6_mssql_20MSSQLStoredPr
ocedure_execute
_mssql.obj : error LNK2019: unresolved external symbol dbsetmaxprocs
referenced in function __pyx_pf_6_mssql_set_max_con
nections
_mssql.obj : error LNK2019: unresolved external symbol dbmsghandle
referenced in function __pyx_f_6_mssql_init_mssql
_mssql.obj : error LNK2019: unresolved external symbol dberrhandle
referenced in function __pyx_f_6_mssql_init_mssql
_mssql.obj : error LNK2019: unresolved external symbol dbinit
referenced in function __pyx_f_6_mssql_init_mssql
_mssql.obj : error LNK2019: unresolved external symbol dbcolname
referenced in function __pyx_f_6_mssql_15MSSQLConnectio
n_get_result
_mssql.obj : error LNK2019: unresolved external symbol dbnumcols
referenced in function __pyx_f_6_mssql_15MSSQLConnectio
n_get_result
build\lib.win-amd64-2.6\_mssql.pyd : fatal error LNK1120: 40
unresolved externals
error: command '"C:\Program Files (x86)\Microsoft Visual Studio 9.0\VC
\BIN\amd64\link.exe"' failed with exit status 1120

I know this might be a bit much to chew on but I have been trying to
figure this out for a while know and I cannot figure this one out.

Thanks in advance for the help!

-JD



More information about the Python-list mailing list