----- Original Message -----
From: "Luis" <[EMAIL PROTECTED]>
To: "Steve Ruby" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 9:59 PM
Subject: Help with ODBC
> Thank you for all the help on MyODBC but I can't connect to mysql server
> threw access.
>
> Here are the steps on how I start.
>
> 1. I download the MyODBC setup file for windows. I ran the setup
everything
> went fine.
> 2. Then I went in to my control panel > double click on ODBC Data
> 3. ODBC Data open , I see seven options User DSN, System DSN, File DNS,
> Drivers, Tracing Connection Pooling, Abaout
> 4. I add in the User DSN "agentinfo" --- agentinfo is a database also in
mysql
> server.
> 5. When i added i got other window that had alot of fields to fill in .,
>
> A. Windows DSN name : agentinfo
> B. Mysql Host : 192.168.2.146 --- that's the
ip
> address were i have mysql running.
> C. Mysql database name: agentinfo -----------name of
> database on mysql.
> D. user name : root -------- thats what i
use
> when running mysql or adding databases.
> E. password ghost ------------password
to
> log into mysql server.
> F. port (if not 3306) 3306 -------- that's what is
says
> it running on in my /etc/services file
>
> after that i say ok . I also added a entry into Data Source files. were
it
> asked me the same question as above.
> I click ok then i get this error message.
>
> "General error: Invalid file dsn 'C:\Program files\Command Files\ODBC\Data
> Source\agentinfo.dsn"
>
> I dont know what this is .
>
> Just wondering what I'm doing wrong. or if someone could show me the right
> steps on loading it configure the ODBC date
> plus how to connect threw access.
>
> Thank you
>
> Luis
>
>
> ---------------------------------------------------------------------
> 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
>
---------------------------------------------------------------------
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
