Connection String for ADO Database in delphi prismHi,
I want to connect to a database with ADO and aspx.
from VB code what is the equivalent in delphi prism ?
....
Dim MyReader as sqldatareader
Dim MyConnection as sqlconnection = new sqlconnection()
myConnection.connectionstring =
configurationmanager.connectionstrings("DSN_MYDB").connectionstring
Dim mycommand as sqlcommand = new sqlcommand()
mycommand.commandtext="select * from mytable"
mycommand.commandtype = commandtype.text
mycommand.connection = myconnection
mycommand.connection.open()
Myreader=mycommand.executereader(commandbehavior.closeconnec...
Can I change my connection string without much ado?
I have a working gridview and I want to change its connection string to another file of exact same structure on another server. It blew up on me saying "error rendering control: Databinding:system.data.datarowview does not contain a property with the name Job-order_number"PS. It's OLE DB for Foxpro
may be you are missing job-order_number column in your new structure, which is there in previous one.My Blog"Don't be afraid to be wrong; otherwise you'll never be right."
Hi,Fonzie :Would you plz post some relative code here?Best Regards,_____________...
ADO Connection stringDoes anyone know where there are any examples of connecting to an ASA db
using an ADO _Connection object in C++?
Thanks,
-TC
A quick search through this newsgroup would have resulted in the following
find :
cnADODB.ConnectionString =
"Provider=ASAProv;LINKS=TCPIP();ENG=myDBEngine;DBN=myDBName;uid=DBA;pwd=SQL"
--
Reg Domaratzki, Sybase iAnywhere Solutions
Certified SQL Anywhere Associate
Please reply only to the newsgroup
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform ...
Recycling connections in a ADO.Net connection pool
I have a requirement where I will need to get a handle on the existing connections in a particular ADO.Net connection pool (identified by the unique connection string) and close and open them one by one.
This is because whenever we compile a package or stored procedure, ADO.Net does not realise this and keeps giving "Package is invalid" error. I am using ODP.Net Client 9.2.0.4.
The current solution is to restart the application pool to flush the connection pool.
Does anyone know how to get a list of all connection objects in the ADO.Net connection pool given a connection stri...
ADO Connection string securityI would like to have an ADO database using ADO Connection string.
Should I use the least rights user ID and password to connect database?
If yes, do I need to build ADO Connection string for every user log in that database can handle all security and user rights?
If this is the case, any example to build ADO Conneciton string at run time and connect to the users.
Your help and information is great appreciated,
Regards,
Inung
> {quote:title=Inung Huang wrote:}{quote}
> I would like to have an ADO database using ADO Connection string.
> Should I use the least rights user I...
ADO.NET Connection StringCan anyone provide the ADO.NET connection string for ASE 12.5? I am using
VB.NET and would like to connect to Sybase's ASE 12.5 server on the Windows
2K platform. The ADO connection string for VB 6.0 did not work.
Thanks
Tom
...
ADO Connection String questionI am trying to setup a database connection using ADOConnection where information
is stored in an INI file. In the form OnCreate event, the INI file is read
into global string fields MyCatalog, MyDbase, MyPassword, MyUserID. Then
I try at FormShow:
procedure TForm1.FormShow(Sender: TObject);
begin
MyConnectString := 'Provider=SQLOLEDB.1;Persist Security Info=True;Initial
Catalog='+
MyCatalog +
';Data Source=' +
MyDbase +
';Password=' +
MyPassowrd +
';User ID=' +
MyUserID;
...
Can change of connection string reset the connection pool?Hi,
In fact, I already asked a similar question about closing/reset all
connections
in connection pool. But I want to know clearly about how to do this.
I have the following questions for this issue:
1. Suppose some connections are created a connection string (with connection
pool settings),
if I update the connection string with new password, will ASEConnection
know to create a
new connections with new connection pool via Open() method? In my case,
it will not.
But I want to know if someone encounter difficult results?
2. If the above step 1 not work, then sho...
ADO Connection Does Not Work W/ Same Parameters As DSN ConnectionFolks,
Could you please help me with the following code? When the program gets to
the line that says:
.Open userid:="myID", Password:="myPassword"
I get an error message saying "[Microsoft][ODBC Driver Manager] Data source
name not found and no default driver specified". What I can't figure out is
I'm not using a data source name and what do I need a default driver for?
I've already specified the driver and it's right where I said it was.
I'm running on an NT 4.0 (SP4) platform using VB6 (SP5). My references are
* Micro...
datetime trouble in ADO Microsoft ADO .NET ConnectionHi, All!
MS SQL 200
PB 10.2.1 build 9557
In PB DB Painter:
select dateevent from AuditInternal where id_event = 201865;
Result:
ADO Microsoft ADO .NET Connection:
214:35:45:633
OLE Microsoft OLE DB Connection:
01.03.2006 12:35:45:633
It has begun in 9537
In 9557 same.
In 9004 all this it was good
thanks,
Alexey
...
ADO Connection Does Not Work W/ Same Parameters As DSN ConnectionFolks,
Could you please help me with the following code? When the program gets to
the line that says:
.Open userid:="myID", Password:="myPassword"
I get an error message saying "[Microsoft][ODBC Driver Manager] Data source
name not found and no default driver specified". What I can't figure out is
I'm not using a data source name and what do I need a default driver for?
I've already specified the driver and it's right where I said it was --
i.e., c:\dbodbc8.dll.
I'm running on an NT 4.0 (SP4) platform using VB6 (SP5). My...
ADO ConnectionWhen I try to connect to my database with ASA Provider I get an invalid
Enum value error. But if I connect to it using the OLE ODBC it connects
fine.
Can you provide a code snippet of what you are doing and a description of
the language/environment you are using?
Steve Radman, iAnywhere Solutions
Sybase, Inc.
"Ryan Wade" <rwade@smscorp.com> wrote in message
news:395218D0.75EDF354@smscorp.com...
When I try to connect to my database with ASA Provider I get an invalid
Enum value error. But if I connect to it using the OLE ODBC it connects
fine.
Hi!
&...
ADO connectivityIs there some kind of Sybase ADO DB Provider available? I need to switch
from the ADO ODBC driver, as it does not support transactions. Any help
would be VERY much appreciated. I can be reached via e-mail as
stew_thomson*NOSPAM*@hotmail.com
Just remove the *NOSPAM* from the e-mail addy.
ASA 7.0 has an OLEDB provider which you can use with ADO. However, I thought
the MSDASQL OLEDB provider also supported transactions. What makes you think
it doesn't?
Jason Hinsperger
International and Sustaining Engineering
Adaptive Server Anywhere
stew_thomson*NOSPAM*@hotmail.co...
Help with ADO connectivity in Delphi XEThe company I work for has finally started migrating applications from Delphi 5 and 7 to Delphi XE and XE2. But, I am having a problem with a TADOConnection.
A simple application built in D5 to connect to a MS SQL database works. But the same code compiled in Delphi XE will not connect. When the user's role changes from User to Power User, they can connect to the database in the app compiled in XE.
The workstation that the user is running from is Windows XP. The SQL Server version is 2005. MDAC version 2.8
Unfortunately, we have been unable to simulate their environment, an...