Just got this error in my vb2008 programs when trying to install on other computers (customers running XP and Vista). I am on a Win7 computer and are using MS Access 2007 databases. Up to now everything was just perfect - but now.... Tried to search the net for solutions, but got a lot of mumbo-jumbo I can not understand. what to do in order to supply a set-up program which works.
View 2 RepliesI am getting errors when I try to use this adodb.connection and command in my code. The error I am getting is saying that the connection and command are not defined. I read online that depending on your version of vb that you might use the "OLE" connection instead of ADODB.
Imports System.Text.RegularExpressions
Imports System.Data.OleDb
Imports System.Data.SqlClient
[Code]....
I'm trying to set up a database connection between an ASP page running VBScript, and I have found code to do this. However, the 'provider' attribute to the connection does not work. The code is below:
set conn=Server.CreateObject("ADODB.Connection")
<strong>conn.Provider</strong>="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.MapPath("mIndexDb.xls"))
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "Select * From mIndexDbTable", conn
[Code]...
I have no experience with VS 2008 Express yet. But, I need to use it to make a small VB app for work that connects to an Access database and gets table values.I have no samples to work from. I keep getting the error: Type 'ADODB.Connection' is not defined. How do I create the reference to ActiveX Data Object?
View 2 Repliesmy program does not work on other machines.although they stood Framework & adodb.dll.writes that the error in the "Update".
View 7 RepliesI recently installed VS 2010 Premium. Since then I can not publish any of my projects due to this error,[code]I just created a new Visual Basic Windows forms application and without adding any code published the project. (I do get this in my previous working projects also).[code]If you later install a more recent service pack, this security update will be uninstalled automatically.url...
View 4 RepliesI have just created a new Extensibility Addin for Visual Basic using VS2005 Professional. This addin will be targeted at MS Outlook (I hope).When I look at the References tab of the project properties, I see the following message:-An error occurred trying to load the page.Unable to cast COM object of type 'System.__ComObject' to interface type 'EnvDTE.ProjectItemsEvents'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{22800963-2811-410D-BF87-A7808EAC977D}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).Why does this appear?How do I correct this?
View 6 RepliesI recently finshed a program and made a finshed copy of it when I tested it on my computer it installed correctly but when I tryed to use it on a nother computer I got a error saying application download did not succeed.Check your network connection, or contact your administor or network service provider.[code]...
View 1 RepliesI have an app which has an icon in the application for the project I have developedIt shows when I run my app but is not shown when the app is installed on another computer
View 7 RepliesI installed VB 2010 Express on 2 different computers using the same activation key. An XP machine and a win 7 machine. Is this is allowed? There is no FAQ and since its free I figured this was OK. Is there a Microsoft Certified person here that has an answer for this 100%?
View 1 RepliesI descovered that an application within my company at the minute reads a 'license.dat' file which must be generated off-site. If the file is missing or is edited in a text editor (which 90% of the content is not english, more gobuldy gook). then the application shows an error and then closes. I would like to know if that can be done for my application, so i can generate a licence.dat file and then install in on the clients computers.
View 2 RepliesWe have a VB.net application using both ADO.net and ADODB connections(both connecting to MS SQl server) Whenever an ADO.net connection throws an expection, we cleared the pools Now if any ADO.connection reopened and everything works fine Is there any way to clear pools for ADODB connection?
View 1 RepliesWe have had a visual basic.net (2002) service running on our server for several years now with no problems. However I recently needed to update one of the DB calls by adding additional fields to the SELECT statement. However, after adding the new fields, some of the returned data is coming back empty when I loop through the records. I have confirmed that the querystring is accurate and returns all of the data through a third party viewer, so I'm not sure what is going on.For example, in the code below, everything worked fine with field1, field2, and field3. However, when I add field4, data for field2 and field4 come back empty when looping through the results.
View 10 RepliesI'm connecting to Outlook using Adodb. (ADO is a requirement)
With ADOConn
.Provider = "Microsoft.JET.OLEDB.4.0"
.ConnectionString = "Exchange 4.0;" _
[code]....
then using the sql
Select * from Calendar
which returns the Appointments, but with no start or finish times.
i wanna know how to retrieve data from a database using adodb connection in VB.
View 1 RepliesI want to access the methods of a dll that is not managed. Seems to be vb6 from my best guess and what I know about the program.That part I have managed to figure out. If I drag the x.dll to my bin folder, the interpreter wrapper is created, etc. I can access the methods in the dll just fine. The problem is the database connection.
For informational purposes: The dll is compiled for a vbscript .asp website. There are a few methods in the dll that just manipulate the input (which I can access error free- its how I tested the dll usage), but most make a db call to get or set or update, etc. data in the db. The dll expects an ADODB connection. The asp files are setup such as:
set DllObj = server.CreateObject("dll.class")
set connect = server.createobject("ADODB.Connection")
connect.open "SystemDSNName","user","password"
[code].....
It is using a DSN but just as easily could be a DSN-Less connection. My problem is that the dll expects the connection to be open and available to it. Can I make a ADODB database connection available and open for this dll in a vb.net asp.net website.Basically,I need to use the business logic and db data changes through this dll, but want to make the front end in asp.net.I know there is an ADODB namespace in .net somwhere and I tried using it but it was not doing the job and really, I did not quite understand how to.
i been creating a project for school that requires me to access a database for username and passwords
I have no problem doing this, but only if i "hard code" the location of the database.
[code]...
I am newbie in Visual studion 2010. May i know how do i setup the connection for a mdb file. Below is my code and i have encountered an error. the error message is "A first chance exception of type '[URL]' occurred in WindowsApplication1.exe".
[Code]...
We have a VB6 program that uses an ADODB.Connection to establish a database connection and use its execute function to run SQL statements. The connection we have established is to a SQL Server. It has been working fine. Currently, I am trying to change the connection to a MySQL database. I changed the connection string and the connection is ok.
However, when it comes to running the execute function, it returns a runtime error 3246 - connection object cannot be explicitly closed while in a transaction.
I checked the connection.status before calling execute and found that it is open. When I use MySQL's server connections to check the status, I found that there was a connection before and after execute was called.
I encountered this same error whether I used MySQL ODBC 5.1 Driver or MySQL ODBC 3.51 Driver.
I am using VB6 for a (ADODB Connection & Record set) database program by connecting MS Access file (MDB). Can I make same program in Visual Studio 2010 by ADODB connection with MS Access (MDB)?
View 1 RepliesI have upgraded my VB app from VB to VB.NET and its working fine. Now, I want to convert my existing DB connection strings from ADODB to ADO.NET so that I dont have to use MS Access on every client which runs this app. Currently the VB app looks up into an Access db to get the server ip, username, password etc. I aim to hardcode these values so that I wouldn't need the Access db anymore. Any inputs on how this could be done?
[Code]...
I am having problem with Visual Studio 2008.... When i add the Microsoft ActiveX Data Objects 2.5 Library from COM References, and just run the blank form, it runs perfectly.... But whenever i declare anything related to ADODB like dim con as new ADODB.Connection, then after that it gives me error and doesnt run the project. A first chance exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll. After that if i comment that like (declaration), then error goes........ I tried uninstalling each and every component and VS as well but the error doesnt goes....i am using Windows 7 x64. The same is working in Windows XP x86 in my virtual machine..... as i am not able to start my project
View 2 RepliesHow can i connect all the computers in a server using vb.net 2005 or latest version of vb.net.?
Scenario: 10 computers in a computer room. connecting it to a server.
The connection string generated by VB only works for my computer because of the path and even tho within the program I used paths which only include the name of the file i need to load when i do that with the DB it doesn't works.
This is the message i get: An attempt to attach an auto-named database for file Database1.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
I have finished my program and now i am ready to deploy it. The only problem is it is a multi-user application. All i want to do is simply run the program with the database from a server, and have other local computers with the program access this same database. I know that you have to change the connection strings for the local computers, but how can i go along doing this?
View 2 RepliesI have something strange occuring. The following code works 100% when run in VB2008 Express.When compiled and run onthe same system, it generates the above message.The codebasically opens a Access DB and loops thru the db There is a progress bar (also tried a simplelabel) to display progress using AbsolutePosition.
dbInUse.Open("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:SCDBv4DataSCDBData.mdb")
rsInUse.Open(OpenCommandSQL, dbInUse, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic)
[code]......
I'm new to VB 2005, the code below is actualy coded from VB 6 and just converted it to VB 2005. I'm having trouble with line that's on bold letters.In VB 6 this works just ok. By the way the error message is "Unable to cast object of type 'System.String' to type 'ADODB.Connection'." [code]
View 5 RepliesThe following VB code is from an application that I am developing. It establishes a record set by executing a SQL query on a SQL connection (ADODB). On the first pass through, the statement fails with an error 91, I trap it and re-execute the sub and then the statement works! The statement that fails is italicized and bolded below.
Private
Sub LBTasksAD_SelectedIndexChanged(ByVal
sender As System.Object,
ByVal e
As System.EventArgs)
[Code]...
After finish my software, when I was try to run in other computer the error was: Don't possible to get the file or assembly 'ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f711d50a3a'...How the best solution for this error? Just to put the last adodb.dll in the application folder?
View 3 RepliesOver the last couple months I've created a fairly substantial program for a friend in vb 2008 express to deal with the management of a fantasy football league, for its data storage it uses mainly an sql server 2008 express database for all the data, however there are a couple of text files for some unrelated fixed values.
I have spent the last week or so putting some vague finishing touches on it so that I can give it to said friend to test for me. However after working perfectly fine for me for the duration of the construction and also working fine on a couple of computers I installed and tested it on, upon giving it to my friend I find that (after installing) as soon as he opens up any form which relies on database data it spits out an error akin to the following:
Exception Text:
System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
[CODE]...
Loaded Assemblies:
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4918 (NetFXspW7.050727-4900)
CodeBase: file:/Q:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
[CODE]...
I have used a combination of LINQ and SQL statements to query and and update the database, with LINQ for querying and SQL for the updating, due to this most of the database communication is done through a LINQ to SQL datacontext using the pre-generated connection string in my app.config file: <add name="FFL.My.MySettings.FFLv2ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\FFLv2.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
The only other time a connection string for the database is used is in an SQL execution function which uses the following: Dim connectionString As String = "Data Source=.\SQLEXPRESS;AttachDbFilename='" + Application.StartupPath + "\FFLv2.mdf';Integrated Security=True;User Instance=True"
The textfiles are also referred to using the 'Application.StartupPath + "folders/filename"' method
As for other details; I started this program on vb 2008 express but upon finding that the express version didn't have much in the manner of deployment facilities, downloaded a 90 day trial of visual studio 2008 pro to deploy the program as an msi install file. Operating system wise, I started the project on XP before converting over to Vista home premium + latest service pack (I think) which is what I've finished it on and am using currently, the 2 computers I successfully installed it on were both running XP SP3 and my friend runs a dualboot of Windows 7 and Vista (not sure what edition), he's tried it on both to no avail.
And for reference; to the above code/error, the database is called FFLv2.mdf and the project FFL.
The pre-requisites for my program (as highlighted by vb) are as follows:
.Net Framework 3.5 SP1
Windows installer 4.5
SQL Server 2008 express edition
I've tried changing the connection strings to specify a specific filepath, but that didn't help.