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
