I have the MySQL connector dll for .net, but am having problems.
1) When I go to phpmyadmin on cpanel, it says the server is localhost. I am confused by which IP i am supposed to use to connect, as im pretty sure just localhost will not work.
2) When connected, can i use credidentials from an account already made to access the database, or do i need to use the admin credidentials?
I have simple code that connects to Sql database... (well it doesn't)
VB
Dim objConn As New SqlConnection("Server=localhost;uid=***;pwd=***;database=***")
objConn.Open()
ERROR MESSAGE: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)But looks like something is wrong with "localhost" thing. Any help? Where can I get name of (my) server?
I've made a WCF server and tested and debugged it only on localhost so far. I wanted to measure its LAN speed and couldn't get it to work. The client returned a EndPointNotFoundException. Below are the configurations I use on the client and server.[code]
View 2 RepliesI'm interested in creating a simple localhost server that can serve dynamically generated data from a ListView into a formatted web page. I'd also like to "control" or otherwise have the program execute functions based on what links are clicked.I've been searching for solutions and it looks like it would be a fairly simple task but I'm not sure exactly what the best way to go about this would be.
View 9 RepliesWhat happen if i want connect to a database server is not my computer local host, is another computer localhost in LAN network? how it works? [code] how about i wan connect the server is another computer localhost database?
View 1 RepliesI have an application which connects to a database, retrieves a username from a user's table and matches it against the username retrieved with System.Security.Principal.WindowsIdentity.GetCurrent.Name.On my localhost, everything works fine. The database exists on the development server but the application lies on my localhost. All of my authorization and authentication techniques are running smoothly.However, when I publish my application to the development server, I'm faced with the following error.Cannot open database requested in login 'databaseName'. Login fails.Login failed for user 'DevelopmentServerNameASPNET'.
[Code]...
I'm trying to see if a file I have loaded is located in the "Xampp-localhost-folder".
I'm loading a php-file-path into a textbox. After pressing a button the php file is loaded in a webbrowser. Now here's a problem. .PHP-files don't load local. The user needs to have at least Apache (MySQL/PHP/FileZilla FTP Server etc) installed so the page can be loaded via localhost.
The most important service that needs to be running is httpd.exe (Apache) or FileZillaServer.exe.
Public Function ProcessesRunning(ByVal ProcessName As String) As Integer
Try
Return Process.GetProcessesByName(ProcessName).GetUpperBound(0) + 1
[Code].....
I need to know if is there a chance to connect a visual basic program to a database , example PhpMyAdmin.
View 16 RepliesWhat's wrong with my code, the query seems to be fine, I tried executing it on phpmyadmin.
CODE:
I got this error: ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.1.36-community-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
the form loads, it loads the fetch data from mysql in a datagridview, but when i click cancel button, it will again load the same data.
View 1 RepliesI am trying to input a very long list of dog breed names into a DB via phpmyadmin, this will take me for ever manualy and I was thinking if I could work out how to write something quick and nasty to create the sql string for each dog breed it would save me so much time. The sql query for each added forum is in the following format:
[Code]...
I am using vb.net with phpMyAdmin MySql database. While running the piece of code below, the program hangs in the for loop before the variables are assigned values from the data table(dt)...
'Check for appraisal period-----------------------------------------------------------------------
Dim sqlCheckDate As String = "SELECT * FROM tblappraisalsetting where appSetID=(select max(appSetID) from tblappraisalsetting);"
[CODE]................
Alright I am trying to create this: [url]
I am having some issues doing this tutorial: [url]
At the step server=localhost; user id=root; password=; database=test
What do I put instead of localhost?
I have a database setup on my localhost hosting [C:xampp] and I want the mysql server from that to connect to the my one on Visual Basic 08, wait no - the other way round. I want Visual Basic 08 to connect to my database which is hosted locally via my computer.
View 1 RepliesIs it possible in .net 2.0 to enable calling web service only from localhost and to disable calling web service from outside?
View 1 RepliesI'm trying to run the website (case study for school) but i encountered an error: could find localhost.[code]...
View 6 RepliesI have made a "webserver" in vb.net the problem is that it seems like it's just listening to 127.0.0.1 (localhost) and not request that is sent over the internet. I have changed the listening adress to my public internet ip but it's still just listening to local requests.
Do someone have a source code with a working example of how this could be accomplished?
Dim address As IPAddress = IPAddress.Parse(79.138.xxx.xxx)
Dim EndPoint As IPEndPoint = New IPEndPoint(address,8082)
Dim ss As Socket = New Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp)
ss.Bind(EndPoint)
ss.Listen(20)
how to temporarily save the user input to the pc he is using then save to another pc in the network later. Our LAN sometimes disconnect or there maybe power interruptions and I don't want that the input of the user disappear due to disconnection or power interruption. What is the easiest way to accomplish this?
Here's what I'm working so far. The data saves to another pc.
Imports System.Data.SqlClient
Public Class formGrammarI_Page01to04
Dim db As New EPTR_DataDataContext
[Code]....
When the web service is uploaded to the external server the desktop application has no problem finding and using the web service which access an Oracle DB to send/retrieve information. However, when I go to properties and change the 'Web Reference URL' of the Web Reference to localhost there seems to be a problem with communicating with the DB.
[Code]...
I have search google but and have done all their instructions,but it doesn't solve my problem at all....
1. I installed visual studio 2008 in drive D:\ and mysql connector 1.1 in drive C:\
2. I try to change my root password but it didn't work
Here is my module:
Imports MySql.Data.MySqlClient
Module Module1
Public conn As New MySqlConnection
[code].....
But if I run this program, i always got a message "Access denied for user "@'localhost' (using pasword:NO)" and i have set password for root,so why it shows "using password:NO"
how to change the destination address from "localhost" to the ip: "192.168.1.1"
[Code].....
Hey guys, I am trying to send data from client to server (encrypted) and the string sent from the client is not the same as recieved from the server. I've been killing my brain for hours to get this to work but I cant manage. Im converting everything to Base64 string.
Client:
Public Sub SendMessage(ByVal msg As String)
Try
SyncLock myclient.GetStream
sw = New IO.StreamWriter(myclient.GetStream)
[code]....
With a Windows form that I would like to be a DDE server. I know that DDE is not natively supported in VS 2010/11 so I'm using the NDde.dll to add DDE functionality to this program.
Objective: Create a windows form to act as a Pop-up notification that has a textbox field. This textbox field must be selectable in order for users to copy a text string to the clipboard and paste into another program that does not support DDE.
Overview: A phone system has an on-screen agent program that triggers a pop-up form, the DDE Server, when an incomming call is presented. When the agent accepts the call the agent program, acting as a DDE Client, registers a DDE session, Application=phnserver and Topic=callerid. Then communicates an "OnExecute" command to the DDE Server followed by a number string. This string should be presented on the pop-up form in a text box. Once the call is completed the agent application will issue a command to close the pop-up form.
Below is my current code.
CODE:
posted again but this time its regarding both the webclient and the web reuqest giving me this error :S
View 1 RepliesI just got into VB 2010 with SQL 2008 Server Report. I was able to create a report as my wish and it's vieable via direct url (URL). But I want to pass login Information and Selection parameters to the report. But I don't want to pass them thru URL, So I want to load them from the application (winform) and launch the report in iexplorer.
View 1 RepliesI am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords. Plan is to host this server so people can login to use the the application and verify they have a valid account. I would like to host all the account information in SQL due to the possiblity of hundreds of users at any given time. I also need the ability to add data to the database for users registering for the first time. The SQL server will need to be able to access the SQL Server databases remote via WAN.
View 3 RepliesI found a few free FTP hosting services and I was wondering how you implement them with your programs.
View 3 RepliesI have a database is SQL Server 2008 Express. I have added this database to an ASP.NET project, now I want to add the same database to a VB.NET project, however, when I try to set it up it says I need to choose a different file because it already is in use (which makes perfect sense). So how can I set the database up so ASP and VB can use at the same time?
View 3 RepliesI'm trying to write a small app that will connect to our SQL database and run a small query.
However, my first stumbling block is the connection to SQL.
The SQL is on a server called RCSRV01, and RCSRV01 is the name of the SQL Server instance. The database is called NHD
This is my connection code...
[code...]
I'm working for a socket tcp/ip. I have a server form on Server PC and client forms on all clients. I want the clients auto find and connect to the server PC when I open connection on server form? (in common, I have to set the server IP and ports to each clients, if not they cannot connect).
View 3 Replies