you mean just
import pyodbc
db = DAL('mssql://acc:p...@localhost/stuff', pool_size=0)?? On Nov 12, 10:51 pm, "mr.freeze" <[email protected]> wrote: > Are you able to open a python shell and do this without error? If not, > there is a problem with the driver: > import pyodbc > > On Nov 12, 10:47 pm, Crim <[email protected]> wrote: > > > > > > > > > i do > > > if it makes a difference im on a 64bit system > > > On Nov 12, 10:46 pm, "mr.freeze" <[email protected]> wrote: > > > > Do you have the pyodbc driver installed?http://code.google.com/p/pyodbc/ > > > > On Nov 12, 10:43 pm, Crim <[email protected]> wrote: > > > > > it gives me this in the error snapshot: > > > > <type 'exceptions.RuntimeError'>(global name 'pyodbc' is not defined > > > > (tried 5 times)) > > > > > On Nov 12, 10:40 pm, mdipierro <[email protected]> wrote: > > > > > > Can you post the exact error? > > > > > There is not nothing working with your URI string and the password is > > > > > indeed optional. > > > > > > Massimo > > > > > > On Nov 12, 10:36 pm, Crim <[email protected]> wrote: > > > > > > > i wasnt able to figure out the meaning of the error... > > > > > > > On Nov 12, 10:32 pm, "mr.freeze" <[email protected]> wrote: > > > > > > > > Can you post the traceback of the error? > > > > > > > > On Nov 12, 5:27 pm, Crim <[email protected]> wrote: > > > > > > > > > so this is all the code i really have for this right now > > > > > > > > > db = DAL('mssql//s...@localhost/master') > > > > > > > > > just trying to connect to my localhost ms sql db that i set up > > > > > > > > using > > > > > > > > the newest version of ms sql server .... > > > > > > > > > im just trying to use the default account sa to connect ... > > > > > > > > which > > > > > > > > doesnt require a password and i always get errors > > > > > > > > > now i have read and checked the web2py book and i cant figure > > > > > > > > out the > > > > > > > > error and i was wondering if one of you kind gents could lend a > > > > > > > > hand.
