Results 1 to 5 of 5

Thread: Connect Without ODBC???

  1. Nov 15th, 2001, 12:36 PM #1
    spetnik
    Guest

    Question Connect Without ODBC???

    Does anyone know of a way to connect to SYBASE or MS-SQL Server through VB without using ODBC?

    Thanx
    Reply With Quote Reply With Quote
  2. Nov 15th, 2001, 03:07 PM #2
    d4v3
    d4v3 is offline
    Lively Member d4v3's Avatar
    Join Date
    Nov 2001
    Location
    Leicester, UK
    Posts
    82
    I dont think so, but why dont u want to use ODBC?
    Reply With Quote Reply With Quote
  3. Nov 15th, 2001, 03:18 PM #3
    JoshT
    JoshT is offline
    Black Cat JoshT's Avatar
    Join Date
    Nov 2000
    Location
    WNY, USA
    Posts
    4,032
    For MSSQL you can use OLEDB (thru ADO) or the SQL-DMO COM objects (SQL-DMO use the SQL ODBC provider behind the scenes).


    Here's an OLEDB connection string, using Windows Intregrated Authentication:
    "Provider=SQLOLEDB;Server=ServerNameOrIPAddress;Database=YourDB;Trusted_Connection=Yes;"
    Josh
    Get these: Mozilla Opera OpenBSD
    I have books for sale: "MCSD in a Nutshell" and "VB Distributed Exam Cram" - PM me for details. Will also trade for a decent ATX Pentium 2 MB/CPU/RAM combo.
    Reply With Quote Reply With Quote
  4. Nov 15th, 2001, 04:27 PM #4
    RSJIG
    RSJIG is offline
    Addicted Member
    Join Date
    Oct 2001
    Location
    Between 2 bosses
    Posts
    210
    SYBASE should also have an OLEDB provider for your to connect to it's database.


    "Provider=" = OLE
    "DRIVER=" = ODBC (even if it is dsn-less)
    Reply With Quote Reply With Quote
  6. Nov 15th, 2001, 04:49 PM #5
    spetnik
    Guest
    Thanx alot.

    Is that the only other way, though?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width