Description:
Microsoft Visual Basic newsgroup.
|
|
|
Need help from Access or ADO or VB6 guru - Weird problem
|
| |
I have a weird problem involving vb6 and MS Access. I'll explain in detail the problem to see if any Access guru can shed some light into this issue. Just in case if it helps, It started happening when we installed a new software in the computer. I have been doing some research online, and found that most likely is a driver, perhaps... more »
|
|
|
VB messed up?
|
| |
I don't know which newsgroup to go to but this seems the closest. I think my Visual Basic might be messed up? I can't open programs that use an Access-based file system like Adobe Photo Album, Asset Manage etc... (programs that don't require Access installed) and when I open Access, and open a database, if I try to click on a table or form to... more »
|
|
|
Urgent Prob- ODBC Connection to .DBF database
|
| |
Hi All, I have an urgent prob connecting a .DBF database using Microsoft Visual Studio 2008. Now i am just trying to connect it on my own computer before trying to connect it on the company server later. Here is what i did, hope experts here can help me out: My database directory is c:\Callcenter\dbfs\MAILALERT.D BF... more »
|
|
|
Query on Oracle DB via ODBC
|
| |
Why does the following query : SELECT st.KST_NAME AS Store, dp.KST_NAME AS Dept, wg.WGR_NAME AS ItemGrp, vp.VPK_NAME AS Unit, ar.ART_NAME AS Item, hp.LBP_MENGEGE AS Qty, hp.LBP_EKP AS UPrice, hp.LBP_MENGEGE*hp.LBP_EKP as Cost, wg.WGR_KONR2 AS AC, dp.KST_KONR as CC, EXTRACT(month FROM hl.LBW_DATUM) AS Mon,... more »
|
|
|
SQL Server 2008 remote connection fails
|
| |
I have an application (VB6) that connects to SQL server 2008 Express using ADO.... sPath = "Provider=SQLNCLI10;Server=ser verx\SQLEXPRESS;Database=dbInf o;Uid=sa; Pwd=passx" The application works great when it runs on the (XP/SP3) machine as the SQL 2008 Express host. The XP machine is named serverx. Remote connection over... more »
|
|
|
Stored procedure + vb to return subset of Suppliers from Northwind DB
|
| |
I am using MS Excel 2003 vba to return a subset of Suppliers (Northwind database) with "exo" in their names. The query returns names with "e", "x", "o", "ex", "xo", "exo". . . not exactly what I want! Details as follows: 1) Stored procedure in Northwind database CREATE PROCEDURE [dbo].[mlsp_Tbl_Suppliers_Filt er]... more »
|
|
|
Programming: ODBC Connection
|
| |
Hi Community, First, I wasn't sure how to describe the question, so a sad Subject line was created. Second, I come from a LAN/Hardware side of Information Technology but am dabling with some basic VB.NET and Access DB programming to accomplish a few things for our Retail side. We are currently using an application that uses a C-ISAM db. We can pay for... more »
|
|
|
Exporting MsSQL query results to Excel?
|
| |
Hi, Using this code found on the web, I'm able to connect to our DB: Const adOpenStatic = 3 Const adLockOptimistic = 3 Const adUseClient = 3 Set objConnection = CreateObject("ADODB.Connection ") Set objRecordset = CreateObject("ADODB.Recordset" ) objConnection.Open "DSN=SomeDBInstance;" objRecordset.CursorLocation = adUseClient... more »
|
|
|
51002: [Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index
|
| |
I was working on a large, legacy VB6 program when some code that hasn't been touched for years began failing consistently on one and only one (client) computer. All mods in the last few years have been done using ADO and we lack any real expertise in rdo. No such problem on any other developers'... more »
|
|
|
Access VBA - ODBC Timeount on Sql command to update records
|
| |
I usually just run a query and set the timeout value = 0 and well now im runnign some code through Access VBA that is carrying string values through: sql2 = "Update IBS_NUMBER SET LOCATION_ID = '" & locid!LOCATION_ID & "' WHERE Box_NUMBER ='" & pal!BOX_NUMBER & "' AND LOCATION_ID = '" & locid2!LOCATION_ID & "'"... more »
|
|
|
|
