i am new to vb .net i just want to ask why is it i don't see the odbc data adapter in the toolbox pane? i just have (under data) pointer, dataset, datagridview, bindingsource, and binding navigator.
View 3 Repliesi am trying to connect to an MS Access database and I am getting an erro message on the following line of
searchtable_command = New SqlClient.SqlCommand(searchtable_string, testsearch_connection)
Error:'System.Data.Odbc.OdbcConnection' cannot be converted to 'System.Data.SqlClient.SqlConnection'.
Here my connection string:
Dim testsearch_connection As New Odbc.OdbcConnection("Provider=MSDASQL;Driver={Microsoft Access Driver (*.mdb)};Dbq=C:CesarAccessdatabase.mdb;Uid=admin;Pwd=;")
What am I missing?
Any links to good descriptions and/or tutorials (with VB.net 2008) on OdbcDataReader? I tried, but didn't find many. MSDN is not such a good help in this case.
View 1 RepliesI'm writing an application that imports and tidy up address data into a cleaned, deduped excel workbook ordered in rows with each column as an address field. One of the issues I've ran into is that we sometimes get a workbook where the multiple address fields are held in a single cell with line breaks. I've written code to extract all of this data out of the excel sheet in to a dataset with each sheet as a table and the address fields contained within. I now want to create a new Excel workbook from this data with the address fields in Row and columns the problem I have is I can Open/create the Workbook but when I try to insert a new Sheet (Table) I get an error saying the Workbook is read only....
Private Sub MakeSimpleXL(ByRef DsTemp As DataSet)
Dim dsTable As Data.DataTable
Dim tblName As String
Dim dsRow As Data.DataRow
[CODE]...
Here is the error: System.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC Excel Driver] Cannot modify the design of table '3 _ 10$'. It is in a read-only database. at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String
[CODE]...
It looks to me like it is trying to create the table (Sheet) but has the workbook opened as read only....
I have a small vb.net application that fires a crystal report through crystal viewer.
The report uses an ODBC connection provided by 32-bit software accounts package, which is installed in the ODBC 32-bit This all works fine on 32-bit XP and 32-bit Win7 with no problems, When run on a win7 64-bit machine the application launches ok, but when it comes to running the report, it prompts for a database logon box for the odbc connection.
When the report is run seperate on its own, on the exact same pc through crystal reports desginer it runs fine, Its almost like the application is not picking the 32-bit ODBC set up is it the case that the connection needs to be coded rather than using the report connection,
Delete Data That Have Same Id In Many Table Using VB ODBC? I try this but it think it doesnt work[code]...
View 3 RepliesI m making my semester project on hotel room reservation i want to get all records from ms acess in data grid.
View 5 RepliesI have an old VB6 program which copies data from a legacy system (Btrieve 6) into our SQL Server so it can be served up on the web and used to feed some of our other needs. The legacy system outputs a file and a feed program posts it into the legacy ODBC database. The program isn't anywhere near realtime and I am now finding the delay between data going into the legacy database and then into the SQL database is becoming unacceptable so I thought I'd look at VB.NET and see if I could find a better way of doing it using FileSystemWatcher so that when the legacy output file is renamed I can then start a copy of the record affected from the legacy to the new database.
[Code]...
I've downloaded the ODBC driver and the MySQL driver and installed them on my system (Win XP SP3). However, the only data sources that are showing up when I try to add a data connection are Access & 2 SQL Server objects. Is there something else that needs to be setup in order for Visual Studio to allow additional data sources? I'm currently running VS 2010 Express.
View 1 RepliesI think, although I am not sure, that my problem may stem from the fact that I am trying to do something with a DB2 Packed Decimal Field.If I use MS SQL to import data from an iSeries file I can do something like this Select a, b, c, sum(d) from a file where (criteria here) group by a, b, c Note: field d is a packed decimal field.
In VB using an ODBC connection I can do this: select a, b, c, d from a file where (criteria here)but when I try to do this Select a, b, c, sum(d) from a file where (criteria here) group by a, b, c I am getting an error: -2147467259 (80004005).
I want to do this using VB in Excel because I want the user to be able to input data on the spreadsheet that defines some of the selection criteria.
I'm using the Microsoft Excel Driver to import an Excel document into a adodb.recordset so that I can remove duplicate rows and put it into the SQL Server database.
The first column has values like 192, 13U, JJJ, etc. but for some reason the query casts it as a double value, and any rows with alpha values get converted to Null. From what I can tell this is because the Majority type is numeric instead of text.
I tried casting it, but got an error.
Here's my function:
Function Read_Excel(ByVal sFile As String) As ADODB.Recordset
On Error GoTo fix_err
Dim rs As ADODB.Recordset
[Code]....
I need code for opening DB connection using an ODBC data source. then I need to get some data from there to a data set.
View 7 RepliesI need to connect to an MySQL database in my VB.NET application (VB 2010 Express). When I attempt to use the Data Sources wizard to establish the connection, it does not provide an ODBC data source. I'm using Add New Data Source/Database/DataSet/New Connection which shows the Add Connection dialog. The only options it gives me for data sources are Access & SQL Server and the OLEDB data provider. It does not appear to give me the option of adding a new data source provider. Attached is an image of my current Change Data Source dialog. Where do I get the ODBC data source provider and how do I install it into Visual Studio?
View 3 RepliesI used the ODBC Data Sources admin panel to create a "data source" for an ".mdb" file. This was very easy. I can access the mdb (database) file via an ODBC driver, locally. However I need to access this data source over the network. Can anyone please help me learn how to make this same database available on the host's network interface? Perhaps there is a tutorial, video, or some other documentation that explains how to modify a data source to make it available on the network. I am using Windows XP. I hope this does not require a special Windows server distribution.
View 11 RepliesI have Informix Dynamic Server 11.50 and Informix Client SDK 3.5 installed on my server. I am developing a .NET application to read data from Informix database using ODBC functions. In the database, i have a table with columns of Serial and BigInt data types defined. My data retrieve function looks like this [Code]
I've tried to modify the columns with Serial and BigInt data types to Integer. And, everything works fine without modifying a single line of code. I do need some advice how to overcome this problem as i need the Serial data type column as an incrementing id column. For BigInt data type column, may be we can change it to column with Integer data type instead.
I have VB Application and VB dll. I am retrieving the data using MS ODBC and through VB application and passing it to VB dll. Dll is then processing the data and inserting the data into Oracle 10g database. Dll uses OraOledb driver. Now when i retrieve the data in my web-page which uses MS ODBC, it displays the data as garbled.
View 10 RepliesI have an Access table in which I connect through ODBC commands. I want to delete the 50% of data rows from it. Can anyone knows a string to write for doing that? ALARMLOG is my table. In MS SQL I tryed succesfully the following command :
[Code]...
I have tried everything.but im not able to insert updat and delete the excel file..im able to connect the excel sheet.the connection also seems to be opened...here s my connection string:
Dim sConnectionString As String
Const kunal = "C:"
sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
[code].....
I have an error "ERROR [22018] [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression". I am using VBdotNet2005 and MS Access as its database, and I can't really get the hang of this error.
View 8 RepliesHow do i call ODBC Data Source Administrator form of Control Panel and get the selected DSN and its contents
View 3 RepliesI downloaded vb 2008 Express edition and i was going to make a software... But when i try to link it with my Access Database (db.mdb) using ODBC i couldnt find ODBC under data sources.[code]...
View 5 RepliesI work with VB.NET (Windows Forms) and database in AS400 iSeries. I wont to make an Update in one table. I have this code:
[Code]...
I have a VB.net application that gets data off our server with ODBC and populates and saves a Word Document. When I try to deploy it to another computer it will get the data just fine and populate the first document, but it will crash before saving it. I've installed the .net framework 4.0, Microsoft Data Access Components, and the Microsoft ODBC .net data Provider. The error code is 0xC0000005, which is from what I can see is called an "Access Violation Exception." It works fine on my computer.
View 3 RepliesI have an error ERROR [22018] [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. and I've been trying to solve this but unfortunately I couldn't get the hack of this error. I'm a newbie in dotNet.
Public Sub LogInContinue(ByVal senter As Object, ByVal e As EventArgs)
Dim LibDS As DataSet = New DataSet
Dim LibDA As OdbcDataAdapter = New OdbcDataAdapter("SELECT * FROM tblUserAccount WHERE Uname='" & txtUserName.Text & "'", LibConn)
[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'm currently doing a project that includes access 2010 My question will be what driver can I use for an access 2010 *.accdb type file? For a *.mdb it works perfectly well with
ConnString ="Driver={Microsoft Access Driver (*.mdb)};Dbq=" & Application.StartupPath & "\CITSDB.mdb;Uid=Admin;Pwd=123;"
But, when I changed the mbd to accdb:
ConnString ="Driver={Microsoft Access Driver (*.accdb)};Dbq=" & Application.StartupPath & "\CITSDB.accdb;Uid=Admin;Pwd=123;"
It resulted in errors:
ERROR[HY000][Microsoft][ODBC Microsoft Access Driver]Could not find file '(unknown)'.
ERROR[IM006][Microsoft][ODBC Driver Manager]SQLSetConnetAttr failed
ERROR[HY000][Microsoft][ODBC Microsoft Access Driver]Could not find file '(unknown)'
And then it shows me that my code for
If dsLogin.Tables(0).Rows.Count = 1 Then
IndexOutOfRangeException was unhandled
Cannot find table 0
I knew it must be the driver but I don't know what accdb driver I can use for the connstring.
when i try to insert data from database into dataset using data adapter, it takes long time, i want to use hourglass but i'm confused how or when i type the code so user will know that application still work.
View 1 Repliesi am trying to join 2 tables together and display them in a list view. i have this code so far
[Code]....
I have a windows form program that pulls data from a sql server. That same data is being read from a ASP.NET website that sets properties for the site. The SQL server has 3 tables: tblWebPage, tblObjects, tblProperties. and 6 views for the 6 web page: vWebPage01, vWebPage02, vWebPage03..ect. When the program loads you see buttons for each web page on the site. When the user clicks on the Home Page it loads this data: [code]Now, the problem lies in updating vWebPage02, vWebPage03, ect.. I assume with the same data I can copy my form with the code and change the form name and the data set to build and update. So that's just what I did changed the form name where needed and changed "vWebPage01" to "vWebPage02".When I tested the program My "vWebPage01" form it built and updated no problem. when I went to test "vWebPage02" it built the dataset and table adapter fine but it did not update at all.
View 1 RepliesI am getting the following ODBC exception when I moved my development platform from Windows XP X86 to Windows 7 X64: ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application What I'm sure it means is that the server it is connecting to is 32 bit, and the computer I'm running on is 64 bit and the ODBC driver in use is 64 bit.
The application I am writing is set to run in 32 bit mode because some of the third-party software that we employ is not 64 bit compatible. I tried downloading a 32 bit driver and changing the DSN but it did not fix my issue. I still get the exception. If anyone has any links for 32 bit SQL drivers, or how I could fix this by changing the project around, I'm all ears.