Reply to thread

Message

ok answered my own question, now im not so tired and not distracted by the FA cup here is the connection string i used which is working great

Dim SQLConnect As New SQLite.SQLiteConnection
Dim sqlcommand As SQLiteCommand
SQLConnect.ConnectionString = "Data Source=""C:\ProgramData\Team MediaPortal\MediaPortal\database\MusicDatabaseV11.db3"";"
SQLConnect.Open()
sqlcommand = SQLConnect.CreateCommand
SQLcommand.CommandText = "CREATE TABLE foo(id INTEGER PRIMARY KEY AUTOINCREMENT, title TEXT, description TEXT, image BLOB);"
sqlcommand.ExecuteNonQuery()
sqlcommand.Dispose()
SQLConnect.Close()

<blockquote data-quote="kyleh0000" data-source="post: 618031" data-attributes="member: 91207">ok answered my own question, now im not so tired and not distracted by the FA cup here is the connection string i used which is working great<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" />&nbsp;Dim SQLConnect As New SQLite.SQLiteConnection&nbsp; &nbsp; &nbsp; &nbsp; Dim sqlcommand As SQLiteCommand&nbsp; &nbsp; &nbsp; &nbsp; SQLConnect.ConnectionString = &quot;Data Source=&quot;&quot;C:\ProgramData\Team MediaPortal\MediaPortal\database\MusicDatabaseV11.db3&quot;&quot;;&quot;&nbsp; &nbsp; &nbsp; &nbsp; SQLConnect.Open()&nbsp; &nbsp; &nbsp; &nbsp; sqlcommand = SQLConnect.CreateCommand&nbsp; &nbsp; &nbsp; &nbsp; SQLcommand.CommandText = &quot;CREATE TABLE foo(id INTEGER PRIMARY KEY AUTOINCREMENT, title TEXT, description TEXT, image BLOB);&quot;&nbsp; &nbsp; &nbsp; &nbsp; sqlcommand.ExecuteNonQuery()&nbsp; &nbsp; &nbsp; &nbsp; sqlcommand.Dispose()&nbsp; &nbsp; &nbsp; &nbsp; SQLConnect.Close()</blockquote>

[QUOTE="kyleh0000, post: 618031, member: 91207"] ok answered my own question, now im not so tired and not distracted by the FA cup here is the connection string i used which is working great:) Dim SQLConnect As New SQLite.SQLiteConnection Dim sqlcommand As SQLiteCommand SQLConnect.ConnectionString = "Data Source=""C:\ProgramData\Team MediaPortal\MediaPortal\database\MusicDatabaseV11.db3"";" SQLConnect.Open() sqlcommand = SQLConnect.CreateCommand SQLcommand.CommandText = "CREATE TABLE foo(id INTEGER PRIMARY KEY AUTOINCREMENT, title TEXT, description TEXT, image BLOB);" sqlcommand.ExecuteNonQuery() sqlcommand.Dispose() SQLConnect.Close() [/QUOTE]