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'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.
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'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 RepliesI 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 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 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 want to ask what is the difference between oledb connection and odbc connection. I have a case, my office used ncomputing then i have to developed an application using sqlserver 2000 and vb.net 2005, i used oledb connection. When i try to implement it in ncomputing, why user must has admin access level and dbo level in sql server, it seems trouble when all users are admin. But there's a rumor that when using odbc connection, we dont need to give admin access level for users.es.
View 1 RepliesI 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]....
I'm trying to connect to a database and keep the connection open for any amount of user activity/queries within the database. Currently I have a connection that opens and closes for any query (save, update, etc...) which requires the logon process to the back-end every time the user saves etc... Is there a way to simply connect and leave the connection open so there won't be a lag time when running the query due to the logon process? This is what I'm using:
Private sConStrFormat As String = "Provider=TDOLEDB;Data Source=TDDEV;Persist Security Info=True;User ID={0};Password={1};Default Database=bcpm_ddbo;Session Mode=ANSI;"
[Code].....
I am trying to coonect to Oracle 10g database through ASP using ODBC connection. The connection string used is con.Open "DRIVER={Microsoft ODBC for Oracle};SERVER=xxxx;UID=xxxxx;PWD=xxxxx".
This works when I tried creating a macro and also using a vbs script. When run through classic ASP it gives error on the connection.open line.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'. [Microsoft][ODBC driver for Oracle][Oracle]Error while trying to retrieve text for error ORA-12154 /TestSC/a.asp, line 23
The connection is opened when using Ora oledb con.Open "Provider=OraOLEDB.ORACLE;Data Source=xxxx;User Id=xxxx;Password=xxxx". I am using IIS 6.0 and Oracle 10g.
I need to update a database table from a dataset and only have access to the database through an odbc connection. Is there anyway to make this work or do I need to go a different direction to do this ?
View 1 RepliesI'm trying to insert values from my asp.net application into my MySQL database.
On the register page people can fill in Name and Pass and press submit.
Public Function InsertMember(ByVal objMember As Member) As Boolean
[Code]...
with odbc connection in vb.net example i have add button on my database and i want that what ive added will be added on the database with odbc connection.i know how in oledb but im really confuse with odbc
View 2 RepliesI have an excel with 10 sheets, each sheet has a connection stored in it because i am using the ms query to read data from access database. when I code the below, both line are accepted by vb.net (with new or without)
Dim wb1 As Excel.Workbook
Dim wb2 As New Excel.Workbook
Now when I code
Dim wb_cnn1 As Excel.ODBCConnection ' Works Fine
Dim wb_cnn2 As new Excel.ODBCConnection ' Error 'New' cannot be used on an interface.
Q1: Why I cannot create New Excel.ODBCConnection? I have this
Dim xlsApp As New Excel.Application
Dim wb_cnn As Excel.ODBCConnection
Dim wb As Excel.Workbook
[code]....
Maybe because it is read only. I want that because the ms query is hardcoding the path of the access db even if i choose DSN so, if I change the location of the access file the query in the excel will not work, Q2: How I can change the connection in the Excel sheet?
I'm trying to create an ODBC in the registry using VB.NET. I had found some code on the internet(link below) to do perform this function in VB6, but have been unable to find a way in VB.NET.
[URL]
I tried to make my ODBC Connection within the class. here's my class code
Public Class Library
Public Function Seek(ByVal Connection As Odbc.OdbcConnection, ByVal TableName As String, ByVal Field As String, ByVal Index As Long)
[Code]....
Here's my error: Unable to cast object of type 'System.Int32' to type 'System.Data.DataSet'. I am using VBdotNet2005
I'm trying to develop a simple app with vb.net in VS 2010 that could monitor the ODBC connections via DSN made on the macnhine running this app.My scenario is an application (non Vb) running on a workstation that connects to an MS Access database on a network share.
The application (non Vb) connects using a link (ODBC connection via Oracle 10G) to the tables on the Oracle side.My VB.net Application should monitor the machine running the main application for ODBC connections drops and alert me via email for example.My question is where in the framework can I find something to instantiate or reference in order to check ODBC connections states constantly as well as network disconnection issues as well so I can log and /or alert when possible for network problems and ODBC connection problems for all the applications that might run on the host (machine running my vb app).
I m making my semester project on hotel room reservation i want to get all records from ms acess in data grid.
View 5 RepliesI'm connecting succesfully to an Oracle 10g DB with an the Microsoft ODBC for Oracle driver.Regular queries without parameters work fine, but parameterized queries act as if the parameters aren't getting passed in.ex.
--this works fine
Select * from tbl1 where column1 = 'test'
--this doesn't
select * from tbl1 where column1 = ?
--odbc string parameter 'test'
Here's what my connection string looks like:
"Driver={Microsoft ODBC for Oracle}; " & _
"CONNECTSTRING=(DESCRIPTION=" & _
"(ADDRESS=(PROTOCOL=TCP)" & _
[code]....
this is code where i want to insert ConnectionString=<%$ConnectionString =""%>[code]....
I can not connect MySql (SQL YOG) at all to this control, this is prob from .net control and not MySqlMark the thread as answered
I'm using Visual Studio 2005 Pro. I have an ODBC (not OLEdb) Connection to a spreadsheet. Works fine except the first row is missing. How do I stop this behavior? I can see that for OLEdb there is a way to suppress this behavior using the HDR=No parameter in the connection string. When I try that for the ODBC connection, No change. Row Still Eaten. I also went to the HKLMSoftwareMicrosoftJet4.0EnginesExcel registry key and changed the FirstRowHasNames value to 00. No change. Row Still Eaten.
View 6 RepliesWhen connecting to a Sybase ASE database via ODBC using the code below, I'll occasionally get a '[IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed' error. this be caused by my code? I read here that I should be using the 'With' statement instead, but I don't understand how that would affect this.
[Code]...
I need code for opening DB connection using an ODBC data source. then I need to get some data from there to a data set.
View 7 RepliesI'm trying to connect to Transoft U/SQL license using an odbc connection and and odbcDataAdapter. I am using a function to return a dataset into the mainModule.
HTML
dsOMD = getOMDinfo(psSerialNbr)
dtOMD = dsOMD.Tables(0)
The Function code that is being used is as follows:
HTML
Function getOMDinfo(ByVal strSerialNumber As String) As System.Data.DataSet
Dim myconnection1 = New OdbcConnection("DSN=omd.udd;uid=;")
Dim strSQL As String = String.Empty
[code]...
I am getting the following error:
Message: "ERROR [42000] [Transoft][TSODBC][usqlsd]Name expected ([)"
Source: "TSODBCW.DLL"
If I change the code to use a datareader it I can loop through the data but a data reader is not recommended to pass through the layers and so I'm wanting to create a dataset/data table process. Anyone have any ideas why the dataset/dataTable code is not working properly?
I use ODBC connection for my application (controlpanel -> administrativetools -> odbc -> DSN) to sql server 2008, and windows authentication
it works perfect on windows xp,but now I run it on windows7 and sql server 2008 with sql server authentication.when I make the DSN and query the connection its ok and I got this message (TESTS COMPLETED SUCCESSFULLY!)but when I run the application I got this error (ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''. ERROR [28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''.) I think a little more and I found that Maybe my password doesn't save for my user, when I make that DSN?