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."
در صورت امکان راهنمایی کنید
ممنون
من به یه مشکل رسیدم برای 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."
در صورت امکان راهنمایی کنید
ممنون