I have a view that flattens out a hierachy of 4 tables to display as a report. within the view it contains the primary keys (Guid) of each of the tables along with some display data. The problem is that the the guids are being returned as varbinary(16) instead of binary(16) and as a result nhibernate throws an error. This would appear...
I have a connection string (to an SQLServer 2005 database) which specifies a server, username and password, but does not specify an InitialCatalog. When I try and open connection it works, and I can list the tables, which lists a lot of tables, but not the table from the database I am interested in. What is it I am connected to when ...
I want to keep encrypted connection string and stmp information in the web.config. can I store Connection String and SMTP information in web.config encrypted and where I need just decrypted and use? OR What is the point/event where i can encrypt the Connection String and SMTP and save in the web.config? (and if the changes happen in w...
I have a .NET solution containing two projects: An ASP.NET MVC project, 'Website' A class library, 'Models' The 'Models' project contains a Linq-to-SQL data-context along with a few partial classes that extend the database objects. The connection string is defined in the web.config of the 'Website' project. However the 'Models' pro...
how can one create a password on a visual basic access database when you have a vb datagrid ...
I guess everything is possible but I am wondering how easy is it for someone to hijack a connection string with a network packet analyzer or equivalent tool. A winforms application fetches data directly from an MSSQL server. (Supposing there are no webservices in the middle for extra protection) 1) Is it possible for someone with an a...
I have a three tier set-up. Someone suggested I should get the ConnectionString from the Web.Config file and I've got it set up like this: Now I'm trying to access the ConnectionString from my DAL tier, but I can't find the ConfigurationManager. How can I invoke my Connection string from here?: ...
This should be painfully simple, but I cannot come up with a working connection string for a local copy of SQL Server 2008 using Windows Authentication. I've tried using the Data Link Properties tool to create a connection string and it has no problems connecting, but when I copy paste the generated string into my ADODB.Connection object...
Hi, i am a newbie programmer, and i have a problem with sqldatasource. In my project, i have a database called "KFS". I have a gridview and sqldatasource as gridview's datasource. I have a connection string like that: "KFSConnectionString" connectionString="Data Source=.\sqlexpress;Initial Catalog=KFS;Integrated Security=True" provi...
This wiki post outlines both a problem and a solution. I wanted to post this for others that may be having similar problems, as I couldn't find anything specifically to solve this problem elsewhere. We recently upgraded our SQL Server 2000 database to SQL Server 2005. One of the databases on the server is a back-end to a MS Access datab...
I have the following connection string: "Data Source=localhost\\SQLEXPRESS;", it complains that '' is an invalid username. I can't quite remember the user name or password commands, nor can i remember if there's anything else i'm missing. Can someone help? ...
Hello, I get this error message when i try to using sql express: An attempt to attach an auto-named database for file C:\Users\Name\Documents\Visual Studio 2008\Projects\MyProject\MyWeb\App_Data\MyDatabase.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share....
Hello, I have a number of SSIS packages that are launched by Windows Services. These packages point to any number of different databases, and the connection information is known only by the service at run-time. I know that I can't save connection strings inside the package, but it seems that I can't even pass in a complete "connection...
Hi everybody, i will develop utility program for a company with more than 1000 client and the program must be win application with .Net because my program will act with another program. What is your suggest for place of app.config? one scenario: We put the app.config on the server that configured once and write a windows service for it t...
I am not sure whether it has been disscussed before or not but I have the following code (I changed from example for an Access database.) I don't know what to put inside the 'Provider' and the 'Data Source'. I'm using MS SQL Server 2005 and how to find this information in my machine? Please, even I try to follow from here http://www.c...
Hi, I've done a fair bit of mysql php programming but am pretty new to asp/access etc. This will either be incredibly easy or impossible! SUMMARY: I'm trying to transfer a web application from a corporate network to an external web host for testing and don't know how to connect the pages to the database on the new server. BACKGROUND...
I have two ASP.NET websites on a web-server, and two SQL Server databases. I have a folder for Website #1, which contains a web.config with a connection string pointing to Database #1. Under the folder for Website #1 there's a staging folder called 'staging', containing Website #2, and the web.config there has a connection string that ...
In my project I used C# with MS Access but data can't be stored permanently. I placed the database file in the project work space, but this did not solve my problem. Please provide connection string for that. ...
I have an asp.net-mvc application with the default membership database. I am accessing it by ADO.NET Entity Framework. Now I want to move it to IIS, but several problems showed up. I had to install SQL Server Management Studio, Create new DB, import there all the data from the previous .MDF file. Only thing left to do (as far a I know)...
I'm using SQLalchemy for a Python project, and I want to have a tidy connection string to access my database. So for example: engine = create_engine('postgres://user:pass@host/database') The problem is my password contains a sequence of special characters that get interpreted as delimiters when I try to connect. I realize I could ju...