Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    Visual Basic




How To Connect Vb 6.0 And Oracle 10G ?remember Its A Client Server Kind Of Thing


hello everybody,

                        How can I connect VB 6.0 and Oracle 10G ? Its like client and server connection where i will need a connection string as told my professor but please tell me the whole procedure for connecting them as I am totally new to it. So please dont say that its same as vb and oracle 9i please give me some proper guidence thanks everybody




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
Connect From Server To Client
hi everybody i need some ideas how can i create a connection from server to a client modem
is there a dll that handle it or activx or something like that thanks a lot
regev

How To Connect Client To Server ?
Hi everyone,

                  I want to create client-server program for a local network game centre.
 
                  I want to make report of what client used what programs and limited access of program usage to client.

                  Plz help.

                              Thank you very much.


                      $t@t!c.

VB Oracle Client Server
Please advice me on a good book that deals with Visual basic and Oracle combination. So far most of the books relating to data access with VB deal with either SQL Server or MS Access

Client Wont Connect To Server..
Hello, im having a little winsock problem, and another form problem.
i would be very pleased to get answers to this.

1. i made a server, that listens on port 8000. i am behind a firewall but already opend the port 8000. but (even from my own computer) the clinet gets an error Timed out. how is this possible?

2. When i open a chatwindow in the server (yes, server can speak to.), it goes like msn. and i use the code:

Code:
set form = new form4
load from
form.show

but when i get a message, how do i retreive this form again? the title is (IE) "Ivan - Coinversation", do i do it with findwindow and stuff?

thnx in advance.

Client Won't Connect To Server At Startup
hi everybody. I 'm working on a client - server app and i want to make client run at startup and "connect" to the server. i have a timer in client that every 5 secs checks if a connection is established or else prepares the client to do so. my problem is that when the client starts with windows never connects to server. it is like the timer never works.
i 've put a shortcut in startup folder, i've tried registry (current user,local machine). in all those cases the client starts with windows with no problem BUT never "finds" the server. if i terminate client and run it again then it "finds" server at once!

does anybody knows why client behaves differently when starts with win and differently when i start it? i guess that this should be a time issue (something is not loaded yet maybe) but i don't know how to deal with it!


Code:
Private Sub Form_Load()

Dim ServerRemIP as integer
ServerRemIP=23232

' .ini
strApp = "Client"
strDefault = ""
strLength = 2000
strIniFile = ".client.ini"

' read server ip from .ini
strReturn = String(2000, 0)
strKey = "ServerIP"
lngResult = GetPrivateProfileString(strApp, strKey, strDefault, strReturn, strLength, strIniFile)
strReturn = Left(strReturn, lngResult)
ServerIP = strReturn

sckServer.RemoteHost = ServerIP
sckServer.RemotePort = ServerRemIP

tmrConnect_Timer
tmrConnect.Interval = 5000

End Sub


Code:
Private Sub tmrConnect_Timer()

If sckServer.State <> sckConnected Then
If sckServer.State <> sckClosed Then sckServer.Close
sckServer.Connect
End If

End Sub

How To Connect Client To Mysql Server?
hi all,

i just wanna ask about database connection from user's pc to database on developer's pc.i've install the system on user's pc but when i run it the error "Database name is incorrect"occured.so,what can i do to connect the system installed on the user's pc to the database on the developer's pc?for ur info,i am using VB6 with Mysql+Mysql 3.51 ODBC Driver version 5.0 .is there any site which i could refer to?plz help,tq in advance

i've try it in connectorODBC i've set ConnectorODBC as below:-

For develepor's PC:-

Data Source Name: AlertData
Server:localhost
User:root
Password:
Database:licencealert

For user's PC:-

Data Source Name: AlertData
Server:192.168.100.111
User: Lina
Password:
Database:licencealert

when i try to run the system in user's pc an error "Request returned with SQL error" has occured.what can i do to solve the problem?please help..tq..

How To Connect Client To Mysql Server?
hi all,

i just wanna ask about database connection from user's pc to database on developer's pc.i've install the system on user's pc but when i run it the error "Database name is incorrect"occured.so,what can i do to connect the system installed on the user's pc to the database on the developer's pc?for ur info,i am using VB6 with Mysql+Mysql 3.51 ODBC Driver version 5.0 .

picture below is my setting on Mysql connector ODBC.localhost and root is the developer's machine server n user name.when i try to open the database on developer's machine from client machine the error"Database name is incorrect"occured.anyone know about this?please help me..tq in advance

Client/Server How Do I Know If Connect Attempt
Hello,
     I don't know much about using the winsock control; anyway, I'm making client/server applications, I can do the client app and I know how to code that, but for the server app how will it know what to connect to if a client is trying to connect to it? and set its port and remote IP settings? By the way: there is only 1 server and one client but the client is portable (on a floppy).




BoyIdiot

I never think of the future - it comes soon enough.
Albert Einstein
  

Connect MS Access In A Server From A Client Within A LAN
I have implemented a VB program(VB6) that connect to a database(MS Access 2000).
I have sccussfully finished the program 'locally', ie. program and database in the same computer using the following connection string...
Code:constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.Databasesource.mdb"
Now, I want to put the database in the server that is within the same LAN. What should I change in the connection string in order to do so?

Client Vb Connect To Server Java
Hi.
I have a vb6 client that have to store data to a oracel db. The access method to db are implemented into a jeb3 container server side.
This client must call the ejb method to strore the data.

How can i do?
:-(
Sorry for my english

How To Connect Web Server DSN From Client Side Vb App.?
hi,

In your web site it had DSN named with testdsn it includes server username and password..

How to connect the Web Server System DSN from local machine using with vb.

Please advoice me

Thank in advance.

K.Babu

Connect Client With Program VB6 To Server With SQL2005
Hi guys,

I have a sofware developed with VB6. It was working connected to a server with SQL2000. Now the servers has migrated to SQL 2005 developer edition and now I cannot connect to the database. (OLEDB error)

Is necesarry to install any client/software of SQL2005 in the client PC?

I tried installing last release of MSDAC and doesn't work.

best regards,

Server Will Not Connect To Client - Winsock Error 0?!!
I am having a problem here.

I have a server program set up to connect to its client as soon as the client connects. The client connects fine, but apparently the server listener's Connect event isn't firing, because I'm not getting a message on the client saying we're connected. I paused the program, and did a wskServerListener.State check, and it was in error. I checked what the error number was, and it says Error 0, and will not give me an error description. Take the error handler out, and I get the error "Invalid operation for current state, and wskServerListener still reports that it's in error.

This is the code that connects to the client as soon as the client connects to the server.


VB Code:
Private Sub wskServerListener_ConnectionRequest(ByVal requestID As Long)    wskServerListener.Close    wskServerListener.Accept requestID    rtbServerMessages.Text = rtbServerMessages.Text & "A client has connected" & vbNewLine    ColorServerMessageLines    If Not wskServerConnector.State = sckConnected Then        wskServerConnector.Connect wskServerListener.RemoteHostIP, 350    End IfEnd Sub


This is the code that handles the connection request to the client.


VB Code:
Private Sub wskClientListener_ConnectionRequest(ByVal requestID As Long)    wskClientConnector.Close    wskClientConnector.Accept requestIDEnd Sub


And as you can see from this code, I do have it set to listen on the correct port, 350.


VB Code:
Private Sub wskClientConnector_SendComplete()    If Not wskClientListener.State = sckListening Then        wskClientListener.LocalPort = 350        wskClientListener.Listen    End IfEnd Sub


Upon connection, the client sends your username to the server for identification like this.


VB Code:
Private Sub wskClientConnector_Connect()    wskClientConnector.SendData "USER " & txtUsername.TextEnd Sub

How To Connect All Possible Way Of Oracle And Sql Server With Visual Basic Using ADO
Hi,

I am trying to use oracle8i and SQL SERVER2000 in my visual basic6 application.

I need to make connection between oracle and visual basic and sql server and visual basic

Please help me out all possible way of connection.

Thanks.

How To Connect Oracle Server (Crystal Reports 8) With VB 6
Hello everyone, I need your help.
I need to make a report in a Vb's project using oracle server of Crystal Reports but I don't know how to establish the cennection into VB, do you know how is the connection string that I have to introduce in the code?????

I appreciate your help.....thanks a lot

How To Write The Log On Parameter Using Vb Connect A Oracle Server To Print Crystal Report?
Hi
I would like to ask a question how to write
the log on parameter using visual basic
connect a oracle database server to print a
report using crystal report?

When i click the button to print a report,
it message me incorrect log on parameter?

thanks

Hi Quick Thing, Cant Remember How To Generate A Random Number :S :P
Hi, can someone quickly tell me how to generate a random number, my mind has gone blank...

Thanks, Lana

Thing On A String Physics (kind Of)
Part of a game im working on involves use of a 'tractor beam' kinda thing.. so i wrote a bit of code to test out some ideas.

the physics are by no means perfect, but if you can use any of it then feel free. also included is clsFPSCounter a class i wrote for making time based code (such as this) a bit easier.

A Me.caption Kind Of Thing For Cmd Buttons...
Is achieving this affect possible? Is there any way to handle a button being pressed's properties? The only reason I ask: I'm going to be recreating the same code 36 times for 36 buttons, only changing the object name every time.

An Internet Chat Kind Of Thing. Something Like Aim
I have no idea how to make such a thing but i heard there is something called winsock. I have no idea what it is or what it does. I am wondering if you could make a program and have it on 2 computer so that you can talk to someone on the other computer or send files to the other person. Is this possible? Would you have to connect through the modem or be on the internet and then connect to each other?

An Internet Chat Kind Of Thing. Something Like Aim
I have no idea how to make such a thing but i heard there is something called winsock. I have no idea what it is or what it does. I am wondering if you could make a program and have it on 2 computer so that you can talk to someone on the other computer or send files to the other person. Is this possible? Would you have to connect through the modem or be on the internet and then connect to each other?

Making A Telnet Client To Connect To Microsoft's Telnet Server
Hello,
I am trying to make a telnet client to connect to Microsoft's Telnet Server. I can get it to connect but the first thing that is received from the server is garbage "%" why am I receiving that? Here is the code I am using:


Code:

Private Sub cmdcon_Click()
wsck.Close
wsck.RemoteHost = txthost.Text
wsck.RemotePort = txtport
wsck.Connect
DoEvents
End Sub

Private Sub cmdsnd_Click()
wsck.SendData txtsnd & vbCrLf
End Sub

Private Sub cmdstat_Click()
MsgBox wsck.State
End Sub

Private Sub wsck_DataArrival(ByVal bytesTotal As Long)
Dim data As String
DoEvents
wsck.GetData data
txtrcv.Text = txtrcv.Text & data
End Sub

Thanks for any help
Ben

Winsock, I Made A Server-Client... Now I'm Trying To Make A Server-Client+++
Trying to get this Winsock Chat thing to support more than 1 person. I don't know at ALL what to do... Could anyone push me in the right direction?

Also, I need help getting screen names to work as well. Thanks.

As you will see, I attempted to add multiple connections myself... I failed. =[

I'm using VB6.

Code:Option Explicit
Private Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, lParam As Any) As Long
Private Const EM_LINESCROLL = &HB6
Dim ClientNum As Integer
Private Sub cmdSend_Click()
    Dim strdata As String
    strdata = "Server : " & txtmsg.Text
    tcpServer(0).SendData strdata
    Text1.Text = Text1.Text & strdata & vbCrLf
    txtmsg.Text = ""
    SendMessage Text1.hwnd, EM_LINESCROLL, 0, 10
End Sub

Private Sub Form_Load()
    Dim s As String
    s = InputBox("Server Port Number: ")
    tcpServer(0).Close
    tcpServer(0).LocalPort = s
    tcpServer(0).Listen
End Sub

Private Sub Form_Activate()
    txtmsg.SetFocus
End Sub

Private Sub tcpServer_ConnectionRequest(Index As Integer, ByVal requestID As Long)

    If Not tcpServer(0).State = sckConnected Then
        ClientNum = ClientNum + 1
        tcpServer(ClientNum).Close
        Load tcpServer(ClientNum)
        tcpServer(ClientNum).Accept requestID
        Text1.Text = "User has entered the server..." & vbCrLf
        SendMessage Text1.hwnd, EM_LINESCROLL, 0, 10
    End If
End Sub

Private Sub Form_Unload(Cancel As Integer)
    MsgBox "Wanna-Be AIM"
    tcpServer(0).Close
End Sub
Private Sub tcpServer_DataArrival(Index As Integer, ByVal bytesTotal As Long)
    Dim strdata As String

    tcpServer(0).GetData strdata
    Text1.Text = Text1.Text & strdata & vbCrLf
    SendMessage Text1.hwnd, EM_LINESCROLL, 0, 10
End Sub

[resolved, Kind Of] VB Stop Responding When Winsock Tries To Connect
Here is how it goes: I've got a simple chat app that uses MS Winsock control for TCP communication. The first time I run the app from VB its all OK. But, when I exit the app (normally, not break), return to VB, run it again, it crashes (app & VB stop responding and need to be killed) when Connect button is clicked. When runing it as an exe when its built everything is OK.

Any ideas why this is happening?

Accessing Oracle From Std VB6 Exe Without Oracle Client
Is it possible to access Oracle database using VB6 std exe without having the Oracle Client Installed on the client machine.
The oracle server resides on a UNIX/SUN machine.

Currently I'm using ADO, MDAC 2.5 without a DSN. It uses tnsnames.ora

Anyone Remember IRC Server Of VBforum ?
I'm sorry for such nutty question... but i've stroll around and didn't find any clue of it. thanx

p.s. :
1. i don't know either where should i post this
2. Could anyone help me with hexagonal problem in graphic and interface

Is Access Client Server?? What Is Client Server?
If I use visual basic to query an Access 97 database, this is what I find:

The SQL query only selects one number from a large table - ie the total info required is 4 bytes.

However, when I analyse the network traffic to my computer I find that 17,000 bytes get downloaded when running this query.

I am using ADODb connections and coding them manually in visual basic. I do not know if this is relevant, but my question is:

I thought using client server that all that went up the wire was the SQL statement and all that went down the wire was the resultant data.

Is this just Access? Does a query have a minimum package of 17,000 bytes? Anything I can do to make the performance better (as my application has to run over a 56K line)?

What about if I used SQL server?

Oracle Client
hello is oracle client needed for a vb 6.0 app to connect oracle database.
let me know

Connect To Oracle.
Hi there,
When I use an ADO to connect to Oracle I get an error "Connecting failed while initializing provider ORA-01019". Does anyone know while this error occurrs and how to correct it.

Thanks in advanced.

Is Is Possible To Connect To Oracle With DAO?
Before I start to beat my head against the wall, is it possible to connect to Oracle databases using DAO?

The client does NOT want to install MDAC on all the client machines.

In other words, is it possible to connect to an Oracle db without using MDAC?

Cheers

Swiss

How To Connect To Oracle 10g XE
Dear All,

How to connect to Oracle 10g XE ? .. I didnot find correct connectionstring..

please help

TIA

Winanjaya

How To Connect Oracle And Vb Without A Dsn
Hi,

I heard there is a way to connect oracle and visual basic without using a DSN.

Will you let me know , please


shoba

Connect To Oracle
I have Visual Basic installed on my system
I have an application which can be used where Oracle client is not installed.
Would my application still run on that system?
What are the possible alternative solutions?
San

How To Connect VB To Oracle
Hi everybody,
Friends please can anybody explain me the what r th procedures to connect VB to Oracle, I have VB6.0 and Oracle i my PC, I am doing a project in VB, for that I need to connect i with the Oracle, please explain me the connection with code an concept. Please friends urgent.

Kanth

Connect To Oracle From VB
I have Visual Basic installed on my system
I have an application which can be used where Oracle client is not installed.
Would my application still run on that system?
What are the possible alternative solutions?
San

Connect VB Through Oracle 9i
Hi,

How I connect to Remote Oracle Server (installed 9i server on windows 2000 server) from Client PC (Installed VB 6 on window XP) by using ADO

Remote Oracle Server's IP = 192.168.30.1, Name = ServerPC, SID= orcl, User ID = system, Password = manager

Client Pc's IP = 192.168.30.10

I have succesfully Installed VB6 and it connect Locally with MS Access 2003 using following code.

Code:Public Sub OpenDatabase(ByVal db_name As String)
Set DB = New ADODB.Connection
    ' Access Database password
    db_name = App.Path + "PassportDetail.mdb;Jet OLEDB: Database Password=GTS;"
    DB.Open _
        "Provider=Microsoft.Jet.OLEDB.4.0;" & _
        "Persist Security Info=False;" & _
        "Data Source=" & db_name
end sub

Can you guide me ?

Thanks

With best regards


Tanweer


<Edit> AbbydonKrafts - Moved from "Code Bank - VB6" to "VB & Databases". Also added CODE tags. </Edit>




Edited by - AbbydonKrafts on 6/12/2007 7:04:24 AM

How To Connect Vb6 And DB In Oracle 8
How I can connect a DB (oracle) to a VB6 project.
the complete process of how to connect the data base of Oracle with VB6 project
My VB project has a mdi form as well, and the name of my DB is "tps"

How To Connect VB6.0 To Oracle 9i
Hi Friends,

I am a BSc IT Student. I have to make a project, with VB6.0 as front-end and Oracle 9i as back-end.

I would like to know :-
a) how to connect the text box, combo box etc... to Oracle database.
b) how to insert data from VB form to Oracle database.
c) how to retrieve data from Oracle database to VB form
d) how to delete a record from VB form in Oracle database.

Friends, if you know any website that I can refer for the above information, please let me know. Thank you

How To Connect Oracle
hi
how to connect from a vb client which is running on windows98 and oracle8i server which is running on unix server.

thanking u

How To Connect Oracle
hi
any one can help out me to solve this problem
i have installed oracle8i server in UNIX system and i want to connect it through vb windows98 client. i have instaled oracle client at my client system.

thanking u

How To Connect Oracle
Hai everybody,
I want know how to connect oracle with remote server..using provider...how to declare the conn string ?
If anyone knows can u help me pls ?

VB 6.0 Oracle 8i Connect
ATTENTION mgn0528-

But I put the data correctly. I have four fields-Emp_Id(Numeric), First_Name(Varchar2),Middle_Name(Varchar2) and Last_Name(Varchar2) and the data I put was 2, Rahul, Pathian, Barua. Hope all are correct.But... the first data i.e Emp_Id =1, I entered from the oracle and not from the VB form...So what is your opinion....

Vb-oracle Connect
I've set up aconnection between VB and Oracle8.When I start my application ,where I use ODBC DSN to connect, stat databaseoperation fails.Ihave to start the database first from Oracle StartDatabase icon.and then start the application.Only then it works.Is there a way to start the application so that the Oracle database starts automatically.

Which Kind Of Data Type In SQL-Server Can Be Shown In A VB Textbox?
Which kind of data type in SQL-Server can be shown in a VB textbox?
for example:
RichTextBox1.text = rs.Fields(address)
"address" in one table of my SQL-Server,and I tried its data type such as "text","char","varchar". It does not work.

Thank you very much!

Trying To Connect To An AS/400 Using OLE-DB && Client Express
I've downloaded the connection string from a site on the internet and get an error message "Run-time error '91': Object variable or With block varible not set" when I try to execute the visual basic program when it tries to open the connection.

The following are the variables I've defined and the connection string:

Dim cmd As ADODB.Command
Dim rs As ADODB.Recordset
Dim SqlCode As String
Dim AS400_Conn As ADODB.Connection


AS400_Conn.Open "Provider=IBMDA400;" & _
           "Data source=CDS;" & _
           "User Id=JIM;" & _
           "Password=mypassword;" & _
           "Transport Product = Client Access" & _
           "SSL=Default"
           
The error occurs on the open command.  TIA!



Oracle Client License
I was under the impression that I didn't need a license for each workstation that I install the Oracle client on. Is this true?

Can I Access Oracle From A Client VB Exe?
Hello everyone,

Me and a guy I work with developed an excellent standalone exe but found out no one else on our team can use it since they do not have the Oracle 8 client installed on their systems, (It is 500MBs).

Is there a way to make our app talk to an Oracle database on a remote server without installing the Oracle client on every user's machine?

-- OR --

If we have to install the client, can we customize it, and if so, which components should we include?

Thanks, hopefully I will get an answer, otherwise 3 months of work will go down the VB drain.

Daud.

Oracle Client Installed On Each Pc?
Hi guys,
i have an application written in VB6 which used by 5-6 users where each of them need to access to a oracle server located in the same LAN.

My question is:

1) Is it a must each of these users need to install an oracle client in their local pc?
2) Is there any simple way to access oracle server without installing oracle client on it? or is it any driver we can used to connect to the oracle server?

The operation that the users need to perform is to search through the data from oracle server only, there are no any update or delete operation performed, thanks..

Oracle Client Software
Is is absolutely necessary to install the Oracle client stuff on the client PCs in order to use ADO to connect? I'd prefer to use the OLEDB Provider so that an ODBC DSN doesn't need to be created on each PC, but can you connect with the ODBC driver(s) without the Oracle Client stuff?

EDIT: Additionally, is Oracle's OLE DB provider better than Microsoft's, or vise-versa?

Copyright 2005-08 www.BigResource.com, All rights reserved