PC Review


Reply
Thread Tools Rate Thread

Connection String to remote Access database

 
 
Tom Grillot
Guest
Posts: n/a
 
      13th Dec 2006
I'm trying to write an ADO connection string that will connect to an Access
2002 database located on a web-hosting site. I've also tried using the ODBC
Data Source Administrator, an ADODC control and a Data Environment wizard in
VB6, all to no avail.



Here are some sample parameters:



Domain name: "myname.biz"

IP address: "11.222.333.444"

Database name: "mydb.mdb"

System database: "secured.mdw"

Database user name: "Admin"

Database password: ""

Path of database: "\folder1\"

In other words, database and system db are located at
"myname\folder1\"

Or, "11.222.333.444\folder1\"

Let's assume that this site will eventually be password-protected with a
password of "mypw"



Can someone please help me construct the necessary connection string. And
tell me when to use back-slashes and when to use forward-slashes.

Thanks,

Tom


 
Reply With Quote
 
 
 
 
Norman Yuan
Guest
Posts: n/a
 
      14th Dec 2006
You cannot do that. A website is usually exposed to outside through web
server with http(s)/FPT protocol, which cannot be used for Access mdb file
connection. Access connection requires a file server. No web services
provider will expose their file server to outside publicly.

Even you can somehow connect to a file server remotely via the Internet, it
usually still not usable because of he slowness. What you need to do is to
create a web application to access data in *.mdb or other type of database.

"Tom Grillot" <(E-Mail Removed)> wrote in message
news:6L%fh.5723$(E-Mail Removed)...
> I'm trying to write an ADO connection string that will connect to an
> Access 2002 database located on a web-hosting site. I've also tried using
> the ODBC Data Source Administrator, an ADODC control and a Data
> Environment wizard in VB6, all to no avail.
>
>
>
> Here are some sample parameters:
>
>
>
> Domain name: "myname.biz"
>
> IP address: "11.222.333.444"
>
> Database name: "mydb.mdb"
>
> System database: "secured.mdw"
>
> Database user name: "Admin"
>
> Database password: ""
>
> Path of database: "\folder1\"
>
> In other words, database and system db are located at
> "myname\folder1\"
>
> Or, "11.222.333.444\folder1\"
>
> Let's assume that this site will eventually be password-protected with a
> password of "mypw"
>
>
>
> Can someone please help me construct the necessary connection string. And
> tell me when to use back-slashes and when to use forward-slashes.
>
> Thanks,
>
> Tom
>
>



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to program a connection string for remote access AAaron123 Microsoft ASP .NET 1 30th Oct 2008 03:17 PM
Connection string from VB6 to Access Database JW Microsoft Access 2 28th Oct 2005 05:04 PM
Asp.net global connection string to access database Colin Graham Microsoft ASP .NET 1 4th Apr 2005 11:57 PM
connection string to connect access database from VB vigneshwaran G via DotNetMonster.com Microsoft VB .NET 7 10th Mar 2005 05:37 PM
remote Access 2000 connection string Konrad Microsoft ADO .NET 5 3rd Jun 2004 01:48 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:44 AM.