Which ports to open?

[megalith]

I have made ports 19998 and 19997 available to the ODBC Server but I still
can't create a database in the Administrator. If I turn off TCP/IP port
filtering on the NIC card then creating datasources works fine.

Any ideas what other port(s) may need to be open for creating datasources to
work?

server 2003
CFMX7

thanks

[mpwoodward *TMM*]

megalith wrote:

> I have made ports 19998 and 19997 available to the ODBC Server but I still
> can't create a database in the Administrator. If I turn off TCP/IP port
> filtering on the NIC card then creating datasources works fine.
>
> Any ideas what other port(s) may need to be open for creating datasources to
> work?
>
> server 2003
> CFMX7
>
> thanks
>

The first and most obvious question is what type of database are you
trying to connect to? Unless you're using an ODBC socket for some
reason (which isn't recommended) you won't be configuring datasources in
the "ODBC Server" (which I assume means the ODBC datasources section of
the Windows admin tools?).

Matt

--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[megalith]

Matt,

sorry, that was lame not to mention the DB. we run Access and MySQL on the
server. All I know is that I can create DB's in the CF admin with tcp/ip port
filtering off, but with it on DB creation in the CF admin fails (times out).

thanks for you response

[mpwoodward *TMM*]

megalith wrote:

> Matt,
>
> sorry, that was lame not to mention the DB. we run Access and MySQL on the
> server. All I know is that I can create DB's in the CF admin with tcp/ip port
> filtering off, but with it on DB creation in the CF admin fails (times out).
>
> thanks for you response
>

Just a couple more points of clarification. Access is a file-based
database application so you don't really "run" Access anywhere except
where you're running the application that creates the Access databases.
In other words, there isn't an Access server that you connect to, you
just hit an mdb file. Connecting to a REMOTE Access database (in other
words, the mdb file is not on the same physical machine as CF) can be a
bit tricky, so if you're trying to do that all I can say is good luck.
:-) If you have the drive mapped and the permissions set up correctly
(meaning you might have to change the user account under which CF runs)
then you should be able to do it but it does involve a bit of work. If
the mdb file is on the same machine as CF then you should have no
problems using the built-in Access drivers that come with CF.

As for MySQL, by default this runs on port 3306. You'll want to do a
quick search on macromedia.com for "coldfusion and mysql" or something
similar to come up with some gotchas for running MySQL 4 or above, since
the drivers that ship with CF don't work out of the box with anything
above 3.x.

Hope that gets you a bit closer to a solution!
Matt

--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion