Connect via OLEDB

General discussion forum about all databases other than SqlBase.
matelix

Connect via OLEDB

Post by matelix » 02 Sep 2012, 22:27

Hi All

I have looked through the forums here but I can't seem to find the example I'm looking for. I need to connect to SQL Server 2005 OLEDB. Is there any example that I could look at to help me achieve this?

Thanks

Jeff Luther

Re: Connect via OLEDB

Post by Jeff Luther » 04 Sep 2012, 18:16

Couple possible resources:
* ccod.pdf TD ebook has a section on MS SS

* Documentation page: https://support.guptatechnologies.com/su ... umentation
and top right links to TD

* and of course, do a search on this forum for: OLEDB

matelix

Re: Connect via OLEDB

Post by matelix » 09 Sep 2012, 20:10

Hi Jeff

Thanks for the response, but I read through the books and they don't specify how to use OLEDB connections. I saw that you can use ODBC but I'm trying to avoid ODBC completely. I've used it in my previous software and I don't like how it handles connections. I need to be able to connect to ANY database on a SQL Server WITHOUT having to include a SQL.INI file. Is this possible. Please find attached a test app that I did, trying to use OLEDB but it kept saying '"Access denied or server does not exist" even though I have full access on that user and I have allowed all connections to my SQL Server. What am I missing in i :? t?

Thanks
You do not have the required permissions to view the files attached to this post.

matelix

Re: Connect via OLEDB

Post by matelix » 10 Sep 2012, 05:43

Hi

Ok, I finally figured it out. Works like a charm now :mrgreen: :D . Turns out i was doing something so silly :oops:

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 1 guest