Solved

I can't work out the connection string for this DB

Posted on 2014-10-04
6
124 Views
Last Modified: 2014-11-06
Hi. So I have this horrible SQLite database that I connect to fine using this monstrosity of a connection string...

What should I use instead for a relative pathway to my database that I can use to publish to a server please??

<add name="SQLiteEntities" connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SQLite;provider connection string="data source=C:\Users\Rob\Dropbox\Rob Businesses\Bribie Indoor soccer\Bribie website\WaqarOctober2014\Soccer\Soccer\App_Data\1.080000.sql"" providerName="System.Data.EntityClient" /></connectionStrings>
0
Comment
Question by:Clever_Bob
  • 3
6 Comments
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
What programming language are you using?  I suggest you click on "Request Attention" to get that added to your Topic Areas so you will have a better chance of someone knowing what you need.  Also remove 'MySQL' because that has nothing to do with your question.
0
 
LVL 7

Author Comment

by:Clever_Bob
Comment Utility
Thanks Dave - I'm using Visual Basic but the connection string should be the same across Visual Studio and more. There was no option for SQLite and I wanted to make it obvious that it was a database question, hence the MySQL inclusion.
0
 
LVL 82

Accepted Solution

by:
Dave Baldwin earned 500 total points
Comment Utility
I not sure about the connection string being the same.  Here http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki is info about the ADO.NET interface for SQLite.
0
 
LVL 82

Expert Comment

by:Dave Baldwin
Comment Utility
0
 
LVL 42

Expert Comment

by:EugeneZ
Comment Utility
try

http://www.connectionstrings.com/sqlite/

SQLite.NET

Basic

Data Source=c:\mydb.db;Version=3;


Version 2 is not supported by this class library.
 
SQLite 



In-Memory Database

An SQLite database is normally stored on disk but the database can also be stored in memory. Read more about SQLite in-memory databases here.
 
Data Source=:memory:;Version=3;New=True;

 
SQLite 



Using UTF16

Data Source=c:\mydb.db;Version=3;UseUTF16Encoding=True;

 
SQLite 



With password

Data Source=c:\mydb.db;Version=3;Password=myPassword;

  

Open in new window

0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now