Link to home
Start Free TrialLog in
Avatar of Ivan Matthys
Ivan Matthys

asked on

Invalid connection string attribute

I'm trying to connect to my database, but get the following error

Run-time '-2147467259(80004005)':
Invalid connection string

Here's the string

.ConnectionString = "Provider=SQLOLEDB.1;" & _
                        "User ID=trisnadi; Password=trisnadi;" & _
                        "InitialCatalog=Insurance"
    .Open

What am I doing wrong ?
SOLUTION
Avatar of Bill Prew
Bill Prew

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bill Prew
Bill Prew

Forest, trees... :-)


»bp
For connection string problem there is only 1 destination ConnectionStrings.com -:)

https://www.connectionstrings.com/
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
For connection string problem there is only 1 destination ConnectionStrings.com -:)

Already shared that Pawan...


»bp
Hey Bill , ohh yes..  -:) sorry i missed.
Recommendation to close this question by accepting the following comments as solution.