OleDbConnection via MS REMOTE -> "Specified cast is not valid. "

Hi everyone,
Im using the following conn string in asp.net 1.1 using vb.net:
Dim conn As New OleDbConnection("Provider=MS Remote;Remote
Server=http://myintranetserver/; Remote Provider=Microsoft.Jet.OLEDB.
4.0;Data Source=c:\pass\be\quiz.mdb;uid=;Password=;")
Whenever I execute rs.executereader,
I will receive "Specified cast is not valid. "
There's nothing wrong with the sql statements.
if i change my conn string to:
' Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.
4.0;Data Source=c:\pass\be\quiz.mdb;User Id=admin;Password=;")
Then the script will have no problem!
Pls advise.,
Thanksif the server is on the same network - instead of the Http://, use a UNC
format in the path, like:
\\Servername\yourpath\your.mdb
David Wier
MVP/ASPInsider
http://aspnet101.com
http://iWritePro.com
"user" <mylinuxjourney@.gmail.com> wrote in message
news:1181215727.462820.245670@.g37g2000prf.googlegroups.com...
> Hi everyone,
> Im using the following conn string in asp.net 1.1 using vb.net:
> Dim conn As New OleDbConnection("Provider=MS Remote;Remote
> Server=http://myintranetserver/; Remote Provider=Microsoft.Jet.OLEDB.
> 4.0;Data Source=c:\pass\be\quiz.mdb;uid=;Password=;")
> Whenever I execute rs.executereader,
> I will receive "Specified cast is not valid. "
> There's nothing wrong with the sql statements.
> if i change my conn string to:
> ' Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.
> 4.0;Data Source=c:\pass\be\quiz.mdb;User Id=admin;Password=;")
> Then the script will have no problem!
> Pls advise.,
> Thanks
>
THanks for the reply.
Do u mind elaborate further? Or post the full conn string?
Thanks
On Jun 7, 10:44 pm, "David Wier" <davidw...@.davidwier.nospam.com>
wrote:
> if the server is on the same network - instead of the Http://, use a UNC
> format in the path, like:
> \\Servername\yourpath\your.mdb
> --
> David Wier
> MVP/ASPInsiderhttp://aspnet101.comhttp://iWritePro.com
> "user" <mylinuxjour...@.gmail.com> wrote in message
> news:1181215727.462820.245670@.g37g2000prf.googlegroups.com...
>
>
>
>
>
>
>
>
>
>
>
> - Show quoted text -