Hi all,
What can be wrong in the database connection bellow to connect paradox?
What is missing??
----------------------------------------------------------------------------
-------------------------
<%
Response.Expires = -1
%>
<%
Dim ConParadox
If Tabela = "" then
Tabela = "d:\icdm\" & Session("SiCod") & "\HITEC\DBCDM\" & DirPredio
End If
Response.Write "<b>path of directory to use in paradox</b>: " & Tabela
'Response.End()
Set ConParadox = server.createObject("adodb.connection")
On Error Resume Next
ConParadox.Open "Driver={Microsoft Paradox Driver (*.db )};" & _
"DriverID=538;" & _
"Fil=Paradox 5.X;" & _
"DefaultDir=" & Tabela & ";" & _
"DBQ=" & Tabela & ";" & _
"CollatingSequence=ASCII"
Response.Write "<p>ConParadox:<br>" & ConParadox
'Response.End()
'»»Err treatment.
If Err.Number = -2147467259 then
Response.Write "<br><font color='#FF0000' face='verdana'
size='2'><b>Erro:</b> " & Err.Description
Response.Write "<br><b>Nº:</b> " & Err.Number & "</font>"
Response.Write "<script language='JavaScript'>alert('Este condomínio e/ou
empresa não possue apartamentos a serem listados'); "
Response.Write "history.back();</script>"
Response.End()
End If
%>
----------------------------------------------------------------------------
-------------------------
I use the same database connection to other page and runs ok.
WITH ERRORS:
Driver={Microsoft Paradox Driver (*.db )};DriverID=538;Fil=Paradox
5.X;DefaultDir=d:\icdm\0\HITEC\DBCDM\4;DBQ=d:\icdm \0\HITEC\DBCDM\4;Collating
Sequence=ASCII
Erro: [Microsoft][Driver ODBC para Paradox]Erro geral Não é possível abrir a
chave 'Temporary (volatile) Jet DSN for process 0xb88 Thread 0x9bc DBC
0x955a15c Paradox' do Registro.
Nº: -2147467259
WITHOUT ERRORS:
Provider=MSDASQL.1;Extended
Properties="CollatingSequence=ASCII;DBQ=d:\icdm\0\ HITEC\DBCDM\004;DefaultDir
=d:\icdm\0\HITEC\DBCDM\004;Driver={Microsoft Paradox Driver
(*.db )};DriverId=538;FIL=Paradox 5.X;MaxBufferSize=2048;PageTimeout=5;"
THANKS,
--
««««««««»»»»»»»»»»»»»»
Vlmar Brazão de Oliveira
Desenvolvimento Web
HI-TEC