|
|
|
OPENROWSET
|
|||
|---|---|---|---|
|
#18+
Мне нужно получить данние из табле FoxPro. Создан ODBC k database FoxPro. Но statements SET @Connect = ODBC_name SET @temp_SQL = 'SELECT CAST(0 AS int) AS jobtitleid, jobtitle INTO tmpJobtitle FROM OPENROWSET(''MSDASQL.1'',''DSN='+ @Connect + ';'',''SELECT jobtitle FROM jobtitle'') ' EXEC (@temp_SQL) vidaet error: Msg 1799 OLE DB Provider 'MSDASQL.1' reported an error. [OLE/DB provider returned message: [Microsoft] [ODBC Visual FoxPro Driver] Cannot open file DB_name.dbc.] В чем причина ошибки? Databases FoxPro закрыты. Заранее спасибо ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 11.04.2007, 11:44 |
|
||
|
|

start [/forum/topic.php?desktop=1&fid=41&tid=1589550]: |
0ms |
get settings: |
9ms |
get forum list: |
10ms |
check forum access: |
2ms |
check topic access: |
2ms |
track hit: |
67ms |
get topic data: |
8ms |
get forum data: |
2ms |
get page messages: |
31ms |
get tp. blocked users: |
2ms |
| others: | 233ms |
| total: | 366ms |

| 0 / 0 |
