server data access 
Author Message
 server data access

howdi,

i am trying to connect to an internet based database using the following
(currently adapted for ASP)

    set conn = server.createobject("ADODB.Connection")
    conn.open
"Dbq=e:/89/st-johns-market.co.uk/user/private/posa.mdb;Driver={Microsoft
Access Driver (*.mdb)};Provider=MS Remote;Remote
Server= http://www.*-*-*.com/ ;Remote
Provider=Microsoft.Jet.OLEDB.4.0;"

it doesn't work - i get:

    Microsoft ADO/RDS error '800a20ff'

    Internet Server Error.

what is the equiv to use within VB6 that does work?

regards,

Sharif.

NB: beta-testers wanted for online accounts program
www.smallaccounts.co.uk
--



Mon, 01 Dec 2003 22:25:27 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Simple, yet complicated, SQL Server data access question.

2. Retrieving data from multiple servers using a common data access component

3. MS Access 2002 vs VB.net as a front-end to SQL Server data

4. Access as data Server Using ADO & DAO

5. data access pages on nt 4.0 server

6. Outlook custom CONTACT form accessing SQL Server data

7. convert data between access to sql server

8. Insert Data Into Access Database From SQL Server ADO Insert

9. Data Replication between SQL Server 7 and MS Access 97

10. Commit data to access database on network server

11. VB6 Data Access (Browsing through tables) Client/Server

12. Storing and Accessing data on web server

 

 
Powered by phpBB® Forum Software