1) In panther, conduct a search for 'odbc.ini'
2) in the search window where it says "search for items whose:" click the plus (+) sign and add the criteria for "Visibility" and set it to "Visible and Invisible"
3) this will display all your files visible (odbc.ini) and invisible (.odbc.ini)


I'm using unixODBC, so I'm not sure if it will be the same for you, but the odbc.ini file Witango uses in Panther is located in my user home directory as an invisible file ".odbc.ini". In the terminal you can view/edit this by typing:

> sudo pico .odbc.ini

If not this, you can check the other odbc.ini files to see what it's reading.

Chris

On Jan 29, 2004, at 6:02 PM, Trevor Green wrote:

Hi Chris

I am actually asking for authentication every time, but for some reason it
will not accept the authentication (I have not been able to authenticate
successfully once). I am thinking that when Dev Studio tries to access the
odbc source it is using a different ODBC config file somewhere. I have
double checked all the configs and they seem OK but there is obviously
something wrong somewhere.


Trevor

On 1/29/04 3:24 PM, "Chris Millet" <[EMAIL PROTECTED]> wrote:


In step 3) "Check" (not uncheck) the box that says "Ask each time"


Chris

On Jan 29, 2004, at 5:18 PM, Chris Millet wrote:

Not sure if this is the same issue, but I have seen this behavior
before when login has been set to be automatic and something is out of
whack with the username and password. In that case:


1) Open the "Properties" menu palette under the "Window" menu bar
2) Open the "Workspace" menu palette (if not already open) and
highlight the datasource
3) In the "Properties" palette, click the "Development" tab, then
uncheck the box that says "Ask each time"
4) try again

if this doesn't work, check your username and password in the DSN

I hope this helps.
Chris

On Jan 29, 2004, at 4:26 PM, Trevor Green wrote:

Hi

Is there some neat little document somewhere that explains how to use
ODBC with MacOSX properly? I am running Panther with Dev Studio 5.5
and mySQL. I have created the DSN’s and when I test them using
odbctest they work fine. When I go into the Dev Studio I can see the
DSN’s but when I try and expand them I get an error saying that a
connection could not be made.


Please help!!!
 
Trevor Green

____________________________________________________________________ __
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf



______________________________________________________________________ __
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


Trevor Green
IT Director

TBWA\Chiat\Day
Telephone: 310-305-5269
Fax: 310-305-6269
Mobile: 310-925-4158

_______________________________________________________________________ _
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf



________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Reply via email to