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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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

Alex Hayes
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.



--- [hidden email] wrote:

> Send unixODBC-support mailing list submissions to
> [hidden email]
>
> 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
> [hidden email]
>
> You can reach the person managing the list at
> [hidden email]
>
> 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 <[hidden email]>
> Subject: [unixODBC-support] Re: unixODBC-support
> Digest, Vol 11, Issue
> 6
> To: [hidden email]
> Message-ID:
>
<[hidden email]>

> Content-Type: text/plain; charset=us-ascii
>
> obdc.ini
>
> [root@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@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 <[hidden email]>
> Subject: Re: [unixODBC-support] Re: unixODBC-support
> Digest, Vol 11,
> Issue 6
> To: Support for the unixODBC project
> <[hidden email]>
> Message-ID:
> <[hidden email]>
>
> > obdc.ini
> >
> > [root@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@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 <[hidden email]>
> Subject: Re: [unixODBC-support] Re: unixODBC-support
> Digest, Vol 11,
> Issue 6
> To: Support for the unixODBC project
> <[hidden email]>
> Message-ID: <[hidden email]>
> 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
> [hidden email]
>
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/
_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mail.easysoft.com/mailman/listinfo/unixodbc-support
Loading...