Does someone here experienced this error: ERROR [58005] [IBM] SQL0902C A system error (reason code = "") occurred. Subsequent SQL statements cannot be processed.sQLSTATE=58005..I'm Trying to make a program that will retrieve data from IBM i Series DB2.I established a code below that will check if the program can connect to the server but the error message above appeared.[code]The error will appear on CheckDB2.Open()
View 2 Replies
I have a chart wich contains a series and I want to determine whether the points are inside or outside the series area.
So I thought that I should find the two X values for the series at the Y value of the point and check if the X value of the point is between them.
I need a series of sentences appear on my screen one after the other. I want to have the possibility of:
1) adding new sentences (as many as I want);
2) make them appear randomly;
3) control the time until the next sentence appears (or may be go to the next one by press of a button) (for EACH sentence(for short sentences shorter for long longer));
4) terminate the operation any time.
I imagine it like this: I start the program/application/file -> first sentence appears e.g. "I like ice cream" (randomly out of those that are in the body of the program or in the outside text file) -> it stays on the screen for 2 seconds (controllable) -> next sentence appears e.g. "Lisbon is the capital of Portugal" -> 2 seconds (controllable) -> "Apple is a fruit" and so on in a loop randomly choosing the sentences until I terminate the run of the program.
So my question is: What is the script? And what exactly do I have to do to realize that? My VB level is: installed it yesterday, learnt how to create a button and make "WELCOME TO VISUAL BASIC 2010" message appear on my screen, search all over the internet trying to solve my problem but found only how to generate random numbers.
Im trying to plot the reading of 20 or more thermocouples in a single chart area.But it seems that the build in charting in vb.net can't handle that. My program just crashes when adding a series somwhere between the 14th or 18th series.Anyone know of any setting i can change or a better charting plugin?
View 2 RepliesI am trying to create a simple form that displays a series of 9 images that will create an animation. the image files are all the same size and spell out a word..
View 19 RepliesI am after running into a problem with a project I am currently working on. I am trying to connect to an Oracle DB. I am running Oracle 10g Express.
Imports Oracle.DataAccess.Client
Module GlobalDefs
Public strSQL As String
[code].....
i have never used visual basic to connect to web pages so i don't know where to start. I want my programme to connect to cleverbot.com and allow me to talk to that bot and let the cleverbot reply back onto my programme. how would i get around doing this?
View 5 RepliesI have created a form that is supposed to fill in the labels with information from a connected database. I have been able to get the PubId field to rotate with the Publishers Names -- dropdown list. However, the rest of the labels do not change as the drop down list name changes.
[Code]...
I'm looking to have a program connect to a specific website, enter data, and then return something but without using the WebBrowser.For instance, I want it to:
Connect to a website
Login to the website
Return if it logged me in or some error
etc
I'm kindof new to VB so I'm not sure how to go about this Edit: I read up a little bit about using WebClient and I understand a small bit of it but not much
Am having a hard time co be connected to sql server 2008 enterprise edition.i am using oledb in this fashion
db.connectionstring="Provider=SQLOLEDB.1;User id=helen;password=123;Initial Catalog=mydb; Data Source=server"
but it gives this error: Login failed for user 'Helen'/ Is SQLclient a must to be connected to sql server?
I have 64bit winform app that is trying to connection Excel 2010 64bit. I researched a lot websites and came up with the following connection string:
Provider=Microsoft.ACE.OLEDB.12.0;data source=<Filename>;Extended Properties="Excel 14.0;HDR=Yes;IMEX=1"
But my code runs I get the following OleDBException
"Could not find installable ISAM."
I've downloaded and installed the correct version of "Microsoft Access database engine 2010".
I am trying connect to a SQL Server database i have created using Visual Basic.Both reside on my local machine (PAUL-PC).Here is what i have done so far but i am missing something (or more worryingly i have got it completely wrong).[code]So i have an MDI form and i want to make a connection to SQL Server when that form loads.I do not want to use a DSN if possible so am trying to use Oledb. Not sure also of the DataAdaptor declaration as in previous versions i used many years ago it was recordset.I would like to use a trusted connection to connect.
View 5 Repliesi am having a issue with my database connection. I have connected the database itself without much issue but i want to be able to edit, add and eventually delete from the atabase using Visual basic interface. This is for an A Level computing course that i teach, i remember a long time ago when i did the course this was fairly simple to do however i cannot for the life of me figure out how to do it at the moment.
View 1 Repliesim trying to connect my vb login/register to my Database/Table on my website.
View 2 RepliesPossible Duplicate: Creating a Serial Port in code in VB.net
I wanna connect RS232 to vb in order to set an input for motor such as the steps and motion. I'm really new with VB. I'm using VB2010 express. Can you help me with the coding?
I want my vb application to communicate with a MySql database on server on a LAN. What connection string can i use? Also, what syntax can i use? My application is installed on many computers in LAN with one central MySql database. I want all data to go to the database.
View 1 RepliesPossible Duplicate: Creating a Serial Port in code in VB.netye. I wanna connect RS232 to vb in order to set an input for motor such as the steps and motion.
View 5 RepliesI have installed Visual Studio 2010 and Oracle 11g in my Window 7. Oracle seem to be fine because i can connect to System user, Create user and create database. But the problem is that I can not connect the Oracle to my VB.net project and there is no System.Data.OracleClient Namespace. Do I need to install Oracle Client in my computer even though i have installed Oracle Server?
View 2 RepliesHaving a bit of a problem connecting to a 2010 access database. Im using the following connection string which works fine for earlier versions of access. Can anyone give me a pointer to where im going wrong. [Code]
View 16 RepliesHow to connect a combo box and an enum which is kept in another class? I have searched google a lot but the only solutions I can seem to find involve declaring an enum with the combo box. I however want to keep my enum elsewhere, not in the main gui element handling form. The closet thing I could guess was:
Combox99.DataSource = System.Enum.GetValues(GetType(MyBookList.OptionsList)
With MyBookList as a previously defined instance of the BookList class.
How do I connect to a mysql database, and write a new column to a certain table there?
View 8 RepliesSo I will be writing a vb program that will need to connect to and display data from a SQL server in a list/dropdown menu. Eventually this program will be ported into a asp.net web app. For now it will be local.
View 8 Repliesconnect to 2 separate databases that control a system of logging in/out and the other a database of items. Think of it like logging in to ebay and searching for items. The only problem is that the x64 computers that will be used to run the final solution dont allow for MS Access databases or SQL databases to work for whatever reason.What other options do we have in order to have an effective system? A series of generated text files with the input registration details is so far the
View 3 RepliesPreviously i used Visual Studio 6 Professional Ed. Now on to 2010 Ultimate.I just want to know how to connect a .accdb (Access 2007 database) in VB 2010 and retrieve/edit/delete records....?
In VB 6.0. i used the code as below to open a .mdb database file....
xyz.mdb contains a table called "pwd" with fields "User" & "pwd"
Public db As Database Public rspwd As Recordset
Set db = OpenDatabase("xyz.mdb", False, False, ";pwd=abc") 'To Open Database
Set rspwd = db.OpenRecordset("select * from pwd", dbOpenDynaset) 'To Open a table as a recordset
I need to connect to an MySQL database in my VB.NET application (VB 2010 Express). When I attempt to use the Data Sources wizard to establish the connection, it does not provide an ODBC data source. I'm using Add New Data Source/Database/DataSet/New Connection which shows the Add Connection dialog. The only options it gives me for data sources are Access & SQL Server and the OLEDB data provider. It does not appear to give me the option of adding a new data source provider. Attached is an image of my current Change Data Source dialog. Where do I get the ODBC data source provider and how do I install it into Visual Studio?
View 3 RepliesIs there any way to have the program still run efficiently when connecting to an mysql database? Would System.Windows.Forms.Application.DoEvents() work anywhere?I have it connecting every 3 seconds on a timer and during that connection the program locks for a second.
View 2 RepliesI am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords. Plan is to host this server so people can login to use the the application and verify they have a valid account. I would like to host all the account information in SQL due to the possiblity of hundreds of users at any given time. I also need the ability to add data to the database for users registering for the first time. The SQL server will need to be able to access the SQL Server databases remote via WAN.
View 3 RepliesHere is the scoop: I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords. Plan is to host this server so people can login to use the the application and verify they have a valid account. I would like to host all the account information in SQL due to the possiblity of hundreds of users at any given time. I also need the ability to add data to the database for users registering for the first time. The SQL server will need to be able to access the SQL Server databases remote via WAN.
View 1 Repliesthere Dream in Code Community! Im an okay programmer as far as skill right now I am still learning as we all are I need some help from some experienced VB.NET programmers in the community, Here is the scoop: I am trying to make a user account SQL database work with Visual Basic 2008 Express for login purposes, i.e. usernames & passwords.
[Code]...
I have a question about listbox. I want to display a series of * in one row. I know I have to use a loop, but I can not have the asterisk lined in one row.
View 3 Replies
