updating problem, newbie probably obvious...

[ironyx]

I have ASP pages on a DSN. The connection is fine, but when I submit from the pages I created the information goes no where. The pages I created are on a server seperate from my SQL server database. Any suggestions on a direction to head would be very helpful. It might be something simple I'm missing or just don't know to do.
Thanks for the help and knowledge!
Va.

 

[Cheech]

Can you display a recordset from your DB back on an asp page? Live long and make your kids suffer..

 

[ironyx]

okay. I got some idea of what I was doing things wrong. Of course while running through I found problems ODBC connect problem. Will I have trouble with the DSN if I am running off of a server that I have no control of? I am saving the files but would there be something that has to be set up on the server itself. If this is a stupid question forgive my newness.
Thanks!
Va.

 

[schase]

It depends on your host.

Some only allow DSN some only allow DSN-less
and the very rare allow both.

if it is DSN only - you need to get them to mount your database.

if it is dsn-less - the best method is finding the path.

<%
' FileName=&quot;Connection_ado_conn_string.htm&quot;
' Type=&quot;ADO&quot;
' HTTP=&quot;true&quot;
' Catalog=&quot;&quot;
' Schema=&quot;&quot;
MM_database_STRING = &quot;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=E:/folder/subfolder/database.mdb&quot;
%>

this is for a access database - the MM_database_STRING reflects your connection name within UD4, and the path you would naturally need to change. There is however some nice scripts to help you find your path.

 

[mlawson]

HI there,

schase's suggestion is best, you have more access (excuse the pun) and control over your connection. There is a small file you can run to determine the root bit of the DBQ filepath. If you pop over to:

http://www.geocities.com/bgx_2000/ultradev/dsnless.htm

There is a small file which you can FTP onto the server and then run. This will simply report back the actual path

ie F:/doggy/path/yourplace

Hope that helps

Have fun!

M

 

[schase]

lol doggy/path?

 

[mlawson]

Well actually I didn't want to use the actual name of the drive my ISP uses, but you got it!!

Shaggycat

Hmm...reeks of class, professionalism and somthing that died last week

M

 

[schase]

I think i found it behind my desk

 

[mlawson]

for once, I'm actually lost for words. ANy luck, Ironyx? Please help us out here I think we're slipping fast.....

 

[ironyx]

you guys are too much. I will be working on them this morning and let you know with a scream or sigh how it works out. I hate missing certain details in my mind about how it is supposed to be working. I understand the big scheme, and then the pieces and parts but the road map of the rest is a blank page in my head. Glad you guys are here to give directions... at least when you aren't verbally getting lost yourselves... hee hee
thanks!
va