o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

cannot execute in ODBCDIRECT -

I am using VB 6.0 and SQL Server 7.0

I am connected using ODBC Direct . I want to execute a delete query on my table

db.execute "DELETE * FROM MASTER"

But i receive the following message

Run Time error 3146. ODBC call failed.

But I am connected to the database and I am able to add, update and delete the records one by one. I am not able to do the same using the Execute query.

 

cannot execute in ODBCDIRECT -
I am using VB 6.0 and SQL Server 7.0 I am connected using ODBC Direct . I want to execute a delete query on my table db.execute "DELETE * FROM MASTER" But i receive the following message Run Time error 3146. ODBC call failed. But I am connected to the database

ODBCDirect -
Hi, I'm converting an app which uses DAO to access a database to use ODBCDirect instead. I need to find out what kind of delimiter the database being accessed will use. e.g. when selecting data from a table which has a space in the name, square brackets might be needed around the tabl

TableDef via DAO and ODBCDirect workspace -
How can i get the List of Tables or TableDef Objects by using DAO and ODBC Data Sources ???

VB & SQL Server -
Good day to you all: I've been noticing that a lot of you work on SQL Server. What is the connect method of choice and why did you choose it? I've been working on VB5/SQL Server 6.5 and I'm using ODBCDirect, but co-workers are trying to insist that I use RDO?? Opinions please.

Why is ODBCDirect more efficient than JET -
Some of you may remember that I converted an Access platform application to an SQL Server platform at the end of last year. The way I did this was with two different data access components, one accessing an ODBC-linked Access 97 mdb and the other using ODBCDirect. The explanation fo

Data Grid with ODBC RecordSet -
Hi, If anyone can help. I have created an ODBC recordset using an SQL query from access database. I want to view records from recordset into Data Grid. I am getting records in recordset 'rstTemp' but cant view them in Data Grid 'DataGridSup'. Sub OpenRecordsetSup() Dim w

SQL query problem -
Hi there! I'm having trouble (in VB5) with a line of SQL being done over an ODBCDirect connection. It keeps telling me "ODBC call failed" which I think means the SQL string is invalid. I designed the string in Access and it works fine there but not in VB5. The string i

Execute -
HI All: I have a stored procedure on mys sqlserver. The name of the sp is deletedata. How can I execute this sp from vb and pass it the record id? In vfp I use to execute the sp by using the following code: sqlcmd = 'EXECUTE[CLEAR_EDIFILE] ' + ALLTRIM(edifile) jtq = SQL

How to connect to a password protected database -
I have a Data Control connected to a password protected database (access 2000) through ODBCDirect data type. How to set the password of the Data Control at design or run time before the Login dialog box appears PLEASE HELP!! IT'S VERY URGENT. With my pure thanks.

appending data -
Hello I have two sql statements that run one right after another to append records to an ms access table from another table. The problem is that if I let them run immediately after each other only the first one gets through correctly, but if I put a 5 second timer between each append,

No overload for method error -
I am a new C# developer (making the switch from VB but have a strong understanding of .NET and a basic understanding of C++). I am using the ADO command.execute method and I keep getting the following error: No overload for method 'Execute' takes '0' arguments I know the error m

Dynamically executing code -
Hello everybody.... I know that you can execute and/or include other ASP in one page. Now... how can I execute code inside the ASP. Pure code.... something like ..... server.execute("reponse.redirect(url)"). Note that I want to execute code and not another page.

New to databases in VB. DAO or ADO -
What I'd like to know is the differences with ADO and DAO? pros/cons, etc... Also what's the deal with DAO ODBCDirect, and DAO MS-Jet? Which is the best to use? Is any of them faster then the others? Also, does anyone here know about proisam? I've several databases created from t

executing functions -
I have create a function and I wanted to know if someone could provide me with an example of how I would execute that function using an execute function this is the execute function public void execute(String program) { }

How to execute -
How can I execute an windows process with C#? Im gonna create a console application that lets me execute files and stop them please help out. Regards Daemoncraft

JDBC: I need a resultsetmetadata before i execute... -
Hello I have an SQL command e.g. SELECT a, b, c from table; And i need to retrieve MetaData, especially the number of columns that it will return, before i actually execute the statement. I realise that once i execute the statement it will become easy as i can just call .getRe

Execute Code based on System Time -
What is the easiest way to have a program written in VB.NET to execute at a precise time? I want to have my code execute when the exact time in seconds is reached on the system clock. For example if it was set to execute at 11 seconds it would do so at 12:00:11, 12:01:11, 12:02:11, 1

Execute URL! -
Hello, I have 3 URLs I need to execute in script! Previously I have used response.redirect method where only 1 URL needed executin, but now there is 3 it wont be possible. How can I execute 3 URL's (in any order, no consecuvation required) in VB code? Thanks

Multithreaded program -
I know Intel has come out with processors that can execute two or more commands at the same time. I also know modern day operating systems Multitask. I am yet to see a compiler that could execute two functions at once. Like if there was a function that split apart a string, could you e

java in vb -
I have created a java function and I wanted to know if someone could provide me with an example of how I would execute that function using an execute function this is the execute function public void execute(String program) { } __________________

Problem with Try - Catch - End Try -
Hi everybody, I am converting old Vb6 code to Vb.Net. In one sub in Vb6 I had this code : on error goto Prob dbSGC.Execute("DELETE FROM arch_economic") dbSGC.Execute("DELETE FROM arch_segments") dbSGC.Execute("DELETE FROM condition&quo

ADO Connection Execute... -
Hello. When you use the ADO's Connection obj to EXECUTE an SQL statement, the VB app hangs and cannot do anything, is there a way to have it execute in the background so the VB app can refresh the screen and do other things? Thanks. Thai

execute other program from vb -
hi all, i want to do a vb program that will automatic execute other software exe file. for example in my vb i have 3 command button. when click command button 1 will execute microsoft word, click command 2 will execute notepad, click command button 3 will execute adobe reader. how t

how can i execute a sql file via ADO or any other technique -
I want to execute sql files. I do not want to hardcode the sql within the vb code, therefore i want to be able to execute sql files in the database through the VB application. Anyway possible? Cheers.

Execute after page has loaded -
I need to execute a function after a page has loaded and the controls and images are visible on the screen. Both Page_Load and Page_PreRender execute before the page is shown. Is there a function that will execute after the page loads with no further action from the user?

Timed Operation -
How do you incorporate a Wait/Pause statement in VB.net. I want the program to execute several things, but there needs to be a set time between these operation. For example: Execute Statement1. Pause program for 500ms Execute Statement2. Pause program for 300ms E

ADO Timing issue -
I have some code where I am doing a standard ADO call and inserting some data into an Access Database. When the Execute method returns I display the information in the VSView Report control. If I report right after the execute, I get all but the last line of data. If I force the progra

how execute/visit a site using the cron daemon -
hi, i need to execute/visit a site to check if the site is up or not i have a server that have cron shedule that can execute a php file now how can i execute/visite a site using the same way as i execute a file? thanks a lot for your help

Connection.Execute vs. .AddNew -
I believe most are against the use of .Addnew in recordset compare to Connection.Execute. I just did a process .Addnew on 3,000 records and it zipped through faster than Connection.Execute. How can this be? I been reading and most people on this forum explain that Connection.Executi

Confirmation after Execute Command -
I have a ADODB connection to an Access2k database via the DataEnvironment. My question is, when I do an execute on a connection in the DataEnvironment i.e. dataenvironment1.supportdb.execute "UPDATE User SET ID = 6 WHERE USER = 'Wright'" is there a way to tell when th

is it possible to execute vbs in vb.net -
guys, is it possible to execute a vbscript in the vb.net? i want to click a button, then a function will execute the vbscript.. thanks

How can I execute an external app (resolved) -
Hi, there! I need to execute an application from my C# program, but I have no clue how to do that... I want to execute, say, "winrar", with all the parameters needed... How can I do it ? Tks in advance, João Luiz

execute.exe <file1.txt> (resolved) -
Hi, I compile my vb program to a execute.exe. I need to know how to code the vb so that it will accept an external file during execution from DOS. Any idea how to make the execute.exe to accept the input <file1.txt>? Thanks, Phillip

Wait for two shell scripts to execute simulatenously -
Ok..I have a unique issue...well, at least I havent been able to find a similar issue in the archives. I want to execute two (or multiple) shell scripts simultaneously (both independent of each other--execute concurrently to save time) and I want the program to wait until those scri

server SQL -
I just noticed that you can browse through databases and execute SQL statements. My question is, are there hotkeys to execute the statements like MS Query Analyzer? In that software you can highlight the statement and press F5 to execute it. I find hotkeys to be very handy. Anyone know

How to Execute a DTS Package within a Procedure -
Good afternoon All i have a DTS Package from a Different Server and i want to Execute it from inside a Stored procedure and execute it in vb. The Vb part i will handle, i would like to know how am i going to achieve that in SQL Thanks

How can you execute javascript with visual basic -
I have a omplicated JS function I need to execute, all it does is take in a string and outputs a new one. How can I execute thsi script with visual basic and get the output?

uploading files with inet control -
I need my aplication sends three files to a server. I put the code: Private Sub cmdPublish_Click() With Inet1 .URL = "ftp://ftp.thedomain.com" .UserName = "username" .Password = "password" .Execute , "c

How to execute DOS commands through our VB -
Hello All, In my VB application when a command button is clicked I want it to execute the operation of copying some file from one location to another location. Eg. In DOS prompt I would type: "copy c:\*.txt d:\my_text " But I don't know the syntax to execute it

[2005] Auto Execute a Function -
hi am trying to execute a function in one of my classes in App_Code. i only need 2 execute the function automatically once everyday and i cant rely on Seesion and Application Start events, is there any elegant way to achieve this?am thinking of cache objects and exploiting their expir