Do yo have an actual error message you can share which gives any indication of why it is failing?
Graham On 20 July 2011 11:14, [email protected] <[email protected]> wrote: > I know this is a bit off topic; but I'm really stuck. I've got a > pyodbc connection to Sybase that works from the command line but not > from within a wsgi app and Apache on linux; my /etc/.odbc.ini looks > like this (also /etc/odbc.ini since I've got conflicting info) and > they have permissions of 777 > > [root]# more /etc/.odbc.ini > [ODBC Data Sources] > Homeworks=SQLAnywhere 12.0 > > [Homeworks] > UID=xxxxxxxxxxxxxxxxxx > PWD=xxxxxxxxxxxxxxxxxx > DatabaseName=Production > ServerName=Homeworks > CommLinks=tcpip(host=192.168.xxx.xxx;DoBroadcast=NONE) > Driver=/opt/sqlanywhere12/lib32/libdbodbc12.so > > Uid, pwd and ip deleted for security. > > Either Apache cannot access this and I'm not an Apache expert or if > someone knows how to convert this into the pyodbc connection string > that does not use the DSN, that might be a solution. > > From the command line > pyodbc.connect('DSN=HomeworksProduction') works but that confuses me > because I don't see that name in the .ini unless it is "assembled" > from the individual lines. > > I've googled all day on this and just cannot find a solution. > > -- > You received this message because you are subscribed to the Google Groups > "modwsgi" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/modwsgi?hl=en. > > -- You received this message because you are subscribed to the Google Groups "modwsgi" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/modwsgi?hl=en.
