U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » How to connect to ODBC??

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

How to connect to ODBC?? [message #47798]

Wed, 29 March 2017 09:42

NilaT
Messages: 70
Registered: November 2011
Location: Austria

Member

Hello everyone, I have a new question for you Wink

I have a mdb Database and I want to connect to it with U++ using ODBC.

So, I added the data source to ODBC32 Bit:
For User-DSN and System-DSN.
Name is anything, Platform is 32 Bit, Driver is Driver do Microsoft Access (*.mdb) and also tried Microsoft Access Driver (*.mdb)

Then, in my program, I use the following code:
(be aware that I use 2010 sources):

ODBCSession session;
if(!session.IsOpen())
{
  String cs = Format("DRIVER=%s;SERVER=(local);Trusted_Connection=yes;", "something"); // DRIVER is the same name as in ODBC data source, also tried {SQL Server}
  if(!session.Connect(cs))
  {
    Cout() << session.GetErrorStatement() << "\n";
  }
}

With DRIVER = "something" I get the error: [Microsoft][ODBC Driver Manager]The datasource was not found, no standard driver... (translated to english, original error message is german so may it's not 100% the right message)

With DRIVER = {SQL Server} I get: [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or connection refused
and [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect())

I also tried disabling the firewall, with no success.

Am I missing something?
Please help me.
Thanks

Report message to a moderator

Re: How to connect to ODBC?? [message #47799 is a reply to message #47798]

Wed, 29 March 2017 10:14

NilaT
Messages: 70
Registered: November 2011
Location: Austria

Member

Nevermind, just found it on my own...
There is no need for an ODBC Data connection, and no need for a firewall rule.

I simply changed my connection string to the following:

connectionString = "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\\path\\database.mdb;Uid=;Pwd=;";

according to:
https://www.connectionstrings.com/access/#net-framework-data -provider-for-odbc

and it works.

[Updated on: Wed, 29 March 2017 10:15]

Report message to a moderator

Previous Topic:	How can .sch express a many-to-many relationship ?
Next Topic:	MSSQL connection cause memory leak

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Apr 23 13:48:15 CEST 2024

Total time taken to generate the page: 0.02393 seconds