unable to connect to database
yesterday i installed vertica extension and connected successfully to vertica db using vertica connector node. today while doing the same i am getting an error saying “invalid settings. please select a driver name”.

why is the configuration asking for driver when the connection was successful yesterday. also is there a way to save my db connections permanently.
hello [@yash](/u/yash),

maybe i got it. when you said you yesterday installed vertica extension you probably installed knime vertica driver extension.

[verticadriver]

also do you maybe have multiple knime instances on your machine? that would explain why you can’t find workflow from yesterday and why is driver option grayed out (cause extension is not installed).

br,

ivan
hi there floriann software,

first of all, i would say that it is always a better idea to open up a new thread, instead of engaging in an old one.

apart from that, as the drive is recognized on other systems except for the xp one, then it comes to drivers. make sure you go to the mobo's website and update the drivers.
is the drive initialized as mbr. in case it is initialized as gpt, i would advise you to back up all the data and initialize it as mbr. win xp has some limitations on that: https://support.microsoft.com/en-us/kb/2581408

cheers,
d\_know\_wd :) For anyone having similar problems, I have solved my issue. It was several-fold.


* As Darren suggested and Paul backed up, the Max..Size properties in the configuration needed to be enlarged. The SvcTraceViewer utility helped in determining this, but it still does not always give the most helpful error messages.
* It also appears that when the Service Reference is updated on the client side, the configuration will sometimes not update properly (e.g. Changing config values on the server will not always properly update on the client. I had to go in and change the Max..Size properties multiple times on both the client and server sides in the course of my debugging)
* For a DataTable to be serializable, it needs to be given a name. The default constructor does not give the table a name, so:



```
return new DataTable();

```

will not be serializable, while:



```
return new DataTable("someName");

```

will name the table whatever is passed as the parameter. 


Note that a table can be given a name at any time by assigning a string to the `TableName` property of the DataTable.



```
var table = new DataTable();
table.TableName = "someName";

```


Hopefully that will help someone. if drivers are uptodate it will not show onto the list. else start the utility with 'run as administrator' option and see if it's working. OK, Problem fixed. If anyone else comes across this problem: I was able to install the new driver by using Intel's EXE version rather than the zip version and disconnecting from the inet. Everything went fine. need to add 



```
services.AddEntityFrameworkSqlite().AddDbContext<ApplicationDbContext>();

```

and delete



```
services.AddIdentity<IdentityUser, IdentityRole>()
                    .AddEntityFrameworkStores<ProductContext>();

```

in startup.
the error was about bad startup configuration.
Was sending too much things.


ApplicationDbContext:



```
 public class ApplicationDbContext : IdentityDbContext
    {
        public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options)
            : base(options)
        {
        }
        public Microsoft.EntityFrameworkCore.DbSet<Product> Products { get; set; }
        public Microsoft.EntityFrameworkCore.DbSet<List> Lists { get; set; }

        public Microsoft.EntityFrameworkCore.DbSet<ProductList> ProductLists { get; set; }


        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            base.OnConfiguring(optionsBuilder);

             optionsBuilder.UseSqlite("Data Source=assistant.db");

        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {

            base.OnModelCreating(modelBuilder);
            modelBuilder.Entity<ProductList>()
                .HasKey(pl => new { pl.ProductId, pl.ListId });

            modelBuilder.Entity<ProductList>()
                .HasOne(pl => pl.Product)
                .WithMany(p => p.ProductList)
                .HasForeignKey(pl => pl.ProductId)
                .OnDelete(DeleteBehavior.Cascade);

            modelBuilder.Entity<ProductList>()
                .HasOne(pl => pl.List)
                .WithMany(l => l.ProductList)
                .HasForeignKey(pl => pl.ListId)
                .OnDelete(DeleteBehavior.Cascade);
        }
    }

``` seek and tell are still required.

see here: <https://docs.lvgl.io/latest/en/html/overview/file-system.html#use-drivers-for-images> Hi  

This is simple. First check whether you are able to connect Sql Server through SSMS or not.If you are able to connect through SSMS, then there may be a problem in connection string. If you are not able to connect through SSMS, then you had some problem with SQL Environment. please refer to the adaptation guide in the developer guide. there is tutorial for how to modify dtb for usb. A trigger is not what you want.


What you need is a scheduled job.


Take a look at the official documentation on the subject:


[Scheduling Jobs with Oracle Scheduler](http://docs.oracle.com/cd/B28359_01/server.111/b28310/scheduse.htm#i1033533)


Feel free to ask more questions if you find any trouble when creating your scheduled job. the problem has been solved.

i got in contact with our provider and they were able to apply the proper access to the folder for verification.

thank you for all of your help and patience. this thread can now be closed.