Groups | Blog | Home
all groups > sql server clients > july 2003 >

sql server clients : unable to connect to Analysis server as client


Ramesh
7/29/2003 2:40:00 PM
I get the following error when connecting to Analysis
Services Server as a client. My machine the client's
Operating system is Win 2000 Professional. The server is
intalled on a Win 200 Server.
When I try to register the Analysis Server, I get the
following error..
"Cannot connect to repository" and
"cannot open a database created with a previous version of
your application"
ramesh
7/30/2003 1:15:23 PM
I found the problem myself. It was due to the Registry
entries for JET ODBCconnection . Hence I applied the
following reg file to correct the problem. And then it
worked.
/*********************************************************/
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines]
"SystemDB"="system.mdb"
"CompactByPKey"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\Jet
2.x]
"win32"="C:\\WINNT\\System32\\MSRD2X35.DLL"
"ReadAheadPages"=dword:00000008
"MaxBufferSize"=dword:00000200
"LockRetry"=dword:00000014
"CommitLockRetry"=dword:00000014
"PageTimeout"=dword:00000005
"LockedPageTimeout"=dword:00000005
"CursorTimeout"=dword:00000005
"IdleFrequency"=dword:0000000a
"ForceOSFlush"=dword:00000000

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\Jet
3.5]
"PageTimeout"=dword:00001388
"LockRetry"=dword:00000014
"MaxBufferSize"=dword:00000000
"Threads"=dword:00000003
"ExclusiveAsyncDelay"=dword:000007d0
"SharedAsyncDelay"=dword:00000032
"FlushTransactionTimeout"=dword:000001f4
"MaxLocksPerFile"=dword:0000251c
"LockDelay"=dword:00000064
"RecycleLVs"=dword:00000000
"UserCommitSync"="yes"
"ImplicitCommitSync"="no"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5
\Engines\ODBC]
"TraceODBCAPI"=dword:00000000
"DisableAsync"=dword:00000001
"TraceSQLMode"=dword:00000000
"QueryTimeout"=dword:0000003c
"LoginTimeout"=dword:00000014
"ConnectionTimeout"=dword:00000258
"TryJetAuth"=dword:00000001
"FatBlastRows"=dword:ffffffff
"FatBlastTimeout"=dword:00000003
"AsyncRetryInterval"=dword:000001f4
"AttachCaseSensitive"=dword:00000000
"FastRequery"=dword:00000000
"ODBCISAMAttach"=dword:00000000
"PreparedInsert"=dword:00000000
"PreparedUpdate"=dword:00000000
"SnapshotOnly"=dword:00000000
"AttachableObjects"="'TABLE','VIEW','SYSTEM
TABLE','ALIAS','SYNONYM'"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\ISAM
Formats]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\ISAM
Formats\Jet 2.x]
"Engine"="Jet 2.x"
"OneTablePerFile"=hex:00
"IndexDialog"=hex:00
"CreateDBOnExport"=hex:00
"IsamType"=dword:00000000

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines]
"SystemDB"="system.mdb"
"CompactByPKey"=dword:00000001
"PrevFormatCompactWithUNICODECompression"=dword:00000001
"SandBoxMode"=dword:00000002

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0
\Engines\Excel]
"win32"="C:\\WINNT\\System32\\msexcl40.dll"
"DisabledExtensions"="!xls"
"ImportMixedTypes"="Text"
"FirstRowHasNames"=hex:01
"AppendBlankRows"=dword:00000001
"TypeGuessRows"=dword:00000008

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0
\Engines\Exchange]
"win32"="C:\\WINNT\\System32\\msexch40.dll"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet
2.x]
"win32"="C:\\WINNT\\System32\\msrd2x40.dll"
"ReadAheadPages"=dword:00000008
"MaxBufferSize"=dword:00000200
"LockRetry"=dword:00000014
"CommitLockRetry"=dword:00000014
"PageTimeout"=dword:00000005
"LockedPageTimeout"=dword:00000005
"CursorTimeout"=dword:00000005
"IdleFrequency"=dword:0000000a
"ForceOSFlush"=dword:00000000

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet
3.x]
"win32"="C:\\WINNT\\System32\\msrd3x40.dll"
"PageTimeout"=dword:00001388
"LockRetry"=dword:00000014
"MaxBufferSize"=dword:00000000
"Threads"=dword:00000003
"ExclusiveAsyncDelay"=dword:000007d0
"SharedAsyncDelay"=dword:00000032
"FlushTransactionTimeout"=dword:000001f4
"MaxLocksPerFile"=dword:0000251c
"LockDelay"=dword:00000064
"RecycleLVs"=dword:00000000
"UserCommitSync"="yes"
"ImplicitCommitSync"="no"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet
4.0]
"PageTimeout"=dword:00001388
"LockRetry"=dword:00000014
"MaxBufferSize"=dword:00000000
"Threads"=dword:00000003
"ExclusiveAsyncDelay"=dword:000007d0
"SharedAsyncDelay"=dword:00000032
"FlushTransactionTimeout"=dword:000001f4
"MaxLocksPerFile"=dword:0000251c
"LockDelay"=dword:00000064
"RecycleLVs"=dword:00000000
"PagesLockedToTableLock"=dword:00000000
"UserCommitSync"="yes"
"ImplicitCommitSync"="no"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0
\Engines\Lotus]
"win32"="C:\\WINNT\\System32\\msltus40.dll"
"DisabledExtensions"="!wks,wk1,wk3,wk4,wj2,wj3"
"ImportMixedTypes"="Text"
"FirstRowHasNames"=hex:01
"AppendBlankRows"=dword:00000001
"TypeGuessRows"=dword:00000008

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0
\Engines\ODBC]
"TraceODBCAPI"=dword:00000000
"DisableAsync"=dword:00000001
"TraceSQLMode"=dword:00000000
"QueryTimeout"=dword:0000003c
"LoginTimeout"=dword:00000014
"ConnectionTimeout"=dword:00000258
"TryJetAuth"=dword:00000001
"FatBlastRows"=dword:ffffffff
"FatBlastTimeout"=dword:00000003
"AsyncRetryInterval"=dword:000001f4
"AttachCaseSensitive"=dword:00000000
"FastRequery"=dword:00000000
"ODBCISAMAttach"=dword:00000000
"PreparedInsert"=dword:00000000
"PreparedUpdate"=dword:00000000
"SnapshotOnly"=dword:00000000
"AttachableObjects"="'TABLE','VIEW','SYSTEM
TABLE','ALIAS','SYNONYM'"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0
\Engines\Paradox]
"win32"="C:\\WINNT\\System32\\mspbde40.dll"
"CollatingSequence"="Ascii"
"DataCodePage"="OEM"
"NetworkAccess"=hex:01
"PageTimeout"=dword:00000258

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0
\Engines\Text]
"win32"="C:\\WINNT\\System32\\mstext40.dll"
"DisabledExtensions"="!txt,csv,tab,asc,htm,html"
"CharacterSet"="ANSI"
"ImportFixedFormat"="RaggedEdge"
"Format"="CSVDelimited"
"Extensions"="txt,csv,tab,asc"
"FirstRowHasNames"=hex:01
"MaxScanRows"=dword:00000019
"ExportCurrencySymbols"=hex:01

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0
\Engines\Xbase]
"win32"="C:\\WINNT\\System32\\msxbde40.dll"
"DbcsStr"=hex:01
"Mark"=dword:00000000
"Date"="MDY"
"Exact"=hex:00
"Deleted"=hex:01
"Century"=hex:00
"CollatingSequence"="Ascii"
"DataCodePage"="OEM"
"NetworkAccess"=hex:01
"PageTimeout"=dword:00000258

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\ISAM
Formats]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\ISAM
Formats\dBase 5.0]
"Engine"="Xbase"
"ExportFilter"="dBASE 5 (*.dbf)"
"ImportFilter"="dBASE 5 (*.dbf)"
"CanLink"=hex:01
"OneTablePerFile"=hex:01
"IsamType"=dword:00000000
"IndexDialog"=hex:00
"CreateDBOnExport"=hex:00
"ResultTextImport"="Import data from the external file
into the current database. Changing data in the current
database will not change data in the external file."
"ResultTextLink"="Create a table in the current database
that is linked to the external file. Changing data in the
current database will change data in the external file."
"ResultTextExport"="Export data from the current database
into a dBase 5 file. This process will overwrite the data
if exported to an existing file."
"SupportsLongNames"=hex:00

AddThis Social Bookmark Button