| Author |
Topic |
|
X002548
Not Just a Number
15586 Posts |
 Posted - 2009-02-04 : 14:05:23
|
Anyone have a background and can see what's the syntax problem here?
Also, How do you identify a server....they originally have what looks like a dns name
C:\Sybase\OCS-12_5\bin\bcp.exe "MMRS_INST.dbo.cloned_with" out "C:\MMRS\dev_mmrs_inst\dbo.cloned_with.DAT" -e"C:\MMRS\dev_mmrs_inst\dbo.cloned_with.ERR" -S"njros1bva0001:2048" -U"X002548" -P"xxxxxxxx" -f"C:\MMRS\dev_mmrs_inst\dbo.cloned_with.FMT" -b1000 -c -t|
Any help appreciatyed
Brett
8-)
Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Add yourself!
http://www.frappr.com/sqlteam
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-02-04 : 17:15:59
|
On the server do you have the sybase client tools installed?
If so, run dsedit or look in the Client Connectivity(?) -> ODBC configuration.
If not, then you have problems.. 
I've spent the last week or so trying to get a linked server setup in SQL 2008 64 bit to a Sybase 32 bit server, finally got it working today..  |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-04 : 17:32:57
|
quote:
Originally posted by RickD
On the server do you have the sybase client tools installed?
If so, run dsedit or look in the Client Connectivity(?) -> ODBC configuration.
If not, then you have problems..
I've spent the last week or so trying to get a linked server setup in SQL 2008 64 bit to a Sybase 32 bit server, finally got it working today..
RickD,
Can you explain what steps you applied to solve this? |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-02-04 : 17:37:19
|
We had to buy the Sybase SDK 15.0.3 then use the ODBC driver to create a linked server.
See here on another thread you had a part in http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=110938
The Sybase SDK is £123 per processor, so still cheaper than the openlink and definitely cheaper than DataDirect's drivers (which were shockingly expensive). |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-04 : 17:39:01
|
| Thanks for sharing. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2009-02-05 : 09:27:23
|
quote:
Originally posted by RickD
On the server do you have the sybase client tools installed?
If so, run dsedit or look in the Client Connectivity(?) -> ODBC configuration.
If not, then you have problems..
Yes, thanks.
Client tools are installed
Did you set up your sql.ini file on your client? And if so, where did you put it? I left it where I found it, and added the rows as the sybase developer mentioned. Still no joy.
Did find out that the pipe needed to be wraped like
-t"|"
But still there's a problem, because when we got the data from the developer, it had pipes in it...ok 1
But they don't want to do the unloads anymore....(they use dbartisan...so I don't think they know bcp all that well)...and I want to try
-t"|~|"
as a delimiter
I'll keep plugging and let you all know what happens
Brett
8-)
Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Add yourself!
http://www.frappr.com/sqlteam
|
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-02-06 : 06:18:17
|
You shouldn't need an ini file from the first post it seems you have an odbc connection (either that or the connection is trying to be made to servername) of njros1bva0001 port 2048.
What error is it throwing? Or is it the BCP general, i'm not gonna work and i'm not gonna tell you why error?
Also, what version of Sybase? There is a wizard in the ASE Plug-in for bcp, it may help. |
|
|
|
|
Sybase anyone?