Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

connect string

4 posts in General Discussion Last posting was on 2005-02-18 18:14:35.0Z
Michael Welter Posted on 2005-02-18 16:07:37.0Z
From: "Michael Welter" <mike@introspect.com>
Newsgroups: ianywhere.public.general
Subject: connect string
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
X-Original-NNTP-Posting-Host: 64.207.35.66
Message-ID: <421612c4$1@forums-2-dub>
X-Original-Trace: 18 Feb 2005 08:07:32 -0800, 64.207.35.66
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 18 Feb 2005 08:07:35 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 18 Feb 2005 08:07:37 -0800
X-Trace: forums-1-dub 1108742857 10.22.108.75 (18 Feb 2005 08:07:37 -0800)
X-Original-Trace: 18 Feb 2005 08:07:37 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4146
Article PK: 8028

I'm trying to connect (unsuccessfully) to ASA7 using the following connect
string:

"ODBC; Driver=Adaptive Server Anywhere 7.0; DefaultDir=d:\DBDIR;
Dbf=D:\DBDIR\dataihw.db; Uid=***; Pwd=***;

What I would like it to do if reference my ODBC entry for that database. Is
tehre a way to do this?

Thanks


Simon Ogden Posted on 2005-02-18 16:16:27.0Z
From: "Simon Ogden" <simon.ogden2@btopenworld.com>
Newsgroups: ianywhere.public.general
References: <421612c4$1@forums-2-dub>
Subject: Re: connect string
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: 194.196.150.2
Message-ID: <421614d1$1@forums-2-dub>
X-Original-Trace: 18 Feb 2005 08:16:17 -0800, 194.196.150.2
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 18 Feb 2005 08:16:19 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 18 Feb 2005 08:16:27 -0800
X-Trace: forums-1-dub 1108743387 10.22.108.75 (18 Feb 2005 08:16:27 -0800)
X-Original-Trace: 18 Feb 2005 08:16:27 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4147
Article PK: 8031

use dsn=

"Michael Welter" <mike@introspect.com> wrote in message
news:421612c4$1@forums-2-dub...
> I'm trying to connect (unsuccessfully) to ASA7 using the following connect
> string:
>
> "ODBC; Driver=Adaptive Server Anywhere 7.0; DefaultDir=d:\DBDIR;
> Dbf=D:\DBDIR\dataihw.db; Uid=***; Pwd=***;
>
> What I would like it to do if reference my ODBC entry for that database.
> Is
> tehre a way to do this?
>
> Thanks
>
>


Michael Welter Posted on 2005-02-18 16:32:35.0Z
From: "Michael Welter" <mike@introspect.com>
Newsgroups: ianywhere.public.general
References: <421612c4$1@forums-2-dub> <421614d1$1@forums-2-dub>
Subject: Re: connect string
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
X-Original-NNTP-Posting-Host: 64.207.35.66
Message-ID: <4216189e$1@forums-2-dub>
X-Original-Trace: 18 Feb 2005 08:32:30 -0800, 64.207.35.66
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 18 Feb 2005 08:32:33 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 18 Feb 2005 08:32:35 -0800
X-Trace: forums-1-dub 1108744355 10.22.108.75 (18 Feb 2005 08:32:35 -0800)
X-Original-Trace: 18 Feb 2005 08:32:35 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4148
Article PK: 8029

OK, that works. Thank you.

To avoid setting-up a DSN on each workstation, can I use the "ODBC; Driver="
form of the connect string? Where can I find a reference for this?

Thanks

"Simon Ogden" <simon.ogden2@btopenworld.com> wrote in message
news:421614d1$1@forums-2-dub...
> use dsn=
>
> "Michael Welter" <mike@introspect.com> wrote in message
> news:421612c4$1@forums-2-dub...
> > I'm trying to connect (unsuccessfully) to ASA7 using the following
connect
> > string:
> >
> > "ODBC; Driver=Adaptive Server Anywhere 7.0; DefaultDir=d:\DBDIR;
> > Dbf=D:\DBDIR\dataihw.db; Uid=***; Pwd=***;
> >
> > What I would like it to do if reference my ODBC entry for that database.
> > Is
> > tehre a way to do this?
> >
> > Thanks
> >
> >
>
>


Chris Keating (iAnywhere Solutions) Posted on 2005-02-18 18:14:35.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <Spam_NoThanks_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <421612c4$1@forums-2-dub> <421614d1$1@forums-2-dub> <4216189e$1@forums-2-dub>
Subject: Re: connect string
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: keating-xp2.sybase.com
Message-ID: <42163087$1@forums-2-dub>
X-Original-Trace: 18 Feb 2005 10:14:31 -0800, keating-xp2.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 18 Feb 2005 10:14:33 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 18 Feb 2005 10:14:35 -0800
X-Trace: forums-1-dub 1108750475 10.22.108.75 (18 Feb 2005 10:14:35 -0800)
X-Original-Trace: 18 Feb 2005 10:14:35 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4150
Article PK: 8030

What application development tool are you using?

"Michael Welter" <mike@introspect.com> wrote in message
news:4216189e$1@forums-2-dub...
> OK, that works. Thank you.
>
> To avoid setting-up a DSN on each workstation, can I use the "ODBC;
> Driver="
> form of the connect string? Where can I find a reference for this?
>
> Thanks
>
> "Simon Ogden" <simon.ogden2@btopenworld.com> wrote in message
> news:421614d1$1@forums-2-dub...
>> use dsn=
>>
>> "Michael Welter" <mike@introspect.com> wrote in message
>> news:421612c4$1@forums-2-dub...
>> > I'm trying to connect (unsuccessfully) to ASA7 using the following
> connect
>> > string:
>> >
>> > "ODBC; Driver=Adaptive Server Anywhere 7.0; DefaultDir=d:\DBDIR;
>> > Dbf=D:\DBDIR\dataihw.db; Uid=***; Pwd=***;
>> >
>> > What I would like it to do if reference my ODBC entry for that
>> > database.
>> > Is
>> > tehre a way to do this?
>> >
>> > Thanks
>> >
>> >
>>
>>
>
>