Hi group, I'm trying to store the information from a various textboxes into my database. However it is not writing the data (I'm getting my planned error message, "New Record FAILED. Please contact your systems administrator." From the code below, do you see where my error may be? What corrections do I need to make to ensure a successful insert? Dim con As New SqlClient.SqlConnection con.ConnectionString = ("Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\Don\Documents\Visual Studio 2019\SalesForm\DWHRPT.mdf;Integrated Security=True") con.Open() Dim com As New SqlClient.SqlCommand("", con) com.CommandText = "INSERT INTO CUSTREC (CUST_ACCT_NO, CUST_COMPANY_NAME, CUST_LOCATION, CUST_TYPE, CUST_FIRST_NAME, CUST_MIDDLE_INITIAL, CUST_LAST_NAME, CUST_MAIL_ADDRESS1, CUST_MAIL_ADDRESS2, CUST_MAIL_CITY, CUST_MAIL_STATE, CUST_MAIL_ZIP_CODE, CUST_MAIL_ZIP_PLUS4, CUST_CREDIT_LIMIT, CUST_PRIMARY_PHONE, CUST_ALT_PHONE, …

Member Avatar
Member Avatar
+0 forum 4

I'm looking more and more about answer for my question. When I open mysql query browser first time, there is place that we can create new mysql connection. I want to create connection like this. In the 4 computers connected to a LAN network. I name these computers A,B,C,D for easy identiting on this example. Think A is the only mysql installed computer and database server. For other computers I installed program wich I made with vb.net 2012. From that B,C,D computers When I entering data, I want to save those data to sql installed computer. I have 2 question …

Member Avatar
Member Avatar
+0 forum 1

1. Form created in VB2008 3 Textbox [Name(string), Company(string), Contact(number)] 3 Buttons [New Record, Update Record, Delete Record] 2. Database created in MS Access 2003 File Name: Contact.mbd Fields: ID [Primary key] Name [Text] Company [Text] Contact [Number] How to Create Connection? How to get data on form load from database in textboxes? How to insert, update, delete data? Please provide information as I am not able to get any simplest way to understand these questions.

Member Avatar
Member Avatar
+0 forum 9

Hello everyone! I am posting this code for anyone who may be having issues with connecting to a database. Feel free to use this code as you wish. This will be using the OLEDB library. [CODE] 'Imports Imports System.Data.OleDb Public Class Form1 'Declarations Dim con As OleDbConnection Dim cmd As OleDbCommand Dim sqls As String Dim sqlcmd As String Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load 'In form_load event, but can be used on button click. 'For hard coded connection string sqls = "Provider=SQLOLEDB;Datasource=YOURSERVERNAMEHERE;" & _ "Initial Catalog=YOURDATABASENAMEHERE;Integrated Security=SSPI" 'For dynamic connection string sqls = "Provider=SQLOLEDB;Datasource=" & …

Member Avatar
Member Avatar
+2 forum 5

Hey everyone, Does anyone know if there is a possible way of using an online Database without uploading the website files onto the server? Cheers,

Member Avatar
Member Avatar
+0 forum 3

please find the attached file and see the output. And help me out please this code getting system current date and function. but my requirement is get date from database like the clock want to spin. Please help me out to fix the error d3.js [CODE] (function(){if (!Date.now) Date.now = function() { return +new Date; }; try { document.createElement("div").style.setProperty("opacity", 0, ""); } catch (error) { var d3_style_prototype = CSSStyleDeclaration.prototype, d3_style_setProperty = d3_style_prototype.setProperty; d3_style_prototype.setProperty = function(name, value, priority) { alert(name); alert(value); alert(priority); d3_style_setProperty.call(this, name, value + "", priority); }; } d3 = {version: "2.7.1"}; // semver var d3_array = d3_arraySlice; // …

Member Avatar
+0 forum 0

Hello, Am new to php and I have a question that is probably very easy. I have been watching tutorials online to learn how to work with databases, but none of them speak on how to upload to server. This is my problem: am using vertrigoserv but specifically using PHPMyAdmin in it. After I create my database, users, etc...how do I know upload those settings to my actual www server (instead of localhost)? I don't know if am clarifying myself but I hope someone out there will understand me. Everything am working on is locally on my machine...besides knowing how …

Member Avatar
Member Avatar
+0 forum 2

Dear Friends, I'm Currently using php session ( $_SESSION[''] ), I want to use $_COOKIE Because when a user didn't click the logout button and he closed the website. still he is showing Online because i write the code at the logout page. So If we use $_COOKIE it is update the database ? Please help me

Member Avatar
Member Avatar
+0 forum 2

I had created a registration page for users to sign up an account and a database to store all information such as username and password. I had also created a login page for users to login after registering an account. How do I link the database so that I will know that the particular user had keyed the correct password. protected void Button1_Click(object sender, EventArgs e) { string username = TextBox1.Text; string password = TextBox2.Text; SqlConnection connection = null; SqlCommand command = null; SqlDataReader dataReader = null; try { string connectionString = ConfigurationManager.ConnectionStrings["TestConnectionString"].ConnectionString; connection = new SqlConnection(connectionString); connection.Open(); //prepare sql …

Member Avatar
Member Avatar
+0 forum 2

All, I can't seem to find anything on the web about how to connect to a LibreOffice database. I am currently using the following code to connect to a MS Access database and would like to know how to change it to work with LibreOffice. [CODE]String strConnect = "jdbc:odbc:DRIVER=Microsoft Access Driver (*.mdb, *.accdb);DBQ=C:\\db\\myDatabase.mdb;"; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection(strConnect, "",""); if (null == con) { System.out.println("Unable to connect to data source " + strConnect); return; } System.out.println("Successfully connected to database. Data source name:\n" + con.getMetaData().getURL() + "\n");[/CODE] Thanks, Bill

Member Avatar
Member Avatar
+0 forum 5

Hi all I am currently working on a project for tech (university). It's a login form that uses a CAPTCHA as validation and must monitor the IP address of the computer that has currently requested the form. The IP monitoring part is so that if a user has made x (let's say 5) wrong attempts, they must be blocked temporarily. The captcha works (few glitches here and there), the IP tracker works too. What I've thought to do is to store the IP addresses in a database along with a primary key to identify each address, then use that primary …

Member Avatar
Member Avatar
+0 forum 2

The following code is a part of my project and the output of this code is that i get all the title of the posts in the database and a delete hyperlink in front of all enteries now when i click delete for a respective title it should be deleted from jsp page how to write code for this? For better understanding i have attached a screen shot also. [CODE] <label><h3> Post published: </h3></label> <% rs = stmt.executeQuery("select title from Postdata"); %> <table id="rounded-corner" summary="all posts"> <thead> <tr> </tr> </thead> <tfoot> </tfoot> <tbody> <% while (rs.next()) {%> <tr> <td> <%=rs.getString(1)%> …

Member Avatar
Member Avatar
+0 forum 1

Hi, i am trying to connect to a database(mysql), is this way right ? I have added[CODE]using MySql.Data.MySqlClient;[/CODE] I am getting a error on [CODE]Conni.Open();[/CODE], the error is saying: "Unable to connect to any of the specified MySQL hosts." Need help [CODE]string email = textBox1.Text; string password = textBox2.Text ; string password2 = textBox3.Text ; string fname = textBox4.Text; string lname = textBox5.Text; string CONFIG = "SERVER=localhost;" + "USERNAME=techozin;"+ "PASSWORD=waleed1984!;"+ "DATABASE=techozin_334900"; MySqlConnection Conni = new MySqlConnection(CONFIG); MySqlCommand Querry = new MySqlCommand(); Querry.Connection = Conni; Conni.Open(); Querry.CommandText = "INSERT INTO mbmemer(email, password, firstname, lastname) VALUE(@email, @password, @firstname, @lastname)"; Querry.Parameters.AddWithValue("@email", email); Querry.Parameters.AddWithValue("@password", …

Member Avatar
Member Avatar
+0 forum 1

Greetings! Hi guys, Im mike, i am new in using Sybase central using sql anywhere 9, i've got a big problem, on how am i to connect my Sybase database to Visual Basic 6.0. Guys.. i badly to want to know this, because i am new to my work. I hope you can help me Guys..:) Regards, Mike Pilapil

Member Avatar
Member Avatar
+0 forum 3

please tell me where am i wrong [CODE]try { OleDbCommand cmd = new OleDbCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "insert into purchase(pdate,bill id,ritem,suppname,smobno,qty,rate,amount,payment,balance) Values('" + dateTimePicker1.Text.ToString() + "','" + textBox15.Text.ToString() + "','" + textBox7.Text.ToString() + "','" + textBox12.Text.ToString() + "','" + comboBox2.Text.ToString() + "','" + textBox14.Text.ToString() + "','" + textBox13.Text.ToString() + "','" + textBox11.Text.ToString() + "','" + textBox8.Text.ToString() + "','" + textBox10.Text.ToString() + "')"; cmd.Connection = conn; conn.Open(); //MessageBox.Show("insert into purchase(pdate,bill id,ritem,suppname,smobno,qty,rate,amount,payment,balance) Values('" + // dateTimePicker1.Text + "','" + textBox15.Text + "','" + textBox7.Text + "','" + textBox12.Text + "','" + comboBox2.Text + "','" + textBox14.Text + "','" + textBox13.Text …

Member Avatar
Member Avatar
+0 forum 2

static void Main(string[] args) { string[,] fp = readFilePaths(); OleDbConnection con = new OleDbConnection(); OleDbDataAdapter da; DataSet ds = new DataSet(); con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/Documents and Settings/kyalanur/Desktop/Nav tool/PCGDataManager.mdb;User ID=;Password=;"; string sq = "SELECT * FROM History"; con.Open(); da = new OleDbDataAdapter(sq, con); da.Fill(ds, "History"); for (int i = 0; i < 284; i++) { if(true) { //Enter into the dtabase DataRow dr = ds.Tables["History"].NewRow(); dr[0] = DateTime.Today.Date.ToString(); dr[0] = fp[i,2]; dr[2] = generateFilePath(fp[i, 0], fp[i, 1]); dr[3] = " "; dr[4] = " "; dr[5] = fp[i, 3]; ds.Tables["History"].Rows.Add(dr); //OleDbCommandBuilder cb = new OleDbCommandBuilder(da); //da.UpdateCommand = cb.GetUpdateCommand(); da.Update(ds, "History"); } …

Member Avatar
Member Avatar
+0 forum 4

Hi Everyone, I have a BIG problem right now. I am currently learning ASP.NET to fulfil my job role, as an IT Manager. Although I have programming experience in other languages, I have never done ASP.NET before. I am currently working on a website called [url]www.packagepets.com[/url] . I recently uploaded the website to a web host, but there seems to be a problem with the website. I have been trying to sort this problem out for over a week now, and it could be something small but it could also be something big. I have contacted the new web host …

Member Avatar
Member Avatar
+0 forum 1

Hi everyone, I had designed an application with Java as front end and mysql as back end. The client application uses both local database as well as Remote mysql server's database for login and other retrievals. I don't know how to generalize the database connectivity code?, I need to access a remote database for more than couple of times,for each time I am creating a new connection(copy paste the same code) and just changing the query, my program size increases and retrievals take more time(>1min). [CODE] Connection connect1 = null; Statement statement1 = null; ResultSet rs1 = null; float available_qty; …

Member Avatar
Member Avatar
+0 forum 5

i am creating a midp 2.0 s40 mobile application s40 that will post some data in to a postgres sql server i have created a form with text boxes and selection list can some one please tell me a way how do i post an sql query i have the ip adress username and password for the server thanks in advance please reply

Member Avatar
+0 forum 0

[CODE]<div style="margin:0px 0px 0px 0px;" class="grid_16 example" align="center"> <asp:DataList ID="DataList1" runat="server" BorderStyle="Groove" CellPadding="5" CellSpacing="5" RepeatColumns="3" RepeatDirection="Horizontal"> <ItemTemplate> <ul> <li> <object id="player" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" name="player" width="328" height="200"> <param name="movie" value="vplayer/player.swf" /> <param name="allowfullscreen" value="true" /> <param name="allowscriptaccess" value="always" /> <%--<param name="flashvars" value="file=<%# Eval("vurl","video/swf/{0}") %>&image=<%# Eval("vpurl","video/thumb/{0}") %>" /> --%> <embed type="application/x-shockwave-flash" id="player2" name="player2" src="vplayer/player.swf" width="328" height="200" allowscriptaccess="always" allowfullscreen="true" flashvars="file=<%# Eval("vurl","video/swf/{0}") %>&image=<%# Eval("vpurl","video/thumb/{0}") %>" /> </object> <br /> <asp:Label ID="Label2" runat="server" Text=<%# Eval("vurl","{0}") %>></asp:Label> </li> <asp:Label ID="Label3" runat="server" Text=<%# Eval("uploadedby","Uploaded By:-{0}") %>></asp:Label> </ul> </ItemTemplate> </asp:DataList> </div>[/CODE] [B]VURL=K:\newweb457\newweb\Video\SWF\how.swf[/B] [B]vpurl=K:\newweb457\newweb\Video\Thumb\how.jpg[/B] Am i doing something wrong.The player is not playing video and neither it is displaying any …

Member Avatar
Member Avatar
+0 forum 4

Hi all, This is ridiculous they teach so much at uni except what you need to know to program :-/ haha. This is actually gonna be a 2 part question but I'll do it one at a time. So I'm developing a small program for a company, this company has a server that runs sql server, what do I have to do so that this program when run on any work computer connects to the server and is able to retrieve information? I have had a look around an it seems that for every computer on the network I have …

Member Avatar
Member Avatar
+0 forum 4

Hi, I'm doing the following code to connect to Access Db. The db1.mdb is placed in c:\db1.mdb. It giving me error "couldn't find file" [CODE]using System; using System.Collections.Generic; using System.Linq; using System.Text; using System; using System.Data.OleDb; namespace CustomerDB { class OleDbTest{ public static void Main() { //create the database connection OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:/db1.mdb"); //create the command object and store the sql query OleDbCommand aCommand = new OleDbCommand("select * from customer_test", aConnection); try { aConnection.Open(); //create the datareader object to connect to table OleDbDataReader aReader = aCommand.ExecuteReader(); Console.WriteLine("This is the returned data from customer_test table"); //Iterate throuth the …

Member Avatar
Member Avatar
+0 forum 4

Hi all, I have had a look around the forums but i could find anything, if someone could point me in the right direction for this. What is the best way to handle an sql connection, in my program I have to get data from the server on a button click now my question is is it better to recreate the connection on every click and perform the query ie create a new SqlConnection every time, or is it better to create the connection once when the program starts up and just open and close it every time the push …

Member Avatar
Member Avatar
+0 forum 3

I am using Oracle for the first time.I installed Oracle SQL*PLUS ver 8.As I had to learn this for an exam. But I am facing the following error after I enter it with the system default scott/tiger ... "ORA-12203: TNS:unable to connect to destination" Sorry ,if this question is already asked as I searched, but didnt get. Thanks in advance

Member Avatar
Member Avatar
+0 forum 10

Okay, So I'm currently working on my A2 computing project, and I am having slight difficulties updating and saving the data in my database when it is entered on a form in VB. I cannot find any reason why it wouldn't work, but if someone could suggest a better way to do it, it would be great as everything else works. It's in the btnsave at the bottom, and when you click the button on the form it come up with a very unuseful error, which is no help to anyone. Any help would be SO greatly appreciated! This is …

Member Avatar
Member Avatar
+0 forum 2

hi.. i'm having problem w/ my [COLOR="Red"]UPDATE SYNTAX [/COLOR] .. I CAN'T FIGURE OUT WHAT'S WRONG WITH MY SYNTAX.. PLEASE HELP ME.. I REALLY NEED TO FINISH THIS FOR MY DTR SYSTEM THESIS.. i can't move on to my other codes.. please... --the error that i get is.. UPDATE SYNTAX ERROR.. [CODE]Private Sub btnEdit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnEdit.Click i = MessageBox.Show("Are you sure you want to Update the record?", "Confirm Update", MessageBoxButtons.YesNo, MessageBoxIcon.Question) If i = MsgBoxResult.Yes Then constr = "UPDATE tblEmployee SET LastName='" & txtLName.Text _ & "',FirstName='" & txtFName.Text _ & "',MI='" & …

Member Avatar
Member Avatar
+0 forum 20

I create a simple data base table using Microfoft SQL Server 2005 and i want to display this simple table as a hole in my form.I use DataSet and DataAdapter to communicate with my SQL data base.i try to pull all the record at data base in to the DataSet by using the interface of DataAdapter,up to this i haven't any problem.My problem is to pull the record from the DataSet in to the Form or directly from the data base to a Form. this is my code [code] System.Data.SqlClient.SqlConnection con; DataSet ds; System.Data.SqlClient.SqlDataAdapter da; con = new System.Data.SqlClient.SqlConnection(); ds …

Member Avatar
Member Avatar
+0 forum 1

Hi, I am getting the error (End Of Statement Expected) for the following line: Please guide me on this issue. [U]Error Line: [/U] Dim MySQL As String = "INSERT INTO Contact Us (Name, Company) VALUES ('" & TextBox1.Text & "')" "('" & TextBox4.Text & "')" [U]Entire Code:[/U] [code] <script runat="server"> Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & Server.MapPath("sociomarker.mdb") & ";" Dim MySQL As String = "INSERT INTO Contact Us (Name, Company) VALUES ('" & TextBox1.Text & "')" "('" & TextBox4.Text & "')" Dim MyConn As New OleDbConnection(strConn) …

Member Avatar
Member Avatar
+0 forum 1

how do I link ADO data control with a protected access database ???

Member Avatar
+0 forum 0

I've been working on getting a SQL DB to return records through an ADODB.Connection object and have had zero luck getting it to work in VB6. Whereas I created an ASP form using VBS to produce the exact same functionality with no issues. In VB6, I've included the following references: Visual Basic for Applications -Visual Basic Runtime objects and procedures -Visual Basic objects and procedures (dupe of the above?) -OLE Automation -Microsoft ActiveX Data Objects 2.1 Library DO I also need to include Microsoft Active Server Pages object Library and/or Microsoft Active Server Pages ObjectContext Object Library? This is what …

Member Avatar
Member Avatar
+0 forum 1

The End.