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.

...that name being "objConn". So in regards to your idea with taking the "." off, it seems to still react erroneously in the same way *sigh*. Any other suggestions. I did find something about trying to upgrade to MDAC 2.7. But after doing that I still get the same error.

...tables. Dim objConn Set objConn = Server.CreateObject("ADODB.Connection") objConn.ConnectionString="Driver={Microsoft dBASE Driver (*.dbf)};" & _ "Dbq=" & DBLocation objConn.Open The DBlocation is just a absolut path name to the folder that contains my...

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

...Dim objConn Set objConn = Server.CreateObject("ADODB.Connection")objConn.ConnectionString="Driver= {Microsoft dBASE Driver (*.dbf)};" & _ "Dbq=" & DBLocation Here is where i open the Recordset: Set RS = Server.CreateObject("ADODB.Recordset") sql =...

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.

...Dim objConn Set objConn = Server.CreateObject("ADODB.Connection") objConn.ConnectionString="Driver={Microsoft dBASE Driver (*.dbf)};" & "Dbq=E:\Internet\Intranet\bupp\Tables" objConn.Open 'OPENED-------------------------------------------- Dim objRS...

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