t***u 发帖数: 368 | 1 Am trying to export some DB on SQL server 2005 to ODBC, selecting Tasks->
Export-> Wizard dialog pops out then.
select source DB, click "Next" and go to destination screen, trying to
find something like "Miscrosoft Ole DB provider for ODBC" but nothing,
do Google but no real answer to deal with, can any super guy here give me
some good hints?
appreciate! |
i****a 发帖数: 36252 | 2 ODBC is connection, not a database
what is the ODBC setup to connect to? export directly to there
>
me
【在 t***u 的大作中提到】 : Am trying to export some DB on SQL server 2005 to ODBC, selecting Tasks-> : Export-> Wizard dialog pops out then. : select source DB, click "Next" and go to destination screen, trying to : find something like "Miscrosoft Ole DB provider for ODBC" but nothing, : do Google but no real answer to deal with, can any super guy here give me : some good hints? : appreciate!
|
t***u 发帖数: 368 | 3 thanks for reply;
there is a mySQL DB behind ODBC...
any better way to export sql server db to mysql ?
【在 i****a 的大作中提到】 : ODBC is connection, not a database : what is the ODBC setup to connect to? export directly to there : : > : me
|
i****a 发帖数: 36252 | 4 I just looked and actually you can export via a ODBC connection
.NET Framework Data Provider for ODBC |
t***u 发帖数: 368 | 5 tried that one (odbc_net.msi) before, no work...
thx
【在 i****a 的大作中提到】 : I just looked and actually you can export via a ODBC connection : .NET Framework Data Provider for ODBC
|
B*****g 发帖数: 34098 | 6 可能需要mysql odbc driver,到mysql网站去下
【在 t***u 的大作中提到】 : tried that one (odbc_net.msi) before, no work... : thx
|