Hi Stef,
This is the way I've done it:
db = DAL('mysql://username:password@dns_or_ip_of_server/
database_name')
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
