4/29/2024 8:30:04 AM
|
| |
| 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 using the SalesLogix OLE DB Provider from external applications (including usage of built-in provider procedures). View the code of conduct for posting guidelines.
|
|
|
|
Unable to connect to SLXOLDEB - Unexpected error
Posted: 19 May 09 4:35 PM
|
Hello,
I'm using the following connection string to connect to SLX to retrieve the RWPass value.
I get an Expected error after the time out expires.
Exception message:
"No error message available, result code: E_UNEXPECTED(0x8000FFFF)."
Full error message:
"System.Data.OleDb.OleDbException: No error message available, result code: E_UNEXPECTED(0x8000FFFF).
at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at UpdateSalesLogix.clsSLXRecordset.GetRWPassword()"
I've reinstalled the OLE DB provider. No Change in results.
I'm on a Vista 32 bit machine running SLX 7.5. The code previously worked on SLX 6.25. I've converted the code from VB6 to vb.net 2008. Only one hard drive (C , 3 gigs of ram.
Dim conn As OleDb.OleDbConnection = New OleDb.OleDbConnection(g_conn)
conn.Open() ' Times out and dies here
Dim cmd As OleDb.OleDbCommand = New OleDb.OleDbCommand("SLX_RWPass()", conn)
Any help would be appreciated.
Ken Pinard
g_conn is listed below.
Provider=SLXOLEDB.1 assword="";User ID=admin;Data Source=yogibear;Initial Catalog=dbNameersist Security Info=True;Extended Properties="Log=ON;IncludeCalcFields=OFF;TIMEZONE=35;TrimCharFields=TrueORT=1706" |
|
|
|
Re: Unable to connect to SLXOLDEB - Unexpected error
Posted: 19 May 09 4:39 PM
|
Additional information:
this connection string works, but of course will not provide any sync processing:
driver={SQL Server};server=(local);uid=sysdba;pwd=masterkey;database=dbname
PS Love all the smiley's that should up in the connection string above (shaking head in amusement).
Ken |
|
|
|
Re: Unable to connect to SLXOLDEB - Unexpected error
Posted: 19 May 09 6:55 PM
|
I'm on a roll today, that was the ADODB connection string.
This is the OLE DB connection string:
Provider=SQLOLEDB;Data Source=192.168.1.100;Initial Catalog=dbname;User Id=admin; Password="";
|
|
|
| |
|
Re: Unable to connect to SLXOLDEB - Unexpected error
Posted: 21 May 09 4:16 AM
|
Thank you,
Those directions helped.
The problem was what I considered the initial catalog to be the SLX Name and not the name of the UDL entry. Most people I know make them the same, I always make them different so I know when which is which. Well, so much for planning
Thank you again, I appreciate the support.
Ken |
|
|
| |
|
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!
|
|
|
|
|
|
|
|