• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 376
  • Last Modified:

ActiveX ODBC Connection Control Works in VB (and IE) but not in FOXPRO! The same control works in one but not in other! (gah)

My ActiveX Control connects to an ODBC connection (made through the control panel)

It works in VB and works in IE, (and any other activex container..)

But when i put it into VisualFoxPro6 (where it was intended to be put), it says it can't create connection or some weird error. I'll post the exact error message soon.

Thoughts?

mycode is:
rsConn.Open "termsconn" <-- that's the name of the connection. That's where its having the error.

-Michael
0
Anderson_Enterprises
Asked:
Anderson_Enterprises
  • 3
  • 2
1 Solution
 
leonstrykerCommented:
Please post more of your code.  It seems you are trying to open a recordset with a connection string.  Is rsConn a recordset or connection object?

Leon
0
 
Anderson_EnterprisesAuthor Commented:
Because you are the only guy that answered, i'm going to award you the points...

i've found the answer.

Apparently when (in foxpro) you type:
 USE Calendar

It opens a connection to the Calendar Database. (That's what I want!)

BUT..

The ODBC driver CANNOT access Calendar when its 'in use' even when you don't use it exclusive.

The solution was to Close all instances of the calendar database. Apparently ActiveX/FoxPro/VisualBasic don't like to share connections to databases. EVEN WHEN they advertise that ability.

-Michael Smyers
0
 
leonstrykerCommented:
Michael,

Thanks, but no thanks.  If you answered your own question, you should post to the Community Support area and ask for the question to be closed and the points refunded.  I would much rather have that happen then get a C grade.

Leon
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Anderson_EnterprisesAuthor Commented:
Hm, How do I go about fixing this for you? I hadn't thought about the negative connotations associated with a C..

I'll see what I can do!

-Michael Smyers
0
 
leonstrykerCommented:
I already made the posts.  A mod should be coming along any time now.

Leon
0
 
CetusMODCommented:
Unaccepted per request http:Q_21093220.html

Closed, 500 points refunded.

CetusMOD
Community Support Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now