My website used ASP program to access several MS ACCESS mdb, could I choose the WIN2003 web edition instead of the WIN2003 standard version? Any body have the advice please?

That is legal.. when you make the jump to using SQL Server, thats when you have to switch to SE..


Jake

thks jake

I mean if I select the DEDICATE server option : W2003 web edition, could I used ms access MDB to stall the data that manipulated by ASP programs?

hmm don't know what you're asking.. but your license for ANY windows 2003 web edition allow use of basic access mdb... for any or all of your sites..

Jake

thks jake

I mean to order the package option of ev1servers dedicated win2003 web edition (while my website used asp & ms access mdb) . Nevertheless currently its out of stock.

I just order the w2003 web edition and upload my ASP programs.
Will below ASP scripts be allowed under w2003 web edition? It got an error of rs became null value. Any expert have advice?

....
dbname="db.mdb"
psql="select * from test.tbl "

set rs=getmdbrecordset(dbname,psql)
.....


Function GetMdbRecordset( FileName, Source )
Set GetMdbRecordset = GetMdbRs( FileName, Source, 2, "" )
End Function

Function GetMdbRs( FileName, Source, Cursor, Password )
Dim conn, rs

On Error Resume Next
Set GetMdbRs = Nothing
If Len(Password) = 0 Then
Set conn = GetMdbConnection( FileName )
Else
Set conn = GetSecuredMdbConnection( FileName, Password )
End If
If conn Is Nothing Then Exit Function

Set rs = Server.CreateObject("ADODB.Recordset")
If Err.Number <> 0 Then Exit Function

rs.Open source, conn, Cursor, 2
If Err.Number <> 0 Then Exit Function
Set GetMdbRs = rs
End Function


Function GetMdbConnection( FileName )
Dim Provider, DBPath

Provider = "Provider=Microsoft.Jet.OLEDB.4.0;"
DBPath = "Data Source=" & Server.MapPath(FileName)
Set GetMdbConnection = GetConnection( Provider & DBPath )
End Function



Function GetConnection( Param )
Dim conn

On Error Resume Next
Set GetConnection = Nothing
Set conn = Server.CreateObject("ADODB.Connection")
If Err.Number <> 0 Then Exit Function

conn.Open Param
If Err.Number <> 0 Then Exit Function
Set GetConnection = conn
End Function

check permissions to ensure that the website user has read/write perms on the *.mdb

thks gooberdlx
U suggestion solve the write permission problem on ms access mdb

One more question

I still fail on used PL/SQL in the getrecordset function. The asp script is ok in my existing site, any idea?

no offense.. but your code looks pretty mangled.. there are a lot of function calls that are unnecessary.

is this code you wrote? or got from somewhere else? If you purchased or are using this software from another vendor, bring up the issue with them...

otherwise..

post the error including reason, line of code (LOC), and code where the LOC is..

Jake

The issue is I could open an access mdb table but not using a sql statement:

could sql statement be used to open an access mdb under win2003 web edition, any setup requirement beforehand to use following coding?

==============
filename="db1.mdb"
source="select * from guest"

Provider = "Provider=Microsoft.Jet.OLEDB.4.0;"
DBPath = "Data Source=" & Server.MapPath(FileName)
Param = Provider & DBPath

Set conn = Server.CreateObject("ADODB.Recordset")
conn.Open Param
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open source, conn, 2 , 2

if rs is nothing then
response.write "open rs fail"
else
response.write "open ok"
end if

response.end
=================

It returned "open rs fail"

but if I changed source to "guest" then it return "open ok"

The problem of OLE using "select * from a table" was temporarily resolved.

I finally identified the problem

it works for "select * from guest" but not ok for " select * from guest where ...."

any idea? Thks


================
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open Server.MapPath("db1.mdb")

set rs=Server.CreateObject("ADODB.recordset")
rs.Open "select * from guestbook where userid=""GUEST""", conn
rs.Movefirst

=======================

Microsoft JET Database Engine error '80004005'

Selected collating sequence not supported by the operating system.

testdb1.asp, line 7



======================

try

rs.Open "select * from guestbook where userid=" & GUEST, conn

instead of

rs.Open "select * from guestbook where userid=""GUEST""", conn

thks gooberdlx for your comment but it seens not the answer

The same problem occurred using & GUEST

Even if I try :

select * from guestbook where day(date)>1

it got the collating sequence error

It seens something difference on win2003 environment...trouble

I finally solved the problem
Its the win2003 web edition didn't install the East Asian LANG..hahha

well I'm glad you got it figured out!

Jake

Just curious, where do you get the Access?
Do you upload the software by yourself?

Not quite sure, but it seems in Web edition, Access is already installed.

However, while I talked with tech. support,
he says:
"standard edition has 5. web edition has 2. we provide those amounts only. "


Anyone knows what this means?

If U are using ASP and has Chinese char. in it then U might need to activate/install the Chinese lang pack