DB/Reporting :: Converting MS Access To MySQL Or MSSQL?
Jul 31, 2008
My website connects to a Microsoft Access DB at the moment, im about to upload it to the internet - its a VB.NET web application but i'm advised to convert it to MySQL or MSSQL for better performance.How would you recommend I export the DB ? there isn't too much data in at the moment so mainly all of the tables and fields.
View 2 Replies
ADVERTISEMENT
Jun 8, 2009
I have a problem with transfering data from MSSQL Server 2005 to Access.
I need to make a VBScript that can take out all data from one table in mssql and update one table in Access. The tables exist in both databases and looks the same, but there can be more data in the table from MSSQL Server so i need to update the table in Access with this data.
E.g. I have a table called: SMP_Alert in both database's. So i want to do something like this (dunno if that is possiable):
Set objConMSSQL = CreateObject("ADODB.Connection")
conMSSQL = "Provider=SQLNCLI;Server=127.0.0.1SMP;Database=SMP;Uid=SA; Pwd=smp;"
objConMSSQL.Open(conMSSQL)
[Code].....
Or do i need to create a recordset of the table (SMP_Alert) from MSSQL, and loop through it to transfer the data into the table in the Access database?
View 1 Replies
Aug 5, 2008
I am asked to write a front end program in VB 2005 (that will run in client computers which running on Win XP) to access an existing MySQL database running in Linux. It is not my preferred choice, but the user have the database and server working just as he wants it, and do not wish to change, at the same time I do not wish to change programming language. Is that even possible? Can we actually write VB 2005 programs that will run in client computers complete with NET framework 2.0 to access a Linux operating database?
View 4 Replies
Jan 17, 2011
I have recently started programming in vb.net (or trying to) I have made a application that gets some info from a mssql server. I can get the information perfectly, but one of the items called "date" i get in to my program is a date field in UNIX time. Is there a easy way to convert that into GMT time?[ code]
View 2 Replies
Nov 16, 2009
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.
[Code]...
View 2 Replies
Feb 17, 2009
i am trying to create an vb.net program to transfer or copy tables from my access database to an MSSQL DB.I got it working to copy from MSSQL to access but not the other way around.
View 7 Replies
Apr 24, 2011
I can connect/login to my database, view a formatted table in the current window, however I want to click a button and see a new table set in a new window. Theoretically I should be still logged in/connection information saved but however I get 'unable to connect to database'.
View 2 Replies
Feb 24, 2008
i am getting this error:
Code:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
When trying to connect to my database using the mySQL v5 drivers. I had the version 3.xx working fine until i installed the newer 5.0 drivers....
Code:
conn = New ADODB.Connection
With conn
.CursorLocation = ADODB.CursorLocationEnum.adUseServer
[code]....
But i can not seem to find the "correct" connection string for use with version 5..
View 1 Replies
Jan 22, 2009
This is my current code.
Code:
Set rs = cn.Execute("SELECT * FROM customer WHERE VsVslNo LIKE 'V16'")
Dim crystal As CRAXDRT.Application
Dim report As CRAXDRT.report
[CODE]...
View 1 Replies
Mar 20, 2012
I'm trying to do a looped insert using the MySQL Connector for .NET and for the most part it's working, except for it's missing out inserts. The code below is what i'm using. An example is there are 20 items in the listview and only 8 out of the list actually insert to the mysql database. It's as if the loop runs too quickly for MySQL to keep up. My issue is that eventually this loop will be inserting many thousands of entries and I can't have it missing information out.
[Code]...
View 2 Replies
Oct 9, 2009
So I'm working with a mysql database, and I already have some queries down. I have to make a windows application form in vb.net that can display the results of these queries in a dataGridView.Lets say I'm working with frm1, and i have datagrid1 which will be filled using the query "select * from xyz" when btn1 is clicked.Can someone please take me through the right steps to do that? References needed, connections to be made, etc. I did look through online materials, but they are mostly way too long and not dataGridView specific
View 2 Replies
Dec 1, 2010
I am new to vb .net and I have been writing simple programs in VB4(16 bit) and now I have to convert a particular program to VB .Net. I have never really used the Crystal report in vb to write my reports and I am really lost as to how to proceed with converting the following module to .net equivalence.
[Code]...
View 1 Replies
Jun 29, 2012
I am creating a database project where I take my data from mysql database and then create graphs and charts.I currently have microsoft visual basic 2010 express edition. I am familiar with visual basic but have never used mysql before. I have quried a database into mysql and server connection to the database is working fine. Furthermore I downloaded mysql a week ago so I have the latest connector.I looked at many youtube tutorials and have tried to find mysql.data in the add reference section (in project) but it doesn't seem to be
there.
View 3 Replies
Dec 7, 2009
I downloaded the free Visual Basic Express Edition to create an application that connects to a Mysql database. I searched for the connection string and found a bunch of different ones.I have no idea which one should I use with Visual Basic Express Edition. I have been using PHP, javascript and mysql for a couple of years, but I have never used Visual Basic and have everything to learn.
View 2 Replies
Mar 27, 2012
how to connect a visual basic front end with a MySQL back end. I am not proficient in VB or MySQL and was not able to find anything on google as a result.
View 1 Replies
Jan 6, 2011
I have a MySQL database online. What do I need to connect to it and exchange data?
View 2 Replies
Oct 17, 2008
I'm confusing between SQL Server and MYSql and Sql Quries Is the SQL Server database like access and Sql Quries is the language Sql like Select * From Table1?
View 1 Replies
Apr 9, 2012
i am creating an application that will upload a picture into a mysql database. I currently am able to add normal records with text and integers into other tables and get the data in the table to display in listview etc, however, i am wondering how i could insert a picture into the mysql database.I know the field needs to be blob type and have that set.The table i want to upload to is "picture" and contains only 3 fields, "ID"; "pic"; "caption".
View 5 Replies
Sep 3, 2009
I got the whole database thing figured out now I've got a problem with these parametrized queries. If I remove them and just explicitly put in the data I'm looking for the datareader works, however doing as I have below returns no results in the datareader.
[Code]...
View 2 Replies
May 8, 2010
I am a developing an application based on VB 2008 express and a MYSQL database.I have created a database called octupus_db and inside it there is a table called customers.I now have a combo box on my form and i want it to populate its contents from field called town inside the customers table. How do do this? [code]but now connection a table and a field with my application is the next night mare, tried .
View 2 Replies
Sep 23, 2008
I am trying to read from a MySQL DB, and then output to the console like this:
[Code]...
View 2 Replies
Jun 16, 2009
i am trying to save image into MySQL database ...is there any easier way to do that ?
View 1 Replies
Jan 5, 2010
I'm having a problem converting a string to a datetime format. the string is depicting an hour, for example 08:00, but in the mysql database it stores that as 2008/00/00 00:00 any idea how to solve this?
[Code]
View 3 Replies
Jun 23, 2009
I am using the Mysql .NET connect and can connect to my database using my program. i want to be able to get a Users Password from the database using there user name
This is the query i want to use: "SELECT Password FROM staff WHERE Username = " & textbox1.text & " '". But i don't know how to run that query and to get it to store the Password as a variable
View 3 Replies
Apr 28, 2010
i am semester 2 in the "system information", as usual just like in semester 1, this hardcore lecturer just has some way to make us difficult he is giving us a one semester long assignment, and as you probably can see.i got mysql as my database to making a hotel system application.
1.now i am stuck with how to connect "crystal report" with mysql database table??
2.after connected, how shoud i display it?.
View 1 Replies
Sep 24, 2011
anyone knows the query of selecting from monthname and year(September 2011) from mysql database DATE format(yyyy-MM-dd)
View 1 Replies
Sep 16, 2011
I need this for displaying in my crystal report here's my code:
Code: cmd.CommandText = "Select * from pos where date= '" & datetimepicker1.text"'" and nothing displays on my crystal report, I need the right query for that...the field value is DATE...I need the conversion for the 1/11/2001 format from date time picker to 2001-1-11 in DATE field
View 3 Replies
Nov 18, 2009
I have a problem here I did make database program for a friend the database is online Mysql I use Visual Studio and put this into setup.exe when he install the program and try to log on he get this error This is my connection to the database
[Code]...
View 1 Replies
Apr 6, 2011
I completed an application and got it to the point where it works fine. I had it setup on a local Access database and now I want to figure out how to connect it to a SQL server 2008 database. I got it setup to a point where the database is connected to app but not sure how to convert it.[code]
View 2 Replies
Sep 25, 2011
I need to convert old .mdb Access files to the new .accdb format.What's the best way to do this in vb.net?
View 1 Replies