provide with necessary code for connecting the remote database.. the remote database is in access. i am facing problem at defining the connection string. And i am using ado control for connecting the database.
View 1 Replies
good mornign here again =D having a problem with connecting to a remote database via adhoc we are using a windows 7 ultimate 32bit OS platform =D
here is the connection message im encountering
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: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)
i have already enable the the Remote Connection enabling the both TCP/IP and name Pipes and its server authentication of our both msSQL server 2005 is SQL SERVER AND WINDOWS AUTHENTICATION MODE
and also i put a check in Allow Remote Connections to this Server...both our laptops...
but still encountering the problem... the default gateway of our adhoc is 192.168.137.1
sample code how i connect to the database
Imports System
Imports System.Data
Imports System.Data.SqlClient
[Code]....
I am currently developing in Visual Studio 2008 (Visual Basic) and I have no problem reading, editing, saving, etc. to a 2007 Access database that is stored locally using the following code:
Dim NotifyDS As New DataSet()
Dim NotifyCon As New OleDb.OleDbConnection
NotifyCon.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|DataSettings.accdb"
NotifyCon.Open()
Ultimately I am going to be installing this program in my office on multiple computers, but would only like to have one "server" program where the database is installed. All of the other computers will have access to this one database over the LAN. For some reason I am unable to access this remote database file over my LAN. I have tried all sorts of things (including a username and password for the server computer),
[Code]...
i have a website www.aybydinnovations.com.I setup a new mySQL Database into my webserver.I am developing vb.et application that will connect into that database from my webserver.
Here is my codes:
Imports System
Imports System.Windows.Forms
Imports System.Net.WebRequestMethods
Imports MySql.Data.MySqlClient
[Code]...
I want to create a software for remote computer Desktop connection(we can see and operate remote computer in our computer display), can any one give Windows itself has a long procedure to do that(Remote Desktop Web connection), sometime it develops security issue, other options are 3rd party. I want to create it on my own.
View 1 RepliesI've been using several search terms, but couldn't find the answer. Maybe it is there and I havent looked good enough. I have a small program to which people can login to. All login info is stored in a simple html page. I manually add the info to that page.
I want to make a 2nd program, that is able to see who is currently logged in into the program. If I click Refresh, I want to let a list fill with all the Usernames currently logged in.
I don't have a clue where to start. I'm guessing making a remote connection between two IP adresses, but if the client programs dont know the IP to connect to, and the host program doesnt know the IP's belonging to the Usernames, Im lost.
[URL]
I have some hosting from [URL] so I set up a mysql db there. the actual db info is:
hostname: db2054.perfora.net
db name: db298669245
username: dbo298669245
[Code].....
The error is get is: "Unable to connect to any of the specified MySQL hosts."
I want to understand the concept of connecting to a remote PC or server. I'm working on an app that will connect to a remote server. Read a value from a registry key and then display the results in a text box. It will also connect and search for a specific log file on a server. I understand how to read the files. I'm just not sure how to connect to a machine remotely if I have valid credentials. There seems to be sever ways to accomplish this. I want the most efficient way using vb2008.
View 3 RepliesI'm been learning about connection strina I have been able to succesfully connect to a sql database stored locally on my Pc.The next logical step would be to connect to a database stored on a remote server. My question is does anyone of a sql database ( or any other type of database ) which can be openly accessed by the general public. Does anyone know if a web hosting service would allow me to remotely connect to a sql database ? Could I for instance upload my database onto a web hosting service and try connect to a remote database that way
View 1 Repliesi am having alot of trouble finding the source code to establish a connection to a remote sql server ( at my university) for vb. All i have is the IP adress and the username and password to the database. I tried coding it with a sqlconnection, sqlreader and a command to execute the statement with no luck.
View 2 RepliesI am making a client/server project where the server can send a String variable to client but for now i'm starting with a simpler code. I was able to code a bit but now i'm having a problem with this UnauthorizedAccessException. It seems that I am not authenticated but i was able to put the admin username and its password. This is my problem.. Here's my code...
[Code]...
I have developed a frontend app using VB 2010 which is to connect to a remote MySQL server. My server has an internal IP address of 202.56.20.72 and an internal IP address of 192.168.20.44.
When I use the internal IP in my connection string and connect over LAN, the whole thing works fine. But when i changed the IP to the external address and tried to connect to the server over the internet, I get an error something like 'Failed to connect to MySQL server for user 'user'@'localhost', [using Password=NO]. This means that for some reason, it is not connecting to the server at all.
I have some hosting from wampserver so I set up a mysql db there. the actual db info is:
hostname: ip address db name: root username: version: MySQL5.0
pw:
VB.net CODE
conStr = "Server=ip address;Database=dbname;User Id=root;Password=;"
or there is another way to connect pc1(server) and pc2(client) using wampserver?
My.Settings.ConnectString = "Data Source=123.132.123.123,3306;
Network Library=DBMSSOCN;
Initial Catalog=Authorities;
User ID=AppUser;
Password=mypassword;"
i need to know what will it take for me to access, insert, update and delete data to a database on a remote SQL Server. I already made some configurations to the SQL Server 2005 that I want to access by following the steps coming from this link -> [URL]. But somehow I am still getting an error. My primary concern is "What connection string should I use on my client VB.NET application to connect to the remote SQL Server?" Since I will be connecting to the SQL Server via Internet and not by LAN, I am wondering which IP Address and Port am i going to put on the 'connection string'? How can i get my 'TRUE' Ip address? Or is there any other way to go through with this? It will be very helpful if you could share your insights and knowledge. Here's my sample connection string:
[Code]...
I need to create a application that will allow me to connect to remote computers and find out the os like w2k or xp so i can run the right scripts for that os.be able to input add an ip or computer name and pass it all scripts like bat, vba and psexec.
I would like to be able to put all util files and scripts in a single dir and have the selected from 2 or 3 differant dropboxs ie... bat's in one droplist and vba's in an other dropbox ect...
have preselected buttons to perform basic function:
1. who is logged on
2. what OS and service pack info
3. connect with netmeeting or remote desk top
4. run a remote command on remote desktop IE.. open with my user account a CMD, Control Panel, Explorer, Explore Network Connections.
have the app ping the pc first to verify connectivity, then execute the script or bat.
My connection to QB online is working fine. It also works for add customers to QB online.When i am passing checks through it gives Bad request error.[code]
View 1 RepliesHere is the final code that worked for me. This uses WNetAddConnection2 to establish a connection first, before using DirectoryEntry.
Imports System.Runtime.InteropServices
Imports System.Net
Imports System.DirectoryServices
Imports System.IO
[Code]...
So I moved the code to an ASP.Net web app, which is impersonating a service account through the Impersonate section of web.config. The account I am impersonating does not have admin rights on any of the workstations so I put in a username/password into the constructor for the computer entry like so:
Dim deComputer As New DirectoryEntry("WinNT://" + Computername + ",computer", username, password).The username is that of a domain account which has local admin rights on every workstation. If I look at the Username property of the resulting deComputer object I can see that the username matches what I entered.Also if I enter in an invalid password it throws an error, so it is authenticating in some fashion.
However if I now try and add or remove a user from a remote workstation I get a general access denied error. If I add the service account that ASP.Net is using as a local admin on that workstation it will add and remove no problem.So next I tried using the LogonAPI (advapi32.dll ->LogonUser call) to login as the user account that is a local admin on all workstations, impersonated the resulting WindowsIdentitiy and tried running just the original deComputer instantiation. When I do this every property, excepty Path, returns an OLE exception..
I'm trying to use LINQ to SQL in Visual Basic 2010 Express.
It allows me to create the .dbml file, but in order to drag items from the Database Explorer window to the design surface, I first have to get my database listed in the Database Explorer!(this is a remote SQL Server database - not a local .mdf)
I already have a good, working connection string to the remote SQL Server database, but that doesn't help me when I'm trying to generate the DBML at design time.
Can anyone tell me how to get my remote SQL Server database identified in the Database Explorere window? When I try the "Add Connection", I am limited to Access, SQL Server Compact, or SQL Server Database File. If I try to enter the IP address & port of my DB Host I get a 'database file does not exist' message. Doesn't seem to want to let me point to a remote DB server...
Recently working in vb 2010 express. I'm using service-based database which is based on SQL Server. This database will be deployed at the server. Is it possible that multiple vb.net programs, which are installed in remote computers or client computers in the same network, connect to this database simultaneously? Does the service-based database support multiple connections?
View 1 RepliesI'm trying to write a method in VB.net so that when I click a button it queries the database and returns all the values which match a textbox which is located next to the button. I have no idea how to do this, I assume in the onclick method for the button I will need to pull in the value from the textbox, connect to the database and display the results to a gridview?
View 2 RepliesI have a database in the same workspace, I've tried to connect to this DB using this codes :
[Code]...
I got vb.net 2008 express and sql server 2005 and 2008 express editions whic I downloaded from microsoft website.Now I just want to connect vb.net with sql server 20o5 or 2008.I am using a connection string as
PubConnstring = "Data Source=RAMANSQLEXPRESS;Database=FirmTest11;Trusted_Connection=Yes"
'Create your connection object
Dim objconnection As ADODB.Connection
Dim strSQL As String
[code]....
Getting Error : [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
I'm having problems connecting to a database. I have sql server 2005 express installed on my PC, and i am using the following to code to connect to it.
Dim nwindConn As SqlConnection = New SqlConnection("Data Source=localhostSQLExpress;Initial Catalog=northwnd;" & _
"Integrated Security=SSPI")
[code].....
Ok I'm finally getting to put on big boy pants and have now moved beyond doing everything in Access (yay me).o here is the problem, can't connect to the Server. created a test button on my form, which is what I usually do with Access so Ican be sure everything is where it needs to be pointing.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connetionString As String
[code]....
is it possible to connect to a database residing on a website (eg., MS Access)to get/update data.can we do it by a VB.net windows application.
View 9 RepliesDim con As New System.Data.SqlClient.SqlConnection
con.ConnectionString = "Server=iraq\sqlexpress ; Database=stats ; Trusted_Connection=True ;"
Dim com As New System.Data.SqlClient.SqlCommand
com.CommandText = "insert into users values('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "')"
[Code]...
There are new events happen when i adjust the connection string
con.ConnectionString = "Data Source=.SQLEXPRESS;AttachDbFilename=C:Documents and SettingsAdministratorMy DocumentsVisual Studio 2005WebSitesWebSite2App_Datastats.mdf;Integrated Security=True;User Instance=True"
show me error with com.ExecuteNonQuery()
I am a wannabe programmer but quite new, started with VB.net about 1 month ago.I write on this forum because It's the first time that I'm actually stuck. The problem is I cannot find a way to connect to SQL server database I have created and saved earlier on my HD using visual express 2010. I want to find a way to connect using code, not by click and drop. I just hope you won't find my issue too trivial to even answer it.The project is very simple, it just consists of a button that should connect to the db on click.[code]
View 9 RepliesToday is my first day trying to use Oracle databases in Asp.NET so I have no idea of what I need to do. I have added this code
[Code]....
I use VB.NET 2010 Express and Windows 7. Access is not installed.The code used to connect database password protected, is:
Public Class Form1
Dim cn As OleDb.OleDbConnection
Dim cmd As OleDb.OleDbCommand
The code is not working. I get this error: "Could not find installable ISAM".
NB: The error occurs only if the database is password protected!For unprotected database, code works without error.
