how do i use ADO in VB to access SQL Server?
i'm using ADO version 2.0, SQL SERVER 6.5, VB 5.0.
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_DB/Q_10090756.html
Zones:
VB DBDate Answered: 12/06/1998 Grade: C Views: 0
I'm using ADO connecting to a SQL Server 2000 backend.
I open a global Recordset which I only use to add records to. SQL:
"select * from tblMap"
When I come to use the Addnew method, on so...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_20286944.html
suppose I have a table containing two fields.
accout_no varchar(20)
create_dt datetime
I have a query as
Select max(create_dt) create_dt
FROM acct_tbl
where acct_no...
http://www.experts-exchange.com/Programming/Languages/CPP/Q_20588681.html
Zones:
C++Date Answered: 04/18/2003 Grade: A Views: 0
I'm trying to translate the following block of SQL into a format that will work with the ADO recordset.open or conenction.execute methods.
It rejects the GO and if I use semi-colons it just runs...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_DB/Q_23540741.html
Can anyone advise me how could I retrieve the field name, lenght and number of field in a table using ADO in ASP QUICKLY. I have tried by creating a record set first using a "Select * from table_na...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_10294195.htm...
Zones:
ASPDate Answered: 02/14/2000 Grade: A Views: 0
I'm new to this. Can I make specific queries (no wildcards) to match against a db of generic rules? Note that following example contains only two fields but in real-life will have about 7 fields....
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_11422299.html
IIS 5, ASP 3, SQL Server 2000.
I have a table that has a "UniqueIdentifier" field. I need to insert a GUID into this field using the NewID() function inside SQL Server.
however, i'm using ADO...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_20251629.htm...
Zones:
ASPDate Answered: 01/04/2002 Grade: A Views: 0
Hi,
I have a 4 tier application. The components are on a different server than the webpages . The SQL server is on a different machine. I am creating a recordset in the component. I have found t...
http://www.experts-exchange.com/Software/Server_Software/Application_Servers/Q_20404317.ht...
I am using Delphi ADO components to connect to local access DB. I also use TDBGrids and other standart Data Controls...
How can modify my application to connect to SQL-server? My SQL-Server DB is...
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_20799243.html
I have moved the SQL databases from a decommisioned sever to a new server (which has a different name). I moved them by stopping all SQL services, copying the data files from the old server and th...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21322237.html
