Did you install pyodbc?
Also, your connection string seems to me doubtfull :
Mine start like that :
db=DAL()
You should stick with db since it is a convention for us and may make help
you easier when we will need to read you code...
But as long as you didn't rename DAL you should have something like that as
a connection string :
db = DAL('mssql://username:password@localhost:portnumber/databaseNAME')
And for sure you need pyodbc
Richard
On Tue, Apr 23, 2013 at 11:42 AM, ab234vv <[email protected]>wrote:
> Hello,
>
> I am trying to learn web2py to display some stored procedures from my SQL
> server
>
> I have managed to set up the environment, work with some sample
> examples....however I am stuck with trying to set up the connection.
>
> What is the connection string? Currently I am using something like this:
>
> b = SQLDB('mssql://username:password@localhost:portnumber/databaseNAME')
>
> Can someone give me a some examples or link to any information where I can
> see how a simple program connects to a SQL SERVER DB and selects a few
> records from a table and displays them...
>
> I have been researching to find examples, but I have not found anything
> specific to my problem,
>
> My apologies if its a repeated question or the nature of the question is
> broad...
>
> Thanks
>
> --
>
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
