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

[user]

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

[David Wier]

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/ASPInsider
http://aspnet101.com
http://iWritePro.com

"user" <my************@gmail.comwrote in message
news:11**********************@g37g2000prf.googlegr oups.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

[user]

THanks for the reply.

Do u mind elaborate further? Or post the full conn string?
Thanks

On Jun 7, 10:44 pm, "David Wier" <[e-mail]>
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" <[e-mail] in message

news:11**********************@g37g2000prf.googlegr oups.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- Hide quoted text -

- Show quoted text -