I'm using Visual Studio 2005 and SQL Server 2000 for my vb.net desktop application..I'm having a SQL Server exception saying that "connection can't be established to the server.hen 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. Also showing
View 2 Replies
This will happen at random, and I can always just catch the error and re-establish connection to the server, but I am confused as to why. When doing lots of inserting into the sql server, I only establish one connection that is public, instead of many little connections. I had my doubts on a public sql connection, but it's been running great, and I've seen no problems until this morning. Again, this random moment I hit an error that stated, sql connection state is broken. Is it bad practice to just accept this error, and when it happens, re-establish the connection?
View 7 RepliesI want to know how to connect sql server 2005 to vb.net windows application
1)is there any connection string ?
2)if so i am using windows authendication in sql server 2005 management studio so am not entering any user id and
password to enter in sql server
3)so what should be the userid and password for the connection string can any one send me a sample code that i can refar
I'm developing a device app in VB.net that will access a SQL Server database. I need to establish a connection when the app is launched, and keep the connection open until the app is closed. I've done the following:In the Master Module:
Public CNN
As SqlConnection
In the Main menu form load:
CNN =
New SqlConnection(sqlConnString)
CNN.Open()
Then when I want to read from the database:
Dim sqlDR
As SqlDataReader
SQL = "SELECT Name FROM Table"
[code]....
When I run the same code without the global CNN, but rather dim the connection inside the Select function, all works well.
i have 2003 access database. why i cannnot connect to my database using the code below?
red
Public BioCon As New Odbc.OdbcConnection
Public GAdp As Odbc.OdbcDataAdapter
red
Public Function Execute(ByVal Qry As String, ByVal Con As Odbc.OdbcConnection) As Boolean
[Code]...
I just can't seem to establish a connection between my two P2P applications over the internet(LAN works perfectly fine).
I have tried the following.
- Disabling Firewall
- Changing Port
The only way I can establish a connection is if I'm connecting to the same computer using the universal IP or the local. Does anyone have a fix for this? Oh and here is the error that I receive when trying to connect over the internet:
System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 255.255.255.255:8787
at System.Net.Sockets.TcpClient..ctor(String hostname, Int32 port)
at P2P_Client.Form1.Msgtxt_KeyDown(Object sender, KeyEventArgs e) in C:\Users\Administrator\Documents\Visual Studio 2008\VB Projects\P2P-Client\P2P-Client\Form1.vb:line 32
i use vb 2008 office 2007 , it's a powerpoint add-in application. I need to use a window form as a bluetooth interface.the working procedure is like that when i click the Enum button, it will help me to search for available bluetooth devices.but now i have an error, it shows "WCL ERROR: Specified transfer is not available"
[Code]...
I have being trying without success to create a program that can establish a SSH connection with [URL] on a changeable post with a set username and password. The program when done will configure IE proxy settings and establish a SSH connection to [URL] to allow the user to browse the internet without restrictions.
View 1 RepliesI'm designing a web service in ASP.NET and VS2008, and am using typed datasets for retrieving table data. These work well and establish their own connections through their associated TableAdapter objects. Edit: I'm using VB, BTW!I am now attempting to run a custom SQL string using a DataAdapter and a Command object, however I need to reference a Connection object in order for the Command to work. What is the best way to handle this?hould I:a) Create a global connection object using Global.asax, retrieving the connection string from web.config? (I've been trying that one already, with not much success)b) Create a class-level connection object using the InitialiseComponent method, also retrieving the ConnectionString from web.config?c) Retrieve a Connection from one of the TableAdapters that I've already created in my typed DataSets?d) Something else I haven't thought of yet?
View 2 RepliesI want to start a new project on PC and Mobile Phone. But i'm still have so many question about the communication between PC and Mobile.
My project List:
1) My idea is establish a connection between PC and Mobile through IP address in first, but my question is 'How to do it' ? izit same like PC to PC by using Winsock open a port to access? i'm using VB.Net 2005 for PC and Net60 for mobile.
2)My mobile phone Nokia 6220 Symbian OS is support GPRS/3G. Since the GPRS/3G can connect to the internet, izit means mobile itself have a IP address and service provider in order to surf the web? So, can i connect my mobile phone to PC through this gateway?
I have a project in Visual Studio 2008 and there is a working data connection to a MySQL database. In other words, I can query the db directly from Visual Studio and it will display the results.
I've tried a couple of approaches that I found online for writing a connection string and accessing the db, but no luck yet.
All I'm trying to do is code a button to query the db and then reset the text property of a label/textbox to display the results based upon another label/textbox value.
The pseudo-code I am imagining is something like this:
Private Sub query_submit_button_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles query_submit_button.Click
result_textbox.Text = SELECT field FROM table WHERE otherfield = key_textbox.Text
End Sub
I didn't see any related questions posted on SO - forgive me if I missed one that already exists and this is a dupe.
What is the correct way to accomplish this?
EDIT
Using MySQL 5.1
I am unable to load the dat into the data Grid. Here is where I keep getting stuck.
dgvOleDb1 = table.Select
dgvOleDb1.DataSource = DataGridViewEditMode.EditProgrammatically
dgvOleDb1.DataSource = ds.Tables(0)
I am confused; I am using VB2010, IBM.iSeries.DB2 on an as400 V5R4. I am trying to establish an OLEDB connection, and return the values from the selected table to a DataGridView. I had one of the admin's make me file named GARBAGE, in the Rprtaccess catalog. In the past, I have been able to connect via access and an ODBC connection. My project is too big for access, and the SQL middleware we have is clunky and not user friendly. This is a program that will generate the SQL statements, specifically the WHERE: clause and populate the datagrid with the selected criteria. In essence I am making a user friendly striped down program, that has variables that are manipulated by the end user, and the rest, referenced tables and libraries are coded.
Imports System.Data.OleDb
Imports System.Exception
Public Class Form11
[code]....
After running the following sub (VS debugger), I try to detach the database in SSMS, but it shows the connection open still and won't let me detach. If I close program in debugger, the database shows no connections. I check the dataadapter's connection in the finally block and is shows closed. What gives
Private Function ClientMasterDBFiles(ByVal MasterClientDBConnection As String, ByVal DBName As String) As DataTable
[Code]...
This emailing code wont seem to work in my program. I get an exception "The SMTP server requires a secure connection or the client was not authenticated. The server response was 5.5.1 authentication required."
Imports System.Net.Mail
Public Class emailStudent
Private Sub sendEmailButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles sendEmailButton.Click
SendMail()
[code]....
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 am tring to make the below application work with SQL Server 2005 Database Currently it works for test.mdb, which is in the same folder with the application. How shoud I modify the MapPath to work with SQL Server.
[Code]...
I am trying to do something fairly simple.. allow my user to import thier data from Excel into SQL Server, where it can be used by the application.To do this, I'm using the fairly simple code that is common everywhere I look:
strFilePath = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fdlgFileOpen.FileName + ";Extended Properties=Excel 8.0"
connExcel = New OleDbConnection(strFilePath)
connExcel.Open()
[Code]...
Now, on my development computer this code works perfectly. The data imports, and I can go on my merry way.
On the TEST computer, this code throws the error: "ODBC -- Connection to {SQL Server} servernamesqlservername failed." This seems very odd to me, because I'm using exactly the same SQL Server and database to interact with the application, and all the other screens in the application work perfectly. The test computer CAN connect to this SQL Server, but it keeps throwing this error whenever I try import data from Excel.I've tried everything I can think of - using the server's IP address instead of the server name, sending the SQL Server administrator data along with the request, taking out the Trusted_Connection=Yes... nothing works. What is going on here? How can this code work fine on my computer, and hiccup on another?
i started programming with .NET (i have express edition) and wanted to make a connection to an SQL Server..previously i had .net 2005 - i started having the issue there - i unistalled it, n installed visual studio 2008. I have installed SQL Compact that came with the .net 2008, and besides it SQL Server 2000.When I try to make a connection to the SQL Server, if server is running I have to stop it and then choose the DB i want to use. (if its running wont let me choose any DB). Then, when i select the DB i need, Im getting this error:
"The instruction CREATE FILE fount SO error 5 (failed to retrieve text for this error.Reason:15105) while trying to open or creating the fysichal file : -path- to northwnd_log.ldf. Cant open the new database -path to northwnd.mdf. CREATE DATABASE discarded.Error while trying to attach a DB automatically named for archive -path to northwnd.mdf. There already exists a database with the same name, cant open the specified file or it is in a shared UNC resourse.File activation error. File name -path to northwnd_log.ldf- might be wrong"And when i try to connect with the SQL compact edition that came installed with the visual studio, im getting this error:"Can not allow access to the file in DB [File name = path to northwind.sdf]"
is it possible to establish if a url exists?
The reason is I want to establish if the server is active or not.
I have many Listviews in my Form and Im retrieving stored procedures to populates my Listviews. Is it necassary to close the connection to SQL Server once I have finished populating my Listviews?The angle which im coming from is that every 30 seconds or so I need to re-populate my Listviews with the latest cut of data from SQL Server therefor Im probably going to slow down my application if it has to connect to SQL Server every 30 seconds to get the latest cut of data... instead of keeping the connection to the SQL Server Stored Procedure live so that I can use some sort of method to refresh the data?
View 2 Replieswhy i'm getting the following error from the code below:
Error Type:
Active Server Pages, ASP 0221 (0x80004005)
The specified 'Import Namespace="System.Data.OleDb" ' option is unknown or invalid.
/default.asp, line 6
[Code].....
I've been trying to make a login system for my application. Which seems to work, but when I try to connect to the database itself, it won't work. I used this code to check the exception:
Catch myex As MySqlException
MsgBox(myex.Message)
That gives this exception:
"Acces denied for user '[my db user]'@'[My IP-Address]' (Using Password: YES)"
The code I use for the connection is:
Dim Connection As New MySqlConnection("server=[The SERVER IP]; user id=[DATABASE USER]; password=[DB USER PW]; port=3306; database=[DB NAME]; pooling=false")
Connection.Open()
MsgBox("Connected")
As you can see, I've tried to change the 'server' part, but it won't affect anything. It will just say my ip address (localhost, I assume) in the exception. Telling me that it couldn't connect to it. Which is not even what I'm wanting to do.
I have installed sql server 2005 in my machine which is installed vb.net 2008. I want my machine to distribute the database to the clients and make it as server.I don't have that much knowledge of how to overcome this issue as i am awfully naive about it.Let me start it here:I have got an application in vb.net...at first i was using ms access database 2007. then decided to switch on to the sql server since i want to distribute the database to the clients who are going to use my application.When i installed the sql server, i imported my access db files onto sql server database. i enabled tcp/ip as enable in the sql server network Configuration. i want use sql server windows authentication as my default user account of my system for the sake to simplify the issue.
Hence, i connected the sql server into the vb.net through the "add new data source".am done with that...the problem is how do i assign the connection string to the vb.net? Or how do i include a connection string in vb.net which tells every other computer that the database data source is in my computer so that every computer can automatically check it in the network.Where exactly shall i put the connection string...as far as my knowledge is concerned for access database, you can easily identify your connection string in project /properties/settings...it goes here and you put your database in any where.And what is the best connection string do i need for sql server 2005..computers are running windows xp.
I making a connection through word 2003 VBA to SQL server 2005 using the following codeDim cn As ADODB.ConnectionSet cn = New Connectioncn.ConnectionString = "Provider=SQLNCLI;Server=LEXAE29150SQLEXPRESS;" & _"Database=MCarter.mdf;Integrated Security=SSPI;"cn.openetc.cn.close.All runs fine up to cn.open.I then get the message error 'Cannot open database "MC.dbf" request by the login. The Login failed'.Tryed websearching but no succes. Been on it a week and the boss is doing his nut. I'm lost and unsure what wrong.The SQL server is set for windows authenticity and SOL Server login.In the MC database under security users my user name (Login) is their and setup as owner and sysadmin.SQLServer is running on the same machine as the word.dot.
View 3 RepliesI using vb.net 2010 and sql server management express 2008. bu I little confused what is wrong with the code for connect sql and vb.net
[Code]...
how to use conection with vb.net 2005 and ms access and also sql server
View 3 RepliesI am wondering if it is possible to perform some SQL command on a datatable. I currently have an application which reads in an excel spread sheet using the excel COM, and stores the data in a object array. The Object array is then used to create a datatable based on user specifications. I have added a number of checked list boxes which are populated with the column names and row number. The user can select what rows and columns that want to see, and the datatable is recreated to their needs and displayed in a datagridview.
Although at the moment the program is fairly simple in design, but I plan to add a bit to it. I am now wondering if you can use an SQL statement to extract a set of data from a pre-existing datatable. Most examples I have seen involve a connection to an SQL server,
I have SQL Server 2008 setup to remote connection. and it works perfect. I can access it from public IP address. [code]...
View 7 RepliesI'm trying to run this code, but it displays the error "overload resolution failed".
[code...]
Here is the full error:[code...]
I'm creating a program in VB.Net that heavily interacts with 2 large MSSQL databases. I do not know a ton of vb and I'm fairly new, but I would assume just having the connection strings in the code and releasing the program it would be quite easy for someone to reverse the program and get my connection info? correct me if I'm wrong. My question is I'm wondering if there is a safer way to use a connection string in my program. Would I just have to encrypt my app? Create a module or dll?
View 2 Replies
