473,769 Members | 2,062 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

adodb.connectio n problem

Hello,
I am having a problem with ADODB connection class. This was all working fine until I restarted the pc with last known good configuration, which seems to have screwed things up

In the code below the conn.open command fails with a cannot find stored procedure error. and system.runtime. interopservices .COMexception. The specified procedure could not be found. at ADODB.Connectio nClass.Open etc.. How can I fix this problem, do I need to re-install anything. I still have a reference to adodb

Regard

Robert

Dim Conn As ADODB.Connectio n = New ADODB.Connectio

GblConnectionSt ring = "PROVIDER=SQLOL EDB.1;PASSWORD= " & txtPassword.Tex t & ";PERSIST SECURITY INFO=TRUE;USER ID=" & txtLoginName.Te xt & ";INITIAL CATALOG=Master" & ";DATA SOURCE=" & txtServerName.T ex

Tr
Conn.Open(GblCo nnectionString) '''*********** FAILS HERE*********** ********
Catch e As Exceptio
MsgBox(e.Messag e
MsgBox(e.ToStri ng

End Tr
Dim rs As ADODB.Recordset = New ADODB.Recordse
Dim strRowSource As Strin

Tr
rs.Open("SELECT Name From sysdatabases WHERE Name NOT IN( 'master','tempd b','model','msd b','pubs','Nort hWind')", Conn
Catch e As Exceptio
MsgBox(e.Messag e
MsgBox(e.ToStri ng
MsgBox(e.Source
End Try
Nov 20 '05 #1
3 1834
* "=?Utf-8?B?Um9iZXJ0IEJ hdHQ=?=" <an*******@disc ussions.microso ft.com> scripsit:
I am having a problem with ADODB connection class. This was all
working fine until I restarted the pc with last known good
configuration, which seems to have screwed things up.


You will more likely get an answer here:

<news:microsoft .public.dotnet. framework.adone t>

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>
Nov 20 '05 #2
Cor
Hi Herfried,

This is no Adonet.

I really do not know how to answer this.

Cor

Nov 20 '05 #3
* "Cor" <no*@non.com> scripsit:
This is no Adonet.

I really do not know how to answer this.


I feel sorry, it's old ADO. Nevertheless I would post database related
questions to the ADO.NET group.

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>
Nov 20 '05 #4

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

Similar topics

13
7779
by: Patrick | last post by:
I understand that with IIS5.1 on Windows XP Professional SP1, I can 1) Either set under IIS Manager-> Any specific Virtual Directory-> Configuration->Options->ASP Script timeout for all pages within that directory OR 2) Within a specific page, set the timeout as per http://www.microsoft.com/windows2000/en/server/iis/default.asp?url=/windows2000/en/server/iis/htm/asp/vbob246s.htm e.g. <% Server.ScriptTimeout = 1 %> and that the value in...
2
395
by: Bob | last post by:
Am using VB.net 2003 on a W2K Pro development and target platform Dim cn as ADODB.Connection = new ADODB.Connectio Works fine in the IDE and with my test app, but immediately throws an exception on the target box Both boxes have the .NET Platform installed. Both boxes have MDAC 2.7.1 installed I've included
4
3449
by: Jim | last post by:
I am having a problem with the IsDBNull function. When it checks what type of value is contained in the parameter that is passed to it, it does not successfully determine that it has a DBNull value. If I access the value of what I am going to pass to the IsDBNull function before I call the IsDBNull function then it does successfully determine that it has a DBNull value. Below is a page that I am using to test. Note: that the value for...
0
2478
by: Channing Jones | last post by:
Hello everyone, I am trying to store data in a binary field of an SQL-Server table using ADODB. So far, I have managed to store a record but not any data in the binary field. I only get exceptions on various part. I have tried both AppendChunk and using a stream object. Unfortunately all the examples I can find in the Net and on the Microsoft site
5
29846
by: Simone | last post by:
Hello I hope you guys can help me. I am very new to ADO... I am creating a ADODB connection in a module and trying to access it from a command button in a form. Function fxEIDAssgn(plngEID As Long) As Boolean Dim rsAssignedUser As ADODB.Recordset Dim strSelectUser As String
7
319
by: Peter Newman | last post by:
Im still trying to get my head around this, but its the only way i have seen to be able to create a 'recordset' and bind text boxex to it and navigate throw each record by the click of a button ... ok it may not be the prettist of code but i have that bit working . i have however stumbled across another problem ... I make a connection to a SQL2005 database when my app loads using the following CON_BOSSCONNECTION.ConnectionString =
0
1723
by: dmckenna | last post by:
I've been tasked to upgrade an old system and there's many different versions of VB code that uses MDAC to talk to MSSql. Do you know what the difference is between the two code versions? Is there problems with re-opening connections all the time? Version 1 of the program is:
4
4285
by: T | last post by:
-------------------------------------------------------------------------------- I tried this audit trail code, using 2003 and it works great, I try and use it at work w/97 and it blows up: Compile error, user defined type not defined I assume the ADODB is the problem? How would I change / fix this to work w/97 Table called UserLog w/field UserName txt
1
5170
by: arcingmad | last post by:
Hi I am using the following code in a button click event to run a query stored in a .mdb file from an external geographic program ArcGIS via a jet adodb connection I have the need to run an existing make table query, my problem is it will over write an existing table. i.e when run in access a warning that you are about to overwrite an existing table will be shown and you will be prompted to accept or reject. When run via the external program...
0
9589
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
9865
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...
0
8872
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7410
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
6674
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5307
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
5447
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3564
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2815
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.