由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - SQL server to ODBC export question
相关主题
大俠 问个关于asp连SQL server的问题how to link to remote access database?
[转载] MS SQL Server有没有一个C API?[转载] ASP问题: Operation must use an updateable query
大家关于用VC透过ODBC来操作SQL数据库是什么看法?[Help]怎么改Access数据库所在的文件夹权限?
有人抽取过AS/400(iSeries)的数据么?为啥不能delete Excel记录???
SQL Server 2008 Exp 怎么export DBF file?请教如何将teradata的数据导入oracle?
扯扯Senior SQL Server DBA咋整 (2)SQL Server 2000 email alert的问题
One question!刚装的 SQL server 2012 express 咋打不开呀?
questions about exporting M.S.Access to MySQLQuestion
相关话题的讨论汇总
话题: odbc话题: export话题: db话题: sql话题: server
进入Database版参与讨论
1 (共1页)
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

1 (共1页)
进入Database版参与讨论
相关主题
QuestionSQL Server 2008 Exp 怎么export DBF file?
urgent: how to compare two dates in SQL?扯扯Senior SQL Server DBA咋整 (2)
One question on SQL ServerOne question!
Question about T-SQLquestions about exporting M.S.Access to MySQL
大俠 问个关于asp连SQL server的问题how to link to remote access database?
[转载] MS SQL Server有没有一个C API?[转载] ASP问题: Operation must use an updateable query
大家关于用VC透过ODBC来操作SQL数据库是什么看法?[Help]怎么改Access数据库所在的文件夹权限?
有人抽取过AS/400(iSeries)的数据么?为啥不能delete Excel记录???
相关话题的讨论汇总
话题: odbc话题: export话题: db话题: sql话题: server