im having some problems, when i do my query from my vb.net program to my mysql DB the data is sent, but its missing some things, let me explain.my query is pretty simple im sending a file path to my DB so that after i can have a php website get the data and make a link with the data from my DB, but when i send my data the results look like this.[code]but next time its going to be something else so i cant hard code the paths, i was looking more of a sql query switch that i might not know, since i already thaught about searching my string and if it finds a backslash it adds another one, but i feel its not a good way to script the whole thing..
It seems I'm not lucky with backslashes in ASP.Net VB.Net.I'm trying to output some infos about files with ffprobe and my paths are cut randomly at some backslash in every string containing backslash.I debugged this function to return the path generated by fileToProcess:
Function ffprobe_show_format(ByVal arg As String) As String Dim myProcess As New System.Diagnostics.Process() Dim fileToProcess As String = MapPath(".") & " emps" & arg
I've not found any info on this again, i think i asked a while back ago and can't find it. But what I have is an application that stores data in xml files. I read these files in/out through datasets. My question is, can i filter or requerry these datatables in the datasets? and how?
I have simple ASP.net web form. With a simple click on a button i need to call a the Multithread process in order to execute my querry in SQL Server DB. I know that my querry willl take up to 45 min to be executed. While the process is running i need to display some status information like: Starting time, Time elapsed, % of completed...So after running the process i got the following error message: "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."So i have 2 problems to fix:
Avoid getting timeout while processing/calling the stored procedure. I tried to add cmd.CommandTimeout = 1000 but it didn't work out! Display correctly Time elapsed and % Completed while processing.
Here's my code in the main form:
Imports System Imports System.Data Imports System.Configuration
I have determined thanks to the last q & a that there is something wrong with my "save to db" code as well as my "retrieve to picture" code. Even If I manually save the pic in the db it stil wont retreive. This is code i patched together from 3 or 4 examples around the net.
Dim filename As String = txtName.Text + ".jpg" Dim FileSize As UInt32 Dim ImageStream As System.IO.MemoryStream[code]......
MySQL databases exists for saving values as strings (text only). Is there any way that i could store files with the same speed as a mysql command ? I know that it depends on the file size but lets say that the file is "Avatar.jpg" 50KB... I ve tried FTP but this is not what im looking for. e.g. You want your users been able to upload a file like the [Add This Attachment] button does in dreamincode.net and you dont have any background on PHP/HTML/Javascript/ASP.NET just VB.NET and the basics of MySQL plus you dont want to use it for a website. How do you accomplish this? Something silly that ive tried was opening an image as text then update the mysql server with that text but it didnt work backwards after i wrote the text on the file and oppened it ...it said that the image was corrupted.
What i have going on, is i have a MySQL connector as a resource on my application, and im basically trying to connect to my MySQL server, to either a) register a new account, or b) check that the account exists and they are premium, and login, Now what i have run into problems with is: My MySQL Database Name has a _ in it which VB is not allowing for some strange reason.
The code i am using is below
Imports MySql.Data.MySqlClient
Public Class Form1
Function UpdateRecord(ByVal query As String) As Integer
[CODE]...
How i can allow the _ into the application, because the only databases that don't have a _ in the user or dbname are a) Paid ones which i DO NOT have the money for or self hosted ones, i cannot leave my computer on 24/7
I am trying to make a login system mysql try to connect to a mysql database.
Here is my code:
Imports MySql.Data.MySqlClient Public Class LoginForm1 Dim MySqlConnection As MySqlConnection Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click MySqlConnection = New MySqlConnection()
i Built A MySQL Login System Using MySQL Connector But If Other People Want To Use The Program Thay Get An Error, I Think This Is Due To Thay Do Not Have The Connector So What Should I Do, Btw Dont Say 'Tell Them To Connector'!
Im building an app to manage PSP contents, and it should connect to my MySQL server on my domain to refresh game info and ratings and so on, but I cant make it connect with MySQL Connector 6.1.
I can have mysql database. but i have not mysql. how to connect this database vb.net 2005. but i have mysql-connector-net . I want to mysql-connector-net use to connect this database. database path(C:Documents and SettingsAdminMy DocumentsVB.NETStock delnaSTC.sql)
I have a query from within my vb.net code which searchs for a record by date. The date being entered via the code is in format dd/mm/yyyy, i need to search in the database using yyyy/mm/dd? Ideally i thought there may just be a function within MySQL which will convert this. If not in vb.net to convert the string 01/01/2011 to 2011/01/01?
What i am trying to do is get my system to look into the database and recognize if the user is a admin or a user, based on that they have certain rights below is my code
Imports MySql.Data.MySqlClient Imports System.Data.SqlClient Public Class Form3
I'm connecting to my mysql server using ODBC in vb.net, the database is shared throughout the company because it is used in an accounting program (simply accounting), each user has their own account user/pass to login to the database. I have developped a program that uses the accounting database and combines it with other information, my problem is that at least once a day I get this error when I run my program: "(10061) ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on"and the error persists for at least 4 hours, for some reason it starts to work again later on in the day.
Now I have my databases in .sdf-files. These files are located on a server and loaded into several listviews. It has worked fine for a while, but I found out that last week one of the computers didn't close the connection with the database, which resulted in (a bunch of) errors on the other computers.
I have a mySQL server (external) where I can add the data into, but I think that it would slow down the loading severely, but it's very important that people can import the data at the same time.
i am having a problem converting MySQL entries to xml format while using visual.net.so far, i have succeeded in creating a plain xml format based on the entries of my database using basic commands.here's what i've done so far:
Dim query As String = "SELECT * FROM " & table Dim connection As New MySqlConnection(Form10.connStr) Dim path As String = ""
[code]....
the problem is, i want to generate an xml report which also contains several extra comments and items that are NOT inside the table.
I'm making a sign in/out program using mysql and visual basic and need a little help I have two tables event_in and event_out and under each table I have event_id, which automatically generates a number(starting from 1) for each row. I was wondering if it's possible to generate the numbers based on the users. So let's say User A comes and signin, 1 is generated into the event_id. Then User B comes and signs in. I want 1 generated for him too...so all User A's event_id will be 1,2,3... and each user's event_id for both the in and out table will also be the same.
With this I will be able to subtract each user's timestamp in event_out from that of event_in to get how long they were in. I believe that if I don't generate the numbers separately for each user, then let's say User A signs in (1 is generated for event_id in the event_in table) but does not sign out yet and then User B comes and signs in (he get 2 for the in) but then he signs out before User A does and he gets 1 for the out and user A gets 2 for the out. So now user and with my current query I will not be able to calculate the timestamp.
I have Visual Basic 2010 Express and i have just installed MySQL, when i type Imports then i can't see the MySQL in the suggestions, what's the problem?
