Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access 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 April 29th, 2004, 10:25 AM
Registered User
 
Join Date: Mar 2004
Location: , , .
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default ADP connection error

I keep getting the following error message when I test the connection between an Access Project and the SQL database:

"Test connection failed due to an error in initializing provider. Login failed for user 'xxx'. Reason: Not associated with a trusted SQL Server connection."

I am trying to use a specific username and password.

Thanks for input,

LH

 
Old April 29th, 2004, 12:10 PM
Friend of Wrox
 
Join Date: Nov 2003
Location: Lehigh Acres, FL, USA.
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

Does the user have valid SQL Account?

 
Old April 29th, 2004, 12:25 PM
Registered User
 
Join Date: Mar 2004
Location: , , .
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes. I also discovered that if I select Windows authentication and then map a drive I can connect.

 
Old April 29th, 2004, 01:00 PM
Friend of Wrox
 
Join Date: Nov 2003
Location: Lehigh Acres, FL, USA.
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

If you have the client tools or access installed you should not have to create a map drive. Using windows authentication make sure the login account in SQL is setup as an windows account.

 
Old April 29th, 2004, 04:20 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

What do you mean by "map a drive".



Sal
 
Old April 29th, 2004, 05:10 PM
Registered User
 
Join Date: Apr 2004
Location: Methuen, MA, USA.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to Skipmeok Send a message via MSN to Skipmeok
Default

Sal, mapping a drive is the process of assigning a local networked computer to yours or another computer within the network. For example, lets say your company has 3 computers, yours, comp1, and comp2. Rather than have to use ip addresses or put files on a floppy disk to share, you can assign the other computers a drive letter on the host computer. So in our scenario, your computer has an A:, a C: and a D: drive. You wish to share files with the other computers easily. You go to Explorer and click Tools, then Map Network Drive, choose a drive letter other than A, C, or D and then Browse to the computer you wish to connnect to. Now, this computer will show up within the Explorer window and allow you to drag and drop files between computers. To see which computer share the same side of a network as yours, click Start, Run, type: cmd. When the command window opens type: Net View, any and all the computers listed in this display are computers that you can map a drive to. One other note, these computers must have there drives setup as Shared. To do this go to the computer, double click on My Computer and right click on the disk you wish to share, choose Share, assign a name for the share, usually the same as the drive letter, click Apply and you should see a small hand under the drive that is now shared.

HTH--

Skipmeok
 
Old April 29th, 2004, 09:14 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The reason I asked is because it is better to use the UNC of the computer. For instance if you have SQLSERVER1 and you want to put some files on a drive, you can just use the UNC for the computer:

\\SQLServer1\$Sharename\folder

this is best practice.





Sal




Similar Threads
Thread Thread Starter Forum Replies Last Post
Error ch 19, opening form, adp-file vitmoss2 BOOK: Access 2007 VBA Programmer's Reference ISBN: 978-0-470-04703-3 0 October 4th, 2008 05:09 AM
Connection Error asters .NET Framework 1.x 3 April 4th, 2008 12:46 AM
connection error janees ASP.NET 2.0 Professional 1 March 2nd, 2007 02:26 PM
Connection State in ADP Scripts82 Access VBA 3 April 6th, 2006 09:48 PM
Connection issues with ADP file tdl6281 Access 7 June 19th, 2004 01:54 PM





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