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!

External Development Forums - SalesLogix OLEDB Provider
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.

Forums RSS Feed

Back to Forum List | Back to SalesLogix OLEDB Provider | New Thread

View: Search:

Author

Thread: Installing the SLXOLEDB driver.

Keith W. Bonin
Posts: 5

Installing the SLXOLEDB driver. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 Jun 06 9:28 AM

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

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Installing the SLXOLEDB driver. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 Jun 06 3:00 PM

abortion pill spain

abortion pill spain dearteaga.es

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.

[Reply][Quote]

Keith W. Bonin
Posts: 5

Re: Installing the SLXOLEDB driver. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 Jun 06 3:08 PM

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.
****************************

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Installing the SLXOLEDB driver. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 Jun 06 3:57 PM

viagra weed erowid

viagra weed website

Quote:

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?

[Reply][Quote]

Chris Maguire
Posts: 7

Re: Installing the SLXOLEDB driver. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 07 Jun 06 9:36 AM

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.

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Installing the SLXOLEDB driver. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Jul 06 4:48 PM

Quote:

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"

[Reply][Quote]

Page 1 of 1

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!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/22/2024 4:25:27 PM