It's a two-line change that pops the new keyword out of the config dict just
like the others that were added.
Mike, can you take a quick look at mssql.py line 804 and see why this might
be complaining? I've got to run out.
On Thu, Apr 17, 2008 at 3:58 PM, Lukasz Szybalski <[EMAIL PROTECTED]>
wrote:
>
> On Thu, Apr 17, 2008 at 2:35 PM, Rick Morrison <[EMAIL PROTECTED]>
> wrote:
> >
> > > Does it matter what case are the parameters? DRIVER in pyodbc, we used
> > > 'driver' in previous connection strings etc...
> > >
> > >
> > >
> > >
> >
> > No the parameters are a straight pass-through, that traceback is
> complaining
> > about the 'odbc_options' keyword itself. Are you sure you're running the
> > current trunk?
>
> svn update
> At revision 4518.
> [EMAIL PROTECTED]:~/tmp/sqlalchemy/sqlalchemy/lib$ python
> Python 2.4.4 (#2, Apr 5 2007, 20:11:18)
> [GCC 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)] on linux2
> Type "help", "copyright", "credits" or "license" for more information.
> >>> import sqlalchemy
> >>> sqlalchemy.__version__
> 'svn'
> >>> e = sqlalchemy.create_engine('mssql://xxx:[EMAIL PROTECTED]
> :1433/xxx',odbc_options='DRIVER={TDS};TDS_Version=8.0')
> Traceback (most recent call last):
> File "<stdin>", line 1, in ?
> File "sqlalchemy/engine/__init__.py", line 160, in create_engine
> return strategy.create(*args, **kwargs)
> File "sqlalchemy/engine/strategies.py", line 114, in create
> raise TypeError(
> TypeError: Invalid argument(s) 'odbc_options' sent to create_engine(),
> using configuration MSSQLDialect_pyodbc/QueuePool/Engine. Please
> check that the keyword arguments are appropriate for this combination
> of components.
>
> not sure why strategies.py would complain?
>
> Are you converting:
> 'mssql://xxx:[EMAIL
> PROTECTED]:1433/xxx',odbc_options='DRIVER={TDS};TDS_Version=8.0'
> to
> SERVER=xxx;UID=xx;PWD=xxx;DRIVER={TDS};TDS_Version=7.0
>
>
> I have added the print line that we had used before that outputs the
> connection string:
>
> import sqlalchemy
> >>> e = sqlalchemy.create_engine('mssql://xx:[EMAIL PROTECTED]
> :1433/xxx',odbc_options='Driver=TDS;TDS_Version=8.0')
> DRIVER={SQL Server};Server=xxx;Database=xxx;Port=1433;UID=xxx;PWD=xxx
>
> The driver is not changed and tds_version is not added
> Lucas
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
