One of my clients wants me to integrate one of his small software he made few years back in vb6 using DB as MS Access . Now he want me to integrate it with his online software which is made in asp.net and SQL as database.
1) Question is it possible to run a vb6 software online which has ms access as its DB.
Currently I have this "commands" to access to a database in my computer:
Public conn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source= " & System.AppDomain.CurrentDomain.BaseDirectory & "bd2.mdb;Persist Security Info=False;")
Dim strSQL As String = SQLcommand
Public cmd As New OleDbCommand(strSQL, conn)
My question is: Is there a way to connect to that database online?
Example: bd2.mdb is on [URL]
I am developing an application on VB.NET 2010, I am planning to make an online activation system, the idea behind is that Whenever someone installs my application, the application presents user an activation form, user will be entering product key, name and email address, and then system will establish a connection to a database which contains all the keys on WEB. So how should I make an efficient program to get rid of that.
View 2 RepliesHow can I connect my vb2008 windows app to an Access 2000 database which is located at www.mysiteserver.com/files/rubbishdatabse.mdb?What code is needed to do so? And where should I put the code in(of coz in the vb app, i know XD, but which part)?
View 8 Repliesi've got a free mysql database online hosted by 000webhost, i'm just wondering if i could connect to the mysql database, and if so what would the connectionstring be like? when i connect using php its something like this: new mysqli("mysql13.000webhost.com", "user", "password", "database1"), how do i translate this into a vb connection string, i can't decide what to put as the data source [code]if there's no way to connect, is there anyway for me to create an application that can store and access database online?
View 7 Repliesim trying to add a new record in a small access database only firstName and lastname i want to chek if that record exist msgbox say record exist if not add a record here what i have done
Dim sqlcmd As String
Dim cmd As OleDbCommand
Dim dr1 As OleDbDataReader
Dim user As Integer
[code]....
I am able to copy the complete online mysql database to the local ms access database, but the problem is that the local database needs to be emptied before the new data is being copied.And a progressbar needs to display the entire progress.Here is the code what I have now:
[Code]...
I am able to copy the complete online mysql database to the local ms access database, but the problem is that the local database needs to be emptied before the new data is being copied. And a progressbar needs to display the entire progress. Here is the code what I have now:
Private Sub StartScreen1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim dt As New DataTable()
[Code].....
I would like to know if I need to get permission from Microsoft to develop applications for Small local firms using Visual Studio 2010.
View 6 RepliesI got an error in my coding. The error is expression expected. How I am to correct my coding. In my coding here I am tried to develop multilevel access login page. Here is my coding which is connected to database. In my coding, I create 3 textbox which is txtusername.text, txtpassword.text and txtdepartment.text. User must key in they username, password and their department in the login page, if the user department is Admin then he will access into admin page and if user department is store then he will access into store page. I am still new beginner in this vb language and for your info I am using visual studio 2005 and sql 2005.
Here is my code and my interface
Public Class Form1
Dim r = Me.StaffTableAdapter
Private Sub btnlogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnlogin.Click
Dim r = Me.StaffTableAdapter.UsernamePassword(Me.txtusername.Text, Me.txtpassword.Text, Me.txtdepartment.Text)
[Code] .....
I am using VB 2008 to develop apps working with Access. With this IDE I can compile my apps as x86 . Then runs fine under 64 bits Windows 7 and Vista Systems.
First question:but if I run this app under XP 64 bits, will run fine too?
second question:the apps developed with VB 2003 (these work with access too ..."jet oledb"). How I can compile as x86? I have not seen this option like VB2008.
I have a mdb file hosted on my site [URL]. I am developing an application which will be running on multiple machines and will contact the mdb file via internet. I am not sure how do i go about it as building the connection string for an online connection.
View 2 RepliesCan this be done? (It didnt want to connect...) so for example:
[Code]...
if not... what can i do to have a database that can be shared over the net? (My site is unix php based)
Im new on this forum here, i have already browsed many topics but i really didnt found a answer on my question.
I want to connect to a web-based linux SQL server. Is there a way to do that? Or do you have to use the Microsoft SQL server?
Are there any other ways to make small databases then to use access or sql server?
View 1 RepliesRecently i had a discussion with someone about the proper way to develop a database driven (SQL Server) application.In his opinion i should design also the database inside the application.At this moment i design the database in SQL Managaement tool and use a custom class to connect to this database (or the one of the client) in my application.What are the cons and pro's of using the VS database designer inside my IDE?
View 4 RepliesI friend and I are trying to work our way through this, and right are having some issues in terms of getting vb.net to connect to an online sql server. We have found lots of resources to connect to local sql servers but nothing about connecting to an online one. I was wondering if this is possible as we are trying to be build an inventory and pos system for a small company we have, which can be accessed through the vb program from any computer as long as it has an active web connection.
View 1 RepliesHow do you connect to an online database? Let's say it's located at www.abc.com/app_data/thisfile.mdb. What would you enter for as the DatabaseFile in the following code?
Dim DatabaseFile as string = ????
Dim connection_builder As New OleDb.OleDbConnectionStringBuilder
connection_builder = New OleDb.OleDbConnectionStringBuilder
connection_builder.DataSource = Me.DatabaseFile
connection_builder.Provider = "Microsoft.Jet.OLEDB.4.0"
connection_builder.Add("Jet OLEDB:Database Password", Password)
Return New Data.OleDb.OleDbConnection(connection_builder.ConnectionString)
Our database has been having some occasional troubles and this seems to be presenting a problem in my new app. How should I test to make sure the database is up before sending SQL statements to it? We are using Oracle 11g and I am using odp drivers, VB.net 2010, .net framework 4.0.
View 4 Replies[url] i found this in youtube but unfortunately i got error, i used filefreak as a free hosting site...i got wrong username or password even i typed it correctly!
Is there another way to have a login system that compare in online database hosting site?
How hard is this. i need to send information from a text box to a website(i not done the website yet) which is anothing il be asking abot.I have basic vb.net skills. so can follow what i am doing. just not great
View 8 RepliesI am trying to develop an application using VS 2008 connected to MySQL database. Previously in vb6 i was using adodb and now when i googled and got a few sample projects done using VS2008 in which most of the module codes were OLEDB.....To which method should i stick to...?
View 2 RepliesI need to make a small programm for ticketing on a parking for a small hotel.So i have 2 Printers pariking In (for delivery of the tickets) and 2 Readers PArking Out.Both Printers and REaders are working Serial.So i need to poll the serial ports of the printers and readers every second.The data is stored on a SQL database so i need to read and write in the database.Can i do this with 1 PC and 1 programm or 1 PC and 4 programms that are runnning at the same time ?
View 2 RepliesI have mysql database in my website (server) .How can i connect to this database using vb.net?
I am only able to connect to local mysql database on my computer.[code]...
I just created some program, using an online database. You can login, register...But the problem is: everything works but how do I fetch data from the user's sql table?I include the project (all connections) over here ->>DOWNLOAD<<-. I use freedb.net....
View 4 RepliesI just created some program, using an online database.You can login, register...But the problem is: everything works but how do I fetch data from the user's sql table?
View 8 RepliesConnecting to a Online MySQL Database using .Net?
View 4 Repliesi got some problems with my connection to a MySQL database so this is my code:
Dim conn As MySqlConnection
'connect to DB
conn = New MySqlConnection()
[Code].....
I got this Database that is Online thats hosted through the Website and uses MySQL, and the Tables have some Data I like to Read From. Heres what I got
vb
Public Sub testconnect()
Dim sqlconn As String = "Server=63.247.93.106;Database=viina_schoolbook;User=---; Password=---;"
[Code]....
Dim
sqlquary2 = "GET Status from Members
WHERE Username='" & UsernameTextBox.Text &
"';"
[Code]....