|
Home > Archive > Sybase ADO .NET > November 2005 > Connection issue with Sybase using Studio 2003 using GUI
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Connection issue with Sybase using Studio 2003 using GUI
|
|
|
| When I use Server Explorer in studio 2003 the connection fails , and also
get some errors.
1.. I used Sybase ADO Provider, when the Data Link properties comes I am
able to the test connection successfully, once I have the connection when I
click on the tables , Procedures etc I get the Connection Failure Error.
So I cannot do any thing with this connection.
2.. I used Sybase ASE OLE DB Provider in the Data Link properties same as
above successful connection, the tables expand and procedure come up(I can
see all the objects)
when I try to drag and drop a table in the schema File in Studio I
get this error
The wizard detected the following problems when configuring the data
adapter for "order_master"
Details:
Error in Select clause:expression near"".
Error in From clause:near"".
Unable to parse query text.
I am using the Sybase driver and in the code and it works fine, but want to
the GUI(Graphics) drag and drops.
If any of u know the fix please let me know
Thanks
bhu
| |
|
| Hi -
Please be specific in citing the exact version and names of the Providers.
I assume you are using the Sybase ASE OLE DB Provider included in teh Sybase
SDK 12.5.1 or 15.0 (ESD#?)
Sybase ADO Provider does not sound like a Sybase product but maybe from
DataDirect.
Sybase ASE OLE DB Provider is an OEM product, and we also have Sybase OLEDB
Provider, which seems to work, except that it is appending "odbc" to the end
of the select object (I think this is supposed to be in front) -
it deos select * from dbo.tableName.odbc, where it should be select * from
odbc.dbo.tableName (odbc is the database I am using)
If this is the problem please report it to Sybase Tech Support (that is if
you are using the ASE OLEDB Provider by Sybase, which displays as Sybase
OLEDB Provider in the Provider list when creating the connection)
-Paul
"bhu" <bhu. karunanithi@newroads
.com> wrote in message
news:437a7808@forums
-1-dub...
> When I use Server Explorer in studio 2003 the connection fails , and also
> get some errors.
>
>
>
> 1.. I used Sybase ADO Provider, when the Data Link properties comes I
am
> able to the test connection successfully, once I have the connection when
I
> click on the tables , Procedures etc I get the Connection Failure Error.
> So I cannot do any thing with this connection.
>
>
>
> 2.. I used Sybase ASE OLE DB Provider in the Data Link properties same
as
> above successful connection, the tables expand and procedure come up(I
can
> see all the objects)
> when I try to drag and drop a table in the schema File in Studio I
> get this error
>
> The wizard detected the following problems when configuring the data
> adapter for "order_master"
>
> Details:
>
> Error in Select clause:expression near"".
>
> Error in From clause:near"".
>
> Unable to parse query text.
>
>
>
> I am using the Sybase driver and in the code and it works fine, but want
to
> the GUI(Graphics) drag and drops.
>
> If any of u know the fix please let me know
>
> Thanks
>
> bhu
>
>
| |
|
| Hi
paul i am using the version 12.5.1 i tried what u have told, i still could
not get it to create the schema.
can u please give me a step by step info,
I unintalled all the sybase driver and reinstalled only 12.5.1 once i did
that i get the Sybase ASE OLE DB Provider in the
Studio Data link properties.
I created a odbc connection in the odbc admin the driver used is Sybase ASE
ODBC Driver
in the studio i created a Microsoft OLE DB Provider for ODBC Driver and
using the created DSN from odbc connection sucessfull, pulls the tables but
when i drop it to the schema i get the DataDirect ODBC sybase wire protocol
error.
i think i may be making some error so could be please give me the steps u
took to get this working.
thanks
bhu
"Paul" <Paul@sybase.com> wrote in message news:437b9c7c$1@foru
ms-2-dub...
> Hi -
>
> Please be specific in citing the exact version and names of the Providers.
> I assume you are using the Sybase ASE OLE DB Provider included in teh
> Sybase
> SDK 12.5.1 or 15.0 (ESD#?)
>
> Sybase ADO Provider does not sound like a Sybase product but maybe from
> DataDirect.
>
> Sybase ASE OLE DB Provider is an OEM product, and we also have Sybase
> OLEDB
> Provider, which seems to work, except that it is appending "odbc" to the
> end
> of the select object (I think this is supposed to be in front) -
>
> it deos select * from dbo.tableName.odbc, where it should be select * from
> odbc.dbo.tableName (odbc is the database I am using)
> If this is the problem please report it to Sybase Tech Support (that is if
> you are using the ASE OLEDB Provider by Sybase, which displays as Sybase
> OLEDB Provider in the Provider list when creating the connection)
>
> -Paul
>
> "bhu" <bhu. karunanithi@newroads
.com> wrote in message
> news:437a7808@forums
-1-dub...
> am
> I
> as
> can
> to
>
>
| |
|
| Hi
I will go do that now - do you know the exact version ? Look a tthe
SYDAASE.DLL file version and post it. If you are on the 12.5.1 GA, try
ESD#10
I be right back with the steps - maybe i am doing something different
-Paul
"bhu" <bhu. karunanithi@newroads
.com> wrote in message
news:437e2f00$1@foru
ms-1-dub...
> Hi
> paul i am using the version 12.5.1 i tried what u have told, i still
could
> not get it to create the schema.
> can u please give me a step by step info,
> I unintalled all the sybase driver and reinstalled only 12.5.1 once i did
> that i get the Sybase ASE OLE DB Provider in the
> Studio Data link properties.
> I created a odbc connection in the odbc admin the driver used is Sybase
ASE
> ODBC Driver
> in the studio i created a Microsoft OLE DB Provider for ODBC Driver and
> using the created DSN from odbc connection sucessfull, pulls the tables
but
> when i drop it to the schema i get the DataDirect ODBC sybase wire
protocol
> error.
> i think i may be making some error so could be please give me the steps u
> took to get this working.
> thanks
> bhu
>
>
> "Paul" <Paul@sybase.com> wrote in message news:437b9c7c$1@foru
ms-2-dub...
Providers.[color=darkred]
from[color=darkred]
if[color=darkred]
also[color=darkred]
I[color=darkred]
when[color=darkred]
Error.[color=darkred]
same[color=darkred]
I[color=darkred]
want[color=darkred]
>
>
| |
|
| Hi bhu
1. From the MS Development Env (Visual Studio 2003)
I go to Server Explorer
2. Under Data Connection: select Add a Connection
3. Go to Provider tab and select Sybase ASE OLE DB Provider
4. FIll in the props you need for connectivity and test connection
5. After creating this connection - I click and there should be fields for
Tables, Views, Stored Procedures
6. expand Tables and select one. Expand the table and you should see the
columns. When I retrieve the data it displays.
7. Now this was with 12.5.1 GA Sydaase.dll: 2.70.0023
8. Now I add connection and setup with Sybase ASE ODBC Driver (Syodase.dll:
4.20.0015)
9. When I do this it also works - I get metadata and I can open the table
and retrieve the data.
Are you doing it this way? I am hitting ASE 12.5.3 on WinXP. It is:
Adaptive Server Enterprise/12.5.3/EBF 12461 ESD#2/P/NT (IX86)/OS
4.0/ase1253/19
04/32-bit/OPT/Tue Mar 22 17:23:51 2005
-Paul
"bhu" <bhu. karunanithi@newroads
.com> wrote in message
news:437e2f00$1@foru
ms-1-dub...
> Hi
> paul i am using the version 12.5.1 i tried what u have told, i still
could
> not get it to create the schema.
> can u please give me a step by step info,
> I unintalled all the sybase driver and reinstalled only 12.5.1 once i did
> that i get the Sybase ASE OLE DB Provider in the
> Studio Data link properties.
> I created a odbc connection in the odbc admin the driver used is Sybase
ASE
> ODBC Driver
> in the studio i created a Microsoft OLE DB Provider for ODBC Driver and
> using the created DSN from odbc connection sucessfull, pulls the tables
but
> when i drop it to the schema i get the DataDirect ODBC sybase wire
protocol
> error.
> i think i may be making some error so could be please give me the steps u
> took to get this working.
> thanks
> bhu
>
>
> "Paul" <Paul@sybase.com> wrote in message news:437b9c7c$1@foru
ms-2-dub...
Providers.[color=darkred]
from[color=darkred]
if[color=darkred]
also[color=darkred]
I[color=darkred]
when[color=darkred]
Error.[color=darkred]
same[color=darkred]
I[color=darkred]
want[color=darkred]
>
>
| |
|
| Hi Bhu,
I upgraded SDK 12.5.1 to esd 11
exisiting ODBC driver was good - but my ASE OLE DB Provider connection threw
an error about the Connection string being out of spec - I recreated the
connection on the object (I did not delete - just did add connection) and it
worked fine)
Let me know what you find...
-Paul
"Paul" <Paul@sybase.com> wrote in message news:437e5e21$1@foru
ms-1-dub...
> Hi bhu
>
> 1. From the MS Development Env (Visual Studio 2003)
> I go to Server Explorer
>
> 2. Under Data Connection: select Add a Connection
>
> 3. Go to Provider tab and select Sybase ASE OLE DB Provider
>
> 4. FIll in the props you need for connectivity and test connection
>
> 5. After creating this connection - I click and there should be fields
for
> Tables, Views, Stored Procedures
>
> 6. expand Tables and select one. Expand the table and you should see the
> columns. When I retrieve the data it displays.
>
> 7. Now this was with 12.5.1 GA Sydaase.dll: 2.70.0023
>
> 8. Now I add connection and setup with Sybase ASE ODBC Driver
(Syodase.dll:
> 4.20.0015)
>
> 9. When I do this it also works - I get metadata and I can open the table
> and retrieve the data.
>
> Are you doing it this way? I am hitting ASE 12.5.3 on WinXP. It is:
> Adaptive Server Enterprise/12.5.3/EBF 12461 ESD#2/P/NT (IX86)/OS
> 4.0/ase1253/19
> 04/32-bit/OPT/Tue Mar 22 17:23:51 2005
>
> -Paul
>
> "bhu" <bhu. karunanithi@newroads
.com> wrote in message
> news:437e2f00$1@foru
ms-1-dub...
> could
did[color=darkred]
> ASE
> but
> protocol
u[color=darkred]
news:437b9c7c$1@foru
ms-2-dub...[color=darkred]
> Providers.
from[color=darkred]
the[color=darkred]
> from
is[color=darkred]
> if
Sybase[color=darkred
]
> also
comes[color=darkred]
> I
> when
> Error.
> same
up(I[color=darkred]
Studio[color=darkred
]
> I
> want
>
>
|
|
|
|
|