connecting ultradev to an access database

[evlhomer01]

i am fairly new to ultradev and i am trying to construct a simple shopping cart system.

I have uploaded my access file to my hosts server and set up to odbc on that server correctly.

when i am back in ultradev and i am trying to establish the connection between my pages and the remote data base it keeps coming up with "HTTP error code 500 internal server error". I think i might need a script pointing to my database in the cgi-bin directory of my server but i really have no idea!

I understand that i may by doing something really stupid, but i really need help!

 

[schase]

Hey Homer,

You need to do a couple of things. First see if your host is DSN or dsn-less. It makes a slight difference when you set it up in UD4.

Then in a page within your site. You hit modify, then connections, then a box pops up, hit new, then define, then the odbc box pops up, click system tab, then define the database (name, locate it), then when you click back to the data source box - click local dsn.

This will let you create your recordsets, and upload. And coincidentially if you have a DSN connection with your host (they need to mount the database) it will work great,
if you have a dsn-less theres a connection script.

If you get lost on any part, don't stress, after doing a couple you'll be flying with it. Hollar if you get stuck "If you feel a post has been helpful to you, click on the link at the bottom of their post to cast a vote for "TipMaster Of The Week". You don't need to be the one who asked the question to vote"

Stuart