[unixODBC-support] Re: unixODBC-support Digest, Vol 11, Issue 7

Alex Hayes alex_iko_hayes at yahoo.com
Tue May 24 18:34:40 BST 2005


We have an sw integrator that requires to connect to
Microsoft 2K via the odbc.ini, but the apps require a
*.so library, How Could I get or create this library? 
The OS is AIX 5200-05. 

We used the isql command an I connected and I ran a
couple of sql commands and it is working.



--- unixodbc-support-request at easysoft.com wrote:

> Send unixODBC-support mailing list submissions to
> 	unixodbc-support at easysoft.com
> 
> To subscribe or unsubscribe via the World Wide Web,
> visit
> 
>
http://mail.easysoft.com/mailman/listinfo/unixodbc-support
> or, via email, send a message with subject or body
> 'help' to
> 	unixodbc-support-request at easysoft.com
> 
> You can reach the person managing the list at
> 	unixodbc-support-owner at easysoft.com
> 
> When replying, please edit your Subject line so it
> is more specific
> than "Re: Contents of unixODBC-support digest..."
> 
> 
> Today's Topics:
> 
>    1. Re: unixODBC-support Digest, Vol 11, Issue 6
> (Alex Hayes)
>    2. Re: Re: unixODBC-support Digest, Vol 11, Issue
> 6  (Eric Sharkey)
>    3. Re: Re: unixODBC-support Digest, Vol 11, Issue
> 6 (Nick Gorham)
> 
> 
>
----------------------------------------------------------------------
> 
> Message: 1
> Date: Wed, 11 May 2005 06:53:09 -0700 (PDT)
> From: Alex Hayes <alex_iko_hayes at yahoo.com>
> Subject: [unixODBC-support] Re: unixODBC-support
> Digest, Vol 11, Issue
> 	6
> To: unixodbc-support at easysoft.com
> Message-ID:
>
<20050511135309.94660.qmail at web30413.mail.mud.yahoo.com>
> Content-Type: text/plain; charset=us-ascii
> 
> obdc.ini
> 
> [root at h50_3:/usr/local/etc]# cat odbc.ini
> Driver = unixODBC
> # IP or DNS name of server
> Server = 172.27.201.133
> Database = kioscos
> Trace = yes
> TraceFile=/tmp/odbc.trace
> Debug=yes
> DebugFile=/tmp/odbc.log
> UID = sa
> 
> [root at h50_3:/usr/local/etc]# cat odbcinst.ini
> [MySQL]
> Description = ODBC for MySQL
> Driver = /usr/local/lib/libiodbc.so.2
> FileUsage = 1
> 
> 
> 		
> __________________________________ 
> Yahoo! Mail Mobile 
> Take Yahoo! Mail with you! Check email on your
> mobile phone. 
> http://mobile.yahoo.com/learn/mail 
> 
> 
> ------------------------------
> 
> Message: 2
> Date: Wed, 11 May 2005 10:35:21 -0400
> From: Eric Sharkey <sharkey at netrics.com>
> Subject: Re: [unixODBC-support] Re: unixODBC-support
> Digest, Vol 11,
> 	Issue 6 
> To: Support for the unixODBC project
> <unixodbc-support at easysoft.com>
> Message-ID:
> <E1DVsIz-0007Zo-00 at mastermind.netrics.internal>
> 
> > obdc.ini
> > 
> > [root at h50_3:/usr/local/etc]# cat odbc.ini
> > Driver = unixODBC
> > # IP or DNS name of server
> > Server = 172.27.201.133
> > Database = kioscos
> > Trace = yes
> > TraceFile=/tmp/odbc.trace
> > Debug=yes
> > DebugFile=/tmp/odbc.log
> > UID = sa
> > 
> > [root at h50_3:/usr/local/etc]# cat odbcinst.ini
> > [MySQL]
> > Description = ODBC for MySQL
> > Driver = /usr/local/lib/libiodbc.so.2
> > FileUsage = 1
> 
> This is wrong in many ways.
> 
> Your odbc.ini does not have any dsn defined.  It
> should start with
> a datasource name in square brackets at the top of
> the file.
> The driver line must specify one of the entries in
> odbcinst.ini.
> And your Driver line in your odbcinst.ini does not
> specify a
> valid MySQL odbc driver, it points to the iodbc
> driver manager, which
> is a completely separate piece of software which
> should not be used
> with unixODBC.  You need to use either unixODBC or
> iODBC, but not
> both.
> 
> You want something like:
> 
> odbc.ini:
> 
> [MySQL-kioscos]
> Driver = MySQL
> # IP or DNS name of server
> Server = 172.27.201.133
> Database = kioscos
> UID = sa
> 
> odbcinst.ini:
> 
> [MySQL]
> Description = ODBC for MySQL
> Driver = /usr/local/lib/libmyodbc.so
> FileUsage = 1
> 
> And use the dsn MySQL-kioscos when you try to
> connect with isql.
> 
> Eric
> 
> 
> ------------------------------
> 
> Message: 3
> Date: Wed, 11 May 2005 15:41:49 +0100
> From: Nick Gorham <nick.gorham at easysoft.com>
> Subject: Re: [unixODBC-support] Re: unixODBC-support
> Digest, Vol 11,
> 	Issue 6
> To: Support for the unixODBC project
> <unixodbc-support at easysoft.com>
> Message-ID: <428219AD.1050903 at easysoft.com>
> Content-Type: text/plain; charset=us-ascii;
> format=flowed
> 
> I would expect something like
> 
> ; odbc.ini
> 
> [DSNNAME]
> Driver=Mysql
> Server=172.27.201.133
> Database=kioscos
> 
> The Driver entry in your odbcinst.ini seems to be
> pointing to the iODBC 
> drive manager ?
> 
> -- 
> Nick
> 
> 
> ------------------------------
> 
> _______________________________________________
> unixODBC-support mailing list
> unixODBC-support at easysoft.com
>
http://mail.easysoft.com/mailman/listinfo/unixodbc-support
> 
> 
> End of unixODBC-support Digest, Vol 11, Issue 7
> ***********************************************
> 



		
__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new Resources site
http://smallbusiness.yahoo.com/resources/



More information about the unixODBC-support mailing list