I'm trying to create an installer for my client that utilizes ADO/SQL technology. ADO as I understand needs MDAC. And Windows2000 comes with MDAC, but 98 and ME do not. I am having troubles installing MDAC with our package. Is there an easier way so that I can just copy some .dll files or...
I'm Using ADO with VFP to connect and modify my SQL 2000 databases. Workstations that arent windows 2000 dont have MDAC. Yet MDAC is HUGE!! 8 megs.. is most of the install just extra files? all i need it to do is a direct SQl connection.. is there a smaller distribution?? 8 megs is quite...
When I try to do a ThisForm.Adodatacontrol1..refreshrecordset
I get a error saying adStateConnecting doesnt exist...
here the code from the ADOdatacontrol object...
any ideas why?? bad connection string? I'm lost here guys..
*-- Loop until we connect
DO WHILE This.Connection.State =...
Here is the code im testing out? why doesnt it work??
it also doesnt provide for user name / password..
it seems no matter what I try here nothing really works for a dynamic connection to a SQL server.. I fail to see why its so hard to create a connection to a server and mess with some data...
I am trying to create a SQL that uses JUST a SQLSTRINGCONNECT() to access the SQL server. I cant open the view when I dont have a connection inculded with the project. this is the code im trying to use for now...
store SQLSTRINGCONNECT("driver={SQL...
I have a fully working view with my SQL server. I display the results on a grid. I wish to add a new record to I have a button with just
APPEND BLANK
in it
i then type in values in the grid and when i try to tableupdate() the SQl server says that im trying to insert the value null into a...
I am developing an application for totally clueless autobodyshop workers. I need to be able to access a MS SQL 7 server to work with data. I know you have to have a system DSN ODBC setup to get that to work. I wanted to know if anybody had any infomation on how I could automatically setup...
Im able to create a SQL view, and grab a table from a MS SQL 7 server. But once I have that info populated into a grid, is there a way I just just edit that data and have it automatically updated on the sql server? Im really new to doing this, so excuse my oversights.
Dave
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.