I have a SQL CE database (SDF) that I tried to edit with Database.net v3, but it is now not opening in Visual Basic Express 2010.[code]I've installed SQL Server Compact 4.0 ENU CTP1, but it is still not working.Is there any way to revert the version back? Or anything else I can do to fix this error?
View 4 RepliesI am trying to add a new record to a table, well first it checks if there is already a duplicate record in the table, and if not it makes one. If there is a duplicate, it tells the user.[code]
View 2 RepliesWith XP set to a language such as Spanish (Spain), the VBA-in-Excel function "Excel.Version" returns the text string "11.0" (not "11,1"). It does not respect the language setting.
"CLng(Excel.Version)" then produces the value "110" (wrong!), perhaps because CLng respects the language setting and is looking for a comma instead of a period.
The work-around is easy. But I need to know if switching to another language requires a setting that my client in Spain missed, or is this just a bug.
If it is a bug, is the problem limited to this one function (Excel.Version), or are there other functions that return values in text format that are affected?
I have used Access databases before so thought I'd try something different. My problem is that when I try to add a new record to one of the tables in the databasethe code runs through fine, but the data is not added into the table :S have probably missed something simple, but it's been a while since I did any projects using a database.Here's my code:
Imports System.Data.SqlServerCe
Public Class Form1
Dim con As SqlCeConnection = New SqlCeConnection("Data Source=C:UsersMattDocumentsVisual
[code].....
I am having some issues with an application written in VB.net.
As part of a routine, an sqlce database gets backed up before the routine then if an error occurred gets restored. I am using system.io methods copy and delete.
I have released all the objects (connections, commands, datareaders) asscociated with the sqlce database by disposing them if they are not nothing. I also do a GC.COLLECT however when my delete command runs, an error message says it is open by another process. The PROCEXP.exe process explorer tool says it is attached to 4 undefined processes. After a while in debug mode, these clear and I am able to delete the file. However this is not acceptable as my program cannot "wait around" until they are released! I was under the impression that object.dispose forced an immediate disposal rather than waiting for the garbage collector to clean up (if you were just to use object=nothing), but still there appears to be a finite time before these objects are released.
My question is, is there an alternative way of checking (programatically in vb) for what is holding open an sqlce database (or in fact any other file for that matter) then killing these processes?
I'm about to pull my hair out on this guys I do not know where I'm going wrong but basically I receive a web request response formatted in XML and I need to insert that data into an SQLCE database. I have tried using LINQ queries but there are no matching ID fields to Join or Group.
View 3 RepliesI want to access the Windows mobile SQLCE database from the desktop application when device is connected to my PC.
View 1 RepliesI've been messing around trying to get an INSERT statement to work, and because of this, it has created lots of records in my database that I dont need or want.
The problem is, when I open up the table by right clicking on it in the database explorer and selecting "Show table data", I click on the record I want to delete and the following error comes up in a message box[code]...
I recently upgraded the MS SQL Server installed on my personal computer from 2005 Express to 2008 Express. Problem is when I try to add an SQL database file to a project using VS 2005 I get an error message saying that the version of my database server is not supported, I must have SQL Server 2005 Beta 2 or later installed. I didn't do it yet but I'm pretty sure that when I open the other projects that I included a database file to it, I'm going to get the same error.
My question is it possible to have two SQL Servers installed on my machine? If so, is it a good idea to have two DB servers in the same machine?
Getting some errors with a loop. It's a log-in app that has username, passwords & account type stored in a SqlCe database. I would like it to sync with a larger database for updates that has not been made so i left it out but I have started to make a loop that would connect it to the larger DB and if connection failed would try a set number of times before stopping the program. I'm coding this project with Visual Studio 08 pro
Dim conndb As New SqlCeConnection("Data Source = |DataDirectory|\Mydb.sdf")
Dim x, y, z As Double
x = 1
y = x + 1
z = 5
[CODE]...
I'm designing a PC-based app that has a little local database. I'm using VB.NET with SQL Server Compact Edition. The user will only ever have access to one database file, because it's all about storing a user specific data. However I'm thinking of the situation where there could be multiple users that access the PC, each with their own Windows account. So ideally I'd need separate database files for each User.
I'm not sure how to implement this. I was hoping to deploy the 'empty' database as a ClickOnce deployment, but I can't see how I can have a database per user doing this. Also I'm not sure where to store the database files anyway. perhaps in MyDocuments for each user? Or perhaps I need to stick to just one database, but add a 'User' column into every table, so it can hold data for every user. I didn't want to do this though - because I wanted to keep the nice separation between the data offered by physically separate files.
"Error # 5 was generated by Microsoft JET Database Engine" regarding databases created with earlier versions of Microsoft Jet. This is nice and true, for instance the function using GetOleDbSchemaTable creates the error.(schemaTable = cn.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, New Object() {Nothing, Nothing, tblname, Nothing}) )
But how can we find out which version was used? In VB 6 we could get the database version using Set db = OpenDbRead(Dbase)Version = db.Version db.Close And we could get the Engine version through: DBEngine.Version But in VB.Net, can that be done? How?And then hopefully the problem can be solved via the .CompactDatabase function.
3. DB2, located on a shared network drive, contains nothing more than the structure of DB1, but which I have updated to include new fields in various tables, as well as some new queries and modules.4. I need to be able to copy whatever new table structure there is, etc, without overwriting the user's existing data.
View 3 RepliesHow they relate and differ from each? What are the best practices for version control? Is there a primer about publish online? Or a good book?
And is it possible to make ClickOnce and a msi in one solution of VS 2008? If so, is there any conflict or pitfall?
BTW I am using VB if that makes any difference.
I have code on log in form but it only get the latest data on username and password column on my database
Here is my code
Public Class Users
Dim MyLogIn As New myRecords
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles
[CODE]...
This is my connection:
Imports MySql.Data
Imports MySql.Data.MySqlClient
Module myconnect
[CODE]...
This is my record:
Imports System
Imports System.Data
Imports MySql.Data
Imports MySql.Data.MySqlClient
[CODE]...
I want to move my programs and the database to another computer and hard-disks. It looks to me as though I nearly have to re-create the controls and rewrite some of the code to make it so the programs still work after the move. At least with ODBC all I would change was the DSN definitions external to the programs. Is there an easy way to move or rename a database without loads of work?
View 3 RepliesThis program is very difficult for me, but I must get threw it or I cannot finish... What I am doing is making a Database of foreign Languages with the spelling of the words and the pronounciation inside the database... The USER enters a paragraph of words into the translator textbox and pushed translate. The program has a DATABANK of words with the phonetic spellings and matches the word, then translates to phonetics. The problem is that new words keep appearing inside the language. So I incorporated a Database of 2 fields
[Code]...
When I am developing an application and I use the 'Data Source' tab to create a database, will that database be automatically created when I use the software on another machine?
View 1 RepliesI'm trying to use LINQ to SQL in Visual Basic 2010 Express.
It allows me to create the .dbml file, but in order to drag items from the Database Explorer window to the design surface, I first have to get my database listed in the Database Explorer!(this is a remote SQL Server database - not a local .mdf)
I already have a good, working connection string to the remote SQL Server database, but that doesn't help me when I'm trying to generate the DBML at design time.
Can anyone tell me how to get my remote SQL Server database identified in the Database Explorere window? When I try the "Add Connection", I am limited to Access, SQL Server Compact, or SQL Server Database File. If I try to enter the IP address & port of my DB Host I get a 'database file does not exist' message. Doesn't seem to want to let me point to a remote DB server...
In vb.net I am using password protected database with following connection stringconnetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:vaivaiDB.mdb;JetOLEDB:Database Password=secret;"Database access works fine on the development machine.
View 2 RepliesWhen I install my application, some forms are unable to connect to the database.
I say some because, when my login form works totally fine. Authentication happens.
But once I go into the main application, and open other windows, I start to get these error mesages:
[URL]
Friends I have Developed my Data base Project on vb6, using adodc and datagrid using ms access database file, it was working nice in vb6, I also put Search box there and used adodc1.recordsource="select * from table" sql query.
later i needed to convert it in vb.net I converted it, every thing is working fine, but one problem appears, an adodc's Recordsource query for searching records is not working, it only works if there is data in dataset (Datagrid),suppose once i pressed search button to search record and if no record found then dataset / datagrid becomes empty, now i wanted to search an other record with other name, but this time it does not work and following error appears Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
[Code]...
I am sitting with a situation that I have to combined (3 years) for 26 site of 29000 database files where there is 1 table in each data base called RECDATA, I need to combined all that data Into one database file called RECDATA.
For example there is a database called DB1 with a REDATA table inside it, and then DB2 with a RECDATA table inside it, DB3 with a RECDATA table inside it est. So I need to put all the Recdata into 1 Database file, or to copy all the RECDATA from all the database files to 1 RECDATA they all have the same columns All I need is to get all that data into 1 RECDATA table.
The program where this database comes from is a voicerecording system creating a new database every day. There is 1 database just for indexing (to view the recordings) and then the daily database is where the recording lies in, that Colum is called RECFILE. I will give you a example of the 2 database.
I have a report made in Crystal Reports XI. The report is generated and exported to PDF in visual basic script using COM interface. Generally everything is running smoothly, but in one case generation breaks with error: Failed to retrieve data from the database. Details: [Database Vendor Code 9421]
Database used is MSSQL 2005 connected over ODBC to CR XI. When I am opening report with exactly the same parameters in Designer, everything works fine.It looks like it is data related, but it is hard to trace since the whole report is pretty sophisticated. Anyway I spent half a day on crawling over Dr. Google and it seems that he has no clue what might be an issue.
I have VS 2005 installed in my sytem fyi.We have two databases, say source database and destination database. The databases is in Oracle. Now we need to pull data from Source database, manipulate it and push it into the destination database on daily basis.We are planning to use VB .Net for this and would like to know if this is feasible. Using windows forms through VB .NET, is it possible to create a exe and schedule the exe on nightly basis to pull the data from source to destination.how to do this as for manipulation of data, there is no intermediate database for us?
View 1 Repliesi need to make a database application that can write/retrieve cells/datasets from/to a database i buyed a book in there was an example of how to create a database application while debugging i had the "Object reference not set to an instance of an object." error and it highlighted this code
objDataRow = objDataSet.Tables("KlantenTable").NewRow
now the problem is here i declare something later in the code i write to it
objDataSet.Tables("KlantenDataTable").Rows.Add(objDataRow)
[Code]....
can anyone teach me how to save data in microsoft access database and retrieving it back from database?[code]so, how do i save it in that and how do i load their data by typing their ic no only..
View 5 RepliesI have created an access database which i want to search with vb.net, I tried a few thing but it didnt work as desired.
Firstly the program is suppose to display items in the database base on the criteria selected by the user. what i've succefssfully done so far is I've added a datagrid 2 combobox, 1 (searchcbo) with the columns in the database and the other (searchcbo1) will autoload the items under the column selected in and a button (searchbtn) but i have no clue of the code to put in the button. i also tried the fill method but that didnt work as i wanted to. ultimately i want a combobox with the list of columns and a textbox to enter criteria and of course a search button.
The searchbtn should act as the "WHERE" sql command, e.g. SELECT EmployeeNumber, Firstname, LastName, Phone, Location....etc FROM CallLog WHERE searchcbo.text = searchcbo1.text And display the results in the datagrid.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'CallLogDataSet.CallLog' table. You can move, or remove it, as needed.
Me.CallLogTableAdapter.Fill(Me.CallLogDataSet.CallLog)
[CODE]....................
Attached image(s)
Ive created one database Sql Server Compact Edition 2005, with one table ("Cliente") I know that I can created my database good, but i have a problem saving information since three textbox, in my table(With columns "Nombre" "Apellido" "Cliente". In my form there is a button save ("Guardar"). When I do click in my button appear the next message : "The column cannot contain null values. [ Column name = Nombre,Table name = Cliente ] " and happen the same with apellido and Id_Cliente. And this happen becouse my code cant save the information....
This is the code
Option Explicit On
Option Strict On
Imports System
Imports System.IO
Imports System.Data
[CODE]...
And the code for my button is:
Private Sub cmdguardar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdguardar.Click
Dim myconnection As SqlCeConnection
Dim mycommand As SqlCeCommand
[CODE]...
I did the following
Imports System.Data
Imports System.data.OleDb
Public Class Form1
Dim con As OleDb[code].....
By this i can fetch only one row(the last row) of the access....how to modify the above code to fetch all the rows starting from the begining from the database..........