database connection

[w1r4]

hi...
i got a problem with the database connection...
i got one file that cant connect to the database....(besides this file all my
database connection are workin properly)
but i dunno wat happen with this file, i cant connect it...when i try to
create the database,the testing on that page are made succesfully but when i
was looking for the database table in dreamweaver itself they didnt come out...

if anyone know how to solve it...plz let me know...
thank you very much....

[lapfama]

Hi
I cannot make a connect to the db. Not only to a db created by myself, but
also to the ones that are for tutoring purposes defined by default.
When I verify the connection of the default db, it gives me "Error" in all 3.
When I try to connect to my db, the message says:
The ColdFusion MX ODBC Server service is not running or has not been installed

Any ideas?

Laura

[mxstu]

Did you check under "Services" and make sure these two services are running?

ColdFusion MX 7 ODBC Agent
ColdFusion MX 7 ODBC Server

[lapfama]

Thanks
I'm runnig cf mx (not mx7)
I don't have a tab or link named "Services"

Where else can I find:
ColdFusion MX 7 ODBC Agent
ColdFusion MX 7 ODBC Server

Thanks,

Laura

[mxstu]

Assuming you're running windows look for Control Panel --> Services or
Administrative Tools ---> Services. The exact location depends on the windows
version. The name of the services might be slightly different, like
"ColdFusion MX ODBC Agent" instead of "ColdFusion MX 7 ODBC Agent".

[lapfama]

Thanks

I'm in ODBC Data Source Administrator.
It has 7 tabs:
User DSN - System DSN - File DSN - Drivers - Tracing - Connection Pooling -
About
Under Systems DSN I can see all the databases (CF defaults ones and mines).
However, I can't see anything similar to:
"ColdFusion MX ODBC Agent" instead of "ColdFusion MX 7 ODBC Agent"

Thanks,

Laura

[mxstu]

No, you don't want "ODBC Data Source Administrator". You're looking for
"Services". You can see an image of the "Services" icon
[url]http://www.microsoft.com/windowsxp/images/using/security/learnmore/admintools.jp[/url]
g. Open up "Services" and you should see an alphabetical listing, look for
something like "ColdFusion MX ODBC Agent" and if it is not started, start it.

[lapfama]

Great!!!
Now all db connections are working.

Thanks a lot Ralph,

Laura

[BetsyW.]

I am new at all of this and the different combinations of software/hardware.
are a bit confusing - seems like I should
really know what works together before I decide what to learn.....

I would like to know if I can connect to a MySQL database from within DW8
using Coldfusion on a Mac?

thanks in advance
BW

[Hedecan]

hi everybody
my questions = i want to connection database on Flash 5 and my database is Access database.
How to?
please help

[Motion Maker]

Generally connection to a DB is done with the DB on a web server. If you dig
there are third party products for connection locally but they may require a
later version of Flash.

I believe in Flash 5 you used loadVariables or XML class.

XML creates an object. The XML class had some type of a whitespace problem
as I recall and you have to do the parsing.


The loadVariables method gets the data in URL variable format from the
server and places them as variables into a timeline.
loadVariables("http://myserver.com/nameofscript",_root.clipInstanceTimelineToHoldVari ables,POST).
I believe it also sends the variables in the timeline to the server script.

The rest is using ASP or ASP.Net and probably the ADO library to use the
Access database.

--
Lon Hosford
[url]www.lonhosford.com[/url]
May many happy bits flow your way!
"Hedecan" <webforumsuser@macromedia.com> wrote in message
news:dr4l79$oar$1@forums.macromedia.com...
hi everybody
my questions = i want to connection database on Flash 5 and my database is
Access database.
How to?
please help

[sabafana]

I can't get a connection to an Access database on a virtual server.
I am trying to use asp.net VB.
I know this may be easy to some people but I am knew to programming.
Please help.