I have a fm database that is protected with a password

my set up is as follows:

client > asp server > FM server

currently when the ASP server queries the FM server i get an access denied error on the line:

--------------------------------------

xmldoc.load(http://127.0.0.1:591/FMPRO?-db=test.fp5&-format=-fmp_xml&id_nr=1&-find" )

--------------------------------------

how can i include the password in the query string / and or successfully query the database.:?

If i delete the password from FM pro it works perfectly.

Many thanks

Neil.

I know only how to log into FileMaker via CDML from URL querystring. I do not know single bit about ASP and XML and FileMaker.

Is that fast?

Isn't it better to use CDML?

Try adding the username and password to the URL; e.g.:

xmldoc.load(http://myusername:[email protected]:591/FMPRO?-db=test.fp5&-format=-fmp_xml&id_nr=1&-find" )

Hope this helps.

Garry

Garry,

Including the password in the query sting works !! Thanks very much.

Anatoli,

I have a VB / ASP / Access background and have to work with FM Pro due to a client requirements.

I would recommend you become familiar with the XML capabilities as it is very flexible.

I looked at the client side javascript example for reading/updating records but it seems dangerous to me to let the client see all that. I also looked at direct contact between the client and FM Pro, but this was inflexible. the ODBC driver wouldn't work so hence the setup i have now.

It works great!!

Neil.

If you include the password in the query string it is no longer secure or secret! Why bother with a password at all?