Re: [GNUe] ODBC

[Jason Cater]

Stefan, 

I don't use ODBC, so I don't have an exact answer. First off, I assume this is 
on Windows. We don't have a proper ODBC-under-linux driver, as we can't find 
any Free python-odbc drivers to use, except the PythonWIn version for 
Windows. 

Secondly, I know that service= is the only valid parameter used in odbc; host 
and port are ignored.

service= should contain the DSN to connect to the ODBC data source. I don't 
really know how the DSN is formatted, but 
http://www.able-consulting.com/ADO_Conn.htm or 
http://www.connectionstrings.com/ may be some help. 

-- Jason 


On Wednesday 02 June 2004 02:28 pm, you wrote:
> Does anybody know what I should put in connections.conf to make it work
> using an ODBC Datasource?
>
> I did this:
>
> [ERP]
> host = 127.0.0.1
> provider = odbc
> service= MyDSN
> port = 2222
>
> Which produces nothing. I can use OpenOffice to get into the ODBC source so
> that one would be ok.
>
> Regards
> Stefan