Problem with 2 database(MYSQL and text)

Anon

Hi, i have a problem here. Well i have did a web application using MYSQL database but i am been ask by my supervisior to interface his application(he is using Perl and text database) with my MYSQL database. May i know is there any possibility of connecting my MYSQL to his text database. I do not want to change his text database to my SQL as this would involve troublesome altering of his code.

Anon

hello
I am in need of ur help my problem is
I am trying to connect my Access database with my login form
But,
My access database is on linux server and connentivity is not
working.
I want to know how 2 configure DSN. or kindly help me out for this
ITs first time i am working on linux
****My server Administrator says this..*******
You need to give a Database Interface link to MySQL via your ASP script. The
ASP drivers for MySQL are installed on our server.
***Please check my code******************

<head>
<title>User Login</title>
</head>

<%
Dim Conn
Dim RSUser
Dim SQL

Set Conn=Server.CreateObject("ADODB.Connection")
Set RSUser = Server.CreateObject("ADODB.Recordset")

accessdb=server.mappath("Forum.mdb")
'confused here about provider is it should be sqloledb something
'My database name is Forum
'table name is user
strconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE="
strconn=strconn & accessDB & ";"

mySQL="Select * from User Where Userid='" & Request.Form("UserName") & "'"
'And here what should come here Help me please i have learned few tips
'from chillisoft but didnt worked..Help...
'call user(mySQL,strconn)

RSUser.Open mySQL,Conn,1,2

If RSUser.EOF Then
%>
<center>
<%=Request.Form("UserName")%> 
User Does Not Exist 
<a href="signin.asp" target="parent">Click to try and login again</a>
 
OR
 
<a href="newuser.asp" target="parent">Click here to join</a>
<%
Else

If RSUser("Password") <> Request.Form("Password") Then

%>
<center>
Password is Incorrect for 
<%=Request.Form("UserName")%> 
<a href="signin.asp" target="parent">Click to try and login again</a> 
 
<h3 align="center">OR</h3>
 
<a href="forgotpw.asp" target="parent">Click here to have your password emailed to you</a>
</center>
<%
Else

	Session("User") = "Yes"
	Session("User_ID") = RSUser("ID")
	Session("UserName") = RSUser("First Name") & " " & RSUser("Last Name")

%>
<center>
Login Successful 
Welcome Back <%=RSUser("First Name")%> 
Your last visit was on <%=RSUser("Last Visit")%> 
<a href="question.htm" >Click to enter the On Line Test Contents</a> 
</center>
<%

	RSUser("Last Visit") = Now
RSUser.Update
End If

End If
%>
</body>

Anon

Please define what you mean by 'interface' and 'connecting'. If you are talking about having changes in one trigger changes in the other, then you might consider writing some sort of connector. A connector which would monitor changes in the one and translate that change based on your business rules to a change in the other. Should be somewhat simple to setup a cron'd script to do that.

If you are talking about some wide-scale movement of data, then I'm at a loss.

Anon

TimD
So how to write the cron'd script , can i have some sample which can i have a look and apply to my application?? Thanks