Trying to access live database on server

[sjurick]

I have a MySQL 5.0.62 Community database which has been created on my hosting
domain server using phpAdmin. I flip back over to DW CS4 and make a connection
to the database using the Insert Record behavior. The connection works fine, I
can see all the contents of the table and map fields as expected, however when
I click OK to confirm my settings I get the following error: "While executing
applyServerBehavior in InsertRecord.htm, a JavaScript error occurred."

I tried creating a RecordSet thinking this was the issue but got a similar
error message upon clicking OK. Instead of "InsertRecord.htm" it read
"Recordset.htm".

So I think I'm close seeing that I can connect to the db but don't know why I
can't complete the behavior.

Thanks,
Steve

[David Powers]

Post by sjurick
I get the following error: "While executing
applyServerBehavior in InsertRecord.htm, a JavaScript error occurred."

That's usually the sign of a corrupted file cache in Dreamweaver. Follow
troubleshooting step 4 in the following technote:

http://www.adobe.com/go/tn_19105

[sjurick]

Thanks for the link David. That's a good troubleshooting list for future
reference, however I got rid of the errors by creating a new page and added the
insert record behavior to it. Then I copied that code (top and bottom) to the
existing page. I made sure I placed the code after the two behaviors that were
already being used on that page and it didn't bark at me. So I uploaded the
page to the server and tried to access it. Now I'm getting a new set of errors
on the web page.

Errors on webpage:
Warning: require_once(Connections/connSCT.php) [function.require-once]: failed
to open stream: No such file or directory in
/home/shortcou/public_html/registration_db.php on line 3

Fatal error: require_once() [function.require]: Failed opening required
'Connections/connSCT.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in
/home/shortcou/public_html/registration_db.php on line 3

I believe I read somewhere that you must remove the (<?php
require_once('Connections/connSCT.php'); ?>) code once it's actually on the
server?

Steve

[David Powers]

Post by sjurick
Warning: require_once(Connections/connSCT.php) [function.require-once]: failed
to open stream: No such file or directory in
/home/shortcou/public_html/registration_db.php on line 3

That means that connSCT.php is missing.

Post by sjurick
I believe I read somewhere that you must remove the (<?php
require_once('Connections/connSCT.php'); ?>) code once it's actually on the
server?

Nope. It won't work without it.