I want my vb.net application to access the sql database from another network segment.I have two network segment, the application program that I made is in 192.168.7.xx segment and the SQL Server 2005 Enterprise Edition is in 192.168.1.xx segment but that application program cannot access the sql server unless I make them in the same segment.
View 1 RepliesI have designed a project that connects to MsSql Server 2008. The local machine that I use to create the software is able to connect to the database but when I try connect from another machine remotely, It doesn't find the server.This is the connection string I'm using Dim Connection As New SqlConnection("Server=MyServer-PC;Database=MyDatabase;Integrated Security=True")
View 3 RepliesI'm having a issue connecting to a SQL server from a network drive. [URL]But i'm not sure how to give my assembly a strong name?
View 6 RepliesI developed a neural network to train for face detection of the extracted images. However my program is built on VB.NET and I need to know the techniques by which I could load this neural network (Exported using NNTOOL) into memory and call it from VB.NET [code]I do not quite understand how this works, any suggestions on whether I could conenct the Neural network to VB.NET using this code and if so could you please explain to me about the Matlab.Execute and Matlab.GetFullMatrix functions.
View 1 RepliesI have an application I have developed which works great on individual PC's. However I've had some interest from a few customers that asked if I have a network version for site licencing.If my app did not save any data or write any reg entries, this might have been ok. But it does to the local computer. I also built in my own copy protection and trial function that stores data in the registry on the local computer.What would I need to do to enable my application to run on a server/network share, so that the only a serial number needed is for the server?
View 3 RepliesI am bignner in vb.net and i have develo[ed a small application of vb forms in which i have use a service based sql server databas(.mdf)i want to make its msi installer last time i have made it and after installation application giving error for connecting to sql server
View 1 RepliesI would like to create a OPC Client... But fist of all how do I connect a OPC-Server to me application. anyone who have done this? and maby hade some sample code??
View 8 RepliesWhat is the output of the following program segment?
[code]...
this is beginner of .NET getting problemin connection with SQL2000 unable to insert data in SQL2000.
View 2 RepliesI am building an app that builds a bunch of cardinal splines by storing their PointF structures in arrays. As the program runs, new points are added to the arrays, and the graphics are drawn to a bitmap. I can let it run for ages and the splines just keep growing like they should with no problems. The amount of points in each spline can grow into the thousands. To speed up execution as time progresses, I don't completely redraw the splines after each pass, I simply draw the last segment of the spline to the bitmap, having let the bitmap 'record' the earlier part of the splines.
But if I pan across the scene or zoom in/out of it, then I DO have to completely redraw the splines, since the size and resolution of the display is limited to its dimensions. Panning works, no problem. But if I zoom in and out of the bitmap with the mouse wheel, after about 14 wheel clicks, I get an "Out of Memory" error. BUT...I have it set up so that whenever the mouse wheel turns, the graphics and the bitmap are disposed so that new ones can be built for the new zoom setting. So why would the program run out of memory when as far as I can tell, I am disposing of all my unused, unmanaged resources on a regular basis?
I have a client/server chat application which I made . My question is how do I make the application work not only Locally but On any other network. I tried putting my IP in the part of creation of the client socket .
View 2 RepliesI am using Microsoft visual basic 2010 and SQL server 2008.I develop a small database application and it run well on my pc.I built and distributed the application to other pc on the same network, but when I run the application from other pc I got error message like this: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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)[code]
View 2 RepliesI am creating a server-client type application that allows the network administrator to perform tasks on remote computers by using TCP sockets (TCPClient and TCPListener).The server application needs to send out a message to a client machine (with client application installed) and from this, the client application will send back the required data (i.e. system info, task progress etc). This part works fine.However, I am having trouble in getting the client application to constantly listen for an information request in the background. It should be listening whenever the application is running. What I want to do is to have an event handler which, when a message comes through, acts upon the instructions to send the relevant information back. The server does not need to constantly listen for data, as it will only receive data after it has sent a request.
View 2 RepliesBasically back in VB6 days, I created several VB6 apps with Access as the backend database. I'd package my Access db file with the application setup, which copied it on to a shared network drive, and then different computers on the LAN could use the same backend database file, and that worked just fine. With SQL and VB .Net, I've done work with a SQL database hosted on a remote server, so you can basically build your query string easily and anyone can connect to it from anywhere, and it works just fine.However, what I'd like to do is have a local SQL express database as the backend for a VB .Net application and make a setup program that can install it in a way that it could be shared on a Local area network, without the user who is installing the application do anything.
I know about building a connection string with the local machine name, but I don't really have any experience with including an actual MDF file with the application. Does anyone know how it works, and is it a better approach? Does it work similar to placing an access file in a shared unc path?I know that ClickOnce (which is awesome) can install SQL express easily on a user's machine. However, the key is that I want SQL express to be installed only on the machine that is going to be the database server in a LAN enviornment, and not on every machine, unless it is neccesseary. And then how does your VB app know how to build the connection string to access the database from any machine on the local share?
How do I, programmicly, connect to a wireless network. I have already got with networks are avalible, now I'm looking into creating a 'Connect' button.
Here is the code I have:
Imports System.Text
Imports System.IO
Imports System.Net.Sockets
[Code]...
Im able to access the internet on my Phone. I made a small app that lets me get to my database hosted by Godaddy. The problem is, unless I have my phone plugged into my computer it says Im not connected to the network. I can show my code if needed, but that has nothing to do with it because the application works fine as long as its hooked to my computer. Any idea on establishing a connection I guess? Im not sure why its not since Im able to access the internet, Im not sure why connecting to the computer makes it work.
View 1 RepliesAbout connecting through lan network with sql. i try all ways but not yet. I depended on another for this by Teamviewer4.0 but he only used sql 2000 and he didn't modify. In last thread . JM advise me " I dont have to change information at client and i only connect string to correct server name but i tried and it is error........" created account of window for user in server ...... -> it is still error.
FINALLY. I am very tired and sad about connecting through lan .( may be using Teamviewer4.0)
In a batch file that logs a user in to a network from a laptop connecting by VPN, the command window displays both the user's login name and the password. Is there some way I can prevent the password from being displayed? How do you hide characters in a command window?
View 7 RepliesI have developed a VB.NET program using a strongly typed dataset. This dataset has its connection to a SQL Server 2008 R2. The software should now be additionally used offline. The database should be exported to a *.sdf database. If no connection to the SQL server is produced, the software have to try to connect to the *.sdf database.I would like to achieve:
1. Export the data in the SQL Server 2008 R2 database to a local *.sdf file.
2. This *.sdf file has to work as an alternate connection string in the strongly typed dataset.
I am writing a small VB 2008 application which connects to a SQL Server 2008 database,which is hosted with Fasthosts in the UK. The connection string I am using is;"connectionString="Data Source=xxx.xxx.xxx.xxx;Initial Catalog=xxxxxxxxxx;User ID=xxxxxxxxxxx;Password=xxxxxxxxxxxx"I can connect to the remote data using the "add data source" within Visual Studio and can preview thehosted data without anyssues however when I try to run the application I get an error stating;"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)"
View 1 RepliesI have this connection string (IP and port number changed)Public ConnectString As String = "Data Source=207.167.717.614,8711;Network Library=DBMSSOCN;Initial Catalog=TableName; User=User; Password=Password;"It does not all a connection, i've opened this port for port fowarding and have unlocked the TCP port of the firewall what else could be wrong?
View 24 RepliesI am using this code to connect to my exchange server using POP3.
I am trying to retrieve an inbox of basically emails that have not been read however, i am just getting a bunch of gibberish and its reading an email.
modify my code to just read the most recent messages.
Try
tcpClient.Connect(hostName, 110)
Dim networkStream As NetworkStream = tcpClient.GetStream()
[Code].....
its been a long time but sincerely, am happy to be back. now i've got a problem on my mind and that is; am trying to develop a database application but i want it to be a console application. the major issue is that i dont know how to go about connecting vb.net console application to sql server or if its possible at all, but am sure its possible in this world of ours...
View 2 Repliesim using SQL Server 2005 as my back end for an information system im currently developing. Im a total beginner with SQL, so i came across a huge blockade.An error appeared while i was configuring my server,"Login failed for 'username'. Reason: Account disabled".i tried searching EVERYWHERE in the net, but nothing helped me.
View 1 RepliesI have installed Visual Basic 2008 express edition, but I didn't get SQL server. Therefore, I installed SQL server 2008 separately, and it works fine..But I want to use the SQL server in Visual Basic, but it doesn't show up when i click Add New Item. Is there some way of connecting VB to SQL server?
View 5 RepliesI 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 trying to develop a multi user application. this is the first time i am doing it. my database is sql server 2005. and using vb.net as the programming language.i have few questions,
1. my database is in one computer. this computer is not actually a database server. it is just a computer. and the database is created in local drive (e:) of the computer. when i develop the application. so, if i am writing an application for the computer where the database is created. i can give the location of the database as my connection string (is there any better way to do this. because there might be problems, if the database location is changed). how can i connect to the database from the other computers in the same network?
2. this is my second question. i have a table which stores customer details (customer id is primary key and its auto number). one customer can have many hobbies. so i took it as a separate table (customer ID as the foreign key of that table) . when i enter data, i use single form to enter the customer details and their hobbies. so when i insert the record into two tables, will the second table take the new customer ID automatically into dat tables customer ID which is a foreign key.
I'm building an application that connects to a SQL Server 2008 database via connection string. The thing is, since the computer loading the app (or the user, in either case) is outside the Active Directory domain, I can't use Windows Authentication to connect to the DB. But when I include the database credentials, it won't let me connect either, telling me that since the computer logging in is from an untrusted domain, access is denied.
The connection string goes like this:
connectionString = "Data Source=" + ServerName + ";Initial Catalog=" + DatabaseName + _
";Integrated Security=SSPI;User ID=" + UserID + ";Password=" + Pwd
[code]......