Cross Database record pulling - Is it possible

Hi Guys,

is it possible to pull records from one database and insert them into another database automatically.

The scenario is as follows,

the users are logged in from one database, their username is saved as a session variable once it has been confirmed by the login database, after that the userscan enter a forum (snitz 2000 3.4) what i would like to do is rather than them have to register again, the snitz database will pull the required fields from the login database to save the user having to register again.

any help appreciated,

Graham

 

Graham,


tell us more about the Snitz setup.


Do you want to restrict Snitz access to registered users, or is it open to all comers like the one at dasp?


R.

 

The snitz setup is just an access DB, it will only be available to registered users just like the rest of the site, i am wondering if i can get the login and registration pages on my site to point to the corresponding forum database fields.


I think i may have just solved my own problem.... bear with me and correct me if im wrong.


If i add a new table into the forum database then i should just be ble to change the connstr's for the login and registration to the new table in the forum database, or is that a total load of boll*cks.


like i said im very new to all this asp stuf and i've never used databases in sites before i am a total novice so please try to explain anything into asp for a dummy.





Cheers


Graham

 

The connection -connstr, conn, whatever -is the same for each database, so no changes there.


The change is in the SELECT statement: sql="SELECT requiredField FROM newTable", etc.


R.

 

arg more SQL, must spend some time getting to grips with this beast, can you recommend any decent reading for a newbie.

Cheers

Graham

 

If you are looking for more of a text book, check out "Beginning ASP databases, by John Kauffman"


R.