Gary Huntress wrote:
> I had a similar problem after I installed a driver set, I don't think it was
> the MyODBC drivers, but the outcome was the same, a very generic windows
> error that was not even associated with an attempted connection.
>
> I had to reinstall the Microsoft MDAC components, available here
> http://www.microsoft.com/data/download.htm#26info
>
> Once I did that I could connect, I didn't even have to reinstall the MyODBC
> driver.
>
> Good Luck
>
> Gary "SuperID" Huntress
> =======================================================
> FreeSQL.org offering free database hosting to developers
> Visit http://www.freesql.org
>
> ----- 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
> >
thank you gary for the link i installed it . went back to control panel - ODBC
went to the "File DSN" option added
server1
filled out all the fields once again, then i said ok
but this time i got this message
" A connection could not be made using the file data source parameters entered
. Save not-verified file DSN?"
So can you please tell me what i'm doing wrong
bye 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
