Originally posted by: quelhas
No DNS.
The code I wrote is
Dim Con As New ADODB.Connection
Con.open = "Provider=MS Remote;" & _
rs.Open strsql, Con 'Error is this line
'OR THIS............
Con.open = "Provider=MS Remote;" & _
rs.Open strsql, Con 'Error is this line
Con.open = "Provider=MS Remote;" & _
rs.Open strsql, Con 'Error is this line
Regards
Hi,
I have tried the code you have written. But an error occurred.It displays "Run-time error '8447': Internet Server Error.".Will you pls. help me in getting the connection.
Dim rs As New ADODB.Recordset
"Remote Server=http://myServerName;" & _
"Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\path\db.mdb;" & _
"admin"
"Remote Server=http://myServerName; & _
"Remote Provider=MSDataShape;" & _
"DBQ=c:\path\db.mdb;DRIVER={MS Access (*.mdb)};"&_
"Uid=Login;" & _
"Pwd=password;"
'OR THIS............
"Remote Server=http://myServerName; & _
"Remote Provider=MSDASQL;" & _
"DBQ=c:\path\db.mdb;DRIVER={MS Access (*.mdb)};"&_
"Uid=Login;" & _
"Pwd=password;"
Quelhas
Originally posted by: jucy
Ms sql connect string is that you use,
but what's the connect string in case of Oracle?
Originally posted by: Jibu Samuel
The code I wrote is
oconn.Open "Provider=MS Remote;" & _
Error is in line ".Open strQuery, oconn, adOpenStatic,
Regards
Hi,
I have tried the code you have written. But an error occurred.It displays "Business objects cannot be created".Will you pls. help me in getting the connection.
"Remote Server=Server name" & _
"Remote Provider=SQLOLEDB;" & _
"Data Source=data Source name;" & _
"Initial Catalog=Database name;" & _
"User ID=Name;" & _
"Password=pwd;"
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
strQuery = "select SiteName from ABD_sitemaster"
With rs
.CursorLocation = adUseClient
.Open strQuery, oconn, adOpenStatic, adLockReadOnly
End With
adLockReadOnly"
Jibu
Originally posted by: Mike Korzeniowski
Some of you have reported problems implementing this solution. The errors dealt with the default handler denying access to database.
To solve this problem:
If you're running this on a standalone machine, you may want to try the following:
Execute "C:\Program Files\Common Files\System\msadc\Handunsf.reg"
then reboot your system.
Note this has to be executed on the machine your're running your web services on.
To return to previous state:
Execute "C:\Program Files\Common Files\System\msadc\Handsafe.reg"
then reboot your system.
This command modifes the registry to disable the remote data handler security. Not a recomennded solution for a
network server, but ok for standalone testing.
To implement security for the remote handler, you must modify the following file:
c:\windows\Msdfmap.ini (for Win95/98) or c:\winnt\Msdfmap.ini (for NT)
This file contains permissions to access specific databases via the DSNs.
For more info see: <http://support.microsoft.com/support/kb/articles/Q230/6/80.ASP>;
Hope this helps.
Mike