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 |
|
shahab03
Starting Member
28 Posts |
 Posted - 2007-05-02 : 16:21:01
|
| I am using Import and Export wizard and seeing a very weird behaviour. I am able to choose 'Microsoft OLE DB Provider for Oralce' and provide server name, username/ password. The test connection results in a success. However when I try to move to next window/page by clicking next I get invalid oracle error ora-01017 - invalid username/ password. what is going on here? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-02 : 22:36:22
|
| Try create odbc dsn to oracle then use ole db provider for odbc drivers, it works better in my experience. |
 |
|
|
kflee2000
Starting Member
14 Posts |
Posted - 2007-06-12 : 04:12:35
|
| >>Try create odbc dsn to oracle then use ole db provider for odbc >>drivers, it works better in my experience. the odbc olde db proivder for odbc drivers only in sql2000 but for sql2005 there is no option, it only provide you the ole db provider to oracle. |
|
|
|
|
|
|
Import Export problem