how can connect to sql server 2005 or 2008 by vb.net from anther computer ? and this computer donot have sql server.i made search on internet and result was use sql client tools but i made search and try to download sql client tools but i did not get any result.so how can i connect to sql server 2005 or 2008 by vb.net on anther computer or on network LAN.
View 4 Replies
how can connect to sql server 2005 or 2008 by vb.net from anther computer ?and this computer donot have sql server.i made search on internet and result was use sql client tools but i made search
View 2 RepliesHow can I connect two tables from MS SQL Server 2005 using vb.net 2008?
View 5 RepliesI have a webbased proj. What i need is to connect the vb.net app to an sql server via internet. My projects run fine in a standalone pc.
View 3 Repliesi am new with SQL server 2005 and visual studio 2008.how do i connect the forms and the tables in the database
View 4 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 wrote a program in VB2005. It is a program that is supposed to run in a client computer accessing an MS Access .mdb file stored in the server. The program itself is stored and run in the clients computer. I am not good in networking at all. The way I do it now is:
1. Have a directory made in the server to hold the MS Access .mdb file, and have the directory to be shared.
2. Have the same directory accessed and mapped in the client computer (say to Z:)
3. Then have the program in the client computer simply access the database as if it is in the same computer (as the directory already mapped into the client computer). In the VB 2005, this is done when we set the connection string of the database connection.
However, my user is complaining that by doing so, the database is basically exposed to the operator of the client computer (through the mapped directory), hence more vunerable for any bad intentions from persons who may have access to the client computer but not the server. He insists that he used to have a program that does exactly the same thing like my program, but the database is shielded in the server, where it cannot be seen in the client computer (I have other people who confirm that this can be done, though they can't tell me how, since they are not programmers themselves). Now, I have no idea on how to connect a database that way, and I don't even know where to start looking.
How can I write a connection string? I has four different computer that can be connect via ethernet.How can I maintain a inserting data if to computer insert on same table at a single time..??
View 1 RepliesI'm trying to connect to a sql server 2005 database. I'm using the following connection string.
Dim cnn As OleDbConnection = _
New OleDbConnection("Provider=sqloledb;Integrated Security=SSPI;Initial Catalog=Iconics")
Using this connection gives me the following error :
Error : Microsoft OLE DB PROVIDER FOR SQL SERVER : [DBNETLIB][Connection open(connect()).]SQL Server does not exist or access denied.
Does anybody know what is wrong with this connection string.
I can connect to both databases with SQL Server Enterprise Manager, so I know the servers are up and available. One of them is SQL1, the other is SQLTEST.In my program when I use the following connection string, it work connects just fine:
conn = New DBConnect("Data Source=SQL1;Initial Catalog=SignInspection;Integrated Security=SSPI")
However, if I change SQL1 to SQLTEST the connection times out I don't get any errors other than the timeout error.I can run the profiler on SQLTest and see that it is most definitely NOT even attempting to connect.
EDIT:Well, it's a moot point now because I got authentication working properly on our SQL1 server.
First off, the web server is running IIS and .NET. Users are logged in to the intranet using Active Directory, and the .NET page needs to retrieve their log-in credentials (username most notably). The database is SQL Server 2005, running on a different machine. But the .NET app needs to impersonate as another user to connect to the database.
To successfully do both of these things go to Windows > Run, enter inetmgr and hit run. Navigate to the site and right click > properties, then click on the tab titled Directory Security, click Edit.., make sure only Integrated Windows Authentication and Digest authentication are enabled. Enter your proper AD realm and click OK. Apply the settings/hit OK.In web.config you need the following lines
<authentication mode="Windows" />
<identity impersonate="true" username="myDomainMyUserName" password="123mypasswordgoeshere">
replacing, of course, myDomainMyUserName and 123mypasswordgoeshere with the username and password that has login rights on both your domain and your sql server. The connection string can probably be modified, but this is mine and it works:
Server=SQL1;Database=SignInspection;Trusted_connection=True;
ive been using vb6 and i just want to learn vb.net 2005... the problem is i dont know how to conect sql server with the form what should i do?
View 3 RepliesI need a bit of advice. How do I connect to the proxy server using the code on below?
Public Function ProxyServer(ByVal URL As String, Optional ByVal UseProxy As Boolean = False, Optional ByVal ProxyAddress As String = "", Optional ByVal ProxyPort As Integer = 0, Optional ByVal UserName As String = "", Optional ByVal PassWord As String = "", Optional ByVal Domain As String = "") As String
[Code]...
i have a microtek server for supplying internet to many pc's i need to control program orders with vb.net 2005 through something called ssh
View 9 RepliesI 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].....
heres my connection module
Imports System
Imports System.Data
Imports System.Data.SqlClient
[Code]...
I have built a client-server VB.net inventory application for our company which connects to our Server machine running on Windows XP. We have 6 client machines running also on Windows XP that connects to the Server's database. Now, my problem is, "How do i connect a client machine running on Windows Vista to our Server running on Windows XP wirelessly?"
- Is there something I have to alter on the SQL Server Surface Area Configuration?
-Or do I have to change the 'Connection String' on my software application so as to properly connect to the Server from a Vista mahine? If then, how?
This is the error its throwing:"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)"
At the momment of the creation of the my connection string a receive the following error:
Format of the initialization string does nor conform to especification starting at index 144
Tell me if I want to run a project that is created in vb.net 2010 and uses a backend SQL Server 2005.........how many changes can be done in a project to run on another computer....?what connection string I can write for it.......?which software do I need to install on the other computer to run a project on it.......
View 1 RepliesI installed MS-SQL Server 2005 Express edition at my home and I want to connect my database from office by using VB/VB.net.
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 want to know how to connect to a remote system having some shared folder.(ex, \myservermysharedfolder).Actually, I was supposed to copy a particular file which is available in a shared location of a system. To copy that file, first i need to connect to that system with an user id and password.I know copying of file (), But not getting clear idea on how to connect to the shared folder. I have tried with System.Management class, but no use..
View 2 Repliesi'm using Visual Basic 2008 Express and SQL Server 2008. I have created a database using SQL Server 2008, but when i try and connect to the data source within VB 2008 there is no option for Microsoft SQL Server(SQLClient)
when i go to add References to my project System.Data.SQLClient is not available.
I have a database on SQL Server 2008 and am trying to run code on Visual Basic 2010 to connect to it. I have the following code but am getting the error 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) on the line SQLConn.Open(): [code]I have been working on VBA code and know the serverinstance and database names are correct. Not sure why it's not working under VB.NET 2010.
View 2 RepliesI'm trying to develop a windows application where i can get connected to remote server and look for process state going in remote server.We have many remote servers where automatic installation of software going on. We have an xml file(installstatus.xml) where it tells us at what stage the installation is (Example : Inprogress , Completed, Failed.)
So our aim is to develop a windows application where i can get connected to that servers and look for their installation status(may be we can use installstatus.xml to look for installation status). Every time i connect to a server, the server information should get stored in XML file(i want to create a xml file where all the servers list i connect to should get stored)
The UI at left side should will have list of servers i can connect to. When i get connected to server, at right side of UI, i want to display the status of installation (In progress, failed , completed).
Can i connect VB.net 2008 (Professional Edition) and Sql Server 2000? It was working fine earlier in vb.net 2003 and sql 2000 My OS is windows 7
View 2 RepliesIs there any possibility to develop an application using Visual Basic that connects to a unix server (using SSH) and run some commands? I will try to describe what i need : The user should enter the server adress, username and password!Than the user must enter some "filenames" and after pressing a button the application will run a command (e.g more "filename") and generates an output file with the result of his command!
View 5 RepliesI am trying to connect to SQL SERVER 2008 from vb.net but failed with Error 40. If I try to connecton to serversqlexpress, error 26 is raised.
View 1 RepliesI'm supporting an old vb.net program whose database it connected to was moved from SQL Server 2005 to SQL Server 2008. Is there a setting on SQL Server 2008 which will allow ODBC connections to access the database but not allow VB.NET to connect to it programmatically?
[Code]...
I have a problem with a connecton from VB.Net to SQL Sever 2008. My code like this:
[Code]...
how can i connect my login form to my sql server 2008, only members of my project is able to sign-in, i want my project to have authentication. can i do it with a stored proc?
View 1 Replies
