473,480 Members | 3,069 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

connecting vb6 with orcle through odbc

137 New Member
dear all,
i'm new to oracle. i used postgresql for my back end n used odbc for the connection. my connection string was :

Expand|Select|Wrap|Line Numbers
  1. public Sub getconnect()
  2. Set ws = CreateWorkspace("","abc","',dbUseodbc);
  3. Set db=ws.OpenDatabase("",,False,"ODBC;dsn=PostgresSQLabc;uid=postgres;pwd=admin");
  4. End Sub
but how could i write the same connection for oracle
i used:
Expand|Select|Wrap|Line Numbers
  1. Driver={Microsoft ODBC for Oracle};Server=myServerAddress;Uid=myUsername;Pwd=myPassword;
but it didn't work
could any body help me to figure it out, what's the problem?
TIA
Jun 10 '11 #1
1 1408
debasisdas
8,127 Recognized Expert Expert
Please refer this for details. You will get multiple options.
Jun 13 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
3259
by: Steve | last post by:
I normally use MySQL with PHP, but I'm delving into connecting to Access with ODBC (for a database that I already have set up at work), and I'm running into a couple of errors. I'm just trying to...
1
2306
by: puppet_sock | last post by:
Does the breaking of an ODBC connection produce a logoff event? I can't seem to get it to. What I was hoping was to use a trigger to do automatic cleanup of session specific data. But the...
0
1386
by: Kong Li | last post by:
Follow up to this thread, the latest Oracle 9i release 2 patchset (9.2.0.5) fixed the handle count leak problem. The problem is in Oracle client component. Thanks. Kong ----- From: Kong...
1
3002
by: Ralf Obst | last post by:
Hello, we get a message SQL0204N when trying to import tables from a DB2/VM into an MS Access database. The message text is: ... "DB2/VM SQL0204N 'SQLTables ' not defined ". When...
4
3556
by: Dave | last post by:
Hey guys, I have an ODBC problem that has me stumped. I wrote a VBA script to run in Microsoft Excel that pulls data out of an application using that application's ODBC driver and puts it into...
3
2219
by: Jeremy Dillinger | last post by:
I am trying to design a program that will use data from a MySQL database. Currently all the data is being used with PHP scripts from a website. I am also trying to build a software solution that...
2
74638
by: SKB | last post by:
Hi, I am absolutely new to this area. I am getting the following difficulty : Access denied for user 'ODBC'@'localhost' (using password: NO) when I try the mysql command from within the...
1
3773
by: RLN | last post by:
RE: Access 2003 using WinXP SP2 Problem: When I start up my app I double click either one of my two Oracle tables in the table list, it asks for an id and pass. I need them to be linked at...
3
4346
by: Mike | last post by:
I have transferred the data from Access to MySQL using MySQL's tool. The transfer worked great and saved me a lot of time (thanks MySQL). Now I'm trying to get the Access database, or a new access...
0
1126
by: mkarim | last post by:
I am running this query: UPDATE REPORT_CLIENT RC SET ca_move = (SELECT UNIQUE (CASE WHEN rtrim(ltrim(ca_vormonat)) = '' OR length(rtrim(ltrim(ca_vormonat))) IS NULL OR rtrim(ltrim(ca_vormonat))...
0
7055
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
6920
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7106
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
7022
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5365
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
3013
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3004
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1311
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
206
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.