VFP 8 OLEDB and ASP.NET

[Redsz]

Hello everyone. I have been searching all afternoon for a way to connect to a visual foxpro database using vfp 8's oledb provider. I can connect to a dbc that is local on my machine but can not connect to a dbc that resides on a different machine. Anyone having any insite into this??


using :

Dim strConn As String

strConn = "Provider=VFPOLEDB.1;Data Source=\\helga\c\somatrak\somatrak\somatrakdb\somatrak.dbc"

Dim objConn As New OleDbConnection(strConn)
Dim SQL As String = "SELECT * FROM Users"
Dim objComm As New OleDbCommand(SQL, objConn)
Dim objDA As New OleDbDataAdapter(objComm)
Dim objTable As New DataTable()
objConn.Open()
objDA.Fill(objTable)
objConn.Close()
dgGrid.DataSource = objTable
dgGrid.DataBind()

 

[Redsz]

I guess i should mention the error message. Invalid Path or File Name. Ther weird thing is i can access the database with the server explorer in visual studio and have tried copying the connection string code that it produces and i still get this error...

Thx in advance

 

[JBalcerzak]

Are you doing this in VB.NET? Can you connect to your db file via the Server viewer and drag and drop a connection on to your web form?

 

[Redsz]

I can connect to the db via the server viewer but dragging and dropping the connection on the web form gives me the same error message when i try to compile and run. Anybody have any tips?

 

[oortiz]

Try allowing write/read access to IUSR account to "helga" machine.

uff, my english is not good

-o.

 

[Redsz]

Im setup as an administrator on our network and i double checked the read write options.. so that is not the case but thanks for the reply