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 |
|
nmendesc1
Starting Member
11 Posts |
 Posted - 2004-04-15 : 10:35:41
|
| HelloI need to use DTS to import rows from a SUN database. My problem is that i don't have a ODBC to do this. Could anyone help me?Thank youNuno Mendes |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-04-15 : 11:25:31
|
quote:
Originally posted by nmendesc1
HelloI need to use DTS to import rows from a SUN database. My problem is that i don't have a ODBC to do this. Could anyone help me?Thank youNuno Mendes
can you dump the data from the SUN database to a comma delimited file or other flatfile? YOu could then DTS that instead.-ec |
 |
|
|
nmendesc1
Starting Member
11 Posts |
Posted - 2004-04-15 : 11:29:59
|
| HellloThat is one solution, but i prefer to have direct access to the SUN db.Nuno Mendes |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-15 : 12:28:42
|
| Your options are ODBC or files. Does no ODBC driver exist for the database?Tara |
|
|
|
nmendesc1
Starting Member
11 Posts |
Posted - 2004-04-15 : 12:35:31
|
| I´m shearching in the internet but i´m not finding...Nuno Mendes |
|
|
|
nmendesc1
Starting Member
11 Posts |
Posted - 2004-04-15 : 12:36:05
|
| ...for the ODBC.Nuno Mendes |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-15 : 12:36:55
|
| Do you know what RDBMS it is cuz isn't SUN just the platform?Tara |
|
|
|
nmendesc1
Starting Member
11 Posts |
Posted - 2004-04-21 : 06:33:03
|
| Yes, but i' can't find a odbc driver to connect directly to SUN platform. I don't want any user intervention in this process.Nuno Mendes |
|
|
|
|
|
|
SQL and SUN databases