Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Sunday, June 20, 2021 
 
View User Profile  

 User Profile - KevLar  
KevLar


fjrigjwwe9r1SiteUser:UserBio
fiogf49gjkf0d
Manage my own company by day, develop SLX for it by night.


Log in to send this member a message!
 


 KevLar's Contributions
KevLar has contributed 3 comments and 0 articles.
 
Select to view:    
Comment: Re: Understanding the SalesLogix 6.2 Connection String
fiogf49gjkf0d
This is the problem I think:
http://www.slxdeveloper.com/forum.aspx?forumid=3000&postid=6487

In the process of going thru these steps it started working. Remember to Iisreset.

Author: KevLar - 3/12/2008

 
Comment: Re: Understanding the SalesLogix 6.2 Connection String
fiogf49gjkf0d
That was quick thanks Ryan.

No more errors, but the page just loads and loads. Nothing happens, it doesn't even time out. I created a test page that just opens and closes the connection just to be sure.

I'm running SBS 2003, SQL 2000, and SLX on the same box (which is also serving up the ASP page in question). Are there certain permissions I need to set to allow access to the SLX provider? Is there somewhere else I should be looking for the problem?

Author: KevLar - 3/12/2008

 
Comment: Re: Understanding the SalesLogix 6.2 Connection String
fiogf49gjkf0d
I have an ASP web page accessing a SQL server using the connection string:

DIM objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "Driver={SQL Server};Server=SERVER;Database=TESTDB;Trusted_Connection=yes;"
objConn.Open

How do I modifiy the the connection string to work with the SLX provider? I tried the code below and I get an "Expected end of statement" error.

DIM conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionString = "Provider=SLXOLEDB.1;Data Source=SERVER;Initial Catalog=TESTSLX;User Id=admin;Password="password";Persist Security Info=True;Extended Properties="Port=1706;Log=On";"
conn.Open

If I take out the extended properties portion of the string I get an error like below:

ADODB.Connection error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/includes/SLXconnection.asp, line 5

Thanks in advance for any help on this.


Author: KevLar - 3/12/2008

 


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

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 6/20/2021 11:04:14 AM