9/13/2025 10:28:46 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 SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.
|
|
|
|
2003 / IIS6 / SQL2005 / v7 / External Web Access
Posted: 05 Mar 07 3:17 PM
|
fiogf49gjkf0d 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
"%>" |
|
|
|
Re: 2003 / IIS6 / SQL2005 / v7 / External Web Access
Posted: 06 Mar 07 7:17 AM
|
fiogf49gjkf0d 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
|
|
|
|
Re: 2003 / IIS6 / SQL2005 / v7 / External Web Access
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
|
|
|
|
Re: 2003 / IIS6 / SQL2005 / v7 / External Web Access
Posted: 12 Apr 07 2:03 PM
|
fiogf49gjkf0d 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). |
|
|
|
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!
|
|
|
|
|
|
|
|