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
-~----------~----~----~----~------~----~------~--~---
