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.

How to construct a connect string in VB?

3 posts in Windows NT Last posting was on 2000-08-31 00:31:36.0Z
Vinay Kothari Posted on 2000-03-24 17:44:04.0Z
Message-ID: <38DBA963.70D5C241@yahoo.com>
Date: Fri, 24 Mar 2000 10:44:04 -0700
From: Vinay Kothari <vinaykot@yahoo.com>
X-Mailer: Mozilla 4.7 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: How to construct a connect string in VB?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 11
NNTP-Posting-Host: vxkpc.Sunquest.COM 149.138.9.98
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2382
Article PK: 1089830

Hi,

We are trying to connect to sybase adaptive server 11.5 through VB. We
do not want to use DSN entry. We are trying to use this format to
construct the string.
"Driver=Sybase System 11;DATABSE=abc;UID=sa;PWD". But are geting error
saying "Insufficient Information to connect to data source".

We will really appreciate if someone can suggest the connect string.

Thanks,
Vinay Kothari


WelsonGao Posted on 2000-04-01 12:33:46.0Z
From: "WelsonGao" <welsongao@163.net>
References: <38DBA963.70D5C241@yahoo.com>
Subject: Re: How to construct a connect string in VB?
Date: Sat, 1 Apr 2000 20:33:46 +0800
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <Z#r9YE#m$GA.202@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 202.101.128.78
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2365
Article PK: 1089791


Vinay Kothari <vinaykot@yahoo.com> wrote in message
news:38DBA963.70D5C241@yahoo.com...
> Hi,
>
> We are trying to connect to sybase adaptive server 11.5 through VB. We
> do not want to use DSN entry. We are trying to use this format to
> construct the string.
> "Driver=Sybase System 11;DATABSE=abc;UID=sa;PWD". But are geting error
> saying "Insufficient Information to connect to data source".
>
> We will really appreciate if someone can suggest the connect string.
>
> Thanks,
> Vinay Kothari
>

We are using the string to connect to sybase 11.5 thtough vb6.0.
ConnString="Driver={Sybase System
11};Srvr=ServerName;Db=abc;Uid=UserID;Pwd=UserPwd"
note:
1. Srvr=ServerName ServerName is Configuring through Dsedit that is
a tool of Sybae client;
2. Db=abc abc is the name of your database;
my Email: WelsonGao@163.net


Anonymous Posted on 2000-08-31 00:31:36.0Z
From: Anonymous@sybase.com
Date: Wed, 30 Aug 2000 20:31:36 -0400
Newsgroups: sybase.public.sqlserver.nt
Subject: Re: How to construct a connect string in VB?
Message-ID: <00F2CC06038E8CDF0002E49F8525694C.0048C920852568B6@webforums>
References: <38DBA963.70D5C241@yahoo.com> <Z#r9YE#m$GA.202@forums.sybase.com>
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.nt:1681
Article PK: 1089159