| |
Registered member
123 messages |
|
| Posted on January, 07 2016 - 7:52 PM |
Pra quem estiver utilizando Webdev com Apache e tentar utilizar Oledb para Mssql (Sql Server) vai receber este erro possivelmente
OLE DB access error. Error Number = 170124 Failure opening connection: Data Source:
OLEDB Provider: System Error Details: Class not registered/Clase não Registrada/Clase no Registrada
#############################################################################################
Estou supondo que todos os drivers de conexão já esta instalado (SQLNCLI correspondente a cada versão de SQL Server que se deseja conectar por exemplo SQLNCLI10 para o SQL 2008 ,etc)
#############################################################################################
Pois bem para contornar isto devemos alterar o http.conf do apache para ele reconhecer o Enviroment do sistema corretamente, que nada mais e que estas linhas
#############################################################################################
#Set Enviroment Manualmente para o Apache
SetEnv ProgramFiles "C:\Program Files"
SetEnv "ProgramFiles(x86)" "C:\Program Files (x86)"
SetEnv ProgramFilesW6432 "C:\Program Files"
SetEnv CommonProgramFiles "C:\Program Files\Common Files"
SetEnv "CommonProgramFiles(x86)" "C:\Program Files (x86)\Common Files"
SetEnv CommonProgramFilesW6432 "C:\Program Files\Common Files"
#Fin Set Enviromente
#############################################################################################
Feito isso só resta reiniciar o serviço do apache e pronto. Conexão Oledb funcionando mil maravilhas
--
Atte. Willian Fernando |
| |
| |
| | | |
|
| | |
| |
Registered member
123 messages |
|
| Posted on January, 07 2016 - 7:54 PM |
Ficaria algo como isto aqui no HTTP.CONF
#############################################################################################
#Set Enviroment Manualmente para o Apache
SetEnv ProgramFiles "C:\Program Files"
SetEnv "ProgramFiles(x86)" "C:\Program Files (x86)"
SetEnv ProgramFilesW6432 "C:\Program Files"
SetEnv CommonProgramFiles "C:\Program Files\Common Files"
SetEnv "CommonProgramFiles(x86)" "C:\Program Files (x86)\Common Files"
SetEnv CommonProgramFilesW6432 "C:\Program Files\Common Files"
#Fin Set Enviromente
#############################################################################################
#IncludeOptional "c:/wamp/vhosts/*"
Include "c:/wamp/alias/*"
#############################################################################################
#Aqui começa as linhas que o próprio Webdev adiciona
Alias /WD200AWP/res/ "C:/WebDev20/AWP/res/"
<Directory C:/WebDev20/AWP/res/>
Require all granted
AddType text/cache-manifest .manifest
AddType image/svg+xml .svg
AddType video/webm .webm
AddType text/vtt .vtt
</Directory>
...........
.........
....
...
.
--
Atte. Willian Fernando |
| |
| |
| | | |
|
| | |
| |
Registered member
123 messages |
|
| Posted on January, 07 2016 - 7:55 PM |
Outra coisa estou usando o Wampserver que já tem alta compatibilidade com o Webdev (o WAS já reconhece o APACHE automaticamente ao instalar)
 
--
Atte. Willian Fernando |
| |
| |
| | | |
|
| | |
| |
| Posted on January, 07 2016 - 9:39 PM |
Obrigado por partilhar
JJM |
| |
| |
| | | |
|
| | |
| |
Registered member
4,521 messages |
|
| Posted on January, 12 2016 - 6:53 PM |
Parabéns Willian!
Que a Wx Informática puder ajudar é só pedir.
São informações como essas que a ferramenta esta cada dia melhor.
Meu muito obrigado!
--
Adriano José Boller
______________________________________________
Consultor e Representante Oficial da
PcSoft no Brasil
+55 (41) 9949 1800
adrianoboller@gmail.com
skype: adrianoboller
http://wxinformatica.blogspot.com.br/ |
| |
| |
| | | |
|
| | |
| |
Registered member
123 messages |
|
| Posted on January, 12 2016 - 8:21 PM |
Apenas para deixar claro o procedimento acima apenas funciona sobre Windows 32Bits para 64 Bits o Erro segue persistente
--
Atte. Willian Fernando |
| |
| |
| | | |
|
| | |