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!
|
|
SLX ODBC provider
Posted: 04 Jan 08 6:13 PM
|
Hey guys,
do you know if the SLX ODBC provider changed from version 7.0 to 7.2?
We've been having trouble accesing the saleslogix database in a 7.2 environment but we have no problem accesing the database in 7.0.
we are trying to access the SLX database through a web application.
thanks |
|
|
|
Re: SLX ODBC provider
Posted: 05 Jan 08 12:54 PM
|
Yep, there have been some subtle changes.
You are on 7.2.1 - right?
Create a .udl file and build a connection string......
--
rjl |
|
|
| |
|
Re: SLX ODBC provider
Posted: 07 Jan 08 10:05 AM
|
Ismael,
Are you inside or outside of the firewall?
If you are on 'the other side', you will need to open port 1706 for SLX to communicate properly.
Carla |
|
|
|
Re: SLX ODBC provider
Posted: 07 Jan 08 2:16 PM
|
Here is our connection string , we would like to know if there's any change in the name of the provider (in this case as you can see we use SLXOLEDB.1) or anything else that has changed in the format of the connection string:
"Provider=SLXOLEDB.1;Data Source=TDG-WKS-005;Initial Catalog=TLX520EVAL721;user id = Lee ;password = ''; Persist Security Info=True;Extended Properties='PORT=1706;LOG=ON;CASEINSENSITIVEFIND=ON;AUTOINCBATCHSIZE=1;'" |
|
|
|
Re: SLX ODBC provider
Posted: 07 Jan 08 4:00 PM
|
As RJL has already mentioned, you can check this yourself.
Just create a blank text document and rename it to something like SLX.UDL. The UDL file extension associates the file to a Universal Data Link. Double-click on the file and configure your connection. The connection string information will be saved to the file - and you can read it after you have configured the connection by opening it with Notepad.
PP |
|
|
|
Re: SLX ODBC provider
Posted: 07 Jan 08 4:56 PM
|
Yeah we've already created the .UDL file and it works fine, then, we referenced that file from the .aspx page , just like this:
Dim objCon = New OleDbConnection("File Name = C:\New Text Document.udl")
objCon.Open()
so, it didn't work..
What we did after that was create a windows application (visual basic.net) using the same .UDL file in order to connect to the database and it works!...
so it raises the following question :
why in a desktop application the connection string works and in a web application it doesn't work ?
thanks in advanced guys |
|
|
| |
|
Re: SLX ODBC provider
Posted: 07 Jan 08 5:00 PM
|
Was the Windows app that worked on the same server as the Web app that does not? Just wondering if there's some security issues between your Web app and the db server.
PP |
|
|
|
Re: SLX ODBC provider
Posted: 07 Jan 08 5:08 PM
|
Yes it was , the Windows app worked in the same server as the Web app is located...
I also added the ASP.net user and the IIS user into the Administrators group, and even doing that the WEb app didn't connect.
|
|
|
|
Re: SLX ODBC provider
Posted: 07 Jan 08 5:17 PM
|
| Another thing that we noticed is the same code works with SalesLogix version 7.0.1, but it doesn't work with the 7.2 version. |
|
|
|
Re: SLX ODBC provider
Posted: 07 Jan 08 5:53 PM
|
I'm running out of ideas  When you say that the connection doesn't work, can you be more specific? Do you get any error messages? Or does it just time out? Anything in the Event Log?
PP |
|
|
|
Re: SLX ODBC provider
Posted: 07 Jan 08 5:58 PM
|
Well, when I say that the connection doesn't work I mean that it's not opened and I catch an exception and the error message says:
"No error information available: E_UNEXPECTED(0x8000FFFF)."
thanks
|
|
|
|
Re: SLX ODBC provider
Posted: 08 Jan 08 12:42 PM
|
Guys, another question:
I have the SLX 7.2.0.1324 version installed in my PC and my customer has the SLX 7.2.1.1672 version,
So..
How can I get the same version in my PC ? |
|
|
| |
|
Re: SLX ODBC provider
Posted: 08 Jan 08 4:30 PM
|
yeah, I tried that and the setup says :
"You currently have no SalesLogix applications that need upgrading"
So, I'm still seeing the same version of my saleslogix (7.2.0.1324)
any ideas would be appreciate. |
|
|
|
Re: SLX ODBC provider
Posted: 10 Jan 08 5:54 PM
|
Hi Carla, I'm new to this site but sure need some help if you know, we are trying to open port 1706 on the sync server so it can talk to the application box. You mentioned someting about opening port 1706 which is TCP IP setting?
Thanks, Todd |
|
|
|
Re: SLX ODBC provider
Posted: 10 Jan 08 9:52 PM
|
Hi Todd,
If your Sync Server and Application server are not separarted by a firewall, you do not need to do anything. "Opening a port" refers to designating an authorized port for communications through a firewall (or across domains, or non-trusted servers in some instances).
Are your servers having troubles communicating?
Carla |
|
|
|
Re: SLX ODBC provider
Posted: 10 Jan 08 9:58 PM
|
| Yes, they do not communicate although you can access the app server from run command. For now I installed the sync on the app server to get around this, but port 1706 is not showing open on the sync box... |
|
|
|