.net 2003 Versus Mysql?
Jun 21, 2010i am not able to use connection string?
View 1 Replies
ADVERTISEMENT
SQL Connection To Access - 2007 Versus 2003?
Dec 17, 2009My application currently works with Access 2003 using the following approach...
strMSAccess_Connection_SQL = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDatabaseFilePath
MSAccess_Connection = New OleDbConnection(strMSAccess_Connection_SQL)
MSAccess_Connection.Open()
When I load it onto a WinVista machine running Office 2007, I get the following error the microsoft.jet.oledb.4.0 provider is not registered I was doing a little research and I guess 2007 changed a few things? Introduced something called ACE? I tried using "Provider=Microsoft.ACE.OLEDB.12.0", etc but I get a similar error to the above...
2003 And Mysql Connection Errors?
Oct 31, 2010I want to connect mysql database with vb.net 2003I install mysql and add referance MySql.Data. When I try to use following connection script which is very common: conn.ConnectionString = "server=localhost;user id=root;password=1234;database=test_1" am getting error 1042. server connection errorWhen I use Mysql Workbench for mysql data browsing. I can connect database with Local Socket/Pipe connection method. Standart TCP/IP method is not working, because I do not use any network just work on local machine.
View 4 Replies[2005] Today.date Versus Now Versus DateTime.Now?
Jan 16, 2009just want to know what is the difference between these date values?Once some one told me that its difference is server date and client date but not sure which one he meant.Below is 3 type of date currently I'm using and don't know what is the difference between them.
DateTime.Now is from System.DateTime.Now
Now is from Microsoft.VisualBasic.DateAndTime
Today.date is also from System.DateTime
Store Picture As BLOB In MySQL Database And Retrieve From MySQL Db Directly Into Picturebox ?
Apr 11, 2011I 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 And FTP - MySQL Databases Exists For Saving Values As Strings (text Only)
Sep 22, 2009MySQL 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.
View 7 RepliesVS 2010 - MySQL Connector As A Resource On My Application - Connect To My MySQL Server
Jun 21, 2012What 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
Make A Login System Mysql Try To Connect To A Mysql Database?
May 3, 2010I 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()
[code]....
Built A MySQL Login System Using MySQL Connector?
Aug 27, 2011i 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'!
View 5 RepliesDB/Reporting :: Connect To MySQL With MySQL Connector 6.1
Nov 16, 2009Im 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.
[Code]...
Mysql Database Connect With Mysql-connector-net
Jan 30, 2011I 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)
View 3 RepliesSql - Convert MySQL Date Within MySQL Query?
Mar 21, 2011I 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?
View 1 RepliesUser RIghts Using VB And Mysql (not Window Mysql)?
Feb 26, 2012What 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
[code]....
.net - X=x+1 Versus X +=1?
Apr 30, 2009I'm under the impression that these two commands result in the same end, namely incrementing X by 1 but that the latter is probably more efficient.If it is correct, why should the latter be more efficient? Shouldn't they both compile to the same IL?
View 17 RepliesIDE Versus EXE Performance In .NET?
Oct 5, 2009I've developed a .NET application that, among other things, does the following:Uses WebClient to retrieve data from a remote server.
Serves as a socket server to 2 'satellite' applications run on the same machine or on a LAN.When I run the app in the VS IDE, it works great. It quickly gets the data from the remote server and communicates perfectly with the 2 satellites.However, when I build it and run it as an EXE, the response from the remote server is very slow and its communication with the 2 satellite applications become very poor.Is there some important difference between running an app in the IDE and running it as an EXE that could effect it like this?
Objective C Versus .net?
Apr 9, 2011For every member object I have to declare the variable 3 times.One in the declaration. One for property declaration. One to tell the compiler to synthesize all the function. Another one to release all those members from memory.Then I learn about Core Data. I generate diagram, poof the classes are made from me and a lot of things are done behind the screen of that visible classes.
Basically Core Data in Objective C represents some form of relational databases. Of course those databases can have relationship, including many to many relationship. The additional detail of having a third table for many to many relationship is already done.Then, there is indexed property so we can search faster. That's also done.
[2008] WPF Versus GDI?
Jan 12, 2009I have thought of a new project to keep me busy for a while, and it involves a more advanced GUI, specifically I want to display a map and put objects on it or highlight certain areas for example. I've been searching the forum for a little while and ran into two options for more advanced GUI building: WPF and GDI.
View 2 RepliesError - (10061) ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't Connect To MySQL Server On
Jun 4, 2010I'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.
View 1 RepliesUnable To Cast Object Of Type 'MySql.Data.MySqlClient.MySqlException' To Type 'MySql?
Sep 20, 2011error " Unable to cast object of type 'MySql.Data.MySqlClient.MySqlException' to type 'MySql.Data.MySqlClient.MySqlDataReader'. " ?
THIS IS THE CODE Ssql = "SELECT ItemID, Prodname, qty, Desc, Cost * FROM items ORDER BY ItemID ASC"
[Code]...
Application.Exit() Versus End?
Dec 8, 2010Can anyone tell me what the technical difference is between Application.Exit() and End?Why would you choose to use one over the other, for example?
View 5 RepliesAsp.net - SQL Transactions: TSQL Versus .NET?
Nov 19, 2010I wanted to know what (if any) differences there are to using the SQL Transaction within the application versus written into the stored procedure using TSQL statement. We would need to restructure the stored procs and vb code to get this to work and I'm not sure it would be worth the effort at this time.
Public Sub RetrieveTData(ByVal cID As String, ByVal cnn As SqlConnection) As Boolean
Dim sqlTran As SqlTransaction
cnn.Open()
sqlTran = cnn.BeginTransaction
[code].....
We aren't certain whether the timeout is occurring in DataAlreadyTransferred() or usp_BigNasty_CopyDataFromDB1toDB2 due to how the try/catch is written. We can restructure this code, but will take a week or so to get it to production (no errors occur on test/dev today)
DB1 - permanent storage, used by other applications as well
DB2 - working set, used only by Web App
DataAlreadyTransferred(cID) first checks to see if DB2 has any copies of the records, if DB2 does and those records are clean it deletes them (data could have changed in DB1 and we want the most up-to-date version). If DB2's data is dirty it is left alone and no data is deleted.
usp_BigNasty_CopyDataFromDB1toDB2 copies rows from approximately 20-30 different tables and copies over the perm copies from DB1 into DB2, essentially creating a working set from which the Web App can access
We are aware this is inefficient and are examining ways to improve it, just haven't had time yet... I believe by having the transactions in the app code it's locking many more tables than is really needed. If we move them to the stored procs, less tables will be locked at one time thus improving our chances of removing deadlock conditions/timeout issues we're seeing today. Just not sure on this..
C# - Appropriate To Use Generics Versus Inheritance?
Apr 28, 2009What are the situations and their associated benefits of using Generics over Inheritance and vice-versa, and how should they be best combined?I'm going to try to state the motivation for this question as best I can:I have a class as shown below:
[Code]...
Now suppose I have a repository that takes an InformationReturn argument, that has to strore different fields in a DB depending on the type of Info object T is. Is it better to create different repositories each for the type T is; one repository that uses reflection to determine the type; or is there a better way using inheritance capabilities over/with generics?
C# - Division By Zero: Int Versus Float?
Dec 18, 2010Deviding an int by zero, will throw an exception, but a float won't - at least in Java. Why a float have an additional NaN info, while int haven't?
View 6 RepliesCase Versus If Then Statements.
Apr 26, 2011i have a program, three radios, and 2 check boxes. the Radios use a constant value and do a multiplication. check one applies a discount. no problem.
the last takes the values of all three radios does a comaparison and displays a label if false, performs a subtraction if true and shows savings.problem>
very convoluted using if statements. and the output is often wrong(i know this is a logic error) i can not find the fault.
would it be easier to use case statments. can and will post code if requested. as it is in if then format currently it is rather long.
Sometimes the answer is so blindingly obvious i fail to see it.
Generics Versus Extensions?
Nov 8, 2009This is my problem:
<System.Runtime.CompilerServices.Extension()> _
Function CastAs(Of TSource As TTarget, TTarget)(ByVal array As TSource()) As TTarget()
Return Global.System.Array.ConvertAll(array, Function(src As TSource) DirectCast(src, TTarget))
End Function
IDE :: VB 2008 Versus 2005?
Sep 1, 2009I have a book from a friend called "Teach Yourself Visual Basic in 21 Days" and so far what I have read has been very nice and easy to look at as well as understand. It also seems like it will do what it says it will do. One problem is it was published in 2006 so it uses VB Studios 2005. There is a rather large difference between 2005 and the new 2008 Express edition and I see the new 2010 beta so I wondered: "light from above, is it worth looking for the 2005 edition of Visual Basic Studios Express Edition or should I rather just look for another book and start working with this 2008 edition? I really fancy this book on the 2005 edition but seeing as it doesn't even have the XP window styles in the figures it might be a little outdated and this new 2010 edition might blow away 2008! I am so confused. Should I throw out the old and go with the new, or should I work with 2008 until IT'S time is up? Is it worth it in this new economy and fast paced evolving career opportunity?" Well, I didn't get a response form the great Computer Techie in The Sky, so I am asking you... What should I do? I understand that it might be better to learn with this new 2008 edition but even still I would imagine their are some 2005 based programs out there people use that might need updating. As a beginning programmer I don't know where to go.
View 3 RepliesNamespace References In C# Versus .Net?
Aug 22, 2009In VB.Net you can do something like the following without any issues... just ignore the fact that this is a pretty useless class :-)
Imports System
Public Class Class1
Public Shared Function ArrayToList(ByVal _array() As String) As Collections.Generic.List(Of String)
[code]....
However if you do the same thing in C#...
using System;
public class Class1
{
public static Collections.Generic.List ArrayToList(string[] _array)
[code]....
You will get an error on the line with the return on "Collections.Generic.List" saying "The type or namespace name 'Collections' could not be found (are you missing a using directive or an assembly reference?)"I know that you have to actually have a using directive to System.Collections.Generic to use List but I don't know why. I also don't understand why I don't get the same error in the function declaration, but only in the return statement.
Edit: Just to note, the question is really about the referencing of a sub-namespace such as in the example being able to reference Collections within System.
Overloads Versus Overrides In .net?
Oct 24, 2011What are the behaviors difference for the Previous Property of Other1 and Other2 Class.Note than the return type of the ovrloaded Previous Property of Other2 as bean changed to Other2 while it stay as Base for Other1.
Public Class Base
Private _Previous as Base
Protected Overridable ReadOnly Property Previous As Base
[code]....
Reference Versus Instantiate?
Aug 25, 2011what actually goes on inside the pc when I reference an object vs when I instantiate it.
Like this
Guys joe; (reference)
Joe = new Guys; (instantiate).So what goes on inside the computer for each line above.
String Concatenation: Using += Versus &=?
Sep 13, 2010Possible Duplicate: The difference between + and & for joining strings in VB.Net.In VB.NET you can use either += or &= to concatenante a string (ignoring using a StringBuilder for this question -- this is directed at a very simple concatenation).
View 2 Replies