thanks Franklin,
On 23-02-2011 23:51, Franklin Freitas wrote:
> Hi Stef,
>
> This is the way I've done it:
>
> db = DAL('mysql://username:password@dns_or_ip_of_server/
> database_name')
>
AFAIK our IP addresses are dynamic,
and with the name of the server it doesn't work.
cheers,
Stef
> Hope it helps
>
> Regards
>
> Franklin
>
>
> On Feb 23, 3:43 pm, DenesL <[email protected]> wrote:
>> According to the dal.py source you either supply
>>
>> mssql://dsn
>>
>> or
>>
>> mssql://username:password@host:port/dbname
>>
>> (port is optional)
>>
>> On Feb 23, 2:17 pm, Stef Mientki <[email protected]> wrote:> hello,
>>
>>> i'm a little bit confused about how the connectionstring should look fro
>>> coupling a remote mssql
>>> database through odbc.
>>> I was first searching for a odbc connecting string,
>>> and I'm finding that odbc is not considered as database engine but as a
>>> protocol ???
>>> Both the databasename and the DSN name in the ODBC definition is "test"
>>> I can connect to the database with:
>>> conn = pyodbc.connect ( 'DSN=test; UID=z571117' )
>>> print conn
>>> Now with the DAL, I tried several constructs (the constructs below are also
>>> tried with the correct
>>> password), and none of them seem to work
>>> Database_Name = r'mssql://z571117:@test/test'
>>> Database_Name = r'mssql://z571117:@test'
>>> Database_Name = r'mssql://z571117:@localhost/test'
>>> Database_Name = r'mssql://z571117:/test'
>>> My_DB = DAL ( Database_Name )
>>> What shpuld the connectionstring look like ?
>>> Do I have to specify an alias in the ODBC manager or can I do without ?
>>> thanks,
>>> Stef Mientki
