VB connection to online Access Database - please help!
VB connection to online Access Database - please help!
VB connection to online Access Database - please help!
VB connection to online Access Database - please help!
VB connection to online Access Database - please help!
VB connection to online Access Database - please help! VB connection to online Access Database - please help! VB connection to online Access Database - please help! VB connection to online Access Database - please help! VB connection to online Access Database - please help! VB connection to online Access Database - please help! VB connection to online Access Database - please help! VB connection to online Access Database - please help!
VB connection to online Access Database - please help! VB connection to online Access Database - please help!
VB connection to online Access Database - please help!
Go Back  Xtreme Visual Basic Talk > > > VB connection to online Access Database - please help!


Reply
 
Thread Tools Display Modes
  #1  
Old 12-21-2003, 09:57 AM
Phats_Domino Phats_Domino is offline
Newcomer
 
Join Date: Dec 2003
Posts: 2
Default VB connection to online Access Database - please help!


I need to make a connection to an Access Database held on an ASP enabled server through a VB front end but don't know how. I have used VB 6 to connect to and manipulate a database held locally with no problems at all but cant find a connection string for an online database.

I have a catalogue database that can be viewed via a website but cant be edited. I need to be able to edit the database through a VB front end. The sort of things I need to do are enter an item number in a text box, click search, the database is queried and the results such as name, cost, quantity in stock etc are all returned in seperate text boxes. The user must then be able to edit these values, click amend and the record in the database is amended.

I can do all these sorts of things using VB on a locally held database and through a website using ASP but not through VB to an online database. The only thing i really need to know is the connection string.

Is it possible to do this the way I want to? Will VB 6 or .NET be easiest to use?

If anyone can answer my questions or point me to an online resource or a book to buy which can help me with this it would be greatlly appreciated. Cheers!
Reply With Quote
  #2  
Old 12-21-2003, 11:49 AM
Optikal's Avatar
OptikalVB connection to online Access Database - please help! Optikal is offline
Codeaholic

Retired Leader
* Guru *
 
Join Date: Oct 2002
Location: Winnipeg, MB, Canada
Posts: 4,543
Default

Access is not a network enabled database. You should use something like SQL Server or Oracle.

If you insist on using Access, you will have to have a separate process running on the server that handles the network interaction. It will have to communicate with your client program and forward your requests on to the Access database, then forward the results back to the client.
__________________
There are 10 types of people in this world, those that understand binary, and those that don't.
Reply With Quote
  #3  
Old 12-21-2003, 03:53 PM
Shurik12VB connection to online Access Database - please help! Shurik12 is offline
Steppe Walker

Retired Moderator
* Expert *
 
Join Date: Jul 2002
Location: Ukraine/Russia/Belgium
Posts: 7,227
Default

Hi,

...and the connection string itself can be found here:
http://www.able-consulting.com/MDAC/...MSRemoteAccess

Regards,
Shurik.
__________________
"A diaper is not like a computer that makes satisfying burbling noises from time to time, hinting at great inner complexity." Malcolm Gladwell

"I'm sitting here completely surrounded by no beer." Onslow, 'Keeping up appearances'
Reply With Quote
  #4  
Old 12-21-2003, 04:20 PM
Phats_Domino Phats_Domino is offline
Newcomer
 
Join Date: Dec 2003
Posts: 2
Thumbs up

Cheers guys. Thanks for the help. I've got about 4 months left to complete this project so no doubt you'll here from me again in the near future with some other problems!!!

Reply With Quote
  #5  
Old 12-21-2003, 08:53 PM
Optikal's Avatar
OptikalVB connection to online Access Database - please help! Optikal is offline
Codeaholic

Retired Leader
* Guru *
 
Join Date: Oct 2002
Location: Winnipeg, MB, Canada
Posts: 4,543
Default

Shurik, what is this MS Remote/RDS, I don't think I've seen that before. Is it something you have to install specifically on the server, or is it part of windows?
__________________
There are 10 types of people in this world, those that understand binary, and those that don't.
Reply With Quote
  #6  
Old 12-22-2003, 04:08 AM
Shurik12VB connection to online Access Database - please help! Shurik12 is offline
Steppe Walker

Retired Moderator
* Expert *
 
Join Date: Jul 2002
Location: Ukraine/Russia/Belgium
Posts: 7,227
Default

Hi Optikal,

RDS is a part of ADO. But now even Microfot itself considers it to be an obsolete thing (as far as I know there also are secutiry issues too).
Now they ship that SOAP Toolkit and encourage people (not sure that many use it anyway) to move from RDS to SOAP.
Should be surely installed on the server where the .mdb file is located.
But in any case as you mentioned Access is by far not the best choice
for this scenario, to say the least.

Cheers,
Shurik.
__________________
"A diaper is not like a computer that makes satisfying burbling noises from time to time, hinting at great inner complexity." Malcolm Gladwell

"I'm sitting here completely surrounded by no beer." Onslow, 'Keeping up appearances'
Reply With Quote
  #7  
Old 01-26-2004, 02:14 AM
malzki malzki is offline
Freshman
 
Join Date: Aug 2003
Location: philippines
Posts: 38
Default

hi!
i hope this link might help:
http://www.Planet-Source-Code.com/vb...34223&lngWId=1
be sure to edit your msdfmap.ini file in your web server.
i'm also developing an application that needs to access a database from my server. i used the correct connection string and for a week of failure to connect to the database, i finally found out what's lacking (need to edit that file on the server).
that's programming life.
Reply With Quote
  #8  
Old 01-26-2004, 02:48 AM
Shurik12VB connection to online Access Database - please help! Shurik12 is offline
Steppe Walker

Retired Moderator
* Expert *
 
Join Date: Jul 2002
Location: Ukraine/Russia/Belgium
Posts: 7,227
Default

A nice link, thanks.
__________________
"A diaper is not like a computer that makes satisfying burbling noises from time to time, hinting at great inner complexity." Malcolm Gladwell

"I'm sitting here completely surrounded by no beer." Onslow, 'Keeping up appearances'
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

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 Off
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a database application with VB v. Doing it all in Access Dwayne 76 Database and Reporting 1 11-13-2003 10:50 AM
Lost of access database connection JALONSO Database and Reporting 2 09-02-2003 06:17 AM
need help! online database access with VB program kicker22 Database and Reporting 0 05-18-2003 09:05 PM
QB to VB Conversion - By AIO BillSoo Tutors' Corner 0 08-06-2002 12:37 PM
Using VB Prog to access Database Online phat32 Database and Reporting 3 05-18-2002 12:42 PM

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
VB connection to online Access Database - please help!
VB connection to online Access Database - please help!
VB connection to online Access Database - please help! VB connection to online Access Database - please help!
VB connection to online Access Database - please help!
VB connection to online Access Database - please help!
VB connection to online Access Database - please help! VB connection to online Access Database - please help! VB connection to online Access Database - please help! VB connection to online Access Database - please help! VB connection to online Access Database - please help! VB connection to online Access Database - please help! VB connection to online Access Database - please help!
VB connection to online Access Database - please help!
VB connection to online Access Database - please help!
 
VB connection to online Access Database - please help!
VB connection to online Access Database - please help!
 
-->