dbTalk Databases Forums  

Return to brOpenConnect

comp.databases.pick comp.databases.pick


Discuss Return to brOpenConnect in the comp.databases.pick forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
soumi0@walla.com
 
Posts: n/a

Default Re: Return to brOpenConnect - 10-22-2006 , 01:04 PM






PS

Quote:
Why? I use D3OleSvr to connect to remote hosts all the time. The only
"trick" is setting the registry key "MdsServerName" to the IP address
or hostname of the remote system.
Why use ODBC? It's slow and a terrible implementation in D3, forcing
you to create duplicate files of your D3 data.
Use the D3OleSvr whenever you can.
By the way, remote host on D3Linux.Can i to do query uses DCOM(local
host on Win, remote-D3Lin) ?. Which interaction type?
Thanks



Reply With Quote
  #12  
Old   
Kevin Powick
 
Posts: n/a

Default Re: Return to brOpenConnect - 10-23-2006 , 06:44 AM






soumi0 (AT) walla (DOT) com wrote:

Quote:
Please get me example your HKEY to group or soumi (AT) walla (DOT) com
I told you what it was. The key name is:

HKEY_LOCAL_MACHINE\SOFTWARE\PickSystems\D3\Current Version\D3FSI

The data is a string value called MdsServerName. It must contain host
name or IP address of D3 Server.

Quote:
Visual Componet Library (C++) present DSN where uses ODBC. I use Table
or Query acros DSN with ODBC.This is obsolescence?
Sorry, I don't understand what you are saying.

--
Kevin Powick



Reply With Quote
  #13  
Old   
Kevin Powick
 
Posts: n/a

Default Re: Return to brOpenConnect - 10-23-2006 , 06:46 AM




soumi0 (AT) walla (DOT) com wrote:

Quote:
By the way, remote host on D3Linux.Can i to do query uses DCOM(local
host on Win, remote-D3Lin) ?. Which interaction type?
No. DCOM for D3OleSvr can only be used Win Client -> Win D3 Server.
No Linux.

--
Kevin Powick



Reply With Quote
  #14  
Old   
soumi0@walla.com
 
Posts: n/a

Default Re: Return to brOpenConnect - 10-23-2006 , 07:34 AM




Quote:
or Query acros DSN with ODBC.This is obsolescence?
Sorry, I don't understand what you are saying.
I have remote D3Linux DataBase and WinClient users.
Except ODBC could i use any anything else ?
On win i have Excel or C++ application.



Reply With Quote
  #15  
Old   
soumi0@walla.com
 
Posts: n/a

Default Re: Return to brOpenConnect - 10-23-2006 , 01:13 PM




Quote:
DSN_name is the name of the Data Source Name you defined to attach to the
database. Usually NOT DM.

Mark, i analysis tcp raw packet with use tcpdump.
Here is result:
Set aCon = aEnv.brOpenConnection("ODBC", "USER_OR_SYS_DSN")
Host send(reply) : Server send(reply)

1.myserver,pick_name,dm,,sql : Logon suseful
2.CASE (f
When i asssign brCasing = true
raw packet 2 is CASE (n
e.g. connect is established ant then breaks.Why?
Thanks.



Reply With Quote
  #16  
Old   
Mark Brown
 
Posts: n/a

Default Re: Return to brOpenConnect - 10-23-2006 , 03:09 PM



Is it possible you mis-typed the statement 1.myserver... ?

I don't think there should be two commas between dm and sql.

In your DSN, how did you define username and account name? Did you put in a
password? Is there a password on either USER DM or the account you used?

The TCP dump should give some indication of why connection breaks. If it
does not, try this:

Run the ODBC service in the "foreground". If this is a unix, linux or aix
system, open a telnet window and type
D3ODBCSRV -dpv /debug

If this is a windows system, open a telnet window and type:
D3ODBCSV -dpv /debug

Make sure D3ODBCS(R)V is not already running. This will display all the
ODBC commands received by the server and usually gives some indication why a
connection is dropped.

Mark Brown

<soumi0 (AT) walla (DOT) com> wrote

Quote:

DSN_name is the name of the Data Source Name you defined to attach to the
database. Usually NOT DM.

Mark, i analysis tcp raw packet with use tcpdump.
Here is result:
Set aCon = aEnv.brOpenConnection("ODBC", "USER_OR_SYS_DSN")
Host send(reply) : Server send(reply)

1.myserver,pick_name,dm,,sql : Logon suseful
2.CASE (f
When i asssign brCasing = true
raw packet 2 is CASE (n
e.g. connect is established ant then breaks.Why?
Thanks.




Reply With Quote
  #17  
Old   
Tony Gravagno
 
Posts: n/a

Default Re: Return to brOpenConnect - 10-23-2006 , 03:15 PM



soumi0 (AT) walla (DOT) com wrote:

Quote:
or Query acros DSN with ODBC.This is obsolescence?
Sorry, I don't understand what you are saying.

I have remote D3Linux DataBase and WinClient users.
Except ODBC could i use any anything else ?
On win i have Excel or C++ application.
While many people have been successful with the D3 Class Library
and/or D3 ODBC, others like myself find them inadequate, and the next
logical question is "what else is there?". Having been down that path
already and having investigated, purchased, and written other
connectivity tools, the one I've finally adopted is mv.NET. I've been
VERY happy with this for a long time and a number of our new and
existing clients have adopted mv.NET as well for use with almost all
MV DBMS platforms and all operating systems. So yes, D3 Linux is
supported. (And for those of you who are interested, I just started
using mv.NET with QM/Windows. Same code, completely platform
independent - cool.)

You will need to shift to .NET to use the libraries, but this may be
the easy way to make that transition. Yes, you can use mv.NET with
Excel and to pass MV data to your ODBC-compliant applications. You
haven't stated exactly what it is that you want to do outside of
connect to D3. Feel free to contact me for more info. Rather than
purchasing the development environment I might be able to write up a
simple component for you and then you'll just need a deployment
license.

HTH
Tony
TG@ removethisNebula-RnD.com


Reply With Quote
  #18  
Old   
Excalibur
 
Posts: n/a

Default Re: Return to brOpenConnect - 10-23-2006 , 04:54 PM



Hi Mark
Since the ODBC service is now buried in FSI what would be the solution in
7.5 NT and on.
Thanks
Peter McMurray
"Mark Brown" <mbrown (AT) drexelmgt (DOT) com> wrote

<snip>>
Quote:
If this is a windows system, open a telnet window and type:
D3ODBCSV -dpv /debug

Make sure D3ODBCS(R)V is not already running. This will display all the
ODBC commands received by the server and usually gives some indication why
a
connection is dropped.

Mark Brown

snip




Reply With Quote
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

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



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.