configuring MyODBC

Nemecsek Gyorke

Delphi Developer

Fri, 20 Feb 2004 20:22:26 GMT

configuring MyODBC

Hello,
I'm using MySQL as a DataBaseServer and I want to acces his
database(eg: the directory is 'Test' and the 'table' is 'tableOne'). I
downloaded the MyODBC driver and I run the 'setup' program).
Now I want to modify the 'tableOne' from an interface created
in Delphi5(here I have controls that can acces the ODBC defined
tables). When I want to activate the database(with the alias
'sampleMySQL') is opened a window that ask for user and password(I
created users without password in mysql tables).
I get the erros 'Invalid configuration parameters'. In ODBC
administrators what changes I have to make(at User DSN, System DSN,
File DSN)?
I have installed BDEadministrator.
Thank you anticipate,
Nemecsek Gyorke
nemec...@personal.ro

M.H. Avegaar

Delphi Developer

Sat, 21 Feb 2004 16:41:02 GMT

Re:configuring MyODBC

Sorry, I don't know anything about MySQL, but why use the ODBC driver if you
can access MySQL directly from Delphi ? See
http://www.productivity.org/projects/mysql/.

Quote

"Nemecsek Gyorke" <romaup...@yahoo.com> wrote in message

news:9ft6pt84536bc90nfbeo735kljtc257c0d@4ax.com...

Quote

> Hello,
> I'm using MySQL as a DataBaseServer and I want to acces his
> database(eg: the directory is 'Test' and the 'table' is 'tableOne'). I
> downloaded the MyODBC driver and I run the 'setup' program).
> Now I want to modify the 'tableOne' from an interface created
> in Delphi5(here I have controls that can acces the ODBC defined
> tables). When I want to activate the database(with the alias
> 'sampleMySQL') is opened a window that ask for user and password(I
> created users without password in mysql tables).
> I get the erros 'Invalid configuration parameters'. In ODBC
> administrators what changes I have to make(at User DSN, System DSN,
> File DSN)?
> I have installed BDEadministrator.
> Thank you anticipate,
> Nemecsek Gyorke
> nemec...@personal.ro

Sundial Services International, In

Delphi Developer

Sun, 22 Feb 2004 02:02:11 GMT

Re:configuring MyODBC

Passwords and other configuration information are provided in the
"Parameters" property of the TDatabase. (You will need an explicit
TDatabase.)

It's the same as with any other ODBC connection.

(and BTW, I am personally in favor of using ODBC for the connection versus
hooking to MySQL directly. You never know when you'll need to change
databases. But that's only an opinion.)

In article <9ft6pt84536bc90nfbeo735kljtc257...@4ax.com>, Nemecsek Gyorke

Quote

<romaup...@yahoo.com> wrote:
> Hello,
> I'm using MySQL as a DataBaseServer and I want to acces his
> database(eg: the directory is 'Test' and the 'table' is 'tableOne'). I
> downloaded the MyODBC driver and I run the 'setup' program).
> Now I want to modify the 'tableOne' from an interface created
> in Delphi5(here I have controls that can acces the ODBC defined
> tables). When I want to activate the database(with the alias
> 'sampleMySQL') is opened a window that ask for user and password(I
> created users without password in mysql tables).
> I get the erros 'Invalid configuration parameters'. In ODBC
> administrators what changes I have to make(at User DSN, System DSN,
> File DSN)?
> I have installed BDEadministrator.
> Thank you anticipate,
> Nemecsek Gyorke
> nemec...@personal.ro

Alle

Delphi Developer

Mon, 23 Feb 2004 08:58:08 GMT

Re:configuring MyODBC

In control panel you can modify property of "SampleMYSQL",
CHANGE user and password.

Quote

Nemecsek Gyorke <romaup...@yahoo.com> wrote in message

news:9ft6pt84536bc90nfbeo735kljtc257c0d@4ax.com...

Quote

> Hello,
> I'm using MySQL as a DataBaseServer and I want to acces his
> database(eg: the directory is 'Test' and the 'table' is 'tableOne'). I
> downloaded the MyODBC driver and I run the 'setup' program).
> Now I want to modify the 'tableOne' from an interface created
> in Delphi5(here I have controls that can acces the ODBC defined
> tables). When I want to activate the database(with the alias
> 'sampleMySQL') is opened a window that ask for user and password(I
> created users without password in mysql tables).
> I get the erros 'Invalid configuration parameters'. In ODBC
> administrators what changes I have to make(at User DSN, System DSN,
> File DSN)?
> I have installed BDEadministrator.
> Thank you anticipate,
> Nemecsek Gyorke
> nemec...@personal.ro

Other Threads

1. MySQL, Delphi 4 and MyODBC

2. MySQL Memo Fields Returned (D5e, BDE5.11, MySQL on Linux Server, MyODBC)

3. MySQL, MyODBC, Delphi: record locked and cursor errors ?

4. MyODBC and installation question

5. myODBC login prompt

6. urgent myodbc/mysql question

7. MYODBC 3.51 PROBLEMS

8. [MySQL]myODBC vs MyOLEDB

9. Problem accessing MYSQL through ADO(MYODBC)

10. MySQL, Delphi 4 and MyODBC