smnssrinivas
asked on
how to connect to a remote .mdb file in a intranet and also internet
Hi.. all
how to connect to a remote .mdb file in a intranet and also internet ...
I am in developing an application and got struck with this problem...
Thanks in advance..
Srinu ;-)
how to connect to a remote .mdb file in a intranet and also internet ...
I am in developing an application and got struck with this problem...
Thanks in advance..
Srinu ;-)
Dim Con
Set Con = Server.CreateObject("ADODB .Connectio n")
ConStr = "Provider=Microsoft.Jet.OL EDB.4.0;Da ta Source=" & yourmdbpath & ";Persist Security Info=False"
Con.Open ConStr
and thats it!
Set Con = Server.CreateObject("ADODB
ConStr = "Provider=Microsoft.Jet.OL
Con.Open ConStr
and thats it!
This site has lots of examples of connection strings that can be used for different purposes.
http://www.able-consulting.com/ADO_Conn.htm
http://www.able-consulting.com/ADO_Conn.htm
what i would suggest is that you create a dsn in your pc that hold the connection to your remote system on the network.
And create the connection just like this
Dim cn As New ADODB.Conection
cn.Open "dsnYourName"
Regards
And create the connection just like this
Dim cn As New ADODB.Conection
cn.Open "dsnYourName"
Regards
Hi
Just few days back i have done the similar sort of project but instead of using mdb i used the sql server.
I pass the ipaddress of the server usernam eand password too to make the connection.
like the following
connMaster.Open "Provider=SQLOLEDB.1;Persi st Security Info=False;User ID=" & UserName & ";pwd=" & TrimPassword & ";Initial Catalog=" & Trim(DBName) & ";Data Source=" & Trim(ipaddress)
Just few days back i have done the similar sort of project but instead of using mdb i used the sql server.
I pass the ipaddress of the server usernam eand password too to make the connection.
like the following
connMaster.Open "Provider=SQLOLEDB.1;Persi
The smnssrinivas account has been suspended: the e-mail address provided is invalid and therefore smnssrinivas is not getting any notifications, and cannot participate on the site properly. Hopefully he'll contact us about this soon so we can get his account rectified.
Until then I have to assume that smnssrinivas will not be back, which leaves a number of open questions to be taken care of.
Perhaps, participants can agree what should happen with this question. Should someone get the points? Should it be deleted?
modder
Community Support Admin
Until then I have to assume that smnssrinivas will not be back, which leaves a number of open questions to be taken care of.
Perhaps, participants can agree what should happen with this question. Should someone get the points? Should it be deleted?
modder
Community Support Admin
Hi smnssrinivas,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:
Save as PAQ -- No Refund.
smnssrinivas, Please DO NOT accept this comment as an answer.
EXPERTS: Post a comment if you are certain that an expert deserves credit. Explain why.
==========
DanRollins -- EE database cleanup volunteer
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:
Save as PAQ -- No Refund.
smnssrinivas, Please DO NOT accept this comment as an answer.
EXPERTS: Post a comment if you are certain that an expert deserves credit. Explain why.
==========
DanRollins -- EE database cleanup volunteer
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This appears to be a good article on this subject ..
http://www.njnet.edu.cn/info/ebook/vbweb/ch09.htm
Cheers,
T.