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!
|
|
OLE DB Provider Download
Posted: 27 Nov 07 8:36 AM
|
Where can I get a download of the OLE DB provider.
I want to attempt creating a form in Visual Studio 2005 and eliminate Scribe. |
|
|
| |
|
Re: OLE DB Provider Download
Posted: 28 Nov 07 7:10 AM
|
The provider is 'Provided' with the SalesLogix install. If you have SLX client on your development machine it will be installed for you to access the server database.
Mark |
|
|
|
Re: OLE DB Provider Download
Posted: 28 Nov 07 10:53 AM
|
| I installed it successful. However it does not show up in odbcad32. How can I connect to it through Visual Studio 2005. |
|
|
|
Re: OLE DB Provider Download
Posted: 28 Nov 07 10:57 AM
|
This is not specific to Web Client Development however, you are not connecting to a type library persay. You need to use the OleDb data access components OleDbConnection, OleDbCommand, ..... and just use a properly formatted connection string. Doing so will route all of the data access calls through the provider. There are articles on this site on how to create the proper connection string.
Mark |
|
|
|
Re: OLE DB Provider Download
Posted: 28 Nov 07 11:05 AM
|
It is not an ODBC driver so it won't show up there. It is an OLEDB provider.
How exactly do you want to connect to it? Are you trying to add it in the server explorer or use it in code? |
|
|
| |
|
Re: OLE DB Provider Download
Posted: 28 Nov 07 12:09 PM
|
Originally posted by K Mill
In the server explorer I am trying to connect to it but can not find it. |
|
1) Add a new connection
2) Select "" as the DataSource
3) For the Data Provider dropdown select ".NET Framework Data Provider for OLE DB"
4) Click Continue
5) In the OLE DB Provider drop down select "SalesLogix OLE DB Provider"
6) Enter the SLX Server name in the "Server or File name" box
7) Enter a SLX user name and password
8) Select the connection/database from the Initial Catalog drop down
That's how you'll add it, but I'm not sure it will work all that well there. Not sure why you'd want to add it to the server explorer anyway? |
|
|
|
Re: OLE DB Provider Download
Posted: 28 Nov 07 12:41 PM
|
Instructions worked fine from the server.
However I installed the Driver on my Laptop with no other SalesLogix compenets and I can not connect to anything in Initial Catalogs do I need to install the architect? |
|
|
|
Re: OLE DB Provider Download
Posted: 28 Nov 07 1:19 PM
|
| I get a ton of Square boxes in the initial catalog changed the Port to 1707. Any idea |
|
|
|
Re: OLE DB Provider Download
Posted: 06 Mar 08 11:15 AM
|
Hello Ryan,
I was using the following connection string:
string connection_string = "Provider=SQLOLEDB.1;DataSource=192.16.11.100;Initial Catalog=saleslogix;UserId=admin assword=passwordersist Security Info=True;";
and i was getting error messages and i guess its related to the Provider=SQLOLEDB.1.
Could you please let me know how to set up SLX OLE DB Provider for server 2003. |
|
|
|
Re: OLE DB Provider Download
Posted: 06 Mar 08 11:33 AM
|
Originally posted by miniL
Hello Ryan,
I was using the following connection string:
string connection_string = "Provider=SQLOLEDB.1;DataSource=192.16.11.100;Initial Catalog=saleslogix;UserId=adminassword=passwordersist Security Info=True;";
and i was getting error messages and i guess its related to the Provider=SQLOLEDB.1.
Could you please let me know how to set up SLX OLE DB Provider for server 2003. |
|
That connection is for the SQL Server OLEDB Provider, not the SalesLogix OLEDB Provider. To use the SLX Provider, you just need to install it on the machine and then use the appropriate SLX connection string (See here http://www.slxdeveloper.com/page.aspx?action=viewarticle&articleid=55) |
|
|
|
Re: OLE DB Provider Download
Posted: 06 Mar 08 11:38 AM
|
currently we are using Saleslogix connection manager and it has only two options under OLEDB provider: Microsoft OLE DB Porvider for SQL server
SQL Native Client? |
|
|
|
Re: OLE DB Provider Download
Posted: 06 Mar 08 11:41 AM
|
Originally posted by miniL
currently we are using Saleslogix connection manager and it has only two options under OLEDB provider: Microsoft OLE DB Porvider for SQL server
SQL Native Client? |
|
OK, so what exactly are you asking?
You provided a connection string, this goes with the assumption that you're using it somewhere. If this is the case, you need to change that to a SLX connection string and ensure the SLX provider is installed.
For connections in the Connection Manager, this is something completely different. This is how you define how the SLX system connects to the underlying database. Not at all the same as what you use to make a connection to SLX via code.
-Ryan |
|
|
|
Re: OLE DB Provider Download
Posted: 06 Mar 08 12:55 PM
|
Could you please let me know how to setup the Saleslogix OLEDB provider connection?
thank you very much |
|
|
|
Re: OLE DB Provider Download
Posted: 06 Mar 08 1:17 PM
|
Originally posted by miniL
Could you please let me know how to setup the Saleslogix OLEDB provider connection?
thank you very much |
|
Just install it. It is located on the SLX installation disk. |
|
|
|
Re: OLE DB Provider Download
Posted: 06 Mar 08 1:21 PM
|
| we have already installed it. How can we add this connection? what is the next step after installation? |
|
|
|
Re: OLE DB Provider Download
Posted: 06 Mar 08 1:24 PM
|
Originally posted by miniL
we have already installed it. How can we add this connection? what is the next step after installation? |
|
I guess I don't understand what you're after. What exactly are you trying to do? |
|
|
|
Re: OLE DB Provider Download
Posted: 06 Mar 08 1:27 PM
|
i dont see the saleslogix oledb provider in "connection manager". Only thing i see is Microsoft OLE DB Porvider for SQL server
SQL Native Client. I dont know how to setup the saleslogix oledb in connection manager? |
|
|
|
Re: OLE DB Provider Download
Posted: 06 Mar 08 1:30 PM
|
Originally posted by miniL
i dont see the saleslogix oledb provider in "connection manager". Only thing i see is Microsoft OLE DB Porvider for SQL server
SQL Native Client. I dont know how to setup the saleslogix oledb in connection manager? |
|
Not sure why you think you need to do this. You don't set SLX up this way. The connection manager tells SLX how to get to the SQL (or Oracle) database. You will always just configure it to connect to SQL or oracle in the connection manager.
You'll use the SLX provider to connect to SLX, like from your code or something. |
|
|
|
Re: OLE DB Provider Download
Posted: 06 Mar 08 1:39 PM
|
| my saleslogix resides in remote server and i am working on my coding on local server. Is this why i get those error messages? |
|
|
|
Re: OLE DB Provider Download
Posted: 06 Mar 08 1:42 PM
|
Originally posted by miniL
my saleslogix resides in remote server and i am working on my coding on local server. Is this why i get those error messages? |
|
What error messages?
If you're coding on your local, then the SLX OLEDB Provider needs to be installed on your local. |
|
|
|
Re: OLE DB Provider Download
Posted: 07 Mar 08 7:40 AM
|
It looks as if the requirement is to use the Data Source window inside of visual studio. Since the tool uses a standard oledb connection and not the extended connection string that is used to connect to the provider you will no be able to see the provider directly or access its objects. This should not bee too much of a problem if you temporaly point the connection directly at the server where your saleslogix database exists and import your objects from there. One of the last steps is to save your connection string into the App.Config file. Say yes to this. As your developing you can go directly, and as you test change the connection string to be SLX provider compliant to ensure that you continue to use SLX security.
Does this make sense? |
|
|
|
Re: OLE DB Provider Download
Posted: 07 Mar 08 12:07 PM
|
Hello,
My code is working now. I thought that I am missing SLX OLEDB provider in connection manager.then I realized i dont need to do any modification to Connection Manager after reading your reply.
I really thank you for your help.
Pathmni |
|
|
|