-Ïîèñê ïî äíåâíèêó

Ïîèñê ñîîáùåíèé â rss_sql_ru_access_programming

 -Ïîäïèñêà ïî e-mail

 

 -Ïîñòîÿííûå ÷èòàòåëè

 -Ñòàòèñòèêà

Ñòàòèñòèêà LiveInternet.ru: ïîêàçàíî êîëè÷åñòâî õèòîâ è ïîñåòèòåëåé
Ñîçäàí: 16.03.2006
Çàïèñåé:
Êîììåíòàðèåâ:
Íàïèñàíî: 4


Òóïëþ ñ çàïðîñîì

Ïÿòíèöà, 25 Ìàÿ 2018 ã. 13:58 + â öèòàòíèê
È òàê, íàïðÿìóþ ïîäêëþ÷àþñü ê òàáëèöå ñåðâåðà, íî íå ìîãó ïîëó÷èòü äàííûå òàáëèöû
Public Sub main()
    Dim cnt As ADODB.Connection
    Dim etp, msk As Object
    Set etp = CreateObject("ADODB.Recordset")
    Set msk = CreateObject("ADODB.Recordset")
Set cnt = New ADODB.Connection
cnt.ConnectionString = "ODBC;Description=test;Driver=SQL Server; SERVER=rtvs-sql1204.local;APP=Microsoft Office 2010; UID=user;PWD=111111;DATABASE=db_production;TABLE=dbo_tehpro_tblprocessdefinitions"
'êîíåêòèìñÿ ïðÿìî ê òàáëèöå
cnt.Open
Ask = "SELECT [subdivision], [master], [code], [element_def] FROM [dbo_tehpro_tblprocessdefinitions]"
Set etp = cnt.Execute(Ask)
cnt.Close
End Sub

×òî ÿ äåëàþ íå òàê?

http://www.sql.ru/forum/1294277/tuplu-s-zaprosom


 

Äîáàâèòü êîììåíòàðèé:
Òåêñò êîììåíòàðèÿ: ñìàéëèêè

Ïðîâåðêà îðôîãðàôèè: (íàéòè îøèáêè)

Ïðèêðåïèòü êàðòèíêó:

 Ïåðåâîäèòü URL â ññûëêó
 Ïîäïèñàòüñÿ íà êîììåíòàðèè
 Ïîäïèñàòü êàðòèíêó