[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

ODBC error message.

Posted on 2002-07-28
7
Medium Priority
?
243 Views
Last Modified: 2010-04-13
Hi, i am using windows 2k, and i am studying ASP.
somehow the ODBC stoped working, and i keep getting this error message.


Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
/search.asp, line 26

it worked before, i tried to install MDAC 2.7 and it's patch, didnt work, is there a way to uninstall the ODBC and reinstall it? any idea?
0
Comment
Question by:SteelFist
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 4

Expert Comment

by:CyberWizard
ID: 7183798
this applies to ultradev by macromedia.
perhaps also to your problem.

you didn't say if you got the error message in an asp page or in the odbc itself.

try removing the users dsn and replace it with a system dsn as shown below.

Regards,

CyberWizard


Issue
The following error occurs when viewing an ASP page in a Web browser or when viewing Live Data in UltraDev:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager]
Driver's SQLSetConnectAttr failed

Note: The error above was generated using a Microsoft Access 2000 database and an IIS 5.0 Web server running on Windows 2000. The error message may differ depending on your database and Web server.

Reason
A User Data Source Name ("DSN") exists on the Windows server being used to process the ASP pages. UltraDev requires a System DSN in order to recognize the database when setting up an ODBC DSN connection. Windows servers also require System DSNs when processing ASP pages that use an ODBC DSN connection and will fail with the error above if a User DSN exists on the server that shares the same name as the System DSN. A System DSN is available to all users and services, including the Web server, whereas a User DSN is only available to the current user and is not available to the Web server.

Solution
Open the Windows' ODBC Data Source Administrator and remove any User, System and File DSNs which share the name of the DSN you want to use in UltraDev. Once the appropriate DSNs have been removed, recreate a System DSN only. Create a new connection in UltraDev using the new System DSN. The SQLSetConnectAttr error should no longer occur.
0
 
LVL 7

Accepted Solution

by:
jmiller47 earned 400 total points
ID: 7183799
[Quote]

Q: Can I uninstall MDAC?

The Microsoft Data Access Components are system components, and installing MDAC should be considered similar to a system upgrade. You cannot remove MDAC without replacing operating system files that were upgraded by the MDAC installer. Many applications, including Microsoft Internet Explorer, Visual Studio, SQL Server, and Office require MDAC for data binding and other application functions. Removing MDAC will negatively impact or break these applications. However, under certain circumstances, Microsoft Product Support Services can assist you in solving installation and behavior problems. For more information, see "What should I do if an MDAC upgrade breaks my application?"

[End Quote]


http://www.microsoft.com/data/mdac21info/MDACinstQ.htm
0
 
LVL 7

Expert Comment

by:jmiller47
ID: 7183803
I agree with CyberWizard here. You should never really use User Data Source Names, Only System Data Sources.
0
On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

 

Author Comment

by:SteelFist
ID: 7184822
Well, it seems to be a mistake of my teacher that cuased it, we created System DSN and user DSN with the same name, i removed the user DSN and it worked.

Thanks for your reply.

The points are yours ;)
0
 
LVL 4

Expert Comment

by:CyberWizard
ID: 7184985
well, don't wanna be whining, but shouldn't you accept my answer instead if that was the solution?

Regards,

CyberWizard
0
 

Author Comment

by:SteelFist
ID: 7185311
I did, strange, i dont have the accept button now.
i can only post a comment.
0
 
LVL 5

Expert Comment

by:Netminder
ID: 7185660
CyberWizard,

Points for you at http://www.experts-exchange.com/jsp/qShow.jsp?ta=win2k&qid=20329586

jmiller47,

I've left your points intact because you did respond to the question regarding removal of MDAC, even though that turned out to not be the problem.

Netminder
CS Moderator
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
What monsters are hiding in your child's room? In this article I will share with you a tech horror story that could happen to anyone, along with some tips on how you can prevent it from happening to you.
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question