[adarsh]

Hello,

ALT+A will open the “Advanced Properties” window in alter table grid and ALT+N will close the alter table grid.

[adarsh]

Hi,

Tell me are you installed more than one version of ASE?

When we install a ASE it will create a four types of servers 1) Sybaes BCKServer 2) SybaseMONServer 3)Sybase SQLServer 4) Sybase XP Server

by default it will take your system name as server name and it will create the server names like this. you need to use the SQL server name in Server Name field in create DSN window.

1) ADARSH_BS for Backup Server

2) ADARSH_MS for MOnitoring Server

3) ADARSH for SQL Server

4) ADARSH_XP for XP Server

If you install the ASE server of another version then it will create name like this ADARSH_BS1,ADARSH_MS1,ADARSH1,ADARSH_XP1 so if you installed more than one verion of server please specify server name.

I tried to create a DSN without specifying the server name i am getting error.

Please verify the server name in which you created that database and also please verify the login id you used to create that database and table and also please specify the port of that correct server in which you have created the database and table.

You need to use that Server Name and Logon Id and correct port.

[adarsh]

Hi,

After installing that ODBC driver from ASE 15.0 installer did you find any driver like “Adaptive Enterprise Server” in control panel–>Administrator tool–>DataSource(ODBC)–>Add. because i just tried to import a table with PK and Unique key using this driver it is working properly.

Please use this driver.

While creating the DSN you have to specify the correct Server Name(host server) and correct Logon ID.

If you create a table using Logon id “sa” default user, then you have to specify that Login ID in create DSN window.

Make sure that all the details (Server Name, Logon ID, Server Port, Database Name) you are entering while creating the DSN are correct.

Adarsh

[adarsh]

Hello,

Thanks for reporting. Issue is confirmed we will fix this in beta2 and we will release soon.

[adarsh]

hi,

I think what you want is to print `TRUE`(1) if there exists at least one match else `FALSE`(0)

for that you can use :

select count(*) >= 1 from test where testdata = 5;

This will return `1` if there is one or more rows that satisfies the given condition.

else if no match is found it will return `0`

If you want the number of matching rows then simply execute the following.

select count(*) from test where testdata = 5;

hope that will solve the problem.

[adarsh]

Hello,

it is not reproducable here.

If you can give us a dump with a test case (schema and that CSV file) we will try to reproduce.

[adarsh]

From here you can download Sybase (Adaptive Server 15.0) for windows, while installing select custom install and choose ODBC driver from components.

This will install a driver called “Adaptive Server Enterprise” with this ODBC driver you should able connect and it will wiok perfectly please try this.

http://www.sybase.com/detail?id=1037439

[adarsh]

While Installing the Adaptive Server select custom install and choose ODBC driver from the components and install.

This will install a driver called “Adaptive Server Enterprise” use this driver this will work.

[adarsh]

We installed the driver which you mentioned in your last post “DATA DIRECT 'S SYBASE WIRE PROTOCOL DRIVERS” and we tried to import we got same problem what you are facing. This is a driver issue.

Please try to install the driver from “Adaptive Server” (to install this you need to select custom install) and try it will work properly.

[adarsh]

Yes we are looking for more information.

Can you export that 2 tables as SQL dump and zip it and attach here don't paste so that we can import easily. This would be the best way to ensure that we don't do any mistakes.

Without this information we cannot do anything.

[adarsh]

We have now installed Adaptive Enterprise Server 15.0 and the ODBC driver that ships with the installer. A fast setup with two small tables gave:

Code:

SQLyog Job Agent Version 5.26
Copyright (c) Webyog Softworks Pvt. Ltd.. All Rights Reserved.

Job started at Wed Mar 28 19:24:26 2007

DBMS Information: SQL SERVER
Importing table schema: Dept… Successful…
Importing table schema: Employees… Successful…
Importing table foreign keys: Dept… Successful…
Importing table foreign keys: Employees… Successful…
Importing table data: Dept…

3 rows transferred!
Successful…

Importing table data: Employees…

3 rows transferred!

Successful…

Total time taken – 1 sec(s)

There are PK's, Unique indexes in both tables and a Foreign Key.

We cannot reproduce, as you see. Everything imports.

It is not the same server version as yours. this is the one that we could get.

A google search tells about a lot of issues with ODBC drivers.

There are a lot of unoriginal drivers. And the original driver does not install as default. You will have to select from the 'custom install' option of the installer.

Are you perfectly sure that you can retrieve data with your ODBC driver to some other program (MS Access / Open Office Base for instance) ?

If you can give us a dump with a test case (schema, a few tables with a few rows of data) we will try to reproduce.

[adarsh]

Please read this : http://www.webyog.com/faq/23_15_en.html

Are you using tunneling if so, please specify which tunneling you are using HTTP or SSH.

[adarsh]

any news?

We would like to ensure that everything is fixed before next release.

[adarsh]

reproduced here!

thanks for giving the details. It is happening only for this table “ind1log” may be some data specific issue. we will fix this in next release.

thanks.

[adarsh]

Issue is confirmed. we will fix this in next release.

[Author]

Posts