I am a newcomer to ultradev. I have created a simple page and wanted to test it live on the net. I have got it working on my local machine with PWS. A friend of mine has offered me some webspace and I uploaded my pages.
When I fill out my form I get a 500 error - page not found.

I have never hosted on windows servers before and I am confused as to what I need to do to migrate my site from PWS to a live site.

I uploaded my database to a folder named private in the root of my webspace. All .asp files were uploaded to the htdocs directory.
I cannot find any detailed info on how I set up my connection string??? - my friend who set up the space asked me for my database name (latch.mdb).

I found info on the GetDatabasePath behaviour. This returned a path of DRIVER={Microsoft Access Driver (*.mdb)};DBQ=e:\domains\realtimestats.net\user\htdocs\private\latch.mdb

I modified my connection in ultradev and chose custom connection and gave my connection a name of latch and in the connection string added "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=e:\domains\realtimestats.net\user\htdocs\private\latch.mdb"

Should I drop the e:\???

I also chose "ultradev should connect using Driver On Application Server - is this correct??

I then uploaded my Connections folder to the webspace.

I'm very confused on this - if you can't guess and feel like I'm banging my head on a brick wall.

Hope some of you guys can help

Nick

oops- here is the url of the form I am testing :- www.realtimestats.net/insert_new_customer_record.asp


thanks

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
oops- here is the url of the form I am testing :- www.realtimestats.net/insert_new_customer_record.asp


thanks


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
well, this is the error i get...
ADODB.Command error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/insert_new_customer_record.asp, line 88


probably zipcode incorrect.
but on a nt host your ado connection should look like so:
&lt;%
// FileName="Connection_ado_conn_string.htm"
// Type="ADO"
// HTTP="true"
// Catalog=""
// Schema=""
var MM_NameOfConnectionHere_STRING = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=E:\\domains\\realtimestats.net\\user\\htdocs\\private\\latch.mdb"
%&gt;

try copying that code into the .asp connection page and try again.
you should definately NOT drop the E:\ !!!

i can see nothing else wrong in how you setup the connection, not sure about the http 500 error, could mean the private folder is not set to allow scripts and page access, ask your provider about that to be sure.

Anyway, i hope this helps you out a little.

With kind regards,

Dennis van Galen
Webmaster SPG Finance
KPN Telecom Holland NV

Also... i got this when looking through the rest of the page, to see if there were other asp things to see if your provider is running the OLE ODBC drivers and got me wondering if you handcode your java menus...

www.realtimestats.net/javascrip;:

obviously that gave a could not find page, notify webhost message.
so, i just did <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
hope you get it to work.

Edited by - djvgalen on 08/09/2001 00:27:03

Hi Nick:
FYI - I'm at the same block as you. I have successfully published a site. However, the dynamic asp pages do not find the app. server.

I think the key is to correctly define the application server on utra dev., the asp pages will then be able to be processed by the app.server.

Note: if you go the macromedia.com and put in the error code IE: 500 , in there search box it brings up Solutions... its cool & helpful...