11/10/2024 12:54:28 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
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!
Forum to discuss using the SalesLogix OLE DB Provider from external applications (including usage of built-in provider procedures). View the code of conduct for posting guidelines.
|
|
|
|
Saleslogix OLE DB provider, using it from a web service.
Posted: 02 Feb 07 8:15 AM
|
fiogf49gjkf0d I have a strange problem. I have a web service that writes to SLX. It works fine when im running it in the visual studio IDE, when I deploy it to a web server, it claims that "The 'SLXOLEDB.1' provider is not registered on the local machine.". Even though it's the same machine.
Im sure it's not permissions, is there something about the IUSR account that requires Saleslogix registry entry's? |
|
|
|
Re: Saleslogix OLE DB provider, using it from a web service.
Posted: 02 Feb 07 9:45 AM
|
fiogf49gjkf0d I've not had that problem. It would have to be one of two things
1) Either some weird security causing restrictions on ASPNET and NETWORK SERVICE accounts (since this is a .NET web service, IUSR doesn't come into play for the executing process)
2) Or something weird at the time the install for the provider ran
I'd revisit the permissions on the machine, rerun the SLX Provider install, etc. You could always try a test with having your web service use impersionation. Add something like this to your web services config file:
<system.web>
. . . .
<identity impersonate="true" userName="username" password="password" />
. . . .
</system.web>
This way you could see what happens when you impersonate the user you're logged in as when running it through VS |
|
|
| |
|
Re: Saleslogix OLE DB provider, using it from a web service.
Posted: 05 Feb 07 10:43 AM
|
fiogf49gjkf0d I was reading through the older messages in this forum and someone mentioned the need to install the Saleslogix network client in order to make it work.
I just tried it and everything works fine now. It must be that v6.2 needs the client installed in order to propogate the registry entries for the OLE DB client?
|
|
|
|
Re: Saleslogix OLE DB provider, using it from a web service.
Posted: 05 Feb 07 11:25 AM
|
fiogf49gjkf0d I don't believe it is required, although it does appear to have fixed your problem. I do have several servers running websites and web services, that only have the SLX provider installed on them, and they are work fine.
Oh well. At least your problem is fixed.  |
|
|
|
Re: Saleslogix OLE DB provider, using it from a web service.
Posted: 12 Apr 07 12:21 AM
|
I know my answer comes a bit late, but its been a while since I have had time to participate on the Forums:
The SLX OLE DB Provider installation doesn't install MDAC.
So, although you get a succesful install, the provider does not work properly.
When you install the SLX Client, it installs MDAC, thus the provider works properly.
Edit:
Then again, I should've read the first part of the post regarding the Provider and running the code on the same machine....... |
|
|
|
Re: Saleslogix OLE DB provider, using it from a web service.
Posted: 23 Apr 09 6:32 PM
|
Hi
In our case we have a Web Service that works fine with SLX6.2 Database using SLX6.2 OLEDB. When we upgraded to SLX7.5 Database and SLX7.5 OLEDB, the Web Service no longer works, or rather unable to connect to the database.
This thread is the only one I can see that seem most similar to our case. Please are you able to give some advise.
Also please can you point me the "older messages in this forum" you mentioned so I can get pressumably more details.
Thanks
Mel |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|