Member Avatar for jellybeannn

hallo can someone please help me my Access Database ConnectionString does not work on the server

string strConnString =
            "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|calculator.mdb";
  • 2 Contributors
  • 1 Reply
  • 98 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Gospp
Member Avatar for Gospp

hallo can someone please help me my Access Database ConnectionString does not work on the server

string strConnString =
            "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|calculator.mdb";

Hello.

The '|' looks a bit fishy, I think the normal syntax is '\' ??
I would recommend you to add a '@' in front of the string, as it tells the program to read the string "as is".

string strConnString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp\Nwind.mdb";

Hope it helps!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.