Member Avatar for GeoEqual 
.ConnectionString = "Driver=MySQL ODBC 5.2a Driver; SERVER=localhost; UID=asdsadafg; PWD=sadsadsJFKSKF9; DATABASE=SampleDB; PORT=3306; OPTION= 1 + 2 + 8 + 32 + 2048 + 16384

can anyone explain the OPTION, what this connetion string will do... i have no idea.. please explain

  • 3 Contributors
  • 6 Replies
  • 194 Views
  • 20 Hours Discussion Span
  • Latest Post Latest Post by imBaCodes
Member Avatar for tinstaafl

It would appear to me OPTION is setting a series of flags. This article might help

Edited by tinstaafl
Member Avatar for imBaCodes

Driver = "Your database drive depends on your database"
Server = "Use localhost when your not connecting to other Server. and use IP if you do."
UID = "User Identifier"
PWD = "is your password"
Database = "Is your Database name"
Port = "the port you are using . me i'm using 8080"

Option its not as much required.
these string is used to connect to a database

Member Avatar for GeoEqual

I am building a program that will be deploy to 3 computers and connected to a single database installed on 4th computer. When i created the connection string, he replied that option without explaining the values of the number.

Member Avatar for imBaCodes

GeoEqual
SEE THIS
this will give you a better idea ..

Member Avatar for GeoEqual

thanks, this will help

Member Avatar for imBaCodes

If your problem is solve just mark this as solve ..

happy coding..

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.