|
Home > Archive > dBASE Web Applications > November 2006 > 2nd database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Claus Mygind 2006-11-10, 7:16 pm |
| I there some spcial trick to adding a 2nd database to MySQL server. I have
one database setup and it works fine. When I try to duplicate that and set
up a 2nd database I cannot get the MS ODBC Data Source Administrator to ping
the file.
After following the same setup procedures and granting priviliges and all on
the Server, I go into the ODBC Data Source Administrator and repeat the
steps for the one that works. Original pings, the new one just says cannot
connect to server.
I know this is a broad question, so just any "Have you thought of this..."
will be fine.
| |
| Ronnie MacGregor 2006-11-10, 7:16 pm |
|
On Fri, 10 Nov 2006 14:59:31 -0600
Claus Mygind said :
> I there some spcial trick to adding a 2nd database to MySQL server. I have
> one database setup and it works fine. When I try to duplicate that and set
> up a 2nd database I cannot get the MS ODBC Data Source Administrator to ping
> the file.
>
> After following the same setup procedures and granting priviliges and all on
> the Server, I go into the ODBC Data Source Administrator and repeat the
> steps for the one that works. Original pings, the new one just says cannot
> connect to server.
>
> I know this is a broad question, so just any "Have you thought of this..."
> will be fine.
With no experience of MySQL (as yet), and limited experience of MSDE2000, my
first thought would be to create a second ODBC connection and pay attention to
the "default database" setting.
--
Ronnie MacGregor
Scotland
Ronnie at
dBASEdeveloper
dot co dot uk
www.dBASEdeveloper.co.uk
| |
| Robert Bravery 2006-11-12, 12:12 am |
| Hi,
I have had no problems setting up multiple MySQL databases.
I set up the MySQL databsae
Create a ODBC DSN
Create a BDE alias
The BDE alias must include the DSN
Robert
"Claus Mygind" <cmygind@tsccorp.com> wrote in message
news:ki$LoyQBHHA.880@news-server...
> I there some spcial trick to adding a 2nd database to MySQL server. I
have
> one database setup and it works fine. When I try to duplicate that and
set
> up a 2nd database I cannot get the MS ODBC Data Source Administrator to
ping
> the file.
>
> After following the same setup procedures and granting priviliges and all
on
> the Server, I go into the ODBC Data Source Administrator and repeat the
> steps for the one that works. Original pings, the new one just says
cannot
> connect to server.
>
> I know this is a broad question, so just any "Have you thought of this..."
> will be fine.
>
>
| |
| Claus Mygind 2006-11-13, 7:14 pm |
| Thanks both Ronnie and Robert.
Ronnie - you can't create a bde connection before the ODBC connection is
established. But thanks anyway
Robert - The steps you outlined was exactly what I did. I did do some
further testing
The webserver pings the MySQL sever just fine. (and of course both my users
Administrator and WebAccsser both can get an OK response to the first
database but neither can get access to the second data base).
On the MySQL server both users can create tables put in data etc. in the 2nd
database. They just can't do it from the Webserver.
Was it you Robert that wrote an online tutorial for how to setup a MySQL
server. If so what was the link so that I might review those steps again to
see what it is that I am overlooking?
"Robert Bravery" <me@u.com> wrote in message
news:2tpH7whBHHA.2036@news-server...
> Hi,
>
> I have had no problems setting up multiple MySQL databases.
> I set up the MySQL databsae
> Create a ODBC DSN
> Create a BDE alias
> The BDE alias must include the DSN
>
> Robert
>
> "Claus Mygind" <cmygind@tsccorp.com> wrote in message
> news:ki$LoyQBHHA.880@news-server...
> have
> set
> ping
> on
> cannot
>
>
| |
| David Ball 2006-11-13, 7:14 pm |
| Hello Claus
"Claus Mygind" <cmygind@tsccorp.com> wrote
> Was it you Robert that wrote an online tutorial for how to setup a MySQL
> server. If so what was the link so that I might review those steps again
to
> see what it is that I am overlooking?
This one perhaps?
http://www.chelseadata.ca/tutorials/mysql1.php
David Ball
| |
| Claus Mygind 2006-11-13, 7:14 pm |
| David,
Thanks, Yes that was the reference I was looking for. I am hoping to find
some clue in there as to what I am doing wrong.
If you have any suggestions on how I can fix my problem it would be greatly
appreciated.
Claus
"David Ball" <Thanks.But@NoSpam.4.me> wrote in message
news:I9U5LY0BHHA.1136@news-server...
> Hello Claus
>
> "Claus Mygind" <cmygind@tsccorp.com> wrote
> to
>
> This one perhaps?
>
> http://www.chelseadata.ca/tutorials/mysql1.php
>
> David Ball
>
>
| |
| Ronnie MacGregor 2006-11-13, 7:14 pm |
|
On Mon, 13 Nov 2006 06:27:32 -0600
Claus Mygind said :
> Ronnie - you can't create a bde connection before the ODBC connection is
> established. But thanks anyway
Who mentioned a BDE connection ?
--
Ronnie MacGregor
Scotland
Ronnie at
dBASEdeveloper
dot co dot uk
www.dBASEdeveloper.co.uk
| |
| David Ball 2006-11-14, 12:13 am |
| Hi Claus
"Claus Mygind" <cmygind@tsccorp.com> wrote
> After following the same setup procedures and granting priviliges and all
on
> the Server, I go into the ODBC Data Source Administrator and repeat the
> steps for the one that works. Original pings, the new one just says
cannot
> connect to server.
What program are you using to create the second database?
What ODBC driver and version are you using?
Thank you
David Ball
| |
| Claus Mygind 2006-11-15, 12:13 am |
| The database is being created in MySQL 5. The ODBC driver is 3.xx the
current version I don't believe they have perfected their verison 5 yet. I
am sure my problem is something simpler that I must be overlooking.
"David Ball" <Thanks.But@NoSpam.4.me> wrote in message
news:9HI3RC5BHHA.2044@news-server...
> Hi Claus
>
>
> "Claus Mygind" <cmygind@tsccorp.com> wrote
> on
> cannot
>
> What program are you using to create the second database?
> What ODBC driver and version are you using?
>
> Thank you
> David Ball
>
>
>
>
>
>
| |
| Claus Mygind 2006-11-15, 12:13 am |
| Oops your right, my mistake.
Your suggestion is what I was trying to do. Connection 1 works fine.
Connection 2 with the same parameter is a no go.
"Ronnie MacGregor" <No_Sp@m.Thanks> wrote in message
news:MPG. 1fc2e2f1636d339b9897
c0@news.dbase.com...
>
> On Mon, 13 Nov 2006 06:27:32 -0600
> Claus Mygind said :
>
>
> Who mentioned a BDE connection ?
>
> --
> Ronnie MacGregor
> Scotland
>
> Ronnie at
> dBASEdeveloper
> dot co dot uk
>
> www.dBASEdeveloper.co.uk
>
>
>
| |
| David Ball 2006-11-15, 7:17 pm |
| Hi Claus
Re: database access:
Thanks, but _how_ are you accessing the database? Are you using the monitor
(ie. a mysql-> prompt) or are you using the MySQL Control Centre or MySQL
Administrator or phpMyAdmin or something else? There are different programs
with different interfaces, some of which are easier to use than others - in
this case, I would use a GUI progam like MySQL Control Centre which will
show you in a treeview all of the databases on a particular server. You can
create the database and it will show you the results right away.
Re: ODBC
From your description, whatever driver you are using appears to be different
from the version 3.51 that I am familiar with. In the Windows ODBC
Administrator, do you get the same screens that I do in my tutorial (ie, the
mySQL-specific Connector/ODBC window with the 'Test' button, etc.) You
mention trying to ping the connection, which I don't see on my ODBC screen.
To be able to help you, I will try to encourage<g> you to use the products
and versions that I am using, otherwise there is too much guesswork. I would
suggest the MySQL Control Centre, which has the treeview of databases
visible. With this product, you should be able to see where the problem is
with a second database, or whether MySQL can create it (and hopefully give
you an error message or something if it cannot.)
If your ODBC connection to MySQL is using the same driver as on the
tutorial, you could check the connection using the instructions, and note
any differences.
Thank you
David Ball
"Claus Mygind" <cmygind@yahoo.com> wrote in message
news:%23XYKuAHCHHA.1472@news-server...
> The database is being created in MySQL 5. The ODBC driver is 3.xx the
> current version I don't believe they have perfected their verison 5 yet.
I
> am sure my problem is something simpler that I must be overlooking.
>
> "David Ball" <Thanks.But@NoSpam.4.me> wrote in message
> news:9HI3RC5BHHA.2044@news-server...
all[color=darkred]
>
>
| |
| Claus Mygind 2006-11-16, 12:19 am |
| Hi David,
I was at home when I wrote the last response so I could not remember all the
particulars. But yes I am using 3.51. When I interface with the MySQL
database I do use the MySQL Administrator (which I find very easy to use)
That said I re-read your tutorial and I think I know what my problem is. I
must have given the computer a name, That is the name I need to use before
I can observe the databases I have created. It just happens I think the
name of the computer is also the same name of the first database I created
(an unfortuante stroke of luck). I will be testing out my theory tomorrow
when I get back to work.
With regards to me using the term "ping", that was a poor choice of words.
Pinging is something you do from the Command window to verify a connection
is there ie: 1) Windows start 2) Accessories 3) Command Prompt 4) at the
prompt type in: >ping <your computer name or ip address> - that will tell
you if one computer can see another (but you probably allready know all this
stuff). And acutally that worked fine.
What I was trying to say - when I clicked the "Test" button that you are
referring to, that is when I got the failure. My connection is not working
(and I think from reading your stuff that it is because I am not typing in
the right computer name). I will post a success or failure on my attempt
tomorrow.
Thanks for all your help.
Claus
"David Ball" <Thanks.But@NoSpam.4.me> wrote in message
news:A33xp%23NCHHA.1140@news-server...
> Hi Claus
>
> Re: database access:
> Thanks, but _how_ are you accessing the database? Are you using the
> monitor
> (ie. a mysql-> prompt) or are you using the MySQL Control Centre or MySQL
> Administrator or phpMyAdmin or something else? There are different
> programs
> with different interfaces, some of which are easier to use than others -
> in
> this case, I would use a GUI progam like MySQL Control Centre which will
> show you in a treeview all of the databases on a particular server. You
> can
> create the database and it will show you the results right away.
> Re: ODBC
> From your description, whatever driver you are using appears to be
> different
> from the version 3.51 that I am familiar with. In the Windows ODBC
> Administrator, do you get the same screens that I do in my tutorial (ie,
> the
> mySQL-specific Connector/ODBC window with the 'Test' button, etc.) You
> mention trying to ping the connection, which I don't see on my ODBC
> screen.
>
> To be able to help you, I will try to encourage<g> you to use the products
> and versions that I am using, otherwise there is too much guesswork. I
> would
> suggest the MySQL Control Centre, which has the treeview of databases
> visible. With this product, you should be able to see where the problem is
> with a second database, or whether MySQL can create it (and hopefully give
> you an error message or something if it cannot.)
> If your ODBC connection to MySQL is using the same driver as on the
> tutorial, you could check the connection using the instructions, and note
> any differences.
>
> Thank you
> David Ball
>
>
> "Claus Mygind" <cmygind@yahoo.com> wrote in message
> news:%23XYKuAHCHHA.1472@news-server...
> I
> all
>
>
| |
| Claus Mygind 2006-11-16, 7:13 pm |
| David
Ok I was able to create a second database connection following your
instructions.
But with all the name changes between the MySQL database, ODBC and the BDE I
am getting a little confused.
Plus I am having to contend with some invalid column issues in tables I am
trying to copy from the one database to the other. Not to mention
frustration about - if something has to be restarted or not before it can be
used or is it case sensitive etc..
Therefore I am going to have to let it be for the moment and get back to it
when time permits.
There is no question though if I just follow your instructions I can set up
the connection.
Thanks for your help. I have bookmarked your site this time so I don't have
to go searching for it again in another year.
Claus
|
|
|
|
|