Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| 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 nameC:\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 appreciatyedBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd 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=110938The 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 installedDid 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 1But 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 delimiterI'll keep plugging and let you all know what happensBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd 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?