Format of the initialization string does not conform to specification startup at index 0

Hot Topic

Remote Database in Client Machine?
Childform misbehaving? Ignoring location commands.
SQL STATEMENT Select, where * problem
Dot Net Interface for an Audio mixer?
know a file size
printing a hard copy
Online SQL-Express database
VNC or TS alike app
adding handler to a button generated at runtime
thread tab in vb ide 2003

Visual Basic

VB program cannot be started when Office Communicator started
String * 255 to VB6.FixedLengthString(255) conversion issue
Save
SQL IIF with <,>,=, Between, or Like
TextBox & ComboBox Autocomplete
Using Typed Datasets Efficiently
MissingMethodException
Starting/Stopping Processes
Managing systems from a common system
Getting Line no. & Column no. of the current cursor position in the Rich text box

Format of the initialization string does not conform to specification startup at index 0

Dear all,

I am creating a new data connection using the Data Source Configuration Wizard in VB 2005. I am selecting "Database" then "New Connection". I am selecting "Microsoft Access Database File". As soon as I click on the 'Ok' button, another windows pops up showing that I need to specify a connectionstring. I've read the Microsoft Press Book Step by step and nothing specifies that a I should specify a connectionstring. The connection string should be build by the wizard itself, and therefore another window should have appear. This should ask for the "Database File Name"

I've read some post that suggested to check if a particular registry key was in place. Mine wasn't but altough I've restared the pc nothing has changed.

Since I can't figure out why I am having this error, can someone indicate what should I do to sort out this issue. Is this a know issue Are there any work arounds

Thanks

Answer this question

Format of the initialization string does not conform to specification startup at index 0

CSharpShooter

Hi,

The connection string may consist of the user-name and password to connect to the database.

I believe it also holds the link url address to the server like http://myServer.someWhere.onTheInternet

Are you connecting to a remote SQL server computer or localhost

Even SQL server 2005 needs to know which in which database to execte a query.

passWord not needed with Windows Authentication.

See these links for more help particularly the last one. >>

http://forums.microsoft.com/MSDN/Search/Search.aspx words=connection+string&localechoice=9&SiteID=1&searchscope=forumgroupscope&ForumGroupID=10

http://msdn2.microsoft.com/en-us/library/ms130822.aspx

http://search.microsoft.com/results.aspx mkt=en-US&setlang=en-US&q=connection+string

Regards,

S_DS
bbossi
Issue is still there, any ideas

Thanks
Arash Partow
The issue is that it is not normal to ask for a connection string during creation of a new connection. As I have said in my previous post, it is not mentioned in the Microsoft Press Book Vb 2005 step by step, that when selecting "Microsoft Access Database File" you should be asked for a connection string. The connection string is built afterwards (automatically).

I've installed VB 2005 Express on another machine and this issue didn't happen and I was instructed to select a database without prompting for the connection string.

This proves that there is an issue -

1) It could be related to a registry key

2) A setup issue

Did you ever encounter such problem

Thanks
Hassan Ayoub

Make sure you have the latest and greatest MDAC installed on your machine:
http://msdn2.microsoft.com/en-us/data/aa937730.aspx
Format of the initialization string does not conform to specification startup at index 0

Answer this question