MajorGeeks Support Forums

Go Back   MajorGeeks Support Forums > ----------= PC, Desktop and Laptop Support =---------- > Software
Register FAQ Members List Calendar Casino Mark Forums Read

Software Software such as operating systems like Windows XP, Windows Vista, Windows 7 etc., or specific programs.


Reply
 
Thread Tools Display Modes
  #1  
Old 08-10-04, 16:20
Wookie's Avatar
Wookie Wookie is offline
Sergeant Major
 
Join Date: Mar 2002
Location: Michigan
Posts: 886
Thanks: 0
Thanked 0 Times in 0 Posts
Default Anyone here have any oracle / VB 6 experience?

Worth a shot im not getting a big reply at other forums and I am kind of stuck.

Heres my problem if anyone knows anything about databases
-----------------------------------------------------------

I am trying to connect to an oracle database. There is an oracle ODBC driver on the system with a DSN set up called tns:live

The driver name is sqora32.dll

I tried connecting to it like this
Code:
Code:
 
 Dim oCn1 As ADODB.connection 
 Dim oRs1 As ADODB.Recordset 
 Dim connection1 As String 
 connection1 = "Provider=MSDAORA.1;Password=xxxx;User ID=xxxx;Data Source=tns:live;Persist Security Info=True" 
 oCn1.Open connection1


It didnt work. I am guesssing because the driver is different. Would I change the provider and what would I change it to?

I also have an excel file using VB that connects just fine like this:
Code:
Code:
 
 Sub RetrieveData() 
 Dim Chan As Variant 
 Dim Stmt As String 
 
 Chan = SQLOpen("DSN=Live Database")
from what ive researched thats using xlodbc.xla which is an excel add in. I dont think I can use sqlopen in VB 6, but correct me if I am wrong.

Should I research SQLopen more or is it just a driver name problem? I appreciate any help anyone has to offer. Thanks
__________________
http://www.undertreephoto.com

Last edited by Kodo; 08-10-04 at 16:29..
Reply With Quote
Sponsored links
  #2  
Old 08-10-04, 16:31
Kodo's Avatar
Kodo Kodo is offline
SNATCHSQUATCH
 
Join Date: Jan 2002
Location: Syracuse NY, USA
Posts: 11,502
Thanks: 17
Thanked 72 Times in 49 Posts
Default Re: Anyone here have any oracle / VB 6 experience?

have you tried it with out doing a DSN?
make a udl file and configure it appropriately, then edit the udl file with a text editor and there is your string..
__________________
"The American people will never knowingly adopt Socialism..." -Norman Thomas
Reply With Quote
  #3  
Old 08-10-04, 16:38
Wookie's Avatar
Wookie Wookie is offline
Sergeant Major
 
Join Date: Mar 2002
Location: Michigan
Posts: 886
Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: Anyone here have any oracle / VB 6 experience?

ah sheit man didnt know that would give me a connection string. Ill try that string thanks
__________________
http://www.undertreephoto.com
Reply With Quote
  #4  
Old 08-10-04, 16:40
Wookie's Avatar
Wookie Wookie is offline
Sergeant Major
 
Join Date: Mar 2002
Location: Michigan
Posts: 886
Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: Anyone here have any oracle / VB 6 experience?

P.S. the name and pass were fake thanks anyway tho.
__________________
http://www.undertreephoto.com
Reply With Quote
  #5  
Old 08-10-04, 17:36
Kodo's Avatar
Kodo Kodo is offline
SNATCHSQUATCH
 
Join Date: Jan 2002
Location: Syracuse NY, USA
Posts: 11,502
Thanks: 17
Thanked 72 Times in 49 Posts
Default Re: Anyone here have any oracle / VB 6 experience?

hey, we gotta watch our bro's backs
__________________
"The American people will never knowingly adopt Socialism..." -Norman Thomas
Reply With Quote
Sponsored links
  #6  
Old 08-11-04, 13:39
Kodo's Avatar
Kodo Kodo is offline
SNATCHSQUATCH
 
Join Date: Jan 2002
Location: Syracuse NY, USA
Posts: 11,502
Thanks: 17
Thanked 72 Times in 49 Posts
Default Re: Anyone here have any oracle / VB 6 experience?

what's the verdict ?
__________________
"The American people will never knowingly adopt Socialism..." -Norman Thomas
Reply With Quote
  #7  
Old 08-11-04, 18:26
Wookie's Avatar
Wookie Wookie is offline
Sergeant Major
 
Join Date: Mar 2002
Location: Michigan
Posts: 886
Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: Anyone here have any oracle / VB 6 experience?

Ill find out tomorrow, had to do tech support all day then go troubleshoot an adtran 612 with a cisco Pix. Fun stuff.
__________________
http://www.undertreephoto.com
Reply With Quote
  #8  
Old 08-13-04, 09:14
Wookie's Avatar
Wookie Wookie is offline
Sergeant Major
 
Join Date: Mar 2002
Location: Michigan
Posts: 886
Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: Anyone here have any oracle / VB 6 experience?

Things arent going good right now the DSN quit working, using oracle net8 config assistant I keep getting a no listener error but the server is up fine, there is an error message on the screen tho but I know nothing about unix and this is a main server for 5 stores not a good morning.
__________________
http://www.undertreephoto.com
Reply With Quote
  #9  
Old 08-13-04, 09:19
Kodo's Avatar
Kodo Kodo is offline
SNATCHSQUATCH
 
Join Date: Jan 2002
Location: Syracuse NY, USA
Posts: 11,502
Thanks: 17
Thanked 72 Times in 49 Posts
Default Re: Anyone here have any oracle / VB 6 experience?

do you have the latest MDAC?
__________________
"The American people will never knowingly adopt Socialism..." -Norman Thomas
Reply With Quote
  #10  
Old 08-13-04, 10:04
Wookie's Avatar
Wookie Wookie is offline
Sergeant Major
 
Join Date: Mar 2002
Location: Michigan
Posts: 886
Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: Anyone here have any oracle / VB 6 experience?

Got it going thankfully, the company called me back (I was shocked) and I guess they restarted the server a while back and the listener service doesnt auto start, they walked me through how to start it so I can connect. My Software keeps erroing out so I am installing oracle client on my work laptop right now so I an connect with it and debug.

Hopefully Ill figure this crap out I got the connection strung from the UDL file tho thanks.
__________________
http://www.undertreephoto.com
Reply With Quote
Sponsored links
  #11  
Old 08-13-04, 10:14
Wookie's Avatar
Wookie Wookie is offline
Sergeant Major
 
Join Date: Mar 2002
Location: Michigan
Posts: 886
Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: Anyone here have any oracle / VB 6 experience?

Heres my problem, when I try to open I am geting this error

"error cannot load resource file sqresus.dll"


Wonder why I am getting that
__________________
http://www.undertreephoto.com
Reply With Quote
  #12  
Old 08-13-04, 10:20
Kodo's Avatar
Kodo Kodo is offline
SNATCHSQUATCH
 
Join Date: Jan 2002
Location: Syracuse NY, USA
Posts: 11,502
Thanks: 17
Thanked 72 Times in 49 Posts
Default Re: Anyone here have any oracle / VB 6 experience?

Try reinstalling your Oracle ODBC driver and reboot.
__________________
"The American people will never knowingly adopt Socialism..." -Norman Thomas
Reply With Quote
  #13  
Old 08-13-04, 10:33
Wookie's Avatar
Wookie Wookie is offline
Sergeant Major
 
Join Date: Mar 2002
Location: Michigan
Posts: 886
Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: Anyone here have any oracle / VB 6 experience?

reboot worked

now I am getting this error here

Code:
oRs1.Open "ITM_PUR_HST", oCn1, adOpenKeyset, adLockOptimistic, adCmdTable

Error: Object variable or with block variable not set


boy debugging is fun
__________________
http://www.undertreephoto.com
Reply With Quote
  #14  
Old 08-13-04, 10:36
Kodo's Avatar
Kodo Kodo is offline
SNATCHSQUATCH
 
Join Date: Jan 2002
Location: Syracuse NY, USA
Posts: 11,502
Thanks: 17
Thanked 72 Times in 49 Posts
Default Re: Anyone here have any oracle / VB 6 experience?

why are you opening up a whole table? that's slow. You should pick the fields you want even if you want them all.
__________________
"The American people will never knowingly adopt Socialism..." -Norman Thomas
Reply With Quote
  #15  
Old 08-13-04, 10:41
Wookie's Avatar
Wookie Wookie is offline
Sergeant Major
 
Join Date: Mar 2002
Location: Michigan
Posts: 886
Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: Anyone here have any oracle / VB 6 experience?

I got it to work, ill refine everything later I am just making sure I can get the connection going.

Code:
Set oCn = New ADODB.connection
Set oRs = New ADODB.Recordset
I had forgotten that

I am rushed right now ill refine my SQL later, gotta go fix an email now then go listen to my boss bitch that I havnt got this done after he sends me 3 other places.

I love computers
__________________
http://www.undertreephoto.com
Reply With Quote
Sponsored links
  #16  
Old 08-13-04, 10:51
Wookie's Avatar
Wookie Wookie is offline
Sergeant Major
 
Join Date: Mar 2002
Location: Michigan
Posts: 886
Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: Anyone here have any oracle / VB 6 experience?

MUHAUAHAUAHAUAHHAUAH


Its the greatest feeling to see something you created work

Thanks for your help Kodosan
__________________
http://www.undertreephoto.com
Reply With Quote
  #17  
Old 08-13-04, 10:52
Kodo's Avatar
Kodo Kodo is offline
SNATCHSQUATCH
 
Join Date: Jan 2002
Location: Syracuse NY, USA
Posts: 11,502
Thanks: 17
Thanked 72 Times in 49 Posts
Default Re: Anyone here have any oracle / VB 6 experience?

I hear that my man!
__________________
"The American people will never knowingly adopt Socialism..." -Norman Thomas
Reply With Quote
  #18  
Old 08-13-04, 10:55
Wookie's Avatar
Wookie Wookie is offline
Sergeant Major
 
Join Date: Mar 2002
Location: Michigan
Posts: 886
Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: Anyone here have any oracle / VB 6 experience?

Ill have to get on making that SQL statement it takes forever to extract it lol
__________________
http://www.undertreephoto.com
Reply With Quote
  #19  
Old 08-13-04, 10:58
Wookie's Avatar
Wookie Wookie is offline
Sergeant Major
 
Join Date: Mar 2002
Location: Michigan
Posts: 886
Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: Anyone here have any oracle / VB 6 experience?

yeah about 2 minutes only got me 1200 records, very slow
__________________
http://www.undertreephoto.com
Reply With Quote
  #20  
Old 08-13-04, 11:14
Kodo's Avatar
Kodo Kodo is offline
SNATCHSQUATCH
 
Join Date: Jan 2002
Location: Syracuse NY, USA
Posts: 11,502
Thanks: 17
Thanked 72 Times in 49 Posts
Default Re: Anyone here have any oracle / VB 6 experience?

holy crap.. yeah man.
__________________
"The American people will never knowingly adopt Socialism..." -Norman Thomas
Reply With Quote
Sponsored links
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 20:26.

MajorGeeks.Com Menu

MajorGeeks.Com \ All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ NEW! PC Games \ System Tools \ Macintosh \ Demonews.Com \ Top Downloads

MajorGeeks.Com \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds


All content Copyright MajorGeeks.com source code Powered by vBulletin® Version 3.8.4
Copyright © 2009 vBulletin Solutions, Inc. All rights reserved.
Ad Management by RedTyger