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

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

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

 

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

 -Ñòàòèñòèêà

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


Ïåðåäà÷å ïàðîëÿ ñ ñèìâîëîì " ; " â ñòðîêå ïîäêëþ÷åíèÿ ê ÁÄ MSSQL

Ïÿòíèöà, 05 Èþíÿ 2015 ã. 11:40 + â öèòàòíèê
Äîáðûé äåíü. Âîçíèê âîïðîñ ïî ïîâîäó ïîäêëþ÷åíèÿ ê ñåðâåðó MSSQL èç ACCESS 2003.
Èñïîëüçóåòñÿ ñòðîêà ïîäêëþ÷åíèÿ:

Dim ss As String
Dim pas AS String

pass = "bla;bla"
ss = "ODBC; Driver={SQL Server};Server=server; Database=database;UID=èìÿ; PWD=" & pas & _
	";AnsiNPW=No;AutoTranslate=No;QuotedId=No;APP=çàäà÷à"


Âñå ðàáîòàåò îòëè÷íî, õîòü è óñòàðåëî.
Íî âîçíèê îäèí íþàíñ: åñëè ïàðîëü ñîäåðæèò ñèìâîë ';', òî âûäàåò îøèáêó.
Äóìàë, ÷òî ACCESS íå ïîääåðæèâàåò ýòîò çíàê â ïåðåäà÷å ïàðîëÿ, íî ïðè êîííåêòå ê òàáëèöå ïðè ïîìîùè êîíñòðóêòîðà èç ACCESS âñå ïðîõîäèò õîðîøî!!!
Êòî ñòàëêèâàëñÿ, êàê ðåøèëè ïðîáëåìó?

Ïðîáîâàë âàðèàíò ýêðàíèðîâàíèÿ, íî ðåçóëüòàòà íåò.
Íèæå ìîè âàðèàíòû:

Dim ss As String
Dim pas AS String
pass = "bla;bla"
'èëè
pass = """bla;bla"""
'èëè
pass = "bla{;}bla"
'èëè
pass = """bla{;}bla"""
'èëè
pass = "bla^;bla"
'èëè
pass = """bla^;bla"""
'èëè
pass = "bla\;bla"
'èëè
pass = """bla\;bla"""
'èëè
pass = "bla/;bla"
'èëè
pass = """bla/;bla"""
ss = "ODBC; Driver={SQL Server};Server=server; Database=database;UID=èìÿ; PWD=" & pas & _
	";AnsiNPW=No;AutoTranslate=No;QuotedId=No;APP=çàäà÷à"


Êòî ñòàëêèâàëñÿ èëè ïðîñòî ìîæåò ïîäñêàçàòü, áóäó ðàä ðåøåíèþ, çàðàíåå ñïàñèáî!

P.S. Çàìåíà ïàðîëÿ ýòî íå âàðèàíò. Òàêèå ïîñòàâëåíû óñëîâèÿ.

http://www.sql.ru/forum/1160119/peredache-parolya-s-simvolom-v-stroke-podklucheniya-k-bd-mssql


 

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

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

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

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