how i make dsn less connection in powerbuilder 8
I want to connect database without dsn how can i do that,
please send code for that
A quick google search yielded:
Simply change the Driver= value to match the ODBC driver you want to use.
> I want to connect database without dsn how can i do that,
> please send code for that
Sybase Adaptive Server Anywhere Professional Version 8
Sign up today for your copy of the SQL Anywhere Studio 9 ...Can I use DSN less to connect database
Can I use DSN less to connect database, like connect to *.mdb?
...DSN less connection with powerbuilder 11.2
Can anyone please let me know to give DSNless connection with SQL Anywhere
database in powerbuilder 11.2. It would be very helpful to me
---== Posted via the PFCGuide Web Newsreader ==---
The basic trick is to pass in the "DRIVER" argument in the connection
string - the SQL Anywhere ODBC driver must still be present on the system.
"DRIVER=SQL Anywhere 11;UID=dba;PWD=sql;ENG=MyEngine;..."
> Can anyone please let me know to give DSNless con...DSN-less, register-less connection?
I have the DSN-less connection ok with the following:
SQLCA.DBParm = "ConnectString='Driver=Adaptive Server Anywhere 7.0;" + &
"UID=dba;PWD=sql;DBF=c:\mydir\mydb.db;" + &
"Start=c:\mydir\rteng7.exe -c 8m'"
But as far as I know the 'Driver=Adaptive Server Anywhere 7.0;' requires a
register setting, or does it?
Can I get around this somehow so I don't need any register settings for a
"Doogie" <email@example.com> wrote in message news:OWG942%23NDHA.364@forums-2-dub...
> I have the DSN-...Database Connection???How to connect a Database in an other server?
How to connect a Database(.mdb) in an other server?
Can I use the connection string like below?
mycon.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=http://www.****.com/***/mydb.mdb"
You can not.
Access is file based. No a client/server architecture.Thomas TomiczekPowerNodes ApS(Microsoft MVP C#/.NET)---Building a Website? Try the PowerNodes CMS - http://www.powernodes.com/
Correction: you can. Just make sure you can reach the acces db file - through a file share that is bound as drive.
Not that you should. Performance will be horrib...How to connect DBClient using a DSN-less connection in a VB5 App
I have a VB5 app connecting to SLQ Anywhere without a data source name
- no problem. I am changing the app to a multi-user environment using
SLQ Anywhere Server & SQL Anywhere Client. I can connect with a DSN -
no problem; the ODBC dialog screen comes up. I don't want to setup a
DSN on all the machines in the office if I don't have to.
We are running Novell (I think 3.1, maybe 4.0)
Here is the code for the standalone version DSN-less- works fine.
RDOConnect = "UID=rico;PWD=rico;DBF=" + DBPath +
"\ricoapp.DB;DRIVER=Sybase SQL Anywhere 5.0;DSN=...DSN-less connection
Our Billing application uses a DSN-less connection to the SQLAnywhere 10
database. Here is the connection info used:
I've tried using this connection info in the .ini generated from Infomaker
for my report, but no luck. I first get the login window. I try entering a
userid and password, then I get the error:
"Database Conneciton Failed. Application cannot be run"
DBMS is not supported in yo...DSN-less connection
Can anyone supply me with the proper syntax for a connect string for
SQLAnywhere version 5.5? I'd be greatly appreciative.
John der Kinderen
sConnectString="Provider=MSDASQL;Driver=Sybase SQL Anywhere
works for me !
<johndk> wrote in message
> Can anyone supply me with the proper syntax for a connect string for
> SQLAnywhere version 5.5? I'd be greatly appreciative.
> John der Kinderen
Can someone post an example of how to do a DSN-less connection to SQL
Anywhere 5.5.03 from Powerbuilder? (The database is running on a server and
the user connect using dbclient.)
Alternately, maybe someone could explain why the database won't use the UID
and PWD I provide in the 'ConnectString' when I connect using a DSN.
If I store the userid and password in the DSN it works fine,
but I want to get away from that because
it is machine dependent. I want to connect to the database using the userid
of the person who signed in. If I take the userid and password out of ...Cannot connect my database to Powerbuilder
I am new to Powerbuilder. I am unable to run a Powerbuilder program
with the database that I have specified in the 'Database Painter'.
Could you please help me? I am able to see the tables in the painter
but when I try and run the exe after building it, it does not seem to
be pointing to that database.
You have to populate those same attributes on the SQLCA connection
object and then issue a CONNECT statement within your application
On Mon, 30 Nov 2009 18:33:22 -0800 (PST), anand_icomm
&g...connecting to database from powerbuilder
Is there any way to connect to database from powerbuilder
other than transaction objects..
Thanks in advance
a powerbuilder application needs transaction objects to interact with any
what functionality are you trying to build?
<Suby> wrote in message news:firstname.lastname@example.org...
> Is there any way to connect to database from powerbuilder
> other than transaction objects..
> Thanks in advance
The transaction object is the object to be used to connect to any database?
What do you...powerbuilder database connections
I receive this error message when I try to connect the dbclient. "unable to
start, server not found"
When I try to connect to any type of database in Powerbuilder, I receive
unable to load Powersoft ODBC DLL
could not load interface for specified database
In article <TcVR68XL9GA.email@example.com>, firstname.lastname@example.org says...
>> When I try to connect to any type of database in Powerbuilder, I receive
>> these errors:
>> unable to load Powersoft ODBC DLL
>> could not load interface for specified ...powerbuilder database connections
When I connect to any database using Powerbuilder 4.0 I get the following
unable to start, server not found
Could not load interface for specified database
unable to load Powersoft ODBC DLL
The system can't find PBODB040.DLL.
Carson Hager Dynamic Data Solutions
Team Powersoft http://www.dyn-data.com
******** Are You Ready for the Web ********
...dsn less connect
Will a deployed pk 2.5.1 app connect to sqlanywhere 10 using a dsn-
less connection like Powerbuilder will?
Yes. You may need to use DRIVER=<full_path_odbc_driver_dll> as there is
no context of a registered driver name.
Please only post to the newsgroup
SQL Anywhere Developer Community
SQL Anywhere Blog Center
Maintenance releases and EBFs
Use Case Express to report b...