7/6/2025 3:30: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.
|
|
|
|
Installing the SLXOLEDB driver.
Posted: 06 Jun 06 9:28 AM
|
fiogf49gjkf0d Where can I get the driver from and does it allow (with scripting on my part) me to update the SLX data so that eveyone in the SLX system (including remote users) will be able to see the changes?
Thanks,
Keith |
|
|
|
Re: Installing the SLXOLEDB driver.
Posted: 06 Jun 06 3:00 PM
|
fiogf49gjkf0d The SalesLogix OLEDB Provider is installed with the client (or any SLX app). So if the client is installed then you already have it. If you are on a machine without SLX installed (like a webserver or something) then you can install the provider separately using the provider install on the installation CDs.
But yes, you can write ADO/ADO.NET code using the provider to update the database and the changes will sync out to everyone. |
|
|
|
Re: Installing the SLXOLEDB driver.
Posted: 06 Jun 06 3:08 PM
|
fiogf49gjkf0d Here is the excerpt from their help. I have the client installed but there is no OLEDB provider for me to connect to. I should show up in the Data Sources (ODBC) but it does not. Read what SLX told me in their response.
I assume we are on our own for this....
****************************
From email....
Keith,
SalesLogix, subsequent to 6.0, use an OLE DB provider to connect with the database; there is no ODBC provider in the newer versions of SalesLogix. The OLE DB provider is installed on the SalesLogix Application server during your SalesLogix implementation and is what allows the various installations of the SalesLogix applications to communicate with the database on your SQL server.
In regards to importing data from an external source: In order for SalesLogix to generate the necessary TEFs to sync out the new data to remote users, the data must come into the database via the SalesLogix OLE DB provider. Beyond that, it may be possible to feed the data out, update it, and then feed it back in through the provider, but it is not a method of update for which we can provide support. If you decide to try this, the best suggestion I could make would be to do it in a test environment first ; check the data thoroughly to make sure the update and synchronization occurs properly before trying a similar solution on your production system.
When replying to this email, please keep all previous responses included.
If this issue is fully resolved and you feel the ticket can be closed, please reply to this e-mail (use the "Reply" in your mail client) and include the word "Confirm" at the end of the Subject. Please make sure the ticket number remains in the subject line. Feel free to add any comments in the body of your reply.
End emal.
**************************** |
|
|
|
Re: Installing the SLXOLEDB driver.
Posted: 06 Jun 06 3:57 PM
|
viagra weed erowid viagra weed website fiogf49gjkf0d Originally posted by Keith W. Bonin
I have the client installed but there is no OLEDB provider for me to connect to. It should show up in the Data Sources (ODBC) but it does not. |
|
Actually, it shouldn't show up in Data Sources for ODBC. It is not an ODBC driver. It is OLEDB.
Something you can try is this:
1) Download the Data Link Designer (from this site): http://www.slxdeveloper.com/page.aspx?action=viewarticle&articleid=36
2) When you execute it you'll see on the Provider tab the SLX provider (if you have 6.2 installed it will be listed as "SalesLogix OLE DB Provider", if 6.0-6.1 then it will be listed as something like "[SalesLogix - OLE DB Provider]" (notice the brackets, it will be at the top of the list). Select it and continue through the tabs to add all details to connect to the SLX database (make sure to check the save password checkbox). Once you click OK, you'll have a complete connection string to connect to the database.
3) From there you'll use that connection string with ADO or ADO.NET to connect to the database and do any work.
ie:
Dim conn
Set conn = CreateObject("ADODB.Connection")
conn.Open myconnectionstring
conn.Execute "update sometable set somefield = 'some value' where someidfield = 'some id value'"
conn.Close
Set conn = Nothing
See what I mean? |
|
|
|
Re: Installing the SLXOLEDB driver.
Posted: 07 Jun 06 9:36 AM
|
fiogf49gjkf0d I've got an app that executes SQL through SLX's OLEDB provider and bypasses the test phase (it's risky, but no more so than Query Analyzer). Email if interested. |
|
|
|
Re: Installing the SLXOLEDB driver.
Posted: 08 Jul 06 4:48 PM
|
fiogf49gjkf0d Originally posted by Keith W. Bonin
Where can I get the driver from and does it allow (with scripting on my part) me to update the SLX data so that eveyone in the SLX system (including remote users) will be able to see the changes?
Thanks,
Keith |
|
In addition to Ryan's suggestion, you can also make a connection string this way:
A - Create an empty text file on the desktop (RMB/LMB New Text Document)
B - Change the extension from .txt to .udl
C - Double-click on the .udl file -> A Data Link Properties 4 tab dialog will open
D - Select the Provider tab (if not selected)
E - Choose the SalesLogix OLE DB Provider
F - Click Next.... Follow the Dialog....
When finished you can open the .udl in Notepad (or some other text tool) and the properly formed string is there
You can also use this (udl) file in the ADO Connection in your code:
sConnectionString = "FILE NAME=C:\PathToFile\x.udl" |
|
|
|
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!
|
|
|
|
|
|
|
|