The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
unable to initialize data dictionary
Posted: 11 Dec 06 3:31 AM
|
fiogf49gjkf0d when i tried to connect saleslogix server wich is located in other machine i got error like unable to initialize data dictionary what is the reason for this ?
thanx,
veeranjan |
|
|
|
Re: unable to initialize data dictionary
Posted: 12 Apr 07 11:13 AM
|
fiogf49gjkf0d If your main SLX host server is running SQL Server 2005 then you will need to install the SQL Server 2005 - Native Client on the client machine. It is on the SQL Server 2005 install disk. |
|
|
| |
|
Re: unable to initialize data dictionary
Posted: 30 Aug 07 1:41 AM
|
SLX version? DB?
I've had the same trouble with SLX 6.2 on Oracle 9i DB because of different regional settings.
Oracle Client "learns" from regional settings... 
Dave. |
|
|
| |
|
Re: unable to initialize data dictionary
Posted: 22 Oct 07 2:59 PM
|
Guy,
Thanks for posting the fix!!!
After wasting a couple hours trying to debug (thinking it was McAffee.... so did tech support). I actually ended up taking the SLXNCLI.msi file from the CD and posting to our install directory on the network.
My thanks to you dude!
Cheers,
Ron |
|
|
| |
|
Re: unable to initialize data dictionary
Posted: 25 Oct 07 9:03 AM
|
I got it yesterday with a 7.2 system sitting on 2005.But i also got the message that invalid table systeminfo.So i looked at the new sql server and got to know that sysdba had admin roles associated with it and when i removed that role , it worked!
dont know if that is the case here..... |
|
|
|
Re: unable to initialize data dictionary
Posted: 29 Oct 07 10:13 AM
|
Got the error this morning, script was working fine on Wednesday and errored today same code with the above error.
On SQL 2000 not 2005...
sysdba only has a db-owner role, that comes default even with slx-eval db
|
|
|
|
Re: unable to initialize data dictionary
Posted: 29 Oct 07 11:41 AM
|
Very strange that the issue is coming and going.
Why don't you run the SLX SQL Profiler and see what is going on when the error happens.
|
|
|
|
Re: unable to initialize data dictionary
Posted: 29 Oct 07 12:23 PM
|
Frank,
strangest thing, I tried a bit later and the issue has disappeared. It seems the DBA's forgot to set the name pipes for SQL server after applying some patches over the weekend. I tried this same script nho changes to it and it ran perfectly fine. This is a strange issue that creeps up. |
|
|
| |
|
Re: unable to initialize data dictionary
Posted: 17 May 11 9:30 AM
|
fiogf49gjkf0d I know this is an old post, but I'm getting the same "Unable to Initialize Data Dictionary" message when trying to make a OleDBConnection from a .NET web page. The connection string in question is valid and works on another of our web servers. I activated the SLX Profiler and tried to execute the same page/command again. Here is the last command it was trying to execute in the profiler:
SELECT P.COCLASS, P.NAME, P.SLXOLEDBPLUGINDATAID, P.PRIMARYDLL, PD.MODIFYDATE, S.FUNCTIONNAME FROM slxsqlscalarfn s INNER JOIN sysdba.slxoledbplugin p ON (s.SLXOLEDBPLUGINID = p.SLXOLEDBPLUGINID)INNER JOIN sysdba.SLXOLEDBPLUGINDATA PD ON (P.SLXOLEDBPLUGINDATAID = PD.SLXOLEDBPLUGINDATAID) WHERE P.OBJECTTYPE = 'S' AND P.ENABLED =
'T'
We're on SQL 2005. The SQL Native Client is installed. Any ideas or insights? |
|
|
|
Re: unable to initialize data dictionary
Posted: 17 May 11 2:55 PM
|
fiogf49gjkf0d How about Name resolution?
Are you able to create a connection directly to the SQL server (you could test it using an UDL file)?
Make sure if you do so, to use the exact name for the SQL server as defined on the entry within Connection Manager on the Server.
|
|
|
|
Re: unable to initialize data dictionary
Posted: 18 May 11 9:30 AM
|
fiogf49gjkf0d Yes. I created a UDL file on the web server and used the SQL Native Client as the provider. The connection worked.
The Connection Manager on the Saleslogix server has the expected name in the entry. I also manually created a Saleslogix UDL on the web server and it worked as well.
It appears not to work only when the OleDBConnection is instantiated from the page on the web server. I compared the connection string used in the web page with the one in the UDL file and they are basically the same.
|
|
|
|
Re: unable to initialize data dictionary
Posted: 26 May 11 12:54 PM
|
fiogf49gjkf0d One thing I have noticed: On the server where the connection is working, the Event Viewer shows the "Privilege Use" Success Audit record; that server is set up in IIS as "Anonymous access" with Windows Authentication and the corresponding user account as "IUSR_ServerName". On the server that has the issue, IIS is also set up as "Anonymous access "with Windows Authentication and the corresponding user account as "IUSR_ServerName"; However, my personal login ID is showing up as the user in the Failure Audit log record.
|
|
|
|