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!
|
|
Basic help getting the OLE DB Provider up and running
Posted: 12 Sep 07 10:46 AM
|
So I'm extremely new to SLX and I'm curious what all has to be in place on my system to get the OLE DB provider up and running?
Do I have to have the slxserver.exe running on my development system?
Or can I just add the SLXOLEDB.dll to my project and call it good?
I had to run a tlbimp on the dll I got from the SLX server to get it into the project and it still says provider cannot be found so just curious  |
|
|
|
Re: Basic help getting the OLE DB Provider up and running
Posted: 12 Sep 07 12:47 PM
|
alright so I found the provider installation files now I'm just getting a port error...
do I have to have the lisense's installed on my system for it to work?
or is it enough to just install the files found in the Client OLE DB Provider directory on my comp |
|
|
|
Re: Basic help getting the OLE DB Provider up and running
Posted: 12 Sep 07 12:57 PM
|
You don't need any license files on the machine running the provider, but you do need to connect to a Valid SLX server.
Question:
- Is your SLX database up and running, in other words, can you access it via the SalesLogix client?
- Are you using Windows Firewall? You might want to consider turning it off to see if it has anything to do with it.
- How did you configure your connection string? Try the following test:
- Create a New Text file on your desktop and change its extension to .UDL
- At this point, you should be able to double click on the UDL file. It will open with the Data Link Properties window.
- On the Provider Tab, select the SalesLogix OLE DB Provider
- On the Connection tab, enter your SLX server, SLX Database name (as defined on the SLX Server's Connection Manager), SLX User NAme and Password.
- Click on the Test connection button, if it is succesful then you are ready to go.
- Click on the "Save Password" button, and then click OK to dismiss the dialog.
- Open Notepad and then open the UDL file with it (you can drag and drop it onto notepad).
- Copy the Connection string from the UDL file onto your Dev environment and modify accordingly.
Hope this will get you on track. |
|
|
| |
|
Re: Basic help getting the OLE DB Provider up and running
Posted: 12 Sep 07 1:28 PM
|
yea that didn't work 
See the thing is is that I know I can connect to the DB without a problem if I take the identical connection string and just change the provider to SQLOLEDB it connects just fine without any errors
even in the Data Link Properties thing. Using the SQL Native Client gets a successful test but when I use the OLE DB Provider it says the same thing everytime
Failed to connect to SLXServer. Check if server is running and is compatible with the current provider version.
or
Could not establish connection with SLXServer.
Check server is running and PORT is correct.
I'm going to check on the version part of that right now |
|
|
|
Re: Basic help getting the OLE DB Provider up and running
Posted: 12 Sep 07 1:36 PM
|
Question:
Is your SLX server the same machine as your SQL Server?
Do you have an SLX Client configured to connect to this DB? If so, what values does it use for Server and Database?
When you use the SQL provider, you are connecting directly to SQL, so if your SQL server is your SLX Server, and the Alias you defined on the Connection Manager matches your DB name, then this should work, otherwise you need to ensure that you are using the Correct values. |
|
|
|
Re: Basic help getting the OLE DB Provider up and running
Posted: 12 Sep 07 1:42 PM
|
Yea that's what I was just looking at and about to ask
I don't have a client
I'll get someones configurations and see what that does
And yes the SLX Server and the SQL Server are on 2 completely different machines |
|
|
| |
|
Re: Basic help getting the OLE DB Provider up and running
Posted: 12 Sep 07 1:48 PM
|
Ok, well, then that tells me that you are using the wrong paramenters.
You stated on a previous post that if you just changed the provider name to SQL, it worked, that leads me to believe that you are putting the SQL Server and Database name.
When using the OLEDB provider, the Server name is not the SQL server, but the name of the Server where the SLX Server is.
Also, the database name is not the SQL Database name (although it could match), but the name that was defined in the Connection Manager tool in the SLX Server.
Please verify those values, and test using the UDL accordingly.
|
|
|
|
Re: Basic help getting the OLE DB Provider up and running
Posted: 17 Aug 09 10:48 AM
|
Raul,
I realize I'm resurrecting a 2 year old thread but I wanted to thank you for this little tidbit. I had some questions as to testing the functionality of the different aspects of the connection string and the instructions for this little UDL file worked like a champ. Thanks again. |
|
|
|