Avatar of Navicerts
Navicerts
Flag 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
.NET ProgrammingVisual Basic.NET

Avatar of undefined
Last Comment
Navicerts

8/22/2022 - Mon
Nasir Razzaq

ADODB is not part of .NET framework as far as I know. What provider are you using? Operating system? 32 bit or 64 bit?
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?
Navicerts

ASKER
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.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Nasir Razzaq

Yes you can use the DSN. Give that a try and let us know how it goes.
Navicerts

ASKER
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".
Nasir Razzaq

Show the code you are using.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Navicerts

ASKER
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
Nasir Razzaq

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Navicerts

ASKER
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?
Nasir Razzaq

What test machine did you try this on? XP? 7? 32bit? 64bit?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Navicerts

ASKER
The test machine is XP 32 bit.

The development machine (it works on) is Win7 32 bit.
Nasir Razzaq

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.
Navicerts

ASKER
I had to install "Microsoft SQL Server 2008 R2 Native Client"; it had the data providers needed.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.