hello i need help to connect my access database in web server,i wnat to need my web server path in asp coding ,i used localhost to run my asp file n database but he cann't be run in web server,plz help me !!!
hello i need help to connect my access database in web server,i wnat to need my web server path in asp coding ,i used localhost to run my asp file n database but he cann't be run in web server,plz help me !!!
aoa
ap ye code dekh lo agr nhai koi point smjh ay tu poch lena bt ye bta dena k ap simple module main kaam ker rhy ho ya class bna ker work ker rhy ho,
Dabase Connection ko open kerny k ley
================================
Dim ConnectionString
ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};" &_
"DBQ=C:\MyDatabases\database.mdb;DefaultDir=;UID=; PWD=;"
ADO Connection ko open kerny k ley
============================
Dim Connection
Set Connection = Server.CreateObject("ADODB.Connection")
Database ko open kerny k ley
============================
Connection.ConnectionTimeout = 30
Connection.CommandTimeout = 80
Connection.Open ConnectionString
Record Set k ley
================
Dim rs
set rs = Server.CreateObject("ADODB.RecordSet")
' Retrieve the records
rs.Open "SELECT * FROM MyTable", Connection, adOpenForwardOnly, adLockOptimistic
Connection ko close kerny k ley
=========================
rs.Close
set rs = nothing
Connection.Close
Set Connection = nothing
(salam)
IBRAR SAHEL
IT MANAGER [BS-IT / MSC SOFTWARE ENGINEERING]
HAIF CONSTRUCTION COMPANY DUBAI UAE
--------------------------------
--------------------------------
Email ID+MOBILE Numbers Not Allowed...ITD TEAM
yeh tu meray pass hai,yeh tu meray computer mai chal raha hai problem yeh hai k isko remote system mai kia path define karo jo hosting lay kar database to connect kartay hai ??? usmai c:/localhost/databasefoldername/filename.mdb
yeh khali locahost k lia hai agar mai isko webserver mai run karonga tu wo error show kardega kyn k waha c:// drive tu nahi hoti mujhe iska path chaiye....
aoa
ok main ap ka point smjh gea hon mjhy ye btay k ap apny computer ko hi online kerna chahty hn ya ap ne hosting leni hy,
ager ap ne apni computer ko hi online kerna hy tu ap ko static ip lena hoga ur localhost ki jaga per uska ip dena hoga.
ager ap ne online host kerna hy tu ap ko access database ki facility k sath web hosting leni pery gi wha per DSN ki option hoti hy hosting k control panel main ap wha ja ker apni file load kero gy ur dsn creat kero gy jesy ap loacl computer main kerty ho phir ap ye method nhai sedha sedha DSN ka method hi use kero gy
Bookmarks