RE: [cobalt-developers] RE: Connection to MySQL through ODBC

["Anthony Noe" <anthony@xxxxxxxxxx>]

I don't know if this will help, but I have been using Dreamweaver for some
time and have not been able to get it to connect via dsn to my cobaly
either.  What I do is run a 'dummy' db on my desktop that is structured the
same as the one you want to connnct on the cobalt.  You can connect as
localhost and your sites will function the same on your desktop as your
server.

Anthony

-----Original Message-----
From: cobalt-developers-admin@xxxxxxxxxxxxxxx
[mailto:cobalt-developers-admin@xxxxxxxxxxxxxxx]On Behalf Of Marcus
Miller
Sent: Tuesday, April 01, 2003 2:21 PM
To: cobalt-developers@xxxxxxxxxxxxxxx
Subject: RE: [cobalt-developers] RE: Connection to MySQL through ODBC


Hi Jean

Think you are doing something wrong, like Ian said the error messages you
are getting are ftp errors.

Any problem like this is best broken up into smaller pieces.
- Can you ftp the .asp pages to the remote server

- If yes, can you request these pages in a browser

- re the DSN. You have setup a mysql odbc driver on a local PC, you are
using this to connect to a mysql database on your raq and that is ok.

The Data Source Name is local to your pc, the Data Source is on the Raq?
The .asp scripts you are trying to run are on the raq?

I am no expert on chillisoft ASP or MS-ASP but i think that chillisoft ASP
runs on linux boxes, MySQL runs on linux boxes, DSN's run on windows boxes.
I have found some code that will allow you to connect chillisoft asp to your
mysql database in DSN less style. (this code assumes the asp scripts and the
database are on the same machine)

<?

'*** create the connection string
strConn = "DRIVER={MySQL};SERVER=localhost;DATABASE=myDatabaseName;"

' *** create variables for login details
strUser = "myUserID"
strPassword = "myPassword"

'*** create the connection object then open it passing your login details.
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open strConn, strUser, strPassword

stResult = "<p> Hi, ASP tells me your connection was a success!</p>"

set mRS = nothing
set conn = nothing

?>

I hope this helps!
I think the majority of this list does not use chillisoft therefore
slim set of replies.

Kind regards
Marcus

-----Original Message-----
From: cobalt-developers-admin@xxxxxxxxxxxxxxx
[mailto:cobalt-developers-admin@xxxxxxxxxxxxxxx]On Behalf Of Jean
Paterson
Sent: 01 April 2003 01:50
To: cobalt-developers@xxxxxxxxxxxxxxx
Subject: RE: [cobalt-developers] RE: Connection to MySQL through ODBC


Dear Ian,
Thanks for responding anyway.  I am sure it is something stupid I am doing
as I am new to this. I just need to figure out what.

Jean Paterson
www.e-zoneuk.com
Tel: 020 8892 9900

-----Original Message-----
From: cobalt-developers-admin@xxxxxxxxxxxxxxx
[mailto:cobalt-developers-admin@xxxxxxxxxxxxxxx] On Behalf Of Ian
Sent: 01 April 2003 10:08
To: cobalt-developers@xxxxxxxxxxxxxxx
Subject: Re: [cobalt-developers] RE: Connection to MySQL through ODBC

On 1 Apr 2003 at 9:36, Jean Paterson wrote:

>
> Hi,
> I wondered if you had a chance to look at my email below yet?  I ma still
> having problems and would appreciate any help you can give.
>
> Many thanks.
>
> Jean Paterson
> www.e-zoneuk.com
> Tel: 020 8892 9900
>
> -----Original Message-----
> From: Jean Paterson [mailto:jean.paterson@xxxxxxxxxxxx]
> Sent: 28 March 2003 15:12
> To: 'cobalt-developers@xxxxxxxxxxxxxxx'
> Subject: Connection to MySQL through ODBC
>
>
> I have installed MySQL version 3.23.54-1 and Sun Chili!Soft ASP version
> 3.6.2 on my RAQ4.  When I set up a DSN and test on the server it I get the
> message the test connection was successful.
>
> When I try to connect using the DSN from my PC using Dreamweaver and using
> the driver on the testing server, I get the following error messages one
> after the other:
>
> 1.  An ftp error occurred. Cannot put MMHTTPDB.asp
>     550 MMHTTPDB.asp: permission denied
> 2.  An ftp error occurred.  Cannot put adojavas.inc
>     550 adojavas.inc: permission denied.
> 3.  An ftp error occurred.  Cannot put MMHTTPDB.js
>     550 MMHTTPDB.js: permission denied.
> 4.  Unidentified error.
>
> If I connect using a DSN less connection string, I am successful if I use
> the driver on my PC, but not successful if I use the driver on the testing
> server.
>
> Does anyone have any ideas what I should do next?

Hi Jean,

I do not use Dreamweaver for asp sites ( I could never get it to work
), so can't help you there.

But, the error message you reported are FTP errors.  Basically the
FTP part of Dreamweaver is complaing because it cannot PUT (or write
) a file to the website.

Make sure you have the right FTP settings in Dreamweaver.

On another note, we have had lots of users complaining that they have
trouble FTP'ing from Dreamweaver ( and claiming its our fault ).  It
turns out that Dreamweaver is slower than most real FTP clients and
needs a larger 'timeout' value.  We usually recommend increasing it
to 60 seconds.

You could also try http://www.macromedia.com for ideas.

Regards

Ian
--



_______________________________________________
cobalt-developers mailing list
cobalt-developers@xxxxxxxxxxxxxxx
http://list.cobalt.com/mailman/listinfo/cobalt-developers



_______________________________________________
cobalt-developers mailing list
cobalt-developers@xxxxxxxxxxxxxxx
http://list.cobalt.com/mailman/listinfo/cobalt-developers

_______________________________________________
cobalt-developers mailing list
cobalt-developers@xxxxxxxxxxxxxxx
http://list.cobalt.com/mailman/listinfo/cobalt-developers