473,588 Members | 2,452 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

OLE DB initialization string

Hello -

I'm using VB .Net 2003 connected to Access 2002 via the OLE DB Jet Engine
driver. When I open the connection in the Server Explorer, it works fine.
But when I build the app I get this error:

"Format of the initialization string does not conform to the OLE DB
specification" from the Microsoft OLE DB Service Components.

I can't find anything about what is causing this error. The Data Connection
has very few options, and this is not obvious.

Thanks for your assistance.

Mark


Nov 20 '05 #1
5 3726
Cor
Hi Mark,

Some links with all kind of connection strings.

http://www.connectionstrings.com/

http://www.able-consulting.com/ADO_Conn.htm

I hope this helps a little bit?

Cor
I'm using VB .Net 2003 connected to Access 2002 via the OLE DB Jet Engine
driver. When I open the connection in the Server Explorer, it works fine.
But when I build the app I get this error:

"Format of the initialization string does not conform to the OLE DB
specification" from the Microsoft OLE DB Service Components.

I can't find anything about what is causing this error. The Data Connection has very few options, and this is not obvious.

Thanks for your assistance.


Nov 20 '05 #2
* "Mark" <ma*****@hotmai l.com> scripsit:
I'm using VB .Net 2003 connected to Access 2002 via the OLE DB Jet Engine
driver. When I open the connection in the Server Explorer, it works fine.
But when I build the app I get this error:

"Format of the initialization string does not conform to the OLE DB
specification" from the Microsoft OLE DB Service Components.

I can't find anything about what is causing this error. The Data Connection
has very few options, and this is not obvious.


What's your connection string?

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>
Nov 20 '05 #3
Hi Cor -

Is the connection string the same as the initialization string? I'm not
sure if they are the same.

Thanks for the links.

"Cor" <no*@non.com> wrote in message
news:OP******** ******@TK2MSFTN GP09.phx.gbl...
Hi Mark,

Some links with all kind of connection strings.

http://www.connectionstrings.com/

http://www.able-consulting.com/ADO_Conn.htm

I hope this helps a little bit?

Cor
I'm using VB .Net 2003 connected to Access 2002 via the OLE DB Jet Engine driver. When I open the connection in the Server Explorer, it works fine. But when I build the app I get this error:

"Format of the initialization string does not conform to the OLE DB
specification" from the Microsoft OLE DB Service Components.

I can't find anything about what is causing this error. The Data

Connection
has very few options, and this is not obvious.

Thanks for your assistance.


Nov 20 '05 #4
Cor
Hi Mark,

This I did copy from something in MSDE

[oledb]
Everything after this line is an OLE DB initstring
Provider=SQLOLE DB.1;Persist Security Info=False;Data
Source=a-iresmi2000;Init ial Catalog=Northwi nd;Integrated Security=SSPI

And that is what I call a connection string.

Cor

Is the connection string the same as the initialization string? I'm not
sure if they are the same.

Nov 20 '05 #5
Good question! I'm not settnig a value myself. The Form appears to set all
those values itself based on the Data Connection I defined - and it has no
option for the connection string, although it says it can connect
successfully.
"Herfried K. Wagner [MVP]" <hi************ ***@gmx.at> wrote in message
news:bp******** *****@ID-208219.news.uni-berlin.de...
* "Mark" <ma*****@hotmai l.com> scripsit:
I'm using VB .Net 2003 connected to Access 2002 via the OLE DB Jet Engine driver. When I open the connection in the Server Explorer, it works fine. But when I build the app I get this error:

"Format of the initialization string does not conform to the OLE DB
specification" from the Microsoft OLE DB Service Components.

I can't find anything about what is causing this error. The Data Connection has very few options, and this is not obvious.


What's your connection string?

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

Nov 20 '05 #6

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

Similar topics

19
1934
by: JustSomeGuy | last post by:
I have a class that has a static member variable. string x; x should never change during use and should be intialized to "abcd". How does one do this?
10
4182
by: JKop | last post by:
What's the difference between them? Take the following: #include <iostream> struct Blah { int k;
8
4178
by: Baloff | last post by:
Hello I am not sure why my compiler will not initialize string e1("sam"); and will initialize string e1 = "sam"; here is my code and the error. thanks alot
4
2199
by: Anton Pervukhin | last post by:
Hi everybody! I have a small problem regarding the initialization of pointer to the file stream under some conditions. Imagine a class which has a pointer to output file stream and some additinional methods to deal with it, i.e. open/close/write: classA { private: const std::auto_ptr<std::ofstream> filePtr;
4
1885
by: Jacek Dziedzic | last post by:
Hello! Suppose I have a class Foo that defines a default c'tor that initializes some data using an initialization list: Foo::Foo() : member1(0), member2(0), member3(NULL), member4(20) // and so on, quite a few members {} and does nothing else.
5
1873
by: Randy | last post by:
Hi, When a class contains another class as a member variable, e.g., class ClassA { int a; public :
10
8534
by: utab | last post by:
Dear all, Can somebody direct me to some resources on the subject or explain the details in brief? I checked the FAQ but could not find or maybe missed. Regards,
17
4791
by: prakashraovaddina | last post by:
Hi ppl, can some one say if the following pointer initialization is legal or no. int *intPtr = 5; While debugging i still see that the pointer is given some address. However, the initialization value is not found there. But, the following string initialization,
3
1707
by: subramanian100in | last post by:
Consider the following program: #include <iostream> #include <string> using namespace std; class Test { public:
4
1431
by: subramanian100in | last post by:
Consider the following program: #include <iostream> #include <string> using namespace std; class Test { public:
0
7929
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8357
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8223
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6634
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
5729
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5398
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
3847
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2372
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1459
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.