Search results for query: *

Can I use Join statments when I do SQL queries on DBASE tables? I am programming in ASP to do reports on some old DBASE 5 tables I have. If it does work, can someone give me a sample query string I can take a look at? Thanks in advance.

Bemima is the name of Dbase table. When I connected to my databse I created a connection object that points to the directory where my tables are located, that name being "objConn". So in regards to your idea with taking the "." off, it seems to still react erroneously in...

I got rid of my previoud error and my new error is Microsoft Cursor Engine error '80004005' Insufficient base table information for updating or refreshing. I then downloaded MDAC 2.7 and it did not help. I am hosting my ASP, VBScript Files on an NT Server and querying Dbase 5 tables. Dim...

Here is a bit of the code. It works fine when running in WinXP... Set RS = Server.CreateObject("ADODB.Recordset") sql = "SELECT * FROM BEMIMA.DBF WHERE UNAME = '" & Session("USERNAME") & "' AND PW = '" & Session("PASSWORD") & "'&quot...

Here is a bit of the code. It works fine when running in WinXP... Set RS = Server.CreateObject("ADODB.Recordset") sql = "SELECT * FROM BEMIMA.DBF WHERE UNAME = '" & Session("USERNAME") & "' AND PW = '" & Session("PASSWORD") & "'&quot...

After some problems here and there, I feel as if I have reached a wall with this error I have been getting when trying to do a RecordSet.Update Microsoft Cursor Engine error '80004005' Insufficient base table information for updating or refreshing. The error is in the line that I call my...

After some problems here and there, I feel as if I have reached a wall with this error I have been getting when trying to do a RecordSet.Update Microsoft Cursor Engine error '80004005' Insufficient base table information for updating or refreshing. The error is in the line that I call my...

sql = "SELECT * FROM BEMIMA WHERE UNAME = '" & Session("USERNAME") & "' AND MIMA = '" & Session("PASSWORD") & "'"

yeah I do. I can't seem to figure out why everything is working on my Win XP version of IIS and not working on Win NT IIS

Hmm I might have forgotten to close a lock table but how do I make sure it is closed? I have put in the code to close the record set but I still get the same error. How do I know it is definitely closed? And also what is the native dBase driver for NT? This is what I use to open the...

Hello, I am trying to make an ASP application and need to be able to not only read, but also Write/Update to my Dbase tables. They are Dbase 5 and I am using VB Script. I use to test my application on Win XP and everything went fine with reading and writing, now I changed everything to...

Hello, I am trying to make an ASP application and need to be able to not only read, but also Write/Update to my Dbase tables. They are Dbase 5 and I am using VB Script. I use to test my application on Win XP and everything went fine with reading and writing, now I changed everything to...

Thanks for all the help, my problem has been SOLVED!!!

I tried using post instead, but then I cant retrieve the query string being sent by the form. My asp file handles the two form data being passed. user_name = Request.QueryString("username") pass_word = Request.QueryString("password") Any other ideas? Or am I doing...

Dear readers, I am writing a small application when users login with username and password via a simple form. The only problem is that when people submit the form i can see in the URL address box their password. It looks like this...

I have figured out my problem! Looks like the problem was with the SQL statment. Looks like it does not like me to use EMPLOYEE.FIELDNAME so by just using the field name it works. sorry have not used dates yet

I have figured out my problem! Looks like the problem was with the SQL statment. Looks like it does not like me to use EMPLOYEE.FIELDNAME so by just using the field name it works. sorry have not used dates yet

I have figured out my problem! Looks like the problem was with the SQL statment. Looks like it does not like me to use EMPLOYEE.FIELDNAME so by just using the field name it works.

Here is my full code: Error message below that. 'OPEN Connection---------------------------------- Dim objConn Set objConn = Server.CreateObject("ADODB.Connection") objConn.ConnectionString="Driver={Microsoft dBASE Driver (*.dbf)};" &...

Just FYI for people, I was doing some more testing and my SQL statement: sql = "SELECT * FROM EMPLOYEE" does work and the sql = "SELECT * FROM EMPLOYEE.dbf" works as well