SQL dns links failure

[Ben Webber]

Can anyone tell me what's wrong with this path below? I've got some users
who can view the report link data and others who can't. I don't want to add
the MSAccess exe path to the front end because I've got some users that
haven't upgraded to 2002and others who have.

Private Sub Command118_Click()
Dim stAppName As String

stAppName = "msaccess.exe \\servername\dirname\data.mdb"
Call Shell(stAppName, 1)
End Sub


I've got the same problem happening with forms that are linked to a SQL dns
file! Some folks can connect, others error out! Except the error reads:

Connection failed:

SQLState: '01S00'

SQL Server Error: 0

[Microsoft][ODBC SQL Server Driver]Invalid connection string attribute

Connection failed:

SQLState: '01000'

SQL Server Error: 53

Microsoft][ODBC SQL Server Driver]Microsoft][Named Pipes]ConnectionOpen
(CreateFile()).

Connection failed:

SQLState: '0800'

SQL SErver Error: 6

[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not
found.


Any help appreciated!

 

['69 Camaro]

Hi, Ben.

You'll need to use the full path to MSAccess.exe. Try the following syntax
to get the proper path to the version of Access:

SysCmd(acSysCmdAccessDir) & "MSAccess.exe"

For your DSN connection failures, check the computers that are failing to
connect and compare the versions of the MDAC (Microsoft Data Access
Components) files with the versions on the computers that successfully
connect to SQL Server. The computers that fail to connect may have an old
version of MDAC installed.

The two files that you need to check are:

C:\Program Files\Common Files\System\Ole DB\Msdadc.dll
C:\Program Files\Common Files\System\Ole DB\Oledb32.dll

To check the versions of these files, right-click with the mouse on the name
of each of these files in Windows Explorer. When the pop-up menu appears,
select "Properties." Select the "Version" tab of the "Properties" dialog
window, and you'll see the file version listed.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. (Only "Answers" have green
check-marks.) Remember that the best answers are often given to those who
have a history of rewarding the contributors who have taken the time to
answer questions correctly.

 

[Tom Wickerath]

Hi Ben,

In addition to Gunny's answer, you might want to try using the MDAC
Component Checker utility:

How to check for MDAC version
http://support.microsoft.com/?id=301202

The DLL Help Database at Microsoft is also a fairly useful tool (....when it
is available)

http://support.microsoft.com/default.aspx?scid=/servicedesks/fileversion/dllinfo.asp


Tom
_________________________________________

:

Can anyone tell me what's wrong with this path below? I've got some users
who can view the report link data and others who can't. I don't want to add
the MSAccess exe path to the front end because I've got some users that
haven't upgraded to 2002and others who have.

Private Sub Command118_Click()
Dim stAppName As String

stAppName = "msaccess.exe \\servername\dirname\data.mdb"
Call Shell(stAppName, 1)
End Sub


I've got the same problem happening with forms that are linked to a SQL dns
file! Some folks can connect, others error out! Except the error reads:

Connection failed:

SQLState: '01S00'

SQL Server Error: 0

[Microsoft][ODBC SQL Server Driver]Invalid connection string attribute

Connection failed:

SQLState: '01000'

SQL Server Error: 53

Microsoft][ODBC SQL Server Driver]Microsoft][Named Pipes]ConnectionOpen
(CreateFile()).

Connection failed:

SQLState: '0800'

SQL SErver Error: 6

[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not
found.


Any help appreciated!