473,783 Members | 2,354 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SalesLogix OLEDB Driver.

I know this is more a Saleslogix issue than and .NET one. I thought I'll try
my luck here.

I'm trying to access Saleslogix database using SLXOLEDB driver in my .NET
application. This seems to work fine when I have the whole Saleslogix client
app installed on my computer. But when I have only the Saleslogix OLEDB
Driver I get an invalid case exception when I try to open a connection.
Here is the code snippet.
mConnString = "Provider=SLXOL EDB.1;Data Source=SLX01;In itial
Catalog=SALESLO GIX_DEV;Persist Security Info=True;Exten ded
Properties='Por t=1706;Log=On'; User Id='user';Passw ord='password'" ;

mConnection = new OleDbConnection (mConnString);

try

{

mConnection.Ope n();

}

Catch (Exception e)

{

Console.WriteLi ne(e.message);

}

finally

{

mConnection.clo se();

}

I was just wondering if anyone had come across the same problem. Any help
would be greatly appreciated. I have been banging my head against this for
the past 3 days :-(
--
Satish
Nov 22 '05 #1
1 3113
You may want to try Jeremy Brayton http://geekswithblogs.net/jbrayton/ - I
konw he does a lot of SalesLogix stuff

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Satish Itty" <NO_SPAMsitty@c laytonDOTcom> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..
I know this is more a Saleslogix issue than and .NET one. I thought I'll try my luck here.

I'm trying to access Saleslogix database using SLXOLEDB driver in my .NET
application. This seems to work fine when I have the whole Saleslogix client app installed on my computer. But when I have only the Saleslogix OLEDB
Driver I get an invalid case exception when I try to open a connection.
Here is the code snippet.
mConnString = "Provider=SLXOL EDB.1;Data Source=SLX01;In itial
Catalog=SALESLO GIX_DEV;Persist Security Info=True;Exten ded
Properties='Por t=1706;Log=On'; User Id='user';Passw ord='password'" ;

mConnection = new OleDbConnection (mConnString);

try

{

mConnection.Ope n();

}

Catch (Exception e)

{

Console.WriteLi ne(e.message);

}

finally

{

mConnection.clo se();

}

I was just wondering if anyone had come across the same problem. Any help
would be greatly appreciated. I have been banging my head against this for
the past 3 days :-(
--
Satish

Nov 22 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
4957
by: Juxta | last post by:
Please could someone help. I am using the Oracle OLEDB driver for a multithreadded VC++ app, useing CComand and the DynamicAccessor (fixed version) and i am crashing on the open when more than one thread is being used to create CComand`s. The crash happens deep in the internals of the ORAOLEDB driver. I even sequentualised all CComand access using critcal sections but it still happends. I guess this is an obscure area that nobody else...
4
1215
by: VK | last post by:
Hello: I am trying to insert the products purchased off our website into Saleslogix - any information out there - websites, links etc.? Many thanks for all your help. *** Sent via Developersdex http://www.developersdex.com ***
4
7811
by: NS | last post by:
Hi, I am trying to execute a prepare statement using oledb provider for DB2. The command.Prepare() statement is giving me an exception " No error information available: DB_E_NOCOMMAND(0x80040E0C)." My code is very simple and is working with other oledb provider, like SQL Server and oracle.
3
8898
by: Giuseppe D'Elia | last post by:
Hi there, I got a problem using an MS Access database through ASP.NET. After updating my system from .NET Framework 1.0 to 1.1, my existing application gives me the following error when opening a connection with the code below:
5
9652
by: petro | last post by:
Hello all, My asp.net web application works on my machine but I get the following error on our test web server, There is only one oracle home on the test server. Does anyone know how to resolve this error? Oracle error occurred, but error message could not be retrieved from Oracle. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the...
0
1102
by: JeffP | last post by:
Error at Open() - Driver does not support this function I've tried the OLEdb driver with similar failure, different error but basically I cannot Open using the Foxpro driver(s) Any clues? ..... snipit Dim sDB As String = "c:\Apps\R2M\Data"
5
23200
by: Jesse Albert | last post by:
Hiyo, I'm trying to import a CSV file into a datatable using either ODBC or OLEDB. One of the columns contains an IP Address. For some reason, the IP address will not display correctly. All of the other information in the CSV is accurate. For example, 10.80.34.100 displays as 10.8034. All the IPs in the column are displayed like this.
1
10021
by: =?Utf-8?B?UmljaA==?= | last post by:
In the Registry at HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Jet \ 4.0 \ Engines \ Text the default key for Text Format is: "Format" = "CSVDelimited" I can use the following OleDB connection string with an OleDB dataAdapter to read a comma delimited text file when "Format" = "CSVDelimited"
7
6650
by: cj2 | last post by:
I'm trying to access VFP 8 tables from VB 2008. How can I determine the version of the VFP OLEDB driver on my PC? What is the latest version?
0
9643
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9480
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10147
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10081
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9946
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7494
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5378
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5511
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3643
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.