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!

Administration Forums - Database Administration
Forum to discuss SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Database Administration | New Thread

View: Search:

Author

Thread: 2003 / IIS6 / SQL2005 / v7 / External Web Access

Carla Tillman
Posts: 290

2003 / IIS6 / SQL2005 / v7 / External Web Access Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 05 Mar 07 3:17 PM

Have any of you seen issues with using the SLX OleDb v7, SQL2005 and an external website? (i.e. not part of SLX). I keep getting catastrophic errors when using 'The Provider'; However, I receive no problems with a direct connect using SQL native client, etc.

Example script. 2003 / IIS6 / SQL2005 / v7

saved as an asp beginning qualifiers @Language, etc. have been removed so script will show.

dim connSLX
dim objRS
dim cn
Dim val
Dim value

connSLX = "Provider=SLXOLEDB.1

assword=<>

ersist Security Info=True;User ID=admin;Initial Catalog=SLXPROD;Data Source=SLXSales;Extended Properties=" & chr(34) & "PORT=1706;LOG=ON;CASEINSENSITIVEFIND=ON;AUTOINCBATCHSIZE=1;" & chr(34)

response.write("
the connstring is: " & connSLX & " ")
sql = "select top 1 contactid from contact"
set cn = server.CreateObject("ADODB.Connection")
CN.Open connSLX
set objRS=Server.CreateObject("ADODB.Recordset")
objRS.Open sql, CN
value = objRS("contactid").Value
response.write("
the value is: " & value & " ")
Set objRS = Nothing

"%>"

[Reply][Quote]

Carla Tillman
Posts: 290

Re: 2003 / IIS6 / SQL2005 / v7 / External Web Access Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 06 Mar 07 7:17 AM

For time being; I am going to use Ole DB for SQL as opposed to Native Client as the first data layer. Is anyone aware of any gotchas using this method? Speed Loss only?

Carla

[Reply][Quote]

Tom Kaiser
Posts: 11

Re: 2003 / IIS6 / SQL2005 / v7 / External Web Access Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 04 Apr 07 9:41 AM

Carla,

Try these three things:
1. Verify you have installed the SalesLogix OleDB Provider on this server. Apply the current SalesLogix service pack.
2. Test the ability to use the SalesLogix OleDb provider by creating a new text file called "TestConn.udl" on the desktop. You are probably already aware how to do this. Verify that you get a successful connection to SalesLogix.
3. Check who the Anonymous user is for your website. (Website properties, Directory Security Tab, Account used for anonymous access.) This is probably IUSR_Machinename. I would try allowing this user access to the SalesLogix directory ("C:\Program Files\SalesLogix).

Hope this helps,

Tom Kaiser
Hilltop Information Systems

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: 2003 / IIS6 / SQL2005 / v7 / External Web Access Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 Apr 07 2:03 PM

And I may have said this a few times already, but if you only installed the SLX Provider on the External Web Server, the Installer did not verified nor installed MDAC.

Please make sure that you have MDAC 2.8 installed and working as well. (This is specially true if testing with the UDL fild also fails).

[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/26/2024 7:20:51 AM