11/21/2024 4:50:37 PM
slxdeveloper.com
Now Live!
|
|
| |
|
|
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
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
|
|
|
|
|
|
|
|