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!
|
|
SLXOLEDB.1 provider is not installed on the SLX server?
Posted: 24 Jul 06 4:59 AM
|
fiogf49gjkf0d I have a slight issue with the SLXOLEDB.1 provider, in that I can't seem to connect to it on the server itself. I have written a simple app to do some data-exports, and on my machine it connects fine and seems to work as intended. When I run it on the server though (it will be a scheduled task eventually) I get an exception error that "The 'SLXOLEDB.1' provider is not registered on the local machine".
I am using SLX 6.2.2, and on the server I can use Admin, Client, etc with no problems. I am logged on to the server as administrator, over a TS session.
I have used the connection-string tool off this site too, in case it was my constring.
conStringSLX = _
"Provider=SLXOLEDB.1;" & _
"Persist Security Info=False;" & _
"Initial Catalog=saleslogix_62;" & _
"Data Source=myservername;" & _
"User ID=admin;" & _
"Password=myadminpassword;"
This works okay from a client. Do I need to install the OLEDB provider on the server seperately?
Many thanks,
Mark |
|
|
|
Re: SLXOLEDB.1 provider is not installed on the SLX server?
Posted: 24 Jul 06 3:54 PM
|
fiogf49gjkf0d I'm running 6.2.3 and my connection strings work on both the client and server without any extra effort.
I'm sure the connection string tool works but have you tried the .udl approach? Create a file with .udl as the extension. Open it, which fires the typical OLE DB config screens and go through the motions as you would normally. Change the extension to .txt or just open it in notepad and it'll give you the connection string.
I just did a test and I'm not showing much difference except for the missing Extended Properties="PORT=1706;LOG=ON;CASEINSENSITIVEFIND=ON;". The hardest part about including that is escaping the quotes so that everything is correctly included. It might explain why the client works but the server doesn't though I'd be surprised if this were the actual problem. |
|
|
|
Re: SLXOLEDB.1 provider is not installed on the SLX server?
Posted: 24 Jul 06 5:11 PM
|
fiogf49gjkf0d If the only thing that is installed on the server is the SalesLogix Connection Manager (ie: The SLX Server) then IIRC you will need to install the client provider on the machine as well in order to make a SLX connection.
-Ryan |
|
|
|
Re: SLXOLEDB.1 provider is not installed on the SLX server?
Posted: 26 Jul 06 12:06 PM
|
fiogf49gjkf0d This is strange. The server has the SLX Server, Administrator, Architect and SLX client installed, and all work fine. It's just my app. The provider seems to be registered to some extent, as I can see it in the registry all over the place.
Incidentally, I have tried running the standalone OLEDB provider from SP2. |
|
|
|
Re: SLXOLEDB.1 provider is not installed on the SLX server?
Posted: 26 Jul 06 12:27 PM
|
fiogf49gjkf0d If the client and all are installed on the server then the provider should be there too. The problem would be something else. Is your code running under the logged in user (or via a service context)? |
|
|
|
Re: SLXOLEDB.1 provider is not installed on the SLX server?
Posted: 26 Jul 06 12:51 PM
|
fiogf49gjkf0d Would the External license come into play here? I have licenses installed in my database and it's the only thing I can think of off the top of my head that may be different. It would be weird that the client would work but it could be that the external license doesn't get checked unless you try to run it through the provider on the server directly. |
|
|
| |
|
Re: SLXOLEDB.1 provider is not installed on the SLX server?
Posted: 27 Feb 07 8:56 AM
|
fiogf49gjkf0d Blimey, was this really so long ago? 
I've finally reached the stage where the sync app I've created (to sync SLX contacts with Joomla and phpBB) is ready to go, but I'm still stumped by this Provider issue 
I've used Ryan's Connector-string creator tool, and hard-coded various Connection Strings into my app, but for the life of me I still can't get this to run on the SLX server.
This is the connection string I'm using, which works wonders on my client machine
Provider=SLXOLEDB.1;
Data Source=MYSERVERNAME;
Initial Catalog=SALESLOGIX_LIVE;
User ID=myadminusername;
Password=mytopsecretpassword;
Persist Security Info=True;
Extended Properties="Port=1706;Log=On"
And this is the error I get
Unhandled Exception: System.InvalidOperationException: The 'SLXOLEDB.1' provider is not registered on the local machine.
at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)
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 WebLogix.SalesLogix.Connect(String connectionString)
SLX server is all running fine
SLX client works fine on the server
Connection test from Ryan's Datalink Designer works fine
I'm stumped At the moment I'm going to have to have this running on a client machine somewhere, which is not ideal. |
|
|
|
Re: SLXOLEDB.1 provider is not installed on the SLX server?
Posted: 27 Feb 07 9:01 AM
|
fiogf49gjkf0d Ah, this is interesting. I followed the .udf test again (I'm sure I tried this before :P) :
Create empty file called test.udf
Double-click to launch editor
click "back" to get to the provider-selection screen
Select "SalesLogix OLE DB Provider"
Click Next to configure
Get an error! "Provider is no longer available. Ensure that the provider is installed properly"
Seems I need to reinstall something? Bit hesitant, as this is the production SLX server. |
|
|
| |
|