[swaze]

Is it possible to connect to a database on a different server? I want someone to fill out a form on one site, and have the information inserted into a database on another site.

Is this possible?

[Rayden]

well usually it is connected to server: "localhost" which is the server you are hosted and to connect to another server just change this with the name server of the site. am I right?

[swaze]

This is what I'm currently using to connect to a database on the same server:

Connection_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("small_business/small_business_entry.mdb")

How can I change this to connect to a database on a different server?

i have never seen one that worked correctly. your best bet would be to post the data in the for to a script on the other site to insert into the database

[Rayden]

oh you are talking of msacess database...I thought it was mysql...sorry cannot help on that...and I never see one work either since I use only mysql...
but I think you should change this part:

Server.MapPath("small_business/small_business_entry.mdb")

into the

Server.MapPath("http://www.siteyouare.com/diretory/database.mdb")

but you must have the set username and password...this part I don't know

rayden that will not work either.
the mappath only works for something on the local computer and cannot include the http://sitename

if you realy want to try it...
http://www.aspfaq.com/show.asp?id=2168

[swaze]

Thanks for the help.. I think I'll just keep it as two seperate databases... But I do have another question for another project:

http://www.programmingtalk.com/showt...2416#post92416

Thanks again for the help!

[ycicom]

I have a solutions for this problem, using xml (ServerHTTP).
Single-signon system demo: http://aspspider.ws/ycicom/xmllogin/login.asp
user:admin
pass:uban694t
user database is stored on http://thuyquynh.somee.com/loginsys/

Storing file in another server : http://thuyquynh.somee.com/?list=str
user:admin
pass:diemyeudau

You can upload files to another freehost storage (1asphost.com/brinkster.com/ipdz.com/...), and these file-links is managed on mainsite database.

For Storing file in another server solutions, I use a multipart-form(include file field,text field...) in order to "post" to file-storage server. File-storage will save file(and needed info) on its db, then it will "post" back other infos to main server.

Dont get strange because of my english, hix, Im only a vietnamese student,so my english is very poor.

About multi-domain single-sign on system, when user login on a sub-site, I use xml to post username&password to login server, then login server will return true(follow by user'info) or false. The rest will be solved by sub-site.

I hope you would understand, hic hic, maybe I will get a english course later

You can use any dababase type, even ms access, it would be a low-cost solutions( for a student like me ).

If you'r interested in my works and want to get multi-domain single-signon asp source, please send me an email (ycicom@gmail.com)