Import From Sybase

[linroc]

Hi,

i am trying to import some data from a remote sybase system. I am able to make the odbc connection. But i keep getting an error – because i can't assign the table owner.

The sybase operates with a owner.tablename notation how do i solve this ?? Is it possible to get in and edit the script instead of the wizard doing it all??

The connection/odbc works – because i can get past all the init stuff and see the tables on the sybase server (but without 'owner').

I get this error:

“Duplicate column name 'ORDER_NUMBER'”

which i assume is because the owner is missing?

I hope this i understandable – and that someone has an idea what to do.

Claus

[Ritesh]

Which version of Sybase are you using?

Could you provide me a link to some kind of trial download for this version of Sybase. I need to set up your environment out here.

[linroc]

Ritesh wrote on Sep 2 2005, 08:39 PM:

Which version of Sybase are you using?

Could you provide me a link to some kind of trial download for this version of Sybase. I need to set up your environment out here.

[post=”7077″]<{POST_SNAPBACK}>[/post]

Hi,

sorry for the late reply – but I went on holiday in Tyrkey 😀

I am pretty sure it's an old Sybase System 11.

I have no knowledge of trial versions of this db (I am extracting data for some customers on their old Unix systems). So i can't even check anything before next time I am at an customer.

I can see that this won't be easy to follow up on – but i am hoping for the best 😕

/cartmann

[Ritesh]

Are you able to extract data correctly using another ODBC application like Excel, MS Access? Basically, I want to know whether it is an issue with your ODBC driver.

[Ritesh]

Can we get temporary access to the Sybase database?

[linroc]

Ritesh wrote on Sep 15 2005, 07:58 PM:

Can we get temporary access to the Sybase database?

[post=”7182″]<{POST_SNAPBACK}>[/post]

Tommorow i will be able to get access to a customer db – so i will try with other clients (it might be a odbc driver problem as you are suggesting)

It is impossible to give you access to these db's – sorry.

I will send more info tommorow when i have db access.

/cartmann

[Ritesh]

Waiting for your comments.

[linroc]

Hi Ritesh,

now I am at the customer. Import through access using exact same odbc works fine – but here I also see the tables with the owner dotted infront

example

test.cardfile

user1.cardfile

I have attached an image of the error I receive – it seems to me that the owner should be inserted somewhere.

[attachment=243:attachment]

Is it possible somehow to edit the sql send by the import wizard??

All hints would be appreciated 🙂

Best regards

Claus

[linroc]

Hi Ritesh,

I've found it 😀

Maybe I am just a little slow 😕 – but in one of the first menu'es in the import wizard one can choose to make your own select.

So i simply uses a select like:

“select * from user1.CARD_FILE”

completes the rest of the wizard and bingo 😀

So thanks for your efforts I am on the way

best regards

Claus

[peterlaursen]

@Claus

I think this should in our FAQ!

Would you mind explain a little bit further ?

And one ore more screenshot(s) explaining where and what you did would be much appreciated.

Do you know whether this is an issue related to a specific Sybase version or -configuration ?

[Ritesh]

We just installed the trial version of Sybase 12.5.2 but we are unable to reproduce the error. 🙁

Can you tell me steps to reproduce the same configuration at our end? How do we create a user with permissions similar to your setup?

Also which Sybase ODBC Driver are you using?

[linroc]

Hi Ritesh,

sorry for not replying – but I thought this thread was ended – and I haven't received any mails about new messages (probably my own fault – haven't configured much on my profile.

I can't tell you much though. The db which caused the problems is an old Sybase version I haven't acces to it anymore.

I am using same version as you are testing with (12.5.2) – but I really think the issue is on the db side.

Sorry I can't help you more – but I am working on these customer tables on a nonregular basis as a freelance consultant (usually a 1 shoot visit to retrive data for conversion) so I haven't got acces to them.

Thanks for Your efforts

/Claus

Ritesh wrote on Sep 22 2005, 03:58 PM:

We just installed the trial version of Sybase 12.5.2 but we are unable to reproduce the error.  🙁

Can you tell me steps to reproduce the same configuration at our end? How do we create a user with permissions similar to your setup?

Also which Sybase ODBC Driver are you using?

[post=”7272″]<{POST_SNAPBACK}>[/post]

[Author]

Posts