4/18/2024 10:34:19 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.
|
|
|
|
How to use udl file to test connection on windows server2008 R2?
Posted: 15 Sep 10 4:15 AM
|
Hi, I have a new server with windows server 2008 R2, and my website will connect the SLX with the SLX Provider.
I installed the Client OLE DB Provider successfully on the server 2008 R2, but I cannot connect to the SLX server, it said "No error message available, result code: E_FAIL(0x80004005). " on the website.
When I try to connect SLX server with udl, I found there is no SalesLogix OLE DB Provider listed on the Provider tab.
I think its because the different between 32 bits and 64 bits. but I don't know how to fix it.
Does anybody know how to resolve this problem? Thanks
|
|
|
| |
|
Re: How to use udl file to test connection on windows server2008 R2?
Posted: 16 Sep 10 1:50 AM
|
Now I can use udl file to test connection on my 64bits server by run the command:
C:\Windows\syswow64\rundll32.exe "C:\Program Files (x86)\Common Files\System\OLE DB\oledb32.dll",OpenDSLFile C:\test.udl
but when I save the test.udl, I double click it, it still says "Provider cannot be found. Ensure that the provider has been installed properly".
And when I run the website, it still shows the error"No error message available, result code: E_FAIL(0x80004005).
"
Anyone help me how to make the SLXOLEDB Provider works on the 64 bits server?
 |
|
|
|
Re: How to use udl file to test connection on windows server2008 R2?
Posted: 16 Sep 10 3:04 AM
|
You must create an empty test.udl file in c:\ first. So, goto to c: - right click and New File - call it test.udl and then run the command above:
C:\Windows\syswow64\rundll32.exe "C:\Program Files (x86)\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile C:\test.udl
|
|
|
|
Re: How to use udl file to test connection on windows server2008 R2?
Posted: 16 Sep 10 3:38 AM
|
Thanks for reply.
Yes, I did exactly what you replied, I can test connection successful by this way.
But my website which use SalesLogix Provider still cannot connect to the SLX server.
And when I saved the test.udl file, If I double click it again, it says:" provider cannot be found". I think that's mean the provider still cannot run automatically on the 64 bits server.
Any suggestions? Thanks |
|
|
|
Re: How to use udl file to test connection on windows server2008 R2?
Posted: 16 Sep 10 3:45 AM
|
You cannot double-click it - this is only used to generate a UDL/connection string. If you double-click the file you will try to invoke the 64bit OLEDB controller and it will then not be able to find the SLXOLEDB.1 provider - which is only 32bit. Hence the error - this is not an error and is to be expected.
The web-site and server etc. is a different issue entirely! Can you start a new thread and put in the issues you face ( "not working" needs fleshing out - with something more useful  ) |
|
|
| |
|
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!
|
|
|
|
|
|
|
|