| |
by: Stuart |
last post by:
Is there any way to attain the names of the tables in a database from using
either ADO connection or ODBC or any other type of connection.
The reason I wish to do this is so that I can display all the information in
table (field names and values - this piece of code works) from a dynamic
SQL statement
Here is what I am trying to do:
<%
Connect to my_table.
|
by: rob |
last post by:
Hi all,
Has anyone had any problems trying to connect to sybase sql anywhere 5.0 in
an ado connection? I'm able to connect via a DSN connection on a pc running
IIS which the database is not on, but if i try and run the same file on the
server with IIS on which also hosts the database it says it says the engine
is not running.
Any ideas?
Many thanks,
|
by: (Pete Cresswell) |
last post by:
I rebuilt my machine a few weeks back - re-installed the developer version...
The app in question can see all it's tables in the SQL back end via ODBC and
everything looks normal via Enterprise Manager, but I can no longer create
an ADO Connection.
Source code is unchanged, what's changed is the PC rebuild and consequent
re-installatin of SQL Server developer version.
I suspect it's something to do with the provider (at least that's...
|
by: jabailo |
last post by:
I created a web method to insert data on a DB2 database.
It runs well, except every time I call it, it opens and closes the ADO
connection.
I think it would run faster, since I send it hundreds of records, if I
could just keep a connection open at the point the web service starts up
and close it when the web service is shut down ( so I would open it in
the Application_Start and close it in the Application_End ).
|
by: SalimShahzad |
last post by:
Dear Gurus,
I have various access database for various purposes. but all are link
with userid table which keep stores every user info and keep tracking
event or actions perforn. currently i used LINK TABLE method. that
feels me very unsecure as any one can connect and get userid/password
of our all networks enviornment from system.
now i am seeking for advice any way that i can connect using
ado/vba(prgramaticlly) that login/auditing...
|
| |
by: Leite33 |
last post by:
Hello
Well i want to make an apllication in C++Builder 6 and connect it with Server 2000. I will use this application to save data and especially pictures. To connect the Server with C++Builder 6 i use 3 componnents, Ado Table,Ado Connection and Datasource.For the connection i dont use code. So the problem is that when i run the application it brings me an error "Can not Cconvert Null to String. How can i solve this problem. Please send me...
|
by: ashleycvernon |
last post by:
I am using MS Access forms as a front end to a backend SQL Server
Database. I am trying to use an ADO connection to return a Select
Statement from the SQL Server to an Access form to be viewable by the
user. I have been able to establish the connection to the SQL Server
and have verified that the SQL statement is correct. I am completely
new to ADO and I can't figure out how to display the data returned in
the ADO recordset. Could...
|
by: psuaudi |
last post by:
I'm using an ado connection to connect to an access database using VB6.0.
The database structure has a table (Table1), with a unique field1 (ID), and another field2 (Name).
How do I use an ado connection to lookup a Name when given an ID? Within Access, I would use a dlookup command and dump the data into a variable...but I'm not sure how to do that using ADO.
Thanks!
|
by: Meedo9 |
last post by:
Hello all
I have been struggling to resolve this with no luck, so i'd much appreciate your help and suggestions.
I have been trying to install and run a software mail notification server. This seems to connect successfuly to the Mail server but it doesnt work for some unknown reason. When checking the trace of the installed mail notification. I the following single line
{Error} Can not initial ADO Connection
I have never had problem...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
|
1
