re: Re: unable to create File DSN

2002-12-29 Thread Victoria Reznichenko
On Saturday 28 December 2002 10:59, Robert Citek wrote:

> Seems like I'm not alone:
>   http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:52006
> On the bright side, I found an answer that pointed me somewhat in the right
> direction:
>   http://www.geocrawler.com/archives/3/13/1998/11/0/56625
>
> I have discovered that I can create a trimmed-down version using notepad:
>
> [ODBC]
> DSN=foobar
>
> If I call this file foo.dsn and put it in "C:\Program Files\Common
> Files\odbc\Data Sources", foo.dsn shows up in the ODBC Data Source
> Administrator application (aka ODBC manager).  However, in order to
> actually use it, I have to create the System DSN that is specified in the
> File DSN, for this example, foobar.  Using the ODBC manager, if I change
> the File DSN, the System DSN also changes, and vice versa.  Yet, when I
> quit and examine the file foo.dsn, nothing has changed.  It still just has
> the single line DSN=foobar.
>
> What is the advantage of creating a File DSN if I have to create a System
> DSN?  Why not use the System DSN instead of a File DSN?  Setting up a
> System DSN so that I can create a File DSN leaves me with the feeling that
> something is broken.  Is it Windows' ODBC manager?  Is it MyODBC?  Should I
> be trying MyODBC 3.51?

Yes, it's only supported by MyODBC 3.51, but not by 2.50.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: unable to create File DSN

2002-12-28 Thread Robert Citek

Hello all,

Seems like I'm not alone:
  http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:52006
On the bright side, I found an answer that pointed me somewhat in the right
direction:
  http://www.geocrawler.com/archives/3/13/1998/11/0/56625

I have discovered that I can create a trimmed-down version using notepad:

[ODBC]
DSN=foobar

If I call this file foo.dsn and put it in "C:\Program Files\Common
Files\odbc\Data Sources", foo.dsn shows up in the ODBC Data Source
Administrator application (aka ODBC manager).  However, in order to
actually use it, I have to create the System DSN that is specified in the
File DSN, for this example, foobar.  Using the ODBC manager, if I change
the File DSN, the System DSN also changes, and vice versa.  Yet, when I
quit and examine the file foo.dsn, nothing has changed.  It still just has
the single line DSN=foobar.

What is the advantage of creating a File DSN if I have to create a System
DSN?  Why not use the System DSN instead of a File DSN?  Setting up a
System DSN so that I can create a File DSN leaves me with the feeling that
something is broken.  Is it Windows' ODBC manager?  Is it MyODBC?  Should I
be trying MyODBC 3.51?

Any pointers greatly appreciated.

Regards,
- Robert

sql

-

At 11:38 PM 12/27/2002 -0600, Robert Citek wrote:
>Why can I not create a File DSN using MyODBC 2.50.39 on Windows 2000?


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php