fail to connect vfp odbc

  • Thread starter Thread starter Agnes
  • Start date Start date
A

Agnes

(1)Session("ConnectionAuth") = "Provider = VfpOleDB.1;Data Source =
d:\cgl\vfpmaster\ttsdata\tts.dbc"
(2)Dim authConnection As New
SqlConnection(Session("ConnectionAuth").ToString())
There is an error in statment(2) , it said invalid ' provider'

tts.dbc is my vfp database which located in my D drive. How can I connect my
vfp database ??
thanks in advance
 
I change by sqlconnection into OLE dbconnection.
Session("ConnectionAuth") = "Provider = VfpOleDB.1;Data Source =
d:\cgl\vfpmaster\ttsdata\tts.dbc"

Dim authConnection As New
OleDbConnection(Session("ConnectionAuth").ToString())
Dim authCommand As String = "select loginid from coinfo
where loginid = @cocode "
Dim oleCommand As New OleDbCommand(authCommand,
authConnection)

oleCommand.Parameters.Add(New OleDbParameter("@cocode", 10))
oleCommand.Parameters("@cocode").Value = UserName
oleCommand.Parameters.Add(New OleDbParameter("@pwd", 50))
oleCommand.Parameters("@pwd").Value = UserPassword
authConnection.Open() <-- error

Error "'VfpOleDB.1' ´£¨ÑªÌ¨Ã¥¼µn¿ý©ó¥»¾÷¹q¸£¤W¡C" String
for english version it said [the user didn't login the machine| (Any thing
wrong in my session|") ??
thnaks
 
Back
Top