By default, `make install' will install the package's files in `/usr/local/bin', `/usr/local/man', etc. You can specify an installation prefix other than `/usr/local' by giving `configure' the option `--prefix=PATH'.
Howde dothis, I use the Merant MySQL driver for MySQL but I`m doing a MyODBC install as well this time with libiodbc-3.0.5. libiodbc-3.0.5 by default, `make install' installs the package's files in `/usr/local/bin', `/usr/local/man', etc. You can specify an installation prefix other than `/usr/local' by giving `configure' the option `--prefix=PATH'. I`ve unpacked the MyODBC into a folder off admin. The problem is where I should set the path prefix to for ./configure for both MyODBC and Libiodbc and nbnb should the path for both be /home/opt/coldfusion/lib as where I want the MyODBC driver to end up. Can the ./configure prefix path environment for MyODBC and IODBC be the same and the resulting myodbc.so driver just copied from there to /home/opt/coldfusion/lib Thanks Colm ----- Original Message ----- From: "chad" <[EMAIL PROTECTED]> To: "CF-Linux" <[EMAIL PROTECTED]> Sent: Monday, February 04, 2002 3:51 AM Subject: Re: Fwd: Remote MyODBC connection > 1/25/2002 10:02:29 AM, chad <chad @ webcorelabs . com> wrote: > > >Now I'm setting up a new webserver that will access a database > >on a remote machine and I am unable to access the database > >from ColdFusion. The datasource fails to verify and a cfquery > >prints out the following (for the MyODBC driver): > > > > Error Diagnostic Information > > ODBC Error Code = 08S01 (Communication link failure) > > > > [unixODBC][TCX][MyODBC]Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) > > > >I don't think I can use UNIX sockets to connect to a remote > >database. What do I have to set to tell ColdFusion or the > >MyODBC driver to use TCP? > > > >Both boxes have Slackware 8.0 (2.4.13 kernel). > >The MySQL server reports Ver 3.23.39. > >The ODBC driver is version MyODBC-2.50.39. > >CF is version 5.0 > >Apache Server version: Apache/1.3.20 (Unix) > > > >Thanks, Chad > > > > I got it, Finally! I just had to edit the /opt/coldfusion/odbc/odbc.ini . > In the corresponding [Database] block I just had to add the line > > SERVER=192.168.1.1 > > The driver defalts to UNIX sockets (and so localhost) unless a > remote server is specified. I just assumed the "Server Host Name" > in cfadministrator was how it was specified. It appears this driver > does not reconize the line (Servername=192.168.1.1) generated > by cfadministrator. > > I hope this helps someone in the future. > > Good luck, > > Chad > < chad @ webcorelabs . com > > Tonight one happy Jr Sys Admin > Webcore Labs Inc > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
