Mysql connection in XP

[scitech]

Just got XP and downloaded MySql, got them and dwmx up and running, DWeaver won't let me connect to the mysql stuff at all :- http error code 405 method not allowed
I can get sql through the command line, it seems to be running in the services panel, as far as I can see all my paths etc are correct, I'm just going round and round

 

[schase]

well I no longer use DW for any coding I do (hand code it all now). So I won't be able to help much, but perhaps I can prod you into the proper direction.

But I did a quick search here and came up with a few pages of people having similiar issues - but first I'd check your connection string. Here is an example taken from a similiar post here.

Dim MM_MYSQL_STRING
MM_MYSQL_STRING = "driver={MySQL ODBC 3.51 Driver};; database=DB_NAME;server=IP_OR_DOMAIN.com;uid=USER;pwd=PASS;option=16386;"

Of course you'd probably need the myODBC driver - but I suspect you already have that on the server. Otherwise, do a search here in this forum for mySQL. Fear not most of the first search results page comes up with no replies to the posts, but as you go further into the search you do get results.

And when you do find the answer - write a FAQ about it, help others coming in behind you.

"Never underestimate the power of determination"

Stuart
A+, Net+

 

[johnwm]

Fear not most of the first search results page comes up with no replies to the posts, ..

I believe the lookup for number of replies is from a static table, updated every now & then. You will find that quite a lot of the '0 replies' threads will actually have answers if you follow the link

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Essex Steam UK for steam enthusiasts

 

[scitech]

I have done some digging and as far as I can see my PHP has no MYSQL support, only SQLite from phpinfo() is this what is wrong?