472,805 Members | 1,683 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,805 software developers and data experts.

how to connect to sybase

can you tell me how to connect to sybase database with vb.net? please give
me one
example.thank you!
Nov 19 '05 #1
1 5923
Standard Sybase System 12 (or 12.5) Enterprise Open Client:
"Driver={SYBASE ASE ODBC Driver};Srvr=Aron1;Uid=username;Pwd=password"

Standard Sybase System 11:
"Driver={SYBASE SYSTEM 11};Srvr=Aron1;Uid=username;Pwd=password;"

Intersolv 3.10:
"Driver={INTERSOLV 3.10 32-BIT Sybase};Srvr=Aron1;Uid=username;Pwd=password;"

Sybase SQL Anywhere (former Watcom SQL ODBC driver):
"ODBC; Driver=Sybase SQL Anywhere 5.0;
DefaultDir=c:\dbfolder\;Dbf=c:\mydatabase.db;Uid=u sername;Pwd=password;Dsn="""""

Note! The two double quota following the DSN parameter at the end are escaped quotas (VB
syntax), you may have to change this to your language specific escape syntax. The empty
DSN parameter is indeed critical as not including it will result in error 7778.

AseConnection (.NET)

"Data Source='myASEserver';Port=5000;Database='myDBname' ;UID='username';PWD='password';"

Declare the AseConnection:
using Sybase.Data.AseClient;
AseConnection oCon = new AseConnection();
oCon.ConnectionString="my connection string";

Imports System.Data.AseClient
Dim oCon As AseConnection = New AseConnection()
oCon.ConnectionString="my connection string"

Juan T. Llibre
Foros de ASP.NET en Español
Ven, y hablemos de ASP.NET...

"xinhuanet.com" <in****@xinhuanet.com> wrote in message
can you tell me how to connect to sybase database with vb.net? please give
me one
example.thank you!

Nov 19 '05 #2

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

Similar topics

by: Data Goob | last post by:
Hi, I had trouble using FreeTDS with Sybase ASE 12.5.2 DE. I kept getting errors when trying to run a stored procedure, using the PHP program found at the end of this post. php:...
by: Vicky | last post by:
Hi, Here it the test perl code to connect to my Sybase database server.... ******************************** use CGI; use DBI; # Connect to database. my $My_dbh =
by: Dotnet_India | last post by:
Iam trying to connect Sybase through Sybase ASE.NET providers.It is giving error while making the connection like this "System.dllnotfoundexception.....Unable to load dll..." Even though I...
by: sleepite | last post by:
If I configure PHP with: ../configure --with-mysql --with-apxs2=/www/bin/apxs --with-sybase-ct=/usr/lo cal/freetds --enable-track-vars --with-xml --with-zlib-dir=/rpms/zlib-1.2.3 --with-png...
by: Chris Fox via .NET 247 | last post by:
I'm trying to access a Sybase database using Visual .net C# using the code below. I've added the Sybase data provider to the references (DDTek.Sybase) and added them to the program usage. Howver...
by: Alex Murphy | last post by:
As title, Thanks
by: mohsin | last post by:
Hi Expert Hope i point to the right grps, I need to connect my access to sybase ASE database and the collect/import the data. I have to use right driver to connect. Questions is, which one?...
by: sandeep sethi | last post by:
Hi, I m new for VB please some one can tell me how to connect Sybase with VB.please give full information and give all steps..... Thanks Sandeep.
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: lllomh | last post by:
How does React native implement an English player?
by: Mushico | last post by:
How to calculate date of retirement from date of birth
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

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.