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.

SQL and Connection string

3 posts in Visual Basic Last posting was on 2005-12-09 17:32:18.0Z
Carl Zuroski Posted on 2005-12-09 15:27:27.0Z
Reply-To: "Carl Zuroski" <czuroski@parentenet.com>
From: "Carl Zuroski" <czuroski@parentenet.com>
Newsgroups: advantage.visual_basic
Subject: SQL and Connection string
Date: Fri, 9 Dec 2005 10:27:27 -0500
Lines: 13
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: 63.170.27.144
Message-ID: <4399a198@solutions.advantagedatabase.com>
X-Trace: 9 Dec 2005 08:24:08 -0700, 63.170.27.144
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!63.170.27.144
Xref: solutions.advantagedatabase.com Advantage.Visual_Basic:1049
Article PK: 1137843

Hello,
I am using Advantage with MS Access. What I am trying to do is use a
'Select....INTO....." SQL statement to extract data from a free Advantage
table and load it into an Access table using ADO. What I am using is -
"Select employee.* Into test From [" & myAccessStr & "].test" where
myAccessStr is the connection string to the access database.
This is giving me a 5041 error. But it looks like it is having problems
with the free table. The error says "link object is not supported on free
connection. Is this a problem with my connection string?

Thanks


Carl Zuroski Posted on 2005-12-09 16:37:07.0Z
Reply-To: "Carl Zuroski" <czuroski@parentenet.com>
From: "Carl Zuroski" <czuroski@parentenet.com>
Newsgroups: advantage.visual_basic
References: <4399a198@solutions.advantagedatabase.com>
Subject: Re: SQL and Connection string
Date: Fri, 9 Dec 2005 11:37:07 -0500
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: 63.170.27.144
Message-ID: <4399b1ee@solutions.advantagedatabase.com>
X-Trace: 9 Dec 2005 09:33:50 -0700, 63.170.27.144
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!63.170.27.144
Xref: solutions.advantagedatabase.com Advantage.Visual_Basic:1050
Article PK: 1137844

Sorry.....I have put the wrong sql statement in the previous post. What I am
using is - "Select * Into " & myAccessStr & ".test From employee"

Sorry for any confustion.

"Carl Zuroski" <czuroski@parentenet.com> wrote in message
news:4399a198@solutions.advantagedatabase.com...
> Hello,
> I am using Advantage with MS Access. What I am trying to do is use a
> 'Select....INTO....." SQL statement to extract data from a free Advantage
> table and load it into an Access table using ADO. What I am using is -
> "Select employee.* Into test From [" & myAccessStr & "].test" where
> myAccessStr is the connection string to the access database.
> This is giving me a 5041 error. But it looks like it is having problems
> with the free table. The error says "link object is not supported on free
> connection. Is this a problem with my connection string?
>
> Thanks
>


"Lee Stigile" <lees Posted on 2005-12-09 17:32:18.0Z
From: "Lee Stigile" <lees@nospam_extendsys.com>
Newsgroups: advantage.visual_basic
References: <4399a198@solutions.advantagedatabase.com> <4399b1ee@solutions.advantagedatabase.com>
Subject: Re: SQL and Connection string
Date: Fri, 9 Dec 2005 10:32:18 -0700
Lines: 43
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: 192.168.30.168
Message-ID: <4399bef2@solutions.advantagedatabase.com>
X-Trace: 9 Dec 2005 10:29:22 -0700, 192.168.30.168
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!192.168.30.168
Xref: solutions.advantagedatabase.com Advantage.Visual_Basic:1051
Article PK: 1137845

I don't know the solution, but I can help explain the problem. Advantage
allows users to select from multiple data dictionaries (databases). In ADS,
this is refered to as a linked table and it's referenced by "[dictionaryname
or path]".[tablename] This is the same syntax that you are using. IOW,
there's nothing wrong with your connection string, it's the SQL syntax. The
following syntax is problematic: From [" & myAccessStr & "].test" ADS
thinks that you're trying to access another ADS database.

Sorry - I don't know the solution, besides linking both tables in access,
which would allow you to refer to both tables by name. Unfortunately, you'd
have to use the ODBC driver. You may just have to loop through two
different recordsets copying the values from one set to the other set.

Lee

"Carl Zuroski" <czuroski@parentenet.com> wrote in message
news:4399b1ee@solutions.advantagedatabase.com...
> Sorry.....I have put the wrong sql statement in the previous post. What I
> am using is - "Select * Into " & myAccessStr & ".test From employee"
>
> Sorry for any confustion.
>
>
>
> "Carl Zuroski" <czuroski@parentenet.com> wrote in message
> news:4399a198@solutions.advantagedatabase.com...
>> Hello,
>> I am using Advantage with MS Access. What I am trying to do is use a
>> 'Select....INTO....." SQL statement to extract data from a free Advantage
>> table and load it into an Access table using ADO. What I am using is -
>> "Select employee.* Into test From [" & myAccessStr & "].test" where
>> myAccessStr is the connection string to the access database.
>> This is giving me a 5041 error. But it looks like it is having problems
>> with the free table. The error says "link object is not supported on
>> free connection. Is this a problem with my connection string?
>>
>> Thanks
>>
>
>