[unixODBC-support] RE: Problems with freetds and unixodbc

Stefan Radman Stefan.Radman at CTBTO.ORG
Wed Dec 7 17:08:01 GMT 2005


Guess that's the easiest way to keep it recorded.

Stefan

> -----Original Message-----
> From: unixodbc-support-bounces at easysoft.com 
> [mailto:unixodbc-support-bounces at easysoft.com] On Behalf Of 
> Brian Morton
> Sent: Wednesday, 07 December, 2005 17:52
> To: 'Support for the unixODBC project'
> Subject: RE: [unixODBC-support] RE: Problems with freetds and unixodbc
> 
> Thanks!  I will write one up later today.  Should I send it 
> here once it is
> done? 
> 
> -----Original Message-----
> From: Stefan Radman [mailto:Stefan.Radman at ctbto.org] 
> Sent: Wednesday, December 07, 2005 11:34 AM
> To: Support for the unixODBC project
> Subject: RE: [unixODBC-support] RE: Problems with freetds and unixodbc
> 
> Hi Brian,
> 
> Thanks for volunteering to write the HOWTO.
> Below you'll find a summary of my findings.
> Use it and distill it as you like ;-)
> 
> Cheers
> Stefan
> 
> ========================================================
> The ODBC-only configuration does not need any FreeTDS 
> configuration files or
> environment variables.
> It lives and works solely from the configuration found in odbc.ini and
> odbcinst.ini.
> 
> Here is a sample configuration that worked very well for me 
> on Solaris and
> Linux with unixODBC 2.2.9 and FreeTDS ODBC driver 0.62.3:
> 
> FreeTDS driver entry in odbcinst.ini:
> -------------------------------------
> [FreeTDS]
> Description=FreeTDS ODBC Driver for Sybase and MS-SQL
> Driver=/usr/lib/libtdsodbc.so Setup=/usr/lib/libtdsodbc.so
> UsageCount=1
> 
> DSN entry in odbc.ini:
> ----------------------
> [testdb]
> Description     = Test Sybase Database with FreeTDS
> Driver          = FreeTDS
> Server          = sybase.example.com
> Port            = 5050
> TDS_Version     = 5.0
> Database        = testdb
> 
> 
> unixODBC has two handy tools for adding these entries:
>   1) the "ODBCConfig" GUI and
>   2) the "odbcinst" command line tool 
>      for non-interactive processing (e.g. odbcinst -i -d -r)
> 
> 
> Valid attributes for use in odbc.ini (or the connection 
> string) can be found
> at:
>   http://www.freetds.org/userguide/odbcconnattr.htm
> 
> For ODBC-only configurations these are:
> 
>   Server       database server DNS hostname or IP address
>   Port         TCP port the database server is listening
>   TDS_Version
> http://www.freetds.org/userguide/choosingtdsprotocol.htm#TAB.P
> ROTOCOL.BY
> .PRODUCT
>   Database     databse name on the server
>   APP
>   LANGUAGE
>   TextSize
>   PacketSize
>   Address
> 
> Note: 
> * do NOT use "Servername" in an ODBC-only configuration!
> * use of "Server" should be preferred over "Address"
>   (see 
> http://lists.ibiblio.org/pipermail/freetds/2004q2/016086.html et
> al)
> 
> A summary of the Q&A regarding "Server","Servername" and 
> "Address" would
> help people a great deal.
> 
> What I haven't found is a comprehensive reference about the 
> default TCP port
> numbers that different versions of Microsoft and Sybase SQL Server
> use:
> 
>   http://www.iana.org/assignments/port-numbers
>     ms-sql-s        1433/tcp   Microsoft-SQL-Server 
>     sybase-sqlany   1498/tcp    Sybase SQL Any
> 
>  
> http://www.ibiblio.org/pub/Linux/docs/HOWTO/other-formats/html
> _single/Sy
> base-ASE-HOWTO.html#AEN382  
>     4100 Sybase ASE SQL Server default
>     2025 old Sybase ASE SQL Server default??
> 
> 
> > -----Original Message-----
> > From: unixodbc-support-bounces at easysoft.com
> > [mailto:unixodbc-support-bounces at easysoft.com] On Behalf Of Brian 
> > Morton
> > Sent: Wednesday, 07 December, 2005 15:26
> > To: 'unixodbc-support at easysoft.com'
> > Subject: [unixODBC-support] RE: Problems with freetds and unixodbc
> > 
> > I read the FreeTDS article I was sent about the three possible 
> > configuration options for FreeTDS and ODBC.  Can anyone shed some 
> > light on tips for the only ODBC method?  I have done pure 
> FreeTDS, and 
> > also done the config file mix, which is the one documented on 
> > unixODBC's site.  How do I do it with ODBC being the only 
> connection 
> > method?  Once I figure it out, I will write a howto for the site.
> > 
> > >  -----Original Message-----
> > > From: 	Brian Morton  
> > > Sent:	Tuesday, December 06, 2005 10:59 AM
> > > To:	'unixodbc-support at easysoft.com'
> > > Subject:	Problems with freetds and unixodbc
> > > 
> > > I have a Debian 3.1 machine with FreeTDS and unixODBC
> > installed.  I am
> > > able to connect to my MSSQL 2000 server via tsql (which is
> > the command
> > > line interface for FreeTDS).  However, I cannot connect via
> > isql or any
> > > odbc connect functions in PHP.  I have read the HOWTO on 
> this on the 
> > > unixODBC site, but it has not helped me.  Where can I begin to 
> > > troubleshoot my problems between FreeTDS and unixODBC?
> > Thanks for your
> > > help in advance.
> > > 
> > > Brian Morton
> > > 
> > > CRM Developer
> > > SecureWorks, Inc.
> > > 11 Executive Park Drive
> > > Atlanta, GA 30329
> > > tel  (404) 417-3728
> > > fax (404) 327-8835
> > > www.secureworks.com
> > > 
> > _______________________________________________
> > unixODBC-support mailing list
> > unixODBC-support at easysoft.com
> > http://mail.easysoft.com/mailman/listinfo/unixodbc-support
> > 
> > 
> 
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at easysoft.com
> http://mail.easysoft.com/mailman/listinfo/unixodbc-support
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at easysoft.com
> http://mail.easysoft.com/mailman/listinfo/unixodbc-support
> 
> 




More information about the unixODBC-support mailing list