2 Resources for

adodb.connection

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

VB6 - Verifying if MS Access Table exists in database: I am in vb and have an sql string created to drop/create/insert data into a table. Is there someway I could check to see if the tables exists before I try to drop it.wrong forumThis question belongs in Technical Q & A. I will look for it there, because...; Tags: ADODB.Connection, ADOX.Catalog, ashley.rowbottom@..., database, Dim, Dim cat, Microsoft Access, Microsoft Corp., Microsoft Visual Basic 6.0, programming, Public Function TableExists, Table Name; Discussion threads 2004-10-01
TechRepublic Tutorial: Use Windows to create a connection string: As a database consultant, you're constantly facing new challenges. You must keep abreast of new technologies in order to meet those ever-changing expectations from clients and users. That means most consultants no longer have the luxury of claiming an expertise in just one or two systems. Now, the consultant that...; Tags: ADO Connection, connectionstring, data source, Microsoft Windows, ODBC, Susan Harkins; Technical articles 2003-11-17

Additional Resources

Sql Quriery in Visual Basic: Software DeveloperADODBYou need to use ADO DB ActiveX Data Objects components to use sqle.g.Dim con as new ADODB.ConnectionDim cmd as new ADODB.CommandDim recs as new ADODB.RecordsetSet con=Open "connection string"cmd.ActiveConnection = concmd.CommandText="Select * from MyTable"Set recs = cmd.Execute; Tags: Programming languages, amolsuryansh@..., SQL, Microsoft Visual Basic; Discussion threads 2007-10-03
Linking VB with SQL Server: Im trying to link VB to an SQL database.Any code samples will be welcomedownload the code from vbcodes.com or codeguru.comTake a look athttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/anch_dataaccess.aspHi,To connect VB with SQL You just need few lines of codes..i'll give you hints,,1)first define connection with passing necessary parameters2)Then define a command or you can use...; Tags: chikukwa@..., Microsoft SQL Server, Microsoft Visual Basic, programming, server; Q&A 2005-02-08
Microsoft Data Access Components - Disable ADODB.Stream Object from Internet Explorer (KB870669) (exe): Adodb.stream provides a method for reading and writing files on a hard drive. Microsoft Data Access Components - Disable ADODB.Stream Object from Internet Explorer (KB870669) by-design functionality is sometimes used by Web applications. However, when combined with known security vulnerabilities in Microsoft Internet Explorer, Microsoft Data Access Components - Disable...; Tags: Microsoft Internet Explorer, Microsoft Corp., Microsoft Data Access Components, ADODB.Stream, Databases, Enterprise Software, Software, Data Management; Software downloads 2007-09-13

To find "Class" for CreateObject method: The syntax of "CreateObject" in VB/ VBA is "CreateObject(Class As String, [ServerName As String])"So if i want to use CreateObject method in VB or VBA for creating any control at runtime then I have to pass "Class" parameter. So how can I find a "Class" for a particular object. That...; Tags: CreateObject method, CreateObject, nirman123_doshi@..., programming, ProgID; Q&A 2006-04-06
visual basic challenge: hi, i am developing a application in which i want to give a area in which user can draw a image and sava it to database with its id.please solve my prblem as soon as possilble.use the doodle example that comes with VB and study up on ADODB. here...; Tags: Doctor List, String Dim, sudeep_395@..., programming, String; Q&A 2005-03-19
passing adodb rst into an array: can i pass a adodb rst into an array using vb code? if so how can i retrieve my rst from the array? thx!!Bit more infoBy rst I presume you mean recordset ?Do you want an array of recordsets.Do want want to access all the records or just the one...; Tags: rst; Q&A 2005-05-13
Access reports through VB6: I am wanting to create dynamic reports by passing a SQL string from VB6 to an access query and then calling a MS Access report from VB6 that is linked to the query I have just passed through. Is this possible and if so can someone please provide me...; Tags: Dim objConn, matthewdeas@..., Microsoft Access, Microsoft Visual Basic 6.0, programming, Value at Risk; Q&A 2004-10-18
ASP is getting connected to my Database: Student RecordsThis is the code iam using to connect MS Access database , but iam facing lot of problems , my web server is IIs , is there any changes i need to do , please help me.With Microsoft Active Data Objects ADO there are three or four connection...; Tags: database, Server.CreateObject, abdul_basheer@..., it management, Microsoft ASP; Q&A 2006-02-08
Access Database: How do i connect to an access database from VB6?There are several ways (ODBC, DAO, etc). The problem is that it depends on the Access version and VB6 service pack. Which Access do you need to connect to?It will be an access 2000 database i want to connect to. I...; Tags: Databases, database, Microsoft Visual Basic 6.0, Microsoft Access; Q&A 2005-06-09
Using Access 2000 and VB 6: I am writting a program using Visual Basic 6. I am trying to read data from an Access 2000 database. I have created a blank form, added the data tool, set the connect property to access, set the DataBase name to point to the database. When I try to set...; Tags: DAO 3.51, database, DHamblet, Microsoft Access, Microsoft Visual Basic, Microsoft Visual Basic 6.0, programming; Q&A 2004-11-17
how to add delete,insert record in msaccess using adodb with vb6.0,& data: how to add delete,insert record in msaccess using adodb with vb6.0,& datagrid control handling with adpdb?; Tags: manisha_gaware@...; Discussion threads 2007-04-22
how to execute insert query inVB Script: i have written a the follwing code in vb scriptand it shows the Error "too few parameter expected 1 80040E10how ever this code when written in VB run smoothly' open database dim idim filenamedim RNOdim restnodim fi=1Set con = CreateObject("ADODB.Connection") Set cmd = CreateObject("ADODB.Command") set rs = CreateObject("ADODB.Connection") set rst=CreateObject("ADODB.Connection")...; Tags: Programming languages, Databases, sitanshuwesley@..., rs.Fields, rtNo, SQL, Chr, CreateObject, Mohan Das Karam Chand Gandhi, rsResult, Access Driver; Discussion threads 2007-10-18
Microsoft Access XP and Visual Basic 6: I have several Microsoft Access XP tables databases that I want to use in Microsoft Visual Basic 6.0. How do I do this? Is there a converter/importer for this purpose? I'm a retired DOS computer programmer and I'm trying to learn Visual Basic 6.0 or should I...; Tags: grouchyone@..., Microsoft Access, Microsoft Corp., Microsoft Visual Basic, Microsoft Visual Basic 6.0, programming; Q&A 2005-05-16
ActiveX Data Objects (ADO) 1.5/2.0/2.1 SP2 and Visual Basic Sample: Using ADO with an MTS Component via DCOM (Adomts.exe) (EXE): This sample demonstrates how to use a lightweight Standard .exe client to connect to an MTS-hosted DLL and retrieve an ADOR recordset through DCOM. This sample does not use Remote Data Service RDS to create the business objects. The code included here demonstrates using both the Connection.Execute and the RecordSet.Open...; Tags: Service Pack 2, Microsoft Visual Basic, DLL, DCOM, Sample, Server DLL, ActiveX/COM/COM+/DCOM, Middleware, Servers, Software Development, Software/Web Development, Enterprise Software, Software, Hardware; Software downloads 2007-09-04
DataReport in visual basic 6: Hi, i'm trying to use DataReport with VB 6. But got Run-time error '13': Type mismatch. Here is my code:Private Sub cmdGenerateReport_Click Dim conString As String conString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "" & "Database.mdb;" Set...; Tags: ray_slayer@..., Datareport; Discussion threads 2007-11-20
ADODB Open statement: someone help me.. how can i open a passworded database using ado. My database is MS Access i set password on it but htne i got an error message not valid password.. please help...Just put it in the connection string...;password="secret"; ....Course means someone could find it.You'd be better off forcing...; Tags: Databases, infotech_hp1984@..., password; Discussion threads 2007-03-25
Change password of shared database: I am starting out in IT, and learning VBA and SQL to write a database for the front of house staff at the office. Included in the specifications for the database is password protection easy enough and a means to change the password programatically again not too tough. I've written...; Tags: Storage, Databases, database; Discussion threads 2005-08-22
Lost in forms and paramaters: Hello folks, I am current in a reporting role at my job and I am working on a project where I am trying to make a form in Access that will enable to update to SQL Server Tables in the background. I was trying to use stored procedures to update...; Tags: jabney@..., programming, Microsoft Access, Microsoft SQL Server; Q&A 2005-04-28

<< Previous
page 1 of 1
Next >>

Content Types

Discussion threads (1 results)

Technical articles (1 results)

IT Hiring Kit: Database Administrator: The IT Hiring Kit for Database Administrators will help you interview, evaluate, and select suitable candidates for a DBA position. This kit comes wit ...; Buy Now

Server System Inventory Form: It's a good idea to document as much as you can about your server while it's up and running so you won't be left in the dark should a disaster occur. This one-page form includes space for delivery information and server specifications.; Buy Now

adodb.connection

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

Additional Resources

Content Types

All-in-One Printers