ورود

View Full Version : connection به foxpro



hramezani
شنبه 27 آبان 1385, 13:56 عصر
سلام
من به یه مشکل رسیدم برای connection در vb به فاکس پرو اگر از کد زیر استفاده کنم :


Dim Conn As New ADODB.Connection
()Private Sub Form_Load
aaa = 33
"a = "tbl
Set DBConn = Nothing
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\test;Extended
";Properties=dBASE III
Set DBConn = Conn
"( '"& SQL = " INSERT INTO " & a & " Values ( '" & aaa
DBConn.Execute SQL
End Sub

این error را دارم :


"Selected collating sequence not supported by the operating system"

و


"External table is not in the expected format"

واگر این کد :


Dim Conn As New ADODB.Connection
()Private Sub Form_Load
aaa = 33
"a = "tbl
Set DBConn = Nothing
;Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\test
Set DBConn = Conn
"( '"& SQL = " INSERT INTO " & a & " Values ( '" & aaa
DBConn.Execute SQL
End Sub

این error :


"The Microsoft Jet database engine cannot open the file 'E:\test'. It is already opened exclusively by another
user , or you need permission to view its data."

در صورت امکان راهنمایی کنید
ممنون