|
 |
access_asp thread: Problems with OLE DB connection!
Message #1 by "Carl Hu" <CarlChina@n...> on Thu, 30 May 2002 09:08:27
|
|
I wrote the following code in an ASP file to make an connection with
Microsoft Access:
<%
Dim strConnect
Dim objConn
strConnect = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source =
C:\data\mydb.mdb; Persist Security Info = False"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open strConnect
'etc....
%>
While i got an ASP error when i requested the page in my browser, which
was said:
Error type:
Microsoft JET Database Engine (0x80004005)
Anyone can help me to find what mistakes i've made? thanks.
Message #2 by erdian hambali <ciledug_r49@y...> on Thu, 30 May 2002 02:39:24 -0700 (PDT)
|
|
--0-1154084597-1022751564=:68362
Content-Type: text/plain; charset=us-ascii
you're database might be read only, you can open that (see in your folder properties) or try to check your IIS, coz' i have a
similliar problem (using XP) and when I change into w2k this problem no longer insist.
bye,
Carl Hu <CarlChina@n...> wrote: I wrote the following code in an ASP file to make an connection with
Microsoft Access:
Dim strConnect
Dim objConn
strConnect = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source =
C:\data\mydb.mdb; Persist Security Info = False"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open strConnect
'etc....
%>
While i got an ASP error when i requested the page in my browser, which
was said:
Error type:
Microsoft JET Database Engine (0x80004005)
Anyone can help me to find what mistakes i've made? thanks.
---------------------------------
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
Message #3 by "Carl Hu" <CarlChina@n...> on Thu, 30 May 2002 11:15:24
|
|
it seems not fix this problem.
The database which i created it myself isn't a read-only one, and the IIS
works well with default settings. Should i do some additional settings to
my IIS to let ASP can connect ACCESS?
> --0-1154084597-1022751564=:68362
Content-Type: text/plain; charset=us-ascii
you're database might be read only, you can open that (see in your folder
properties) or try to check your IIS, coz' i have a similliar problem
(using XP) and when I change into w2k this problem no longer insist.
bye,
Carl Hu <CarlChina@n...> wrote: I wrote the following code in an
ASP file to make an connection with
Microsoft Access:
Dim strConnect
Dim objConn
strConnect = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source =
C:\data\mydb.mdb; Persist Security Info = False"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open strConnect
'etc....
%>
While i got an ASP error when i requested the page in my browser, which
was said:
Error type:
Microsoft JET Database Engine (0x80004005)
Anyone can help me to find what mistakes i've made? thanks.
---------------------------------
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
|
|
|
View Cart
