Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > ADO.NET
|
ADO.NET For discussion about ADO.NET.  Topics such as question regarding the System.Data namespace are appropriate.  Questions specific to a particular application should be posted in a forum specific to the application .
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 7th, 2004, 07:18 PM
Authorized User
 
Join Date: Jun 2004
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yup I copied the string but the syntax does not matched, it says the "name of DATA1.mdb is not declared yet".

And my senior just checked it out the server which the MS Access database contained does not have MS Access installed, nor the .mdw file, could that be the problem?

 
Old July 7th, 2004, 11:58 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 996
Thanks: 2
Thanked 11 Times in 11 Posts
Send a message via Yahoo to melvik
Default

If I remember right u should have a file called ADOVBS.INC for using Access as a DataBase.
plz correct me if Im wrong.

Always:),
Hovik Melkomian.
 
Old July 8th, 2004, 08:49 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,101
Thanks: 0
Thanked 2 Times in 2 Posts
Default

I made a small error also with quotes...

Code:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source="  & Server.MapPath("DATA1.mdb") & ";")

As you can see you need quotes around the file name..

Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee
 
Old July 15th, 2004, 04:53 AM
Authorized User
 
Join Date: Jun 2004
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Where is this ADOVBS.INC should be placed in, Melvik? My local pc? The database server?
No, I din know about that, I only know there is a .mdw file for Access for storing passwords and authority? I barely know what it is used for.

And I tried the string too, Hal Levy, but it gives another different error this time:
Could not find file 'c:\inetpub\wwwroot\msds\DATA1.mdb'.

My boss has gave me an application which done by previous employee and she has been linking to local pc during the development.
These few days my head is getting bigger and bigger trying to understand what she wrote about coz I got to do a few enhancement.
And it's over a month I can't figure out how to link it to a network server, and my boss' face is getting unhappier all the time :S

 
Old July 15th, 2004, 08:49 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 996
Thanks: 2
Thanked 11 Times in 11 Posts
Send a message via Yahoo to melvik
Default

Im not sure plz check MSDN but try to copy it where ur .mdb file is.
I know its part of Ado.cab

Always:),
Hovik Melkomian.
 
Old July 15th, 2004, 07:28 PM
Authorized User
 
Join Date: Jun 2004
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yup I found it in the Program Files folder and copy to the same folder as my database was.
But it still gives the error of:
Could not find file 'c:\inetpub\wwwroot\msds\DATA1.mdb'.

 
Old July 16th, 2004, 11:54 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 996
Thanks: 2
Thanked 11 Times in 11 Posts
Send a message via Yahoo to melvik
Default

Where is ur file EXACTLY?! is it c:\inetpub\wwwroot\msds\DATA1.mdb?! Sis u use [u]MapPath</u>?! What does it return?!

Always:),
Hovik Melkomian.
 
Old August 25th, 2006, 08:25 AM
Registered User
 
Join Date: Aug 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yeah There. I have got another problem. I am creating Window Application created in .NET which is going to connect with a database which resides on Web Server. I have throughout Internet Connection Available. I wanted to try virtual path name in Query String like http://ServerName/ApplicationName/file.mdb. I tried hard to find such querystring but I haven't got it.
I wanted to make a client server application like Yahoo Messanger Having. Which is client but work in integration with Yahoo Server.
Could you help me out in this regard?
Please be fast. Thanks in Advance.
Quick anticipation in your reply.

 
Old December 11th, 2006, 04:45 AM
Registered User
 
Join Date: Dec 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi all,
My name's phu. I help you. Because I have been successful to connect Access 2003 database by VB.NET
Connection string: "Provider=MSDataShape;Provider=Microsoft.Jet.OLEDB .4.0; Data Source=e:\db1.mdb; User Id=Admin; Password='123'; Persist Security Info=False; Jet OLEDB:System Database=C:\Documents and Settings\phuvo\Application Data\Microsoft\Access\System.mdw "

Dim tempOleDbConnection As OleDb.OleDbConnection = New OleDb.OleDbConnection("Provider=MSDataShape;Provid er=Microsoft.Jet.OLEDB.4.0; Data Source=e:\db1.mdb; User Id=Admin; Password='123'; Persist Security Info=False; Jet OLEDB:System Database=C:\Documents and Settings\phuvo\Application Data\Microsoft\Access\System.mdw ")

The steps which you must follow:
1) Create password for admin (or any accounts)
2) Create workgroup administrator for this account.
Tools | Security | Workgroup Administrator | Join | Ok
3)Connection string:

"Provider=MSDataShape;Provider=Microsoft.Jet.OLEDB .4.0; Data Source=e:\db1.mdb; User Id=Admin; Password='123'; Persist Security Info=False; Jet OLEDB:System Database=C:\Documents and Settings\phuvo\Application Data\Microsoft\Access\System.mdw "

with db1.mdb is a access 2003 (2000) database C:\Documents and Settings\phuvo\Application Data\Microsoft\Access\System.mdw is a database which has stored workgroup information.
---------------------------------------------------------------------
Contact: phungocvo@yahoo.com
I have received all of projects to do by .NET


 
Old December 11th, 2006, 04:45 AM
Registered User
 
Join Date: Dec 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi all Friends,
My name's phuvo. I help you. Because I have been successful to connect Access 2003 database by VB.NET
Connection string: "Provider=MSDataShape;Provider=Microsoft.Jet.OLEDB .4.0; Data Source=e:\db1.mdb; User Id=Admin; Password='123'; Persist Security Info=False; Jet OLEDB:System Database=C:\Documents and Settings\phuvo\Application Data\Microsoft\Access\System.mdw "

Dim tempOleDbConnection As OleDb.OleDbConnection = New OleDb.OleDbConnection("Provider=MSDataShape;Provid er=Microsoft.Jet.OLEDB.4.0; Data Source=e:\db1.mdb; User Id=Admin; Password='123'; Persist Security Info=False; Jet OLEDB:System Database=C:\Documents and Settings\phuvo\Application Data\Microsoft\Access\System.mdw ")

The steps which you must follow:
1) Create password for admin (or any accounts)
2) Create workgroup administrator for this account.
Tools | Security | Workgroup Administrator | Join | Ok
3)Connection string:

"Provider=MSDataShape;Provider=Microsoft.Jet.OLEDB .4.0; Data Source=e:\db1.mdb; User Id=Admin; Password='123'; Persist Security Info=False; Jet OLEDB:System Database=C:\Documents and Settings\phuvo\Application Data\Microsoft\Access\System.mdw "

with db1.mdb is a access 2003 (2000) database C:\Documents and Settings\phuvo\Application Data\Microsoft\Access\System.mdw is a database which has stored workgroup information.
---------------------------------------------------------------------
Contact: phungocvo@yahoo.com
I have received all of projects to do by .NET







Similar Threads
Thread Thread Starter Forum Replies Last Post
connect to access paul20091968 Excel VBA 1 January 16th, 2007 04:07 AM
HOW TO programatically connect to Access Database Deepa7476 Visual Basic 2005 Basics 4 May 23rd, 2006 09:12 AM
Connect textbox to Access field aya_hbkenshin04 Classic ASP Databases 0 May 3rd, 2006 12:52 PM
How to connect to an MS Access database? petercahyadi Java Databases 3 February 22nd, 2005 07:28 PM
Cannot Connect to Access DB mjmfgm Classic ASP Databases 8 March 9th, 2004 07:34 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.