I'm working on a project that getting infos from an Excel book. I've created an Excel book (called as "Kitap1.xls"), entered some infos and created a table (called as "asd") Then I added a DataGrid object on Form1 and codes setteled below; [code]Program is running but the infos ,which in the excel book, do not appearing in DataGrid1 object.
View 11 RepliesFor my current Project I need to fetch the data from an excel file.Each second the data in the excel file is changing... What I want to do is, copy it from the excel and Validate it in every second.So I use an Oledb connection to get the data from Excel file... s working excellent for two hours... After 2 hours I am getting an error that"the connection for viewing your linked microsoft excel worksheet was lost......"
View 1 RepliesI have a simple scraper. It works on some websites, but on some there is this Error:
Quote:
IOException was unhandled Unable to read data from the transport connection: The connection was closed
It is occuring at "Dim htmlresults As String = Urlcontents.ReadToEnd()".
'Create the HttpWebRequest object
Dim req As HttpWebRequest = WebRequest.Create(URL)
'Set the timeout to 1 second (or 1,000 milliseconds)
req.Timeout = 10000
[code]....
I'm creating a tool that will query Excel and intialize the default settings for the site's Cad Software.I want 2-20 users to be able to simultaneously query excel. Currently I have the spreadsheet open on one computer and the other test machine gives me this error.
GetOleDbSchema Table Require an open and available connection. The connections state is closed.
I could use some help on the code design. Should I use Datareader instead....Does that have less permissions issues? Or do I need to open up the oledbconnection in a different manner?
Private Const cPageData = "PageData"
Private Const cPrinterData = "PrinterData"
Private Const cSupportData = "SupportData"
Private Const cUserData = "UserData"
I'm trying to connect excel sheet with VB 2008 in my project, but it show a error message: A first chance exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll
[Code]...
I have a small application where I am importing different versions (2008, 2010) of Excel sheets and saving them in SQL server. My program will find the 2008 versions but for some reason it will not find the Excel 2010 versions. I am not sure if my code for the Connection String is correct. Perhaps someone could have a look at my Connection String code?
Imports System.Data
Imports System.Data.OleDb
Public Class DBHelperClass
[code].....
I created a vb form application that I want to query a SQL Server database that is hosted through godaddy. Below I have my function that calls the db and also my connection string in my app.config file. When it tries to open the connection I get the following: {"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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"}. Do I have to set something on the godaddy end to allow a connection? Or can I only access the database from a web page on my site? [Code]
View 2 RepliesI created an vb.net Application with microsoft visual studio 2008 and Access 2003 as Database. The application work fine in XP O/s but when i run the application in Windows 7 it gives error when connecting to Database. It works fine when i create an new Access 2003 database in Window 7.It gives error System.Data.OleDb.OleDbException: Operation must use an updateable query.
View 1 RepliesI 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 Repliesi have an application. which is executed after every 5 mins. i have an open connection but it gives me the following error:
ExecuteScalar requires an open and available Connection. The connection's current state is closed.
my code is something like this. I have shown where all i am using ExceuteScalar()
Sub Main()
Try
connection.open()
cmd.ExecuteScalar()
[code]....
I am trying to do something fairly simple.. allow my user to import thier data from Excel into SQL Server, where it can be used by the application.To do this, I'm using the fairly simple code that is common everywhere I look:
strFilePath = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fdlgFileOpen.FileName + ";Extended Properties=Excel 8.0"
connExcel = New OleDbConnection(strFilePath)
connExcel.Open()
[Code]...
Now, on my development computer this code works perfectly. The data imports, and I can go on my merry way.
On the TEST computer, this code throws the error: "ODBC -- Connection to {SQL Server} servernamesqlservername failed." This seems very odd to me, because I'm using exactly the same SQL Server and database to interact with the application, and all the other screens in the application work perfectly. The test computer CAN connect to this SQL Server, but it keeps throwing this error whenever I try import data from Excel.I've tried everything I can think of - using the server's IP address instead of the server name, sending the SQL Server administrator data along with the request, taking out the Trusted_Connection=Yes... nothing works. What is going on here? How can this code work fine on my computer, and hiccup on another?
I have attached Database to my vb.net application. Client has sql server 2008 express installed.I built my application and gave to him. he is encountering errors.
PHP
"Data Source=.SQLExpress;Database=xx.mdf;Trusted_Connection=True;Integrated Security=False"
i am getting Cannot Open Database for requested Login. Login Failed. i am using SQL 2008 server Developer edition. And using Windows Authentication mode.
Code:
Dim cn As New ADODB.Connection()
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:BackupEon of LightEon Of Light.mdb"
[code]....
' This code not Working :('Error Messege in md.Save()
This will happen at random, and I can always just catch the error and re-establish connection to the server, but I am confused as to why. When doing lots of inserting into the sql server, I only establish one connection that is public, instead of many little connections. I had my doubts on a public sql connection, but it's been running great, and I've seen no problems until this morning. Again, this random moment I hit an error that stated, sql connection state is broken. Is it bad practice to just accept this error, and when it happens, re-establish the connection?
View 7 RepliesError message receiving 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) The project is written in VB.Net 2008. Production server uses SQL 2008, Dev Server uses SQL 2000. The application has been built and published.
Prod Connection String: strCN = "server=SGMAGNCPQ03.;Initial Catalog=APO_Tax;Integrated Security=True"
Dev Connection String: strCN = "server=S04423711940995.;Initial Catalog=APO_Tax;Integrated Security=True"
The Problem: When I change the connect string from dev back to prod and try to run my app, I get the above error message. If I reboot everything works fine but if I switch the connect string from prod to dev and try to go back to prod, I'm back to the same problem.
I have a routine in VS 2008 that exports data to an excel spreadsheet. This has been running without any problems for months. Now I am getting the 'cannot expand named range' error. The strange thing is that it doesn't happen all the time. I can export the data 2-3 times and it works fine but the fourth time I get the error. There is no rhyme or reason. We have upgraded to Office 2010 recently but I updated the excel reference in my project to Microsoft Excel 14.0 Object library. Even if that was an issue why would it work sometimes and other times not? [code]
View 9 RepliesI am trying to read excel data (Excel 2007 SP1) with visual basic .net 2008 (VB 9.0 SP1). I have tried several attempts and even when I copy and paste the code that manhit45 proposes (Thread: working with excel) I am getting the following error message: ystem.Runtime.InteropServices.COMException was unhandled ErrorCode=-2147319784 Message="Altes Format oder ung�ltige Typbibliothek. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))"
View 14 RepliesI have a program that sends some data on a networkstream through a tcp connection.
[Code]...
I'm creating a small application that will export the record from database to excel format (.xls) and import the record from excel as well. i have this code below i dont if this the right approach but im getting the error. Im using emulator btw. error :"The process can not access the file 'My Documents est1.xls' because it is being used by another process." Code: I'm still figuring out about import function any ideas?
View 2 RepliesError2'KeyUp' is not an event of 'Microsoft.Office.Interop.Excel.TextBox'. how can i fix this error
View 12 Replieswhen I attempt to make the connection through a VB.Net with window application, I am getting the following error: ERROR [28000]
My connection string is
HTML
<connectionStrings>
<add name="MyConnection" connectionString="Driver=PostgreSQL ANSI;Server=10.146.152.23;Port=5432;Database=pacs;Uid=postgres;Pwd=postgres;" />
</connectionStrings>
<system.diagnostics>
I have an excel with 10 sheets, each sheet has a connection stored in it because i am using the ms query to read data from access database. when I code the below, both line are accepted by vb.net (with new or without)
Dim wb1 As Excel.Workbook
Dim wb2 As New Excel.Workbook
Now when I code
Dim wb_cnn1 As Excel.ODBCConnection ' Works Fine
Dim wb_cnn2 As new Excel.ODBCConnection ' Error 'New' cannot be used on an interface.
Q1: Why I cannot create New Excel.ODBCConnection? I have this
Dim xlsApp As New Excel.Application
Dim wb_cnn As Excel.ODBCConnection
Dim wb As Excel.Workbook
[code]....
Maybe because it is read only. I want that because the ms query is hardcoding the path of the access db even if i choose DSN so, if I change the location of the access file the query in the excel will not work, Q2: How I can change the connection in the Excel sheet?
How can we read an excel file without using Oledb?
View 3 RepliesHow to write into excel sheet using oledb connection or how to export dataset into excel sheet using oledb connection.
Iam using console application in vb.net. If there are any alternate ways to write into the excel files from dataset.
We have a VB 2005 program that reads data from a database and builds an Excel output file to be emailed. This works fine from my computer but when we put it on the server it fails on the Excel functionality.
The error is: Unhandled Exception: System.Runtim.InteropServices.COMException
Although Excel is not installed on the server we did also build a Setup program to install our program. It copies the Microsoft.Office.Interop.Excell.dll to the server folder with the exe.I thought the setup program should register the Excel DLL and the program should work even if the server does not have Office or Excel installed.
I have the following database defined in app.config now:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory| able.mdb
can I use excel instead as datasource there? are there any limits if I use excel file, the database is simple 300 rows, and it would be more handy to use excel file.does excel need to be readonly?
A While back I developed a application that connected to Excel using DB connection. It worked fine since the application was designed for usage on one particular PC with Excel 2003. I especially liked the solution since the data retrieval was much faster compared to what I would get if I connected to Excel using Interop libraries.
However, recently when I tried to implement the same solution onto another app that would run on various PC that could use different versions of MS Office I ran into multiple problems. First of all, I can't use the same connection string on various versions. Also, the whole x64 vs x86 thing is adding to the problem.
I wonder if there is a way to check the version and use the apropriate connection string for every version?
i am making a website for trading, with trading feeds coming from a source in an excel sheet. I have to show data from the excel sheet in a gridview. When i make connection it will fail due to rapidly changing data; each cell in the sheet changes value 1-3 times per second. I am using an Ajax Timer of interval 100. Here is my code:
[Code]...
i making a website for trading in which trading feed coming from a source in excel sheet. i have to show data from excel sheet to gridview. but when i make connection it will lost due to rapidly data( in excel sheet each cell change value 1-3 times in one second).Am using Ajax Timer of interval 1000.
View 1 RepliesI have this program that uses OLEDB connection to import excel file to data table then use it in other functions.Now I have this question: What are the possible limitations of OLEDB when it reads the Excel file. The File is on xls format, and I want to know if there is such limitations(for example: It has limitation in reading value on a cell).
View 6 Replies