473,668 Members | 2,654 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Please help with ConnectionStrin g to SQLAnywhere 5.0

Hi all,

i have a client with an old working app. in PowerBuilder for which i
need to create new modules.
The db is sqlanywhere 5.0.4
The db is configured in ODBC.
Now, i don't seem to be able to connect to this db.

Can anyone help me with the connectionstrin g and maybe references to
add?

string connectionStrin g = "Data Source=Ghoenix; uid=dba;pwd=ger ling";
Conn = new OdbcConnection( connectionStrin g);

try{Conn.Open() ;}
catch(Exception ex){MessageBox. Show(ex.ToStrin g());};

He keeps giving : datasource & driver not found...

Help would greatly be appreciated,
Oswald
Nov 16 '05 #1
2 2178
i found it myself
SQLAnywhere 5.0 is supported by ODBC 2.x instead of 3.x
And this string worked just fine!

For everybody's information (if ever needed):
---------------------------------------------
String ConnectionStrin g =
"Provider=MSDAS QL;DSN=Ghoenix; userid=dba;pass word=gerling";
OdbcConnection myConnection = new OdbcConnection( ConnectionStrin g);
myConnection.Op en();

os************* *@skynet.be (oswald verlinden) wrote in message news:<1c******* *************** ****@posting.go ogle.com>...
Hi all,

i have a client with an old working app. in PowerBuilder for which i
need to create new modules.
The db is sqlanywhere 5.0.4
The db is configured in ODBC.
Now, i don't seem to be able to connect to this db.

Can anyone help me with the connectionstrin g and maybe references to
add?

string connectionStrin g = "Data Source=Ghoenix; uid=dba;pwd=ger ling";
Conn = new OdbcConnection( connectionStrin g);

try{Conn.Open() ;}
catch(Exception ex){MessageBox. Show(ex.ToStrin g());};

He keeps giving : datasource & driver not found...

Help would greatly be appreciated,
Oswald

Nov 16 '05 #2
Still had problems with security issues, but this one is a winner :

String ConnectionStrin g = "Provider=MSDAS QL;DSN=Ghoenix; UID=dba;PWD=ger ling";
os************* *@skynet.be (oswald verlinden) wrote in message news:<1c******* *************** ****@posting.go ogle.com>...
Hi all,

i have a client with an old working app. in PowerBuilder for which i
need to create new modules.
The db is sqlanywhere 5.0.4
The db is configured in ODBC.
Now, i don't seem to be able to connect to this db.

Can anyone help me with the connectionstrin g and maybe references to
add?

string connectionStrin g = "Data Source=Ghoenix; uid=dba;pwd=ger ling";
Conn = new OdbcConnection( connectionStrin g);

try{Conn.Open() ;}
catch(Exception ex){MessageBox. Show(ex.ToStrin g());};

He keeps giving : datasource & driver not found...

Help would greatly be appreciated,
Oswald

Nov 16 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
2961
by: Siemel Naran | last post by:
Hi. I have a table of products and versions, and these 2 columns are the unique key. My challenge is to write a SQL statement to find the latest version of each product. My solutions below seem correct, yet MySql complains that the syntax is incorrect. How to fix? And which solutions are MySql specific, and which are ANSISql (for
5
4599
by: trint | last post by:
Ok, Everything connects correctly and loads properly in this WebApplication. I have four buttons and all work correctly except one (the NEXT RECORD button). PREVIOUS, FIRST and LAST all work properly. This identical code works correctly in a windows app. Please tell me what I am doing wrong. Here is my connection code: private void InitializeDataConnection ()
1
1451
by: Esteban Felipe | last post by:
Hi, thanks for reading. I hope to find some help here before I commit suicide because this is driving me crazy. Please excuse me if this looks like a long post, but I hope that a complete explanation help you to help me :=) ....Let's start with some background: ..- I'm building an asp.net application that requires users to upload text files in cvs format with data exported from an AS-400. ..- The files will be something between 800kb...
3
3442
by: Shapper | last post by:
Hello, I have created 3 functions to insert, update and delete an Access database record. The Insert and the Delete code are working fine. The update is not. I checked and my database has all the necessary records in it when testing it. I get the error "No value given for one or more required parameters." when I try to update the database. Can you tell me what am I doing wrong?
1
1316
by: davidman73 | last post by:
Hello, I have VS 2005 with SQL Server Express in the same machine, but need to connect to a remote SQL Server 2000. I'm getting this error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to...
1
3213
by: teddymeu | last post by:
hi guys I posted the other day regarding a solution i needed to design, im new to development an asp,net and built a local post office search tool using asp.net 2. vb in visual studio, using an sql express mdf database(this means the database is transferable with the solution even if the server doesnt have sql server on it) The app works fine, users can search, admins can edit data, insert and delete. The site also has membership and role...
0
1048
by: Radu | last post by:
Hi. On the first page of my website the user selects one document which can be in either English or French. I store that choice in a class, and I can extract it with: CType(Session("UsersSessionClass"), UserSessionClass).SelLanguage Later in my 'wizard' I have a page which contains this html: __________________________________________________________________ <form id="frmStep4ConfigureDoYous" runat="server"> <%-- Store the language...
1
3750
by: Brad Isaacs | last post by:
I am working with ASP.NET 2.0 and using an SQL Server 2000 database. I am using Visual Studio 2005 and developing on my Local machine. I am working with Login controls ASP.Configuration, I wanted to move my work and needed to place it on the server. Using VS 2005 , went to BUILD -Publish Web Site Checked the box for :: Alow this precompiled site to be updatable.
4
2212
by: Brad Isaacs | last post by:
I am working with ASP.NET 2.0 and using an SQL Server 2000 database. I am using Visual Studio 2005 and developing on my Local machine. I am working with Login controls ASP.Configuration, I wanted to move my work and needed to place it on the server. Using VS 2005 , went to BUILD -Publish Web Site Checked the box for :: Alow this precompiled site to be updatable.
0
8462
marktang
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...
0
8893
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8797
jinu1996
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...
1
8583
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,...
0
8656
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
5681
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();...
0
4205
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2791
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
2
1786
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.