Link to home
Start Free TrialLog in
Avatar of Navicerts
NavicertsFlag for United States of America

asked on

adodb deployment

Hello,  

I am having an issue with deployment that you may be able to help me with.

My code uses some legacy adodb.  On my development pc this code was working fine.  According to what I have read adodb should be included in the .net framework.

However, when I install the application on a testing machine I am getting an error message as soon as the code hits a point where adodb is accessed with an error message of “Data Provider not found.  The data provider may not be installed properly.”

I do not know how to solve this problem, can you help point me in the right direction?

Thank You
Avatar of Nasir Razzaq
Nasir Razzaq
Flag of United Kingdom of Great Britain and Northern Ireland image

ADODB is not part of .NET framework as far as I know. What provider are you using? Operating system? 32 bit or 64 bit?
Avatar of Navicerts

ASKER

Pay no attention to my guess at what the probem is, im probably wrong :)  

The issue is the error message im getting on the test machine.  The error occurs when I try to open an adodb connection.

The connection string I have in my app.config file looks like this....

<add name="CSOLEDB" connectionString="Provider = SQLNCLI10;Server=SG_Test;Database=xxxxx;Trusted_Connection=yes"/>

Also, im supposed to be working with another team who set up a dsn for me but gave me no further information.  It could be that im supposed to change my connection string to target the DSN (guessing here); does that sound plausable?
I do see a DSN that was set up for me.  If they created an ODBC connection and then a DSN to go with it could I change the connection string to point there instead of the current one which is failing?

I'm swimming here so just stop me if i've gone off the deep end.
Yes you can use the DSN. Give that a try and let us know how it goes.
I think there might be a problem with the connection string.  I am getting the same error when I switch out the connection string to be simply "DNS=dnsname".
Show the code you are using.
app.config

  <connectionStrings>
    <add name="test" connectionString="DSN=Small_Group_Product_DB_Dev"/>
  </connectionStrings>

Open in new window



module where i set some globals

    Public ConnectionString As String = ConfigurationManager.ConnectionStrings("test").ConnectionString

Open in new window



Point where program crashes.
If ADODBConn.State = ConnectionState.Closed Then : ADODBConn.ConnectionString = ConnectionString
            ADODBConn.Open() : End If

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Nasir Razzaq
Nasir Razzaq
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
too much given the time frame i have to work with.  I started switching some stuff over but if I try to do it all right now as opposed to swapping it out over time im going to run into problems.

I am including a refrence for adodb.  Do you know what I need to to do to find out what provider I am missing?
What test machine did you try this on? XP? 7? 32bit? 64bit?
The test machine is XP 32 bit.

The development machine (it works on) is Win7 32 bit.
The only thing I can think of is to compare what you have installed on 7 and on xp and see if you can download the missing components.
I had to install "Microsoft SQL Server 2008 R2 Native Client"; it had the data providers needed.