Hi,



When I try to create DNS connection using SQL Driver from ODBC Data Source
Administrator I am getting an error:

“[Microsoft][ODBC Driver Manager] Data Source Name not found and no
default driver specified. When I check SQL Driver in the Driver’s page of
the ODBC Administrator program I see that Version and Company attributes
are not shown. Then I have tried is to reinstall MDAC. That did not work
since my MDAC does not exists as standalone any more and it is included in
Windows XP SP2, so I have tried Microsoft suggested steps to fix the
driver manually. I have finished that procedure but the problem remained.



Any ideas?



Thanks,

Djordje

Hello Djordje,

To understand the issue better, I'd like to know the following informaiton:

1. What's OS do you use? Is it XP? If so, did you install SP2 as you
mentioned?

2. I'd like to know if you have reinstall MDAC by using MDAC.inf file?

If you didn't try this, please try to use MDAC.inf to reinstall MDAC from
SP2.

How to Repair MDAC 2.8 Under Windows XP with SP2 Installed
http://www.macropool.com/en/download/mdac_xp_sp2.html

If the issue persists, please try to repair MDAC by using mdac repair tool
to see if it works.

Please let's know if you have any update. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Peter,

First of all I want to thank you for taking a time and looking into the
problem that I have. Here are the answers to the questions you have had:

1. Windows XP with SP2.
2. I did reinstall MDAC using two methods:
a) Manually (starting from MDAC.inf and then followed
instructions
provided below).
b) Using MDAC repair tool that I have downloaded from macropool

Neither of them fixed the problem, ODBC Manager still does not
recognizes SQL Driver and if I try to create DNS file I am getting the
same error message as before (see my original post).

Regards,
Djordje

-----Original Message-----
From: "Peter Yang[MSFT]" [mailtoetery@online.microsoft.com]
Posted At: Sunday, March 16, 2008 11:34 PM
Posted To: microsoft.public.sqlserver.odbc
Conversation: Corrupted SQL Driver
Subject: RE: Corrupted SQL Driver

Hello Djordje,

To understand the issue better, I'd like to know the following
informaiton:

1. What's OS do you use? Is it XP? If so, did you install SP2 as you
mentioned?

2. I'd like to know if you have reinstall MDAC by using MDAC.inf file?

If you didn't try this, please try to use MDAC.inf to reinstall MDAC
from
SP2.

How to Repair MDAC 2.8 Under Windows XP with SP2 Installed
http://www.macropool.com/en/download/mdac_xp_sp2.html

If the issue persists, please try to repair MDAC by using mdac repair
tool
to see if it works.

Please let's know if you have any update. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...default.aspx#n
otif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>
..
Note: The MSDN Managed Newsgroup support offering is for non-urgent
issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each
follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach
the
most efficient resolution. The offering is not appropriate for
situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are
best
handled working with a dedicated Microsoft Support Engineer by
contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.

Hello Djordje,

Before we go further, please collect the information:

1. Is it a 32 or 64 bit version Windows XP?

2. Please check the permission of the following registry key, then export
the registry as a reg file, and compress it as a zip file before you send
it to me at petery@microsoft.com
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Server

3. Does the issue only occur with SQL odbc driver? Did you try other driver
such as Text driver or Excel driver?

4. Please use the following utitlity to check MDAC on your machine, and
send me the result.
MDAC Utility: Component Checker
http://www.microsoft.com/downloads/d...DF6-4A21-4B43-
BF53-14332EF092C9&displaylang=en

If you have other related information, please feel free to let's know.
Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


================================================== ===

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.

Hello Djordje,

I'm still interested in this issue. If you have any comments or questions,
please feel free to let's know. We look forward to hearing from you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


================================================== ===

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Peter,

I have forwarded all your questions to our user who had that problem on
his computer. As soon as I get feedback from him I will send it to you.

Thank you,
Djordje


-----Original Message-----
From: "Peter Yang[MSFT]" [mailtoetery@online.microsoft.com]
Posted At: March 20, 2008 6:34 AM
Posted To: microsoft.public.sqlserver.odbc
Conversation: Corrupted SQL Driver
Subject: Re: Corrupted SQL Driver

Hello Djordje,

I'm still interested in this issue. If you have any comments or
questions,
please feel free to let's know. We look forward to hearing from you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


================================================== ===

When responding to posts, please "Reply to Group" via your
newsreader so that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no
rights.

Hello Djordje,

Thank you for your reply. From the "mdac check" log file:

- <file xmlns="http://tempuri.org/CCFilestream_template.xsd"
name="SQLSRV32.DLL" dir="%SYSTEMDIR%\" CoreFile="Yes">
<release name="MDAC 2.1 SP2" version="3.70.6.90" />
<found xmlns="" />

Also, I found some old file versions (MDAC 2.1) that are not supposed on
Windows XP SP2 machine:

- <group name="NOTFOUND" count="7">
- <file xmlns="http://tempuri.org/CCFilestream_template.xsd"
name="DBMSSOCN.DLL" dir="%SYSTEMDIR%\">
<release name="MDAC 2.1 SP2" version="1999.4.5.0" />
<found xmlns="" />
</file>
- <file xmlns="http://tempuri.org/CCFilestream_template.xsd"
name="DBMSSPXN.DLL" dir="%SYSTEMDIR%\">
<release name="MDAC 2.1 SP2" version="1999.4.5.0" />
<found xmlns="" />
</file>
- <file xmlns="http://tempuri.org/CCFilestream_template.xsd"
name="MSDATL2.DLL" dir="%COMMONFILES%\system\ole db\">
<release name="MDAC 2.1 SP2" version="2.10.4202.0" />
<found xmlns="" />
</file>
- <file xmlns="http://tempuri.org/CCFilestream_template.xsd"
name="ODBCBCP.DLL" dir="%SYSTEMDIR%\">
<release name="MDAC 2.1 SP2" version="3.70.6.90" />
<found xmlns="" />
</file>
- <file xmlns="http://tempuri.org/CCFilestream_template.xsd"
name="OLEDB32X.DLL" dir="%COMMONFILES%\system\ole db\">
<release name="MDAC 2.1 SP2" version="2.10.4202.0" />
<found xmlns="" />
</file>
- <file xmlns="http://tempuri.org/CCFilestream_template.xsd"
name="SQLSRV32.DLL" dir="%SYSTEMDIR%\" CoreFile="Yes">
<release name="MDAC 2.1 SP2" version="3.70.6.90" />
<found xmlns="" />
</file>
- <file xmlns="http://tempuri.org/CCFilestream_template.xsd"
name="SQLSTR.DLL" dir="%SYSTEMDIR%\">
<release name="MDAC 2.1 SP2" version="1999.4.5.0" />
<found xmlns="" />
</file>
</group>

It seems the MDAC components are overlapped by some application installed
on this machine. Since reinstall MDAC.inf cannot solve the issue, I suggest
that you try to re-apply Windows XP SP2 to see if it fixes this problem.

If it works, please install other Windows updates after SP2 so that it's
upgraded to the latest file versions.

Please let's know if this resolves the problem. If you have any questions,
please feel free to let's know. Thank you.


Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support




================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.