Forum

Posts

RECENTLY INDEXED PROGRAMMING SOLUTIONS OF Oracle


'{MySQL ODBC 3.51 Driver}' provider is not registered  

G'day, No error information available: REGDB_E_CLASSNOTREG(0x80040154). The '{MySQL ODBC 3.51 Driver}' provider is not registered on the local machine is the the basis of my error essage despite having installed it (twice). Am I missing something? There are so many potential... Continue Reading
Views : 162
Wednesday 21st of November 2012

Connection to Oracle9i  

I'm trying to connect to oracle from this page, but i got an error I'm Running XP home edition with WebMatrix Version 0.6 (build 0.812) and .Net framework 1.1, is it possible to connect to ora9i from the Webmatrix WebServer?, do you think that the problem it's that the... Continue Reading
Views : 59
Wednesday 21st of November 2012

I think that this is basic.....  

But I am still struggling !!! I have built a section of code that works fine inside a click event of a form button to run a stored procedure, however, I want this to work inside a class that can be called on deman. However when I move this code into a public sub procedure of... Continue Reading
Views : 139
Wednesday 21st of November 2012

Assembly registering with C# for OracleClient.  

Hi, First of all I am not using Visual Studio.Net. Everything is notepad and command line. I am totally new to this so please excuse my stupidity! I have stolen some code out of a book to connect to an Oracle database but have amended it to use another provider as my Oracle... Continue Reading
Views : 938
Wednesday 21st of November 2012

1 Dimensional Array  

I have tried to create an add entry form for a page made with ASP.net (VB) and MYSQL. I have managed to get something working with edit / delete, but when I try and add an entry with this page I get the following error. Continue Reading
Views : 164
Wednesday 21st of November 2012

Oracle Helper class  

Hi all, I remember someone creating an oracle helper class something like the SQL helper class a while back but I can't remember where I saw this or even who did it. If you remember this and know where it can be found, I would appreciate a link. Thanks Bruce Continue Reading
Views : 212
Wednesday 21st of November 2012

DATEFORMAT Q  

I have a table containing a DATETIME field. How can I in my SELECT use DATEFORMAT to retrieve only the parts of this DATETIME field that I need, i.e. just month and day with a "/" between, or just hour and minutes with a ":" inbetween? /Raymond Continue Reading
Views : 105
Wednesday 21st of November 2012

Problem with OdbcParameter and DataReader - Help  

Hi Can some one help me with this one? We try to used OdbcParameter and it's not work why? ODBC Driver "MySQL ODBC 3.51 Driver" Code attach: Dim?sSQL?As?New?System.Text.StringBuilder ... Continue Reading
Views : 45
Wednesday 21st of November 2012

Live version of site can't find database  

Hey guys, I have just started learning how to use MySQL, and I have just uploaded my first site which was working fine on my computer, but for some reason now that I have uploaded the site, it doesn't seem to be finding the database. The connection string that I am using is... Continue Reading
Views : 64
Wednesday 21st of November 2012

Connecting to ASA 8.0 or 9.0  

With ASP.NET I would like to retrieve data from a Sybase Database using ASA 8.0 or 9.0. Anyone been successful at doing so? Continue Reading
Views : 63
Wednesday 21st of November 2012

can't connect to Oracle in the solaris 5.6  

dear all : My Database is running in the Solaris 5.6 , my acount belong to DBA Group but when I used Sqlplus to connect to database , system give me error ! why ? my operation is as following : szsun12{spcadmin}4: id uid=1003(spcadmin) gid=400(dba) szsun12{spcadmin}5:... Continue Reading
Views : 124
Wednesday 21st of November 2012

can't load oci.dll  

I use ado.net connect oracle database in my asp.net application, but cant connect the database,it reports can't load oci.dll, but I use sql plus to connect the database ,it works well, who can give me a idea? thanks a lot! Continue Reading
Views : 180
Wednesday 21st of November 2012

Problem -> can't find table using ODBC  

Hello, I'm using an ODBC connection to my database. This connection works and is set correctly. In my program i'm using IAnywhere from Sybase. The problem is that when I'm trying to get data from de database it doesn't work. Can't find table. The code I wrote is correctly... Continue Reading
Views : 71
Wednesday 21st of November 2012

Can't See Synonyms  

I was under the impression that when a synonym of a table was created and made public, then all users could see and use the table. I have created an account with connect privileges which cannot see tables in another account which have public synonyms. My account "Team" has... Continue Reading
Views : 56
Wednesday 21st of November 2012

Could not find installable ISAM  

I am trying to get the data from a dBase database but I get this error: "Could not find installable ISAM". Here is my code so I am wondering if I do something wrong. Thanks Dim?strMyConnection?As?String Dim?strSelect?As?String ... Continue Reading
Views : 103
Wednesday 21st of November 2012

Connection Pooling  

I'm a newbie, and I'm wondering about the steps i have to do to enable Connection pooling in my web application, I'm using OracleClient class to connect, but I don't know how to set up the connection to enable connection pooling. Does anyone have tried to do that, or have... Continue Reading
Views : 93
Wednesday 21st of November 2012

Inserting Records  

I have this code that should insert records: But i get this error: Server Error in '/' Application. -------------------------------------------------------------------------------- ERROR [23000] [MySQL][ODBC 3.51 Driver][mysqld-4.0.16-standard-log]Duplicate entry '000255'... Continue Reading
Views : 42
Wednesday 21st of November 2012

For a MySql Expert  

As you can see I am trying to make a bussiness object with an ODBC Connection and I am using MySQL. Where the problem comes in though is the "objCmd.Parameter.Add(objParam)" Now that actually works with an oledbConnection, but not odbc, can anyone else tell me how to fix... Continue Reading
Views : 102
Wednesday 21st of November 2012

How to use ODP.NET on aspx page (not in compiled code-behind)  

Hi Folks. I'm trying to use the ODP.NET provider in an .aspx file in a block. The page is not part of a "project", does not have a code-behind page, is not compiled, and I am not using VS.NET for development. Continue Reading
Views : 255
Wednesday 21st of November 2012

stored procedure  

does mySQL 4.1 support stored procedure? Continue Reading
Views : 81
Wednesday 21st of November 2012

Connecting to an Oracle Database  

I try to create a connection to an oracle database throught asp.net and net framework 1.1, but I get the following error : Erreur de compilation Description : Une erreur s'est produite lors de la compilation d'une ressource requise pour r?pondre ? cette demande. Veuillez... Continue Reading
Views : 57
Wednesday 21st of November 2012

FoxPro table posted on other computer  

Please help and tell me why if the data is posted on other computers the result of ?test_director? and test_driver functions is ?? does not exists? call test_director("\\com\com1\931") call test_director("z:") call test_director("o:\931") call test_director("c:\931") call... Continue Reading
Views : 112
Wednesday 21st of November 2012

Retreiving data (string type) from Oracle Database and store into ArrayList  

Hi all, I'm developing a web application that has a lot of database interaction. I know how to insert data into a Oracle Database, and retrieving data from Oracle and store into a listbox/dropdown etc. Now I've come to a situation that I have to retrieve all data from a... Continue Reading
Views : 84
Wednesday 21st of November 2012

OLEDB data reader not reading Extended ASCII values properly  

In our intranet website Login passwords are encrypted using a function in Login.asp and stored in Oracle database. When a user logs in his password information are retrieved from the oracle table with recordset object, then we encrypt the password entered by the user with... Continue Reading
Views : 118
Wednesday 21st of November 2012

100% Free - Generate your C#/VB.NET business entities and stored procs  

See MyGeneration Software Continue Reading
Views : 132
Wednesday 21st of November 2012

invalid port number  

I'm getting back an invalid port number when I try to connect using the sybase ASE provider. I do have the follow in my connection string server port Address = 5000 anyone run into this problem??? Continue Reading
Views : 137
Wednesday 21st of November 2012

MySQL Tables  

Hi everyone, Does anyone has any idea to share with me how to retrieve all the tables in particular MySQL database? Please kindly include the code(VB) Thanks, *EverLearner* Continue Reading
Views : 78
Wednesday 21st of November 2012

Oracle Connection Open error  

hi everybody, i have oracle 8.1.7 installed on my server machine. but i am trying to connect, its giving me this error "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater" I am giving my constring as : strCon = "Data Source=dbname;User... Continue Reading
Views : 39
Wednesday 21st of November 2012

Error when i try to update fron dataset  

I get a row from the data base to my dataset and make few changes in the row. When i try to update the row in my data base using dataset i get error: "System.Data.DBConcurrencyException: Concurrency violation: the UpdateCommand affected 0 records." here is the code: My conn... Continue Reading
Views : 167
Wednesday 21st of November 2012

using sqlldr with c#  

is anyone familiar with calling sqlldr from a C#.NET web application The user is going to upload a file, and when done, my application will load the file into my oracle db using sqlldr. Any help is appreciated Continue Reading
Views : 152
Wednesday 21st of November 2012