access database on another machine

[AcidGuy]

hi guys!

is posible to connect coldfusion mx with databases residing in another machine
?

an access database is required to be on another machine running windows 98,
that is the database of the host computer on a x store, so when the company
has to do inventory, the store is closed and the people of inventory will turn
on a laptop that is running like a web server using coldfusion mx, each
employee will get a pocket pc and start counting the remaining products in the
store connected through wireless, so the laptop will have coldfusion mx and
will send the data to the database on the host computer that is in the store...

huh!, my bosses are pressuring me with this project...

is coldfusion mx capable of doing this ?

thx for any help!

[rmorgan]

You can with other types of databases, not sure about access. But I dont see any reason why you cant, you just may have to map a drive to the remote computer.

[AcidGuy]

the drive just doesnt appear on coldfusion 6 administrator panel, in coldfusion
7 developer edition it just say the database cannot be located, and when i make
it using the odbc windows panel, i can manipulate it through it but coldfusion
just cant access to the database...

help!!!!

[syseng]

I am not sure this will help but ....

Make sure your db allows CF username and password accesses. And what is the
CF service accounts you are running under? are these accounts allowed to
access the box that have the db?

Connie

[AcidGuy]

yes, they are allowed...

the weird thing is that i can create a virtual unit pointing to the database
in the other machine and then the server cant manipulate the database, and
creating a dns in the local machine and then pointing the the other computer
doesnt work too, no matter if i can manipulate de database through the windows
dns control, coldfusion just seem not available to do it...

any help is apreciated!

[sdupre]

You can use ODBC Socket to get to the other machine without the use of mapped
drives.

Machine-with-db - CF with "cfsnippets" datasource to local MS Access database.
(ODBC datasource registered)
-Start up 'ColdFusion MX ODBC Server' on machine 1.

Machine-remote - CF with datasource "cfsnippets_remote"
- Create an "other" type datasource with the following parameters

URL:
jdbc:sequelink:odbcsocket://Machine-with-db:19998;serverDatasource=cfsnippets
Driver: macromedia.jdbc.MacromediaDriver

If you're using CF7, the port would be 19996.

Stephen Dupre
Macromedia QA

[Dai Wei]

jdbc-odbc bridge driver can operate remote Access database, if you used
mapped driver to share your MS Access database.

HXTT Access([url]www.hxtt.net[/url]) provides pure Java REMOTE ACCESS mode and
DIRECT ACCESS mode for MS Access. It needn't DSN setting or ODBC
support. But it doesn't provide MS Access compatible lock for
concurrent access now, so that you can't use it to write data into your
Access database when MS Access application is writing data at the same
time.

[AcidGuy]

what happens is that the another machine doesnt have cfmx installed, just has
windows 98, since the engineers in this company just know visual 6...

hahahaha, not like me, they just have another mind...
huh!, maybe the microsoft one .....

so the case is that the laptops that are going to travel through the country
making the inventory check, will have coldfusion 6 running, the host not, so i
am making my best effort to connect those laptops to the host through
coldfusion mx, i am limited to 3 licenses of coldfusion professional that the
company acquired in united states through a solution company, i think a
macromedia partner..., 1 year ago or a little more...so they are 3
laptops...that gonna run the application that i am testing perfectly with my
computer running the database locally and using the pocket pcs i have...

the main problem is the connection to the host database ( the store ones ),
running windows 98 and others 2000

if anyone can point me to a good tutorial online, would be great!
thx for the support until now...

[AcidGuy]

huh!

is done!

mapping through a virtual unit doesnt work
just enter into the host machine through panel control and then look for the
database on the host machine,
thats the path i am going to give to coldfusion... it works pretty!