How do I connect to SAW 5.5 with VB.NET/ADO.NET?

I want to connect to a SQL Anywhere 5.5 database running on a W2K Pro 
server, using VB.NET and ADO.NET. Here's how I connect to MS SQL Server 
with VB.NET and ADO.NET:

gstrADOConnectionString = "Data Source=" & gstrServerName & ";" & _
"Initial Catalog=" & gstrDatabase & ";" & "Integrated Security=SSPI;" & _
"Connect Timeout=" & Convert.ToString(gshoADOConnectTimeout)

Example: Data Source=PSI_Dell;Initial Catalog=BRM;Integrated 
Security=SSPI;Connect Timeout=60

Here's how I did it with VB6 and ADO:

gstrADOConnectionString = "Provider = SQLOLEDB;" & _
    "Data Source = " & gstrServerName & ";" & _
    "Initial Catalog = " & gstrDatabase & ";" & _
    "Integrated Security = SSPI"

SSPI = Security Support Provider Interface. It is for NT integrated 
security. I suspect I'll need to use the Microsoft OLE DB Provider for ODBC 
Drivers. Can someone give me an example of how to do it?

Thanks,
Rick McCorkle
Professional Software, Inc.
rmccorkle@compuserve.com
770-963-9254
fax: 770-682-4375
0
Rick_McCorkle
6/7/2003 2:16:37 PM
sybase.sqlanywhere.general 32637 articles. 4 followers. Follow

1 Replies
895 Views

Similar Articles

[PageSpeed] 49

This is no providor for SQL Anywhere 5. Use the MS ODBC OLEDB interface -
MSDASQL.

Example Code

Dim myConn as New ADODB.Connection
myConn.Provider = "MSDASQL"
myConn.ConnectionString = "Data Source={your odbc dsn}"
myConn.Open



<Rick_McCorkle> wrote in message
news:632EC8D17C699B9B004E6CE885256D3E.004E6D0085256D3E@webforums...
> I want to connect to a SQL Anywhere 5.5 database running on a W2K Pro
> server, using VB.NET and ADO.NET. Here's how I connect to MS SQL Server
> with VB.NET and ADO.NET:
>
> gstrADOConnectionString = "Data Source=" & gstrServerName & ";" & _
> "Initial Catalog=" & gstrDatabase & ";" & "Integrated Security=SSPI;" & _
> "Connect Timeout=" & Convert.ToString(gshoADOConnectTimeout)
>
> Example: Data Source=PSI_Dell;Initial Catalog=BRM;Integrated
> Security=SSPI;Connect Timeout=60
>
> Here's how I did it with VB6 and ADO:
>
> gstrADOConnectionString = "Provider = SQLOLEDB;" & _
>     "Data Source = " & gstrServerName & ";" & _
>     "Initial Catalog = " & gstrDatabase & ";" & _
>     "Integrated Security = SSPI"
>
> SSPI = Security Support Provider Interface. It is for NT integrated
> security. I suspect I'll need to use the Microsoft OLE DB Provider for
ODBC
> Drivers. Can someone give me an example of how to do it?
>
> Thanks,
> Rick McCorkle
> Professional Software, Inc.
> rmccorkle@compuserve.com
> 770-963-9254
> fax: 770-682-4375



0
Chris
6/8/2003 4:08:48 PM
Reply:

Similar Artilces:

Request Suggestion: ASP=>ASP.NET 3.5 or ASP=>ASP.NET 2.0 ->ASP.NET 3.5 (in 5 years)
Hi there, I have a few questions:My company has about 40 mid-sized application written in class asp. We plan to upgrade to ASP.NET since Microsoft will no longer support ASPin three years. As of today, most of our servers are running ASP.NET 2.0. Here are a few of the questions:1.) Is ASP.NET 3.5 or ASP.NET 3.0 stable enough to be put to production?  2.) Can IIS run different versions of ASP.NET? 3.) For new applications, would you guys develop it in ASP.NET 2.0 or the latest version?4.) Any known problems?  I love the the MVC and ORM/LINQ about ASP.NET 3.5; however, I...

ASP.NET Extensions CTP and .NET Framework 3.5 SP1/.NET Framework 3.5 and vs2008 sp1?
Can someone explain the differences/relationships between asp.net extensions ctp, .net framework 3.5 sp1/.net framwork 3.5, and vs2008 sp1? I currently have a web app built with vs2008 RTM, .net framework 3.5 (no sp), and asp.net extensions ctp.  The system.web.extensions for framework 3.5 is version 3.5.0.0 and for .net extensions ctp it is 3.6.0.0.  Can I replace all web references with the ctp version 3.6?     CTP = Community Technology Preview; these are something like beta versions that are released so that they can be tested. these are generally...

.Net Connection to SQL Anywhere 5.5
I am trying to connect to a SQL Anywhere database via VB.Net. The database was created by one of my clients. I am new to SQL Anywhere 5.5. Could someone please walk me through the process from setting up the DSN if needed to the end where I can display the data....the driver is wod50T.dll version (5.5.5.2817). I also notice that the database has a .dbf file extension (not dBase) which seems confusing but maybe I just am not up on SQL Anywhere version 5.5 Thanks in advance for any and all ideas and help. BrianB ...

ASP.NET 3.5 to ASP.NET 3.5 Extensions
Hi, I have a ASP.NET 3.5 web site, I want to enable it for ASP.NET 3.5 Extensions. How do I do it? Thanks in Advance,Anup --Go for it now. The future is promised to no one.-- Or How do I convert ASP.NET 2.0 website to ASP.NET 3.5 with Extensions ? --Go for it now. The future is promised to no one.-- >Or How do I convert ASP.NET 2.0 website to ASP.NET 3.5 with Extensions  Open the solution for the project is Visual Studio 2008 and change the target type from 2.0 to 3.5. You will then be able to start using all the extension to the 2.0 framework.Don't forget...

ASP.NET/ADO.NET/VB.NET Books
Can anyone suggest a good book(s) on ASP.NET, ADO.NET and VB.NET, I have familiar ASP 2.0 and have used VB 6 a few times, so I’m a total newbie, to this type of thing. Thanks Jason One free place to start is the Quickstart tutorials. They are available on the tutorials tab on this website. The best "starting out" book, IMO, is still "ASP.NET Unleashed", by Stephen Walther. This gives you an excellent introduction to all of the essentials. From there, it would depend on your needs. BTW - there is a "Book Review" forum within the ASP.NET Forums t...

DW.NET 1.5 support for ADO.NET
Does the new version 1.5 support ADO.NET from Sybase? Only via OLE-DB. On 21 Dec 2004 05:34:43 -0800, "Germano" <gsilva3891@yahoo.com> wrote: >Does the new version 1.5 support ADO.NET from Sybase? > Will a future version support it? It does not make much sense to have support for Microsoft's ADO.NET and not Sybase's own ADO.NET "Jim O'Neil [Sybase]" <joneil_at_sybase_dot_com> wrote in message news:bdegs01trng2706pugk8kracqg7elq250r@4ax.com... > Only via OLE-DB. > > On 21 Dec 2004 05:34:43 -0800, "...

hebrew in mysql with asp.net 3.5 and net connector 5.08
hi,i cant read hebrew from my mysql, isert works.when i try this queryselect cityname from citysautocompletion where cityname like אi dont get any values back but when changing א to e i get the values.when running in query analyzer, both return values.i tried utf-8 and hebrew charset and none worked. thanx,  it should be that the data is not saved as hebrew from the first time you saved it.thus, mysql supports most of the charsets and should work fine if you have the data saved in the database as hebrew. :)why not try to edit the data cell in your row and re-write it in hebrew an...

Connecting to ASA 9 through network with ADO.NET in VB.NET
Hi, I'm having trouble connecting to an Adaptive Server Anywhere database with the ADO Provider "ASAProv" with client computers. It works perfectly when the application is in the same computer as the database server. But when I try to connect to it from another machine, this machine opens a new ASA Database server and cannot access the database because its being used by the first computer. My connection string is Provider=ASAProv; UID=dba; PWD=sql; ServerName=GUS; DatabaseName=LCMS2; AutoStop=No; DBF=\\Gustavo\DB\LCMS2.DB How can I tell the application to use ASA ...

SetFocus in ASP.NET 3.5 using VB.NET
How would I do that? I have a button to be clicked, once that is clicked, I want the focus to be on a specific label. you cant set focus to a label, A label renders as text in span and nothing can be done after setting it to focus. If you want to scroll it to view on the page, you can create an anchor just before the label and can call this in url example <a name="myLabel" /><asp:Label id="mylabel" ....... . . .. /> then if you request url :  http://www.siteName.com/pageName.aspx#myLabel this request will show the label on either top-left or in pr...

Best book to learn C# with .NET 3.5 (ASP.NET 3.5)
 I have a little background in ASP.NET 2.0 and I would like to learn  C# and ASP.NET 3.5 for Visual Studio 2008. I need a beginner to intermiediate book. Kanika TolverIT Specialist U.S. Department of Transportation You might try : Professional C# 2008 (Wrox Professional GuidesDavid WierMCP/ASPInsiderASPNet101.com - where to look first!Please Vote for ASPNet101 - 'Best Community Resource'!Control Grouper - easily control properties for multiple controls with one control!Calendar Express - The Best HTML Calendar Generator on the web!(Please 'Mark as Answer' wh...

.Net Connector 5.0 Encryption vs .Net Connector 5.1 Encryption
Is there any different between the AES Encryption in .Net Connector 5.0 and .Net Connector 5.1 ?? previously i using .Net Connector 5.0 to build my system. the encryption and descryption work fine. but after i upgrade to .Net Connector 5.1 ( uninstall the .Net 5.0 Connector, Install 5.1, delete the "<add assembly="MySql.Data, Version=5.0.7.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/>" in webconfig, then add the 5.1 MySQL reference to the system) i cant encrypt the data that i previously decrypt when using .Net Connector 5.0. What is the problem that ca...

Problem migrating ASP.NET from .NET 3.5 beta2 to 3.5 RTM
Hi, not sure is this the right place to post. But I'd posted a message here http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2553018&SiteID=1 and there said I should post in asp.net forum. (Even I think my problem is more related to .NET Framework issues)   Ok, my problem is I use VS2008 beta2 to develop a web application project. Recently I install .NET Framework 3.5 RTM to my box. After fixing my code a little bit (due to the changes of Linq to SQL in 3.5 RTM) I can recompile my project. But when I run the application, there was a runtime error saying...

ASP.NET + ADO.NET + VB.NET: Book recommendation?
I’m new to ASP.NET, but not to ASP.  I’m also new to most things .NET, but have worked with VB and databases quite a bit up through VB6.  Since then my programming has been in hibernation.  Anyway, I need to build a new corporate website using ASP.NET and VB.NET.  It will be heavily database driven using SQL Server (ADO.NET).  I have bought a couple of books, but still haven’t found one that I feel is going to get me what I need.  I need something that focuses on database-driven web-based applications using ASP.NET.  Most ASP.NET books kind of brush ov...

Connecting to SQL 6.5 with VB.NET
Hi, I am trying to connect to a SQL 6.5 database with VB.NET. Is this possible, and if so, what kind of connection string is used and what mode of data access (OleDB, ODBC, etc.) I have had several problems doing this and I am starting to wonder if there is anything special that needs to be done or if it is even possible. Thanks in advance! OleDB. Check out http://www.connectionstrings.com/Darrell Norton, MVPDarrell Norton's BlogPlease mark this post as answered if it helped you! Alright, I tried creating an OleDB Connection using Visual Studio. I set up the connection ...

Web resources about - How do I connect to SAW 5.5 with VB.NET/ADO.NET? - sybase.sqlanywhere.general

First Capital Connect - Wikipedia, the free encyclopedia
( FCC ) is a British train operating company , owned by FirstGroup , operating the Thameslink Great Northern franchise . FCC operates passenger ...

Connect
mobile photography technology, culture and community www.dpreview.com News Reviews Features Phones Tablets Cameras Apps Forums Mobile photography ...

CloudCraze Connects Consumers To Facebook Brands Via Cloud Technology
Brands on Facebook are always looking for new, efficient ways to connect with customers . CloudCraze, which recently released its 3.0 e-commerce ...

Apple celebrates App Store records as it notes iTunes Connect’s usual holiday break
Apple has posted the dates of the usual holiday shutdown of iTunes Connect , running for eight days from 22 to 29 December inclusive. During ...

FishbowlNY Newsstand: Connect The Dots
FishbowlNY Newsstand: Connect The Dots

Apple announces Dec. 22-29 holiday closing dates for iTunes Connect
Apple has announced the dates for the annual holiday shutdown of iTunes Connect. As in the previous year , Apples developer portal is scheduled ...

How different networking standards are competing to connect the Internet of Things
The Internet of Things (IoT) — a vast network of connected devices — is set to become the world’s largest device market over the next decade, ...

App connects seniors across the globe
The start-up behind the app raised $1 million in its first six months and has grown to serve a global user base of 25,000.

Ford announces Sync Connect smartphone app
The app works with Ford's new embedded modem, first arriving on the 2017 Escape, to bring vehicle functions to the owner's smartphone, no matter ...

Uber Launches Service To Help Drivers Connect With Passengers On Their Route
Between offering taxi, private car and rideshare options, Uber seems to have a service to meet just about every users’ transportation needs. ...

Resources last updated: 11/24/2015 11:19:00 AM