Don't need pyodbc, web2py comes with pypyodbc.
On Tuesday, April 23, 2013 5:35:03 PM UTC-7, Richard wrote:
>
> 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]<javascript:>
> > 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] <javascript:>.
>> 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.
