Visual Basic :: VB Oracle Connectivity

VB Connectivity To Oracle DSN Using Oracle In OraHome92 Driver
Hi,

I have a desktop VB application which connects to an Oracle 9i database. Uptill now it has been using the Microsoft ODBC for Oracle driver (MSORCL32.DLL) to connect to the Oracle DSNs. Now I wish to change over to the "Oracle in OraHome92" driver (SQORA32.DLL).

When the above change is made, the application connects fine and the select queries (simple fetches without aggregate functions) execute alright. However I am facing issues, when I try to execute complex SQL statements such as statements invoking stored procedures and returning recordsets.
eg.
Code:
{ call wPHARMACY_VALIDATIONS.pwPHARMACY_VALIDATIONS(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, {RESULTSET 1, o_validation_error_codes}) }

This gives an oracle error "o_validation_error_codes needs to be defined". This error was not encountered with the Microsoft ODBC driver for Oracle previously.

Also, we are facing issues with executing stored procedures directly using ADODB command object
The error in this case is "-2147217887 Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done".

If anybody has worked on something similar or can give pointers on the same, and similar such issues that we might encounter because of the driver change, please reply.

Thanks & Regards,
V!kram

Connectivity With Oracle
how can i connect oracle wth VB
and what should i write to add records in a database

Oracle Connectivity With VB
How can u connect the Oracle 8 with VB
and What program i should write to insert ,update,delete the record

Connectivity With Oracle
hello !

i need to connect VB with Oracle. how shud i creat e the ODBC, how to go abt it ?? and what shud be the connect string in VB for connecting ??
i dont know the database name in wich im working in oracle ? how can i know that also ?

i simply have a table and i want to write & read from it from VB

thanks shruti !

ADO Oracle Connectivity
hi friends,
i am facing a problem with connecting oracle 8i with
Vb form...the form has just 3 Text boxes and i have
movefirst,movelast,next and prev buttons to move thru
the employee database in oracle..having the 3 fields
as emp_id,emp_name,emp_addr
i need to display them in the text boxes as soon as
the applcation is running...BUT i dont seem to get
connected to oracle....WHat all is needed to be
done???
can someone Plzz guide me through the steps...i'm in a
FIX
NEED some HElp urgentlyyy!!!!
the Username is Scott and pwd is tiger...this is
generally whats used with oracle global username...
I was wanting to use ADO connectivit.....
i have just been using DAO all this while and that TOO
just with access
so plzz help!
Thanxxx in advance
neena

VB+Oracle Connectivity
I am a new entrant into the arena of VB+Oracle. Iam currently using VB6 with Personal Oracle8 and have set up the database conectivity using an ODBC DSN.
I want to provide a search facility in the frontend.Using Find method is too slow,as I expect to have alarge database in the backend.Pl give tips for setting up search.
Also in the backend database,I have a table in which certain records or certain fields are blank.They give me problems when using navigation buttons set on the frontend side form.Though the Navigator shows the 'Not Null' property set up for the fields.

VB - Oracle Connectivity Issue
Hi,

In our ASP application, we are using a visual basic Dll file to perform database operations. We have a function in our Dll file for executing stored procedures.

This function takes 3 input parameters from ASP

1. Connection String

2. SQL String (call stored procedure string)

3. Input Parameters.

We are using “Microsoft ODBC for Oracle” drivers for the database connectivity .Due to some crash problems; we have changed the drivers to “Oracle 10g Drivers”. After changing this none of the procs seem to work

Sample SQL String -> “{call Package.Stored_Proc(? , {resultset 100, v_flag })}"

? is for the input parameter which we will add using ADODB.Command object

V_Flag is the output parameter which we directly specify in the call proc statement.

When we are using “Microsoft ODBC for Oracle” drivers, it is working fine. But when we are changing the drivers to “Oracle 10G”, it is throwing error “V_Flag : Invalid Identifier” and the proc is not getting executed.

Is anyone aware of this problem/work around?

Service Name In Oracle For VB Connectivity
hello,
I KNOW THAT THIS IS NOT HTE CORRECT FORUM FOR MY QUERY BUT PL HELP...

I m new to Oracle.

I have Personal Oracle 8 on my pc. OS is ME. I want to use with VB 6. For that i have tried to get an entry of tnsname through Net8 Assistant which i can use in VB. But i end up with JAVA ERROR.

Pl correct me where i m wrong

1) Name of Service (Sunbird)
2) TCP/IP (internet Protocal) (Is this the correct one, my oc is not a part of network, database is on this pc itself)
3) HOST Name (SEJAL) (Wht i m supposed to write here, Name of my pc or something else?)
Port number 1521
4) Database SID ORCL

when i give scott/tiger and test connection, system gives an JAVA ERROR

Please guide me.

Test Oracle For Connectivity
Is there a way to "Test" an oracle connection to see if it has dropped other than running a query and waiting for it to fail?

VB: Oracle 9i Connectivity Problem
Dear Friends,

I'm developing an app where I'm using VB 6.0 for front-end & Oracle 9i for back-end. Scenario is such that there will be one Oracle Server over the network & the app will be installed on more than 100 machines. But, the machines will not have Oracle clients installed. I'm finding a problem here. What kind of code shall I write in VB which can easily send requests & receive responses to/from Oracle Server over the network without using any Oracle client software.

Please, help me in finding a solution.

Oracle 8i (netorked) Connectivity Thru ADO
Dear Friends
I am having problems connecting to an Oracle 8i networked backen through ADO in the sense that where is the host string (use during startup of Oracle 8i networked model) to be given when try and connect using the property page of a Dataenvironmen connection object. With standalone version of Oracle I have n problems but networked model has had my happiness.I want to us a DSNless connection if possible .Thanx in advance

Connectivity For VB6.0 With Oracle Database
Hai,i am kiran kumar .Please any body helps me how to connect Visual Basic 6.0(front end) with Oracle8i(Back end) databasePlease show me a solution so that i can continue with my projectThankyou

Connectivity To Oracle Trough VB
Is it possible to develope a package in VB which is having connectivity to oracle datbase through ADOs. I don't want to use DSN. I am using connection string.
i have developed a programme, developed a package for it, but when i install it on the PCs that are connected through local area network (LAN) to ORACLE SERVER (server is having VB code as well as Visual studio installed on it), it asks for networking components of oracle on client part. i am using following code for connectivity:

Dim rs1 As ADODB.Recordset
Dim sql1, sql2, sql3, sql4, sql5, sql6, sql7, sql8 As String
Dim con As ADODB.Connection
Set con = New ADODB.Connection
con.Open "Provider=MSDAORA.1;Password=tiger;
User ID=scott;DataSource=galileo;Persist Security Info=True"

where galileo is name of NT SERVER having VB, Oracle
if i install client part of oracle on the PC on lan and run the program then it gives error

can't resolve tns name.

but if i install client part and use following code for connectivity

Set con = New ADODB.Connection
con.Open "Provider=MSDAORA.1;Password=tiger;User ID=scott;Data Source=cimnet;Persist Security Info=True"
Set rs = New ADODB.Recordset
rs.Open "select * from emp", con, adOpenKeyset, adLockOptimistic

then it runs fine.

what i want to do is.:

1) to develop a package on SERVER.
2) install it on PCs on LAN
3) I don't want to have oracle and VB on PCs on lan( except on server)
4) execute the program on LAN PCs ( after running set up of package) and access database from SERVER.

is it possible. please help me out.
i need help urgently.

Regards,
amit

VB6, Oracle 9i Connectivity Problem
The follwoing error occurs intermittently while tring to connect to Oracle 9i from a service written in VB6. The connection is dsnless and commandtime out=15.

Err:-2147467259 Oracle error occurred, but error message could not be retrieved from Oracle.
ADO Provider: MSDAORA;ADO DataSource: <data_source>; ADO UserID: <user_id>; ADO Provider Name: Not defined (Provider Friendly Name); ADO Provider DLL: Not defined (Provider Name); ADO Provider Version: Not defined (Provider Version)

We installed MDAC2.7SP1 to resolve the problem, but it didn't go.
Any kind of help to resolve the problem and/or to find the cause of the problem is alwys welcome.

Vb3 Oracle Connectivity Problem
We have Installed VB3 on Windows NT 4.0 and Oracle 7.3.4 client for windows
(which comes in oracle 7.3.4 on Window 95 and NT) client. We have
installed 16 bit ODBCc drivers and tried to run this sample code. While
running we get the following error. Could any body please help us

The sample code is

Sub Form_load()

Dim db as database
set db=opendatabase(“”)
End sub

As soon as we run the app we are getting a dialog box listing all the
datasources and we log on to the oracle by giving the username and
password.After this
The error we are getting is

Reserved error(-7751), there is no message for this error.

Thanks a lot in advance
Sandosh

VB Oracle Lite Connectivity
Can anybody tell me how to connect Oracle Lite database from Visual basic

Facing Different Issue With The Oracle Connectivity
Hi all,
First let me tell you what I am trying

I have a password file which will have all the server passwords. I am renaming it as .old extension, and I am running my exe to make sure it is running without crash. My aim is to ensure that my exe should keep on trying for the existense of the password file in the mentioned path. If it exists then it should take the password from that file and it should connect.

Now what actually happening was,
after say 15 minutes of checking for that file, I am renaming it back to the origianl name, so that it would be available to my exe.

What I found wasonce it reach the below mentioned line of code, its getting crashed with giving Microsoft warning dialogue: A problem encountererd in my exe" and asking me to send /dont send error report to Microsoft

<code>
db.CDAConnect db, "Provider=MSDAORA;Persist Security Info=True; Data Source=tns:" & ServerName & "; User ID=ops$oracle; Password=" & g_servers(g_current_server).password
</code>
where g_servers is a type variable which has servername, password etc.

Any help regarding this would be appreciated.

Thanks in advance.

Surendran N

Visual Basic Connectivity With Oracle
i'm using data bound grid control(DBgrid) in ODBC CONNECTIVITY and i wish to make the rows in of a table in ORACLE to appear as columns in DBgrid. how can i make it possible
also i want to trap 'print screen' key AND 'esc' key

[

Connectivity Between V B And Oracle Using LARGE OBJECTS
Hi! FELLAS....
I AM WORKING ON A PROJECT NAMED DESEASE ANALYSIS.
WHILE CONNECTING V B TO ORACLE THE DATA TYPE SPECIFIED IS CLOB(CHARACTER LARGE OBJECT) WHICH IS NOT BEING SUPPORTED BY V B. THE CONNECTION IS BEING COMPILED BY ADODB. PLEASE SOME ONE HELP ME OUT FROM THIS PROBLEM

[B][U]

Crystal Report Connectivity To Oracle
We have used crystal reports in our VB project.

When exe is compiled and run from client machine givs problem.

The application when run from server can invoke crystal reports but when we try to invoke crystal reports from exe on client machine we get the following error message.

20599: Unable to Logon
Can Not open Sql Server.

Although we are using Oracle Database why do we get this errors.

Work around on the crystal site is horrible.

Need urgent help.

Thanks in advance.
Khozema

Visual Basic And Oracle Connectivity And Data Inserting Problems
Hello to everybody ,
Will any one be kind to help me.
Please help me solve this problem
I am not an excellent Programmer but doing this as part of a College Project So kindly help me in this .I am having a software coded in Visual basic 6,a simple front end system ,very simple ,which is connected to Ms access ,
a simple sales system .
But I wish to conneet this system to oracle 8i ,I changed the DSN ,but when I enter the values .it’s showing problems to insert values with oracle when u try to debug ,the cursor is pointed on the
Cn.execute sql senetence ..

Else
sql = "insert into customer(customerno,name,address,telno,creditlimit) values ('" & Trim$(.Text1(0).Text) & "','" & Trim$(.Text1(1).Text) & "','" & Trim$(.Text1(2).Text) & "','" & Trim$(Val(.Text1(3).Text)) & "','" & Trim$(Val(.Text1(4).Text)) & "');"
cn.Execute sql
.cmdView.Enabled = True

Also I am attaching the module file -and code where the Problem ,showing
sincerely,

Ronie Jacob/kerala/India
my email is:
ronyjacobpurackal@hotmail.com

Those who are willing to help me ,pleaase do email me

Problem Connecting To An Oracle 9i Database With The Oracle ODBC Driver
I have this older VB6 application that I don't have the time to convert to VS2005 right now. I have the Oracle ODBC client installed and the DSN are created as system DSN's. They are not using the "Microsoft ODBC for Oracle" driver, instead they are using the actual Oracle driver. Ive tried several connection strings including:

Code:
cn.connectionstring = "Password=gers4us;Persist Security Info=True;User ID=gers;Data Source=NUREV"

cn.connectionstring = "Password=" & gstrPassword & ";Persist Security Info=True;User ID=" & gstrUser & ";Data Source=" & gstrDSN

cn.connectionstring = "Driver={Microsoft ODBC for Oracle};" & "UID=report;PWD=reportpw;DSN=nurev"

cn.connectionstring = "Driver={Microsoft ODBC for Oracle};Server=nurev;Uid=report;Pwd=reportpw;"

I keep getting the error handler from my function:

Code:
Public Function OpenDatabaseConnection() As Boolean
On Error GoTo errhandler
Dim connectionstring As String

    Set cn = New ADODB.Connection
    cn.Provider = "MSDAORA.1"
    'cn.connectionstring = "Provider=OraOLEDB.Oracle.1;Password=gers4us;Persist Security Info=True;User ID=gers;Data Source=NUREV"
    'cn.connectionstring = "Password=gers4us;Persist Security Info=True;User ID=gers;Data Source=NUREV"
    'cn.connectionstring = "Password=" & gstrPassword & ";Persist Security Info=True;User ID=" & gstrUser & ";Data Source=" & gstrDSN
    'cn.connectionstring = "Driver={Microsoft ODBC for Oracle};" & "UID=report;PWD=reportpw;DSN=nurev"
    cn.connectionstring = "Driver={Microsoft ODBC for Oracle};Server=nurev;Uid=report;Pwd=reportpw;"
    cn.Open
    OpenDatabaseConnection = True
    Exit Function
errhandler:
    MsgBox "Connection failed, Enter Login Parameters Again", vbCritical
    OpenDatabaseConnection = False
    Exit Function
End Function

...any ideas on the correct connection string?

How To Connection To Oracle Dataase Using Oracle 9.2 ODBC Driver
I try to connect to the Oracle database using the Oracle in OraHome92 driver, the code is:

Private Sub ConnectDB()
   Dim sConn As String
   Dim DB As String

   Select Case cboEnviro.Text
      Case "Production"
         DB = "PROD"
      Case "Testing"
         DB = "TEST"
   End Select

   sConn = "Driver=(Oracle in OraHome92);" & "Data Source=" & DB & _
                ";Uid=userid;Pwd=password;"
   dbConn.Open sConn
End Sub

I got the following error message:

Run-time error '2147467259 (80004005)':
[Oracle][ODBC][Ora]ORA12560: TNSrotocol adapter error

Can anyone tell me what wrong with this and how to fix the problem. Thanks.

Connection To An Oracle 9i Database With The Oracle ODBC Driver
I have this older VB6 application that I don't have the time to convert to VS2005 right now. I have the Oracle ODBC client installed and the DSN are created as system DSN's. They are not using the "Microsoft ODBC for Oracle" driver, instead they are using the actual Oracle driver. Ive tried several connection strings including:

Code:

cn.connectionstring = "Password=gers4us;Persist Security Info=True;User ID=gers;Data Source=NUREV"

cn.connectionstring = "Password=" & gstrPassword & ";Persist Security Info=True;User ID=" & gstrUser & ";Data Source=" & gstrDSN

cn.connectionstring = "Driver={Microsoft ODBC for Oracle};" & "UID=report;PWD=reportpw;DSN=nurev"

cn.connectionstring = "Driver={Microsoft ODBC for Oracle};Server=nurev;Uid=report;Pwd=reportpw;"

I keep getting the error handler from my function:

Code:

Public Function OpenDatabaseConnection() As Boolean
On Error GoTo errhandler
Dim connectionstring As String

Set cn = New ADODB.Connection
cn.Provider = "MSDAORA.1"
'cn.connectionstring = "Provider=OraOLEDB.Oracle.1;Password=gers4us;Persist Security Info=True;User ID=gers;Data Source=NUREV"
'cn.connectionstring = "Password=gers4us;Persist Security Info=True;User ID=gers;Data Source=NUREV"
'cn.connectionstring = "Password=" & gstrPassword & ";Persist Security Info=True;User ID=" & gstrUser & ";Data Source=" & gstrDSN
'cn.connectionstring = "Driver={Microsoft ODBC for Oracle};" & "UID=report;PWD=reportpw;DSN=nurev"
cn.connectionstring = "Driver={Microsoft ODBC for Oracle};Server=nurev;Uid=report;Pwd=reportpw;"
cn.Open
OpenDatabaseConnection = True
Exit Function
errhandler:
MsgBox "Connection failed, Enter Login Parameters Again", vbCritical
OpenDatabaseConnection = False
Exit Function
End Function

...any ideas on the correct connection string?

DB Connectivity
Dear friends,

When I execute the program,getting following error.

"c:....pass.mdb is not a valid path.Make sure that the pathnameis spelled correctly and that you are connected to the server on which the file resides"

VB Code:
conn.connectionstring = "Provider=Microsoft.Jet.OLEDB.3.51; Persist Security Info=False;Data Source=" & App.Path & " pass.mdb"

But pathname is correct only.Please help me!

Connectivity
In last few months i have noticed on this forum that people use winsock controls and api to make connectivity with database instead of using ADO or something. I am just wondering what makes then use winsock and not ADO ???

DB Connectivity
Hi,

I have created my app using Access 2000 as the backend. I have locked my database by giving a password in Exclusive mode. Whenever I try to open the db through the ADODB connection object by entering the following code, I get an error.

'CODE BEGINS
'-----------------
Dim con as new ADODB.Connection

Private Sub Form Load()
With con
.Provider="MICROSOFT.JET.OLEDB.4.0"
.ConnectionString="Data source=D:db1.mdb;User ID=admin;Password=mypassword"
.Open
End With

'-----------------
'CODE ENDS

The error message reads out as following:

"Cannot start your application. The workgroup information file is missing or opened exclusively by another user."

Though I tried running my app even after closing the mdb file, it shows the same error.

Is the connection string correct? Please reply regarding this at the earliest.

Bye & TIA.
Ravi.

Connectivity To DB2
Hi all
can anybody tell me the code for connectivity to DB2 in visual basic.and concept also bcoz my data is on another server.i am getting the error "provider is not found"
thx

ADO Connectivity Not Thru
i have been trying to open a database thru DSN, but my database isalways in closed state

it shows the following error and this occurs while fetching recordset.below is my code. kindly help
**************
Run time error 3709;
"Operation is not allowed on an object referring a closed or invalidconnection"
********************

Private Sub Form_Load()
Set db = New ADODB.Connection
db.ConnectionString ="Provider=Microsoft.Jet.OLEDB.4.0;DATABASE= EProfile.mdb;UID=;PWD;DN=Profile"
db.Mode = adModeReadWrite
db.CursorLocation = adUseClient
MsgBox "db state: " & GetState(db.State)
Set rst1 = New ADODB.Recordset
rst1.Open "Select * from userMaster", db, adOpenKeyset, adLockOptimistic
End Sub

Public Function GetState(intState As Integer) As String

Select Case intState
Case adStateClosed
GetState = "adStateClosed"
Case adStateOpen
GetState = "adStateOpen"
End Select

End Function

FTP Connectivity
Hi

Im a total vb newbie
Our app which is used by around 200 clients is written in VBA
I have undertaken the challenge of writing a basic auto update proceedure for our clients.
I have designed the form and partially done some initial processing but have come stuck when trying to connect to an FTP server.
The file which will be in the form of a zip sits on our FTP server, i want to be able to connect to this server and download the file.
All my references so far have come from my own understanding from what i have learned from VBA and for most of my programming i am using "Microsofts Visual Basic.Net Programmers Cookbook" So far this book has given me all the info i need, however when trying to program the FTP connection and download i become completely stuck.

Any help on how to do this would be greatly appreciated.

Thanks in advance

gumuk

ADO Connectivity
Can anyone out there please tell me is there any problem with this codes? I keep on getting the message OBEJCT REQUIRED on the rs.rs.Open ssql, oConn, adOpenForwardOnly, adLockReadOnly, adCmdText. Any idea will be appreciated

--------------------------------------------
Private Function dbConnect() As Boolean
Dim oConn As New ADODB.Connection
Dim rs As New ADODB.Recordset
On Error GoTo Err_dbConnect
dbConnect = False
oConn.Open "dsnHostels"
Debug.Print "ADO Connection = " & oConn.ConnectionString
dbConnect = True
oConn.Close
Exit Function

Err_dbConnect:
MsgBox "Something went wrong!"
Exit Function

End Function

--------------------------------------------
Private Sub RRCommand1_Click()
If (RRText2.Text = "" Or RRText3.Text = "" Or RRText4.Text = "" Or RRText5.Text = "" Or RRText1.Text = "") Then
Call MsgBox("Please check your data entry", vbCritical, "Error!")
Else

Dim ssql As String

rs.Open ssql, oConn, adOpenForwardOnly, adLockReadOnly, adCmdText
ssql = "insert into Student( StudentID, StudentName, StudentCourse, StudentEmail, StudentAddress) " & _
"values('" & RRText1.Text & "','" & RRText2.Text & "','" & RRText3.Text & "','" & RRText4.Text & "','" & RRText5.Text & "')"
oConn.Execute ssql

rs.Close

End If
End Sub
--------------------------------------------

andy

Connectivity
Question for all you wise and wonderful people:

I want to be able to have a user on the internet select a data element from a drop-down list and have it then create an e-mail message (for example) to a text pager from associated data. Any suggestions?

Thanks in advance...

Dnd

ADO Connectivity
Hi
I am new VB , I am doing Database work using ADO in VB, I want some Sample which help to start. Any one could suggest a good book as well as send some good sample codes .

thanks in advance
cheers
Arunesh

COM VB Connectivity
Hello,
I have created a small COM component as a DLL using Visual C++. I didn't use MIDL therefore I don't have a type library for my component. I want to use that component in my VB application. How can I do that?

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

Oracle 9 DMP File Cannot Be Imported In Oracle 8i
Dear all
I have exported a file in oracle 9 and created a dmp file.
I am unable to import the same in Oracle 8i
Is it technically possible, if so please guide me
Turab

Importing Dmp File From Oracle 7.3 To Oracle 8.0 I
I would like to get detail unformation.
I have a file puls.dmp exported from oracle 7.3
I would like to import this file on to new Oracle 8.0 i Server

I would be oblidge if any one

Let me know step By step process of creating dataBase,User,Schema

---> Importing and restoring the exported file.

Connectivity B/w Excel And VB
Hi
Can any one please tell me how to connect visual basic and an excel spreadsheet.
Its quite urgent
Thanks in Advance
Dhiraj

Internet Connectivity Through VB
I've been working w/ VB for a while and now is the first time I am trying to tackle learning how to create programs that can communicate over the internet. Can anyone tell me of a few *good* tutorial sites that walk through the basics of how to do this? Any help is much appreciated.

Connectivity From 3 Location?
how i can connect my vb application with 2 the remote database..
i mean to say suppose i want to connect my database application which is written in vb from 3 different location , how and where i can put my database from where if person enter new customer detail , it can be update and accesable from other location how i can make connection between 3 location and , important thing is where i should i keep my data base and please tell me in detail , thanks

DAO Connectivity/ADO And Advice
Hello:

I have been working on a large phone switch project for my organization and I have one stage left. I currently have three VB 6.0 exes with Crystal Reports that link via ADO/ODBC to three seperate Access MDB (each database represents a office). I also created in Access the main "Switch.mdb" which gets data directly from our Phone Switch...this eventually will serve as the backend datasource. Currently, this mdb has over 15,000 records.

Now, my final coding piece involves automatically filtering data from the main Access "Switch.mdb" into the three divisional mdbs. I initially sorted these by hand, just to get the VB exes up and running with a datasource.

Basically, based on a Select Statement (Select * from Swith where Office = 'name'), I need the Switch MDB to connect with the three filtered mdb's (as in, all "Office 1" records go to the Office1.mdb which is connected to the Office1 VB exe for user interaction, etc.). I have not done a connectivity/data transfer like this in a very long time..any ideas of the best way to do it? Would ODBC be better for this sort of thing..it is Access talking to Access, or is DAO the way to go.

Also, would it be easier to do this sort of thing in VB 6.0? Since part of this project is in Access and part is in VB 6.0 I'm not sure which to use for this last piece.

And coding advice to get me started? How would you all go about doing this? If I have confused anyone about what I am trying to do, let me know . Thanks for any advice.

Martin K

Database Connectivity
Is it bad practice to keep opening and closing a database connection in an db application? Are there any advantages/disadvantages to it?

MySQL Connectivity Help
Hi All,

Can sum1 please provide me with assistance to get VB to connect to MySQL database. At this point I have MySQL successfully installed and I am able to create tables using the MySQL-Front GUI interface. I am also able to get the Visual Data Add-in from VB to access the data.

What I want to do is have a Data Control on the form that links to a DBGrid where all the info from the table is displayed.

I am using a MSRDC Data control to connect at the moment cos I cannot find a MySQL one in the components list.

Is this correct or am I missing something here??

Many thanks

Tweeg

Database Connectivity
Hey all.

Of the major types of connection objects:
ADODC,
DATA, &
MSRDC (remote data con)
I am forced to use MSRDC due to MSFlexGrid restrictions and database recognition (MSFlexGrid doesn't work with ADO and DATA isn't compatible with my database).(seems obsurd to me that Data will not recognize an MS Access DB)

So, being forced to use an MSRDC, I have this annoyance. The property CONNECT.... it doesn't seen to matter what I put there, I am always prompted at the start of run time for the path to the database. Anybody know enough about this object to know what kind of string goes here? I tried
c:whatever path and filename = c:whatever path and c:pathconnect.udl. None seem to point to the database at design time. It is just annoying to have to browse to my database at run time.

If someone knows of a library of property that I need to set to have DATA recognize an MS Access database, that would be great too. I could just ditch the MSRDC which no one seems to know about.

Yes, I have to use MSFlexGrid because I am required to set cellBackColors depending on what's in the cell.

Thanks all.
PB

Nokia Pc Connectivity
I've found a sample program on here (see attachment) that I'm trying to convert but...

These two lines don't connect with my software:
Dim objSMS As SMS3ASuiteLib.SMS_SuiteAdapter
Dim objMess As SMS3ASuiteLib.ShortMessage

I don't know if its because I'm using a Nokia 6300 or the version of the disk I have installed - I've tried googling but I've not found any solutions as yet

ANY IDEAS?

edit: i'm using Nokia pc suite 6.83