Data Library and Connections

HI

 

I have tried to download from a number of posts samples of how to change a data library connection string at 'runtime' but have had problems in getting them to compile in Vb .net 2008...

Can someone please give me a example of how to do this

Regards

Graham

 

Hi Graham,

Attached is a small sample that updates the connection string at runtime.
See the DataClass.SchemaDef1_CreateSchema() method.

Regards,

-Andrey

Thanks Andrey...

An unrelated 'problem' as a newbie to vb.net... how do I access a 'variable' set by the the loading project so I can change the connection string?

I have 2 projects, DataLibrary and Project1... the user selects if they want 'live' or 'test' database in project1 and we create a db connection  accordingly for use with non-data library related access ... how can I pass this 'connection string' to the Data library project after selection?

Regards

Graham

 

Hi Graham,

You may find a new version of the sample in the attachment.

Regards,

-Andrey

Hi Andrey

Many THANKS!!!

Regards

Graham