By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 1,421 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Jun 7 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Jun 7 '07 #2

P: n/a
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.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- Hide quoted text -

- Show quoted text -

Jun 7 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.