Database On FTP Server?
Mar 10, 2010In one of my programs I have a MS Access database that i want to change so i can access it from a FTP server. however i have read that that's not possible.
View 14 Replies
ADVERTISEMENT
Host Site With ASPNETDB.MDF Database From Development Server To Production Server?
Jan 21, 2011I have created my site using ASP.NET Personal Starter Kits 3.5. I use Visual Studio 2008 only . .with its built-in SQL Server (2005 Express) ... my database in App_Data is ASPNETDB.MDF ...I have created some of my tables also ....in ASPNETDB ..In my local PC the site was running fine ...But when I publish my site on production server it doesn't work and shows the following error
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
[code].....
Switch Network SQL Server 2008 R2 Database To A Mobile SQL Server CE *.sdf File
Nov 2, 2011I have developed a VB.NET program using a strongly typed dataset. This dataset has its connection to a SQL Server 2008 R2. The software should now be additionally used offline. The database should be exported to a *.sdf database. If no connection to the SQL server is produced, the software have to try to connect to the *.sdf database.I would like to achieve:
1. Export the data in the SQL Server 2008 R2 database to a local *.sdf file.
2. This *.sdf file has to work as an alternate connection string in the strongly typed dataset.
Careful Steps To Connect To A SQL Server 2005 Database On Server
Dec 7, 2010How can I write a connection string? I has four different computer that can be connect via ethernet.How can I maintain a inserting data if to computer insert on same table at a single time..??
View 1 RepliesConnection To MS SQL Server 2005 Database (using Server.MapPath)
Feb 29, 2012I am tring to make the below application work with SQL Server 2005 Database Currently it works for test.mdb, which is in the same folder with the application. How shoud I modify the MapPath to work with SQL Server.
[Code]...
Insert Data To A SQL Server Compact Database Sql Server Mdf?
Feb 28, 2010i have a app in visual basic mobile 2008, so i finish but now i need to tranfer the data generate in the in the app mobile to data base in sql server 2008.
View 1 RepliesAdd An SQL Database File Using VS 2005 Getting Error Message Saying Version Of Database Server Not Supported?
May 18, 2009I 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?
Database Sql Server Compact Edition 2005 - Save In A Database - Column Cannot Contain Null Values
Oct 15, 2009Ive 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]...
Incrementally Backup MS SQL Server 2005 Database By Program That Uses The Database Also
Oct 19, 2009before re-inventing the wheel, i want to ask you how i can do this best: I have a VB.Net application that uses a database connection to MS SQL Server 2005 (express version). There are users that input data with the application into the database lets say once to 2x an hour to once a minute. I want to do backups like this: Once a day or once a week (in the evening) a full backup, and whenever the program/user is idle for lets say 10 Minutes, i want to do an incremental backup (so that it does not take so long until he can work on after the backup).
There are no big security issues, just copying the backup data files to a network share / a different computer or server would be fine. i guess the average db size may be 300MB, but the daily increments about 1MB.
[Code]...
Sql Server - Convert A SQL Database To A DBF Database Without Provider Using Text File?
Jun 8, 2011I work with vb.net I have a sqlServer database and i need to migrate to a DBF database.I know that a dbf file sctructure is a hexadecimal text file.I want to generate this file without a provider...building this file with this hexadecimal structure.
View 1 RepliesUsing SQL Server As May Database And Developing That Database In Visual Studio 2008?
Apr 22, 2009I have a problem here... I'm using SQL Server as may database and developing that database in Visual Studio 2008.my problen is, when I use the STORED PROCEDURE from SQL SERVER it doesn't update/save new data on a the table. here's my coding; This is my stores procedure: when I execute this on on SQL SERVER it worked perfectly.
[Code]...
Make A Copy Of Sql Server Database - Get Error "Unable To Connect To Source Server For Transfer"?
Feb 18, 2011I am trying to make a copy of an existing database, I use .net framework data provider for SQL Server.I get error "Unable to connect to source server for Transfer" when it runs to oPackage.Execute().
oConnection = oPackage.Connections.New("what the providerID should be?")
oStep = oPackage.Steps.New
oTask = oPackage.Tasks.New("DTSTransferObjectsTask")[code]......
Database (access Database) Should Be Stored On A Web Based Server?
Aug 10, 2010I have developed some software(vb.net) that records fees paid by the students. The purpose is that the database should be stored in a server, which can be accessed from any stations linked with it.This is working fine with a network of 10 computers. I need to publish it over the net so people could do this job logging in over internet. Database (access database) should be stored on a web based server.
View 1 RepliesSql Server - Dump Data From One Database Table To The Other Database?
Mar 18, 2011I have to write a code in vb.net (2010).To get a data from Database A table 1 and dump it to Database B Table 2.What's the best way to do this? Most efficient way? I know I can do this very easily in sql management studio but I need to write a code to do this in vb.net.
View 2 RepliesCreate A SQL Server Database Using Database Explorer?
Nov 18, 2009My question is does Visual Basic 2008 Express Edition provide a way for you to create a SQL Server 2008 Database using the Database Explorer ?
View 2 RepliesMigrate From Access Database To SQL Server Database?
Nov 10, 2010I am trying to migrate from Access Database to SQL server database. Do I need to make changes (for saving, reading, deleting etc. data) to my code as well?
I understand I need to change connection but what about code?
Connect Different VB Applications To A Database Server.like Accessing Data From One Database By Different Applications?
Aug 15, 2011how to connect different vb applications to a database server.like accessing data from one database by different applications...
View 4 RepliesPopulate Local Database Table With Remote Server Database Table ?
Aug 11, 2012I am having a remote server it has INVENTORY DATABSE , and also iam having same databse in my local system. I want to populate by local database table with my Remote database table through Vb.net code by click a button. How to do this .
View 1 RepliesAdd Data In Database Sql Server?
Jan 14, 2011[code]...
This codes are working but how can I validate the username if it is already in the database?[code]...
Add The Database To SQL Server Instance?
Oct 18, 2010I am adding a datasource to a form.I have add the database to my SQL Server instance.
From the wizard i have succed to connect to the database
The test is OK
But at the last step to save the connexion this is the error message i am receiving an unexpected error has occured :
[Code]....
I thought because i did not yet build the solution. I did it but the same error message remains.
Attaching Database To SQL Server?
Jan 13, 2011I already made a .VB project using MVS 2010,I'm new in attaching database to SQL server and I'm confused attaching which database I'm going to attach because in the same folder i found that there's two
View 2 RepliesBackup Database SQL SERVER?
Apr 16, 2008"How to backup database SQL SERVER from VB NET?"
View 9 RepliesCan't Add Images Into SQL Server Database
Jun 21, 2010I want to save image from Picture box to SQL Server DB. I am trying to do this using the following code but cannot able to do so.[code]...
View 3 RepliesConnect To Database Server?
May 13, 2009my friend tell me .they use file.txt,file.ini,file.xml and registry for save connectionstring for connect to database and what do you use save connectionstring.
View 6 RepliesDeploy SQL Server Database?
May 22, 2012Does anybody know how to deploy SQL server database using VBnet.(When you install application on user computer, application should be setled to use database, How?)
View 1 RepliesDisconnect From A Database Server?
May 24, 2012I Have created an application with MySQL as database server.everything goes fine.When i tested the application on multiple system at a time.When i monitored the database server (MySQL) I saw huge number of connection to the database. and all are in sleep mode.I used below code for connecting and closing connection after every query.
'Connection variable declaration
Public conn As New MySqlConnection
'Connection Opening command[code]....
But i see huge number of connections in sleep mode at database server.
Excel To SQL Server Database Using .NET?
Aug 24, 2009I have created a database to house a lot of data. I have created a front end application to allow the users to enter the data and it gets checked and then written to the database. The problem I am having is the users have a lot of data that has been kept in Excel sheets and they are wanting to import the data to the database without having to reenter all the data. I have been reading through the different posts trying to find one that will fit my needs and haven't been able to. The old way of putting the data into Excel has now been turned into a few different tables in the database. The database is created off a national standard so it can't be changed. What I am needing to know is how to take data from these Excel sheets and import either into my application and then find a way to covert the data over to where it can go into all the tables that need it or to create something that will write the data directly to the database into the different tables. I am not sure if this is possible but thought this would be the best place to ask the questions.
View 10 RepliesExcel To SQL Server Database?
Aug 29, 2011I have created a database to house a lot of data. I have created a front end application to allow the users to enter the data and it gets checked and then written to the database. The problem I am having is the users have a lot of data that has been kept in Excel sheets and they are wanting to import the data to the database without having to reenter all the data.I have been reading through the different posts trying to find one that will fit my needs and haven't been able to. The old way of putting the data into Excel has now been turned into a few different tables in the database. The database is created off a national standard so it can't be changed. What I am needing to know is how to take data from these Excel sheets and import either into my application and then find a way to covert the data over to where it can go into all the tables that need it or to create something that will write the data directly to the database into the different tables.
View 2 RepliesHow To Access Sql Server Database Through LAN
Aug 8, 2010How to access sql server database through LAN? I ask this for my client server progrmming because im a beginner.
View 1 RepliesManipulate Sql Server Database
Mar 10, 2010Do you know of any beginner tutorial on how to manipulate(Add, Edit, Delete, Search, List) sql Server database in vb.net?
View 2 Replies