how a database software is developed? i tried using sql server, the weak thing is that.....the database software is unable to run in a pc that is not installed sql server program. using others software instead of sql? or is there any other way that possible to let my database program to access database data without required sql installed.
View 1 RepliesWhen I click "Connect to Database" I get this error..
View 1 RepliesI have written a new app in VB.net as a front end to a mySQL database held on a PC on the LAN running Windows XP. This worked fine for a while. The PC running the mySQL server started locking up (XP errors, not mySQL errors according to the event logs), so I decided to have a go installing Ubuntu to run the mySQL server to see if that was more stable.Ubuntu 11.10 is now installed, and mysql server is also running. I have imported the old sql database files and the mySQL workbench shows all tables are imported successfully.
HOWEVER, I cannot get my VB application to connect to the database now it resides on Ubuntu - just returns "Unable to connect to any of the specified MySQL hosts" when i try to open a connection. I am fairly new to Ubuntu and MySQL, and don't know if the fault lies with the O/S (a firewall config problem perhaps?) or if I need to do something different with mySQL.I can ping the Ubuntu pc from the client pc and vice versa.I have used ufw to open port 3306 on the server The ufw logs do not show any errors when I try to connect from the client pc, so I don't think it's a firewall problem (but could be wrong). I thought it may be something to do with the usernames I use in the connection string, but when I change these (deliberately use the wrong password for example) I get the same message, rather than a username/password error Is anyone else using a client PC running Windows (W7 or XP) to connect to a mySQL database running on a Ubuntu server?
,i write a simple program in vb.net 2005everything is ok when i run the program in solution, but problem appears when i run the program from bin eleasemyprogram.exethe error message is :'..bin eleasedbx.mdb' is not a valid path. make sure that the path is spelled correctly and that you are connected to the server on which the file residesi dont have a clue about what mistakes i did..
View 2 RepliesI added a new database using SQL Server Management studio express 2008. I can connect to that database using Web Developer and Visual Studio just fine. But when I try to connect from VB Express 2008 I get an error message "file in use by another program". VB only prompts me for the name of the database, but Web Developer and Visual Studio prompts me for both server instance and database name. I'm sure this is just something simple I'm missing.
View 2 RepliesRunning off my laptop: Visual Basic 2010 Express & SQL Server 2008 . I've successfully been able to use the connection wizard to connect to my database in vb.net and read/write data using datasets/tableadapters/binding_source etc.
Now I am trying to create an SQL connection via code to connect to my database to do some more complicated queries. I was successful in being able to connect to my database with SQL, but by doing so it produces an error when it tries to run any .Fill() methods from my TableAdapters below. The error produced is the following: "SqlException was unhandled. Cannot open user default database. Login failed. Login failed for user 'Chris-PCChris'".
If I remove my SQL connection code, the TableAdapter.Fill() methods will work fine.
[Code]...
I am trying to connect to my remote MySql Database within Visual Studio using the compact framework.
I can successfully add a data source and preview the data within the IDE so assume that the connection is ok regarding Connection strings and remote access.
However, when I attempt to access the data using any run time control I get the following error when the table is loaded using the .fill method.
MySql.Data.MySqlClient.MySqlException was unhandled
ErrorCode=-2147467259
Message="Unable to connect to any of the specified MySQL hosts."
[Code]....
I am trying to make a copy of an existing database, I use .net framework data provider for SQL Server.I get error "Unable to connect to source server for Transfer" when it runs to oPackage.Execute().
oConnection = oPackage.Connections.New("what the providerID should be?")
oStep = oPackage.Steps.New
oTask = oPackage.Tasks.New("DTSTransferObjectsTask")[code]......
I am able to connect to the sql server 2008 express by using this as connection string
View 10 Repliesi installed visual studio ( full installation)then i got xampp from their site i have mysql and apache running i downloaded the connector from mysql site and i created a simple project to check if i can connect to mysql or not i have made this code so far
Imports System.Data.SqlClient
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim Connection As String = "Data source=localhost;user=root;password=;Initial Catalog=test;Integrated Security=true;"
[code]....
im having trouble with an exception though it says {"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"}
how can i get rid of this, is it because i installed mysql 2005 with visual studio 2008? and maybe it runs with xampp's mysql and creates these problems?
i added the bindingsource control on my winform. here are the details of my connection:[URL] when i test the connection, it says "the connection cannot be tested because the specified DB file does not exist" the DB is located in [URL]. how should i set up bindingsource?
View 2 RepliesI am trying to connect windows form to oracle database on a remote server through VS 2005 and get the following error:Unable to connect: ORA-12154: TNS
[Code]...
I've created an application that inserts data into an MySQL database, I have used xampp on the local machine to make sure that the database worked with the application and that everything worked correctly
now when editing the connection string so that I can connect to a remote machine on my LAN I keep getting an error saying "Unable to connect to any of the specified MySql Hosts"
I've checked all the credentials in the connection strings I.E username, password, database name and the machine address.[code]...
I have created a server-client application in Vb.net with back end Mysql .In client while am trying to run its showing the following message
"Unable to connect to the specified MYSql hosts"
I need to read a command from a .html file. To do this I use:[code]My application constantly loops to check the .html file for commands. I need it to do this, even if the internet is off. Obviously, it wont read commands if its off.. I just need it to resume reading when it comes back on WITHOUT crashing my application.Any code to ignore timeouts so where my application will still TRY to read and not crash.
View 3 RepliesUnable to connect to any of the specified MySQL hosts. My code is as follows:
[Code]....
I have checked and double checked username, password, database name, and server. I am new to using MySQL etc., but I pulled the information directly from my phpMyAdmin.
System.Net.Mail.SmtpException: Failure sending mail. ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: A socket operation was attempted to an unreachable network 184.xx.xxx.xx:25 at
[code].....
I've gone through different sites and got ideas about how to connect MySQL but it didn't work.
Imports MySql.Data.MySqlClient
Public Class Form1
Dim con As MySqlConnection
[code]....
I am trying to make a new data connection to an Access DB using the Server Explorer. The connection test OK then when I click on the OK button to finish I get the following error message.
Unable to add data connection. Index was outside the bounds of the array.
I am using VS2010 and the 4.0 .Net Framework. I have found several posts on this but done have worked out.
I have created my asp.net website using database ASPNETDB.MDF but when I try to host my site on server ...
The SQL Server 2005 hosting provider issue me the
database name dobriyalji
server ip : 69.112.222.220
database username : XXXX
[Code].....
I have a problem with my webserver connecting to SQL server.I have setup the connectionString and everything is okay. Except that I kep on getting the following error message:
Logon failed.Details: 01000:[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).Query Engine Error: '08S01:[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.'Logon failed.Error in File C:WINDOWSTEMPCouncilDistrict {4F892A8B-2AC6-4302-8A58-1466157C3ED7}.rpt:Unable to connect: incorrect log on parameters.
im currently making use of the VNCSharp lib here this is the API im trying to understand how to connect at a lower bandwidth but am unable to find an option, i know from the vnc protocol (RFB) it requires a setpixelformat command to be sent during the client init to the framebuffer process
View 2 Repliesodbc driver not found unable to connectmysql 5.1 odbc already installed and i have the following code to connect mysql
Imports System.Data.Odbc
Conn.ConnectionString = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=localhost;" + "DATABASE=apdata;UID=root;PASSWORD=acelle;Port=3306;"
[code].....
I want to connect Access 2007 with vb.net 2005 but its giving me error while doing same
View 1 RepliesUneable to connect to BBDD MySql in Virtual Server with Parallels Plesk Panel.
Does any one know how to connect to a Parallels Plesk Panel Server (my host is 1&1)?
I have web service which updates MS access database. Im using OleDB for Updating MS Access database
View 9 RepliesI create an application in VB.net which connects to MySQL, deployed it to 10 computers. 8 of them worked perfectly, 2 of them gave me the error:Unable to connect to any of the specified MySQL hosts.What was different with those 2 computers? Is there any setting I need to do on the MySQL server itself? Anything I need to change/update on those two computers?
View 4 RepliesAn Error has occurred while establishing a connection to the server. When Connecting to a SQL Server2005, this failure may be caused by the fact that under the default settings SQL server doesn allow remote connection (provider: Named Pipe Provider, error: 40- Could not open a connection to SQL Server)I want to connect to the SQL Server 2005 Express Edition which is running on my system from a VB.NET application. I am using Visual Basic 2008 Express Edition. Here is the Coding,
Dim sqlConn As SqlClient.SqlConnection
sqlConn = New SqlClient.SqlConnection("server=localhost" & "initial catalog=LIB")
Try
[code].....
I'm working on a tool that allows the user to connect to his SQL database and edit some of the database values.First here's a screenshot of the GUI (you can see my problem as well):
[Code]...
I have application in which i have implemented backgrounder worker class. Main form_load and Back ground class both accesses the same DB but with their own oracle connections.The problem is if the form_load is executed before background thread then i recieve "operation is not valid due to the current state of the object" in background while opening the connection or executing some thing.but if the background thread is executed first i dont recieve the problem while connecting DB in other part.
HTML
Friend Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
LoadPermanentData()
hblogicthread.WorkerReportsProgress = True[code]......