DataSource Controls :: Connecting To Remote Database Using DSN And ODBC?
Mar 25, 2010
In my windows application, i am listing the System DSN's configured on the remote machine in a combobox. Once i select the DSN and click on Connect button, i should be able to connect to the remote database. I am trying to open the connection to the database using ODBC but am getting the below error.
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
I have a SQL server in my office. I can connect from my home development workstation website to the remote SQL server with no problems but when I upload the site to the web host and try and use the same SQL server it fails with 'A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible'
I have a project that must illustrate that connection to the database is not locally, so I have install VirtualBox and I intend to install SQL Server on it. So any one have the idea of how can I connect from the Host Machine to the SQL Server located on the Virtual Machine
I am working on an asp webform that pulls from an ODBC datasource then puts the data in an sql server. Once the data is in the sql server several queries pull data from it to provide information for a report.
This is an example of what I am talking about
private void ODBCpdEmployeeAb() { DataTable dt = new DataTable();
[Code]....
The first part gets the data from the ODBC connection and the next part stores it in an sql server table. The problem is I have these methods in the page load event of the webform so everytime it loads it just puts the exact same data in the sql server table which would then provide incorrect information on the report.
Is there a way to append the most recent data from the ODBC table to the sql server ?
I'm using an ODBC connection to connect a SQL 2005 database to my ASP.NET app in Visual Web Developer Express. I'm finding that the expected functionality that tutorials review does not work for ODBC connected databases the same way as it does for SQL databases created in the Web Developer. For example, I can't use stored procedures because the option to create one is disabled in the Web Developer, and if I create the stored procedure in SQL Server Management Studio Express, it doesn't show up in Web Developer because Web Developer only finds the system stored procedures, not the user-defined ones. I've seen other cases as well where database management options in Web Developer don't work with ODBC databases.
Am I missing something in my setup, or is there an inherent limitation with ODBC connected databases? Or, is this a limitation with using the Express versions of these development tools?
Could not establish a connection to the database. If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider. I have set up a db locally which mimics the production DB, THe production db and website has no has no issues.
THis used to work till i had hard disk failure and had to reinstall all software and do the db from scratch. Used the table scripts and ran the aspnet_regsql. I am using sql server express 2008 asp.net 3.5 I am using custom provider for Roles and custom membership provider for Memberships. Pretty sure the problem is in the db permissions, though I have set up Users in the Security of the DB.
connecting my database to the online server. My server is seekdotnet. But I had been receiving this error code Cannot open database "database.bak" requested by the login. The login failed. Login failed for user '219_nypmecom'.
I am using Visual Studio 2008 and asp.net technology with C# language. Whenever I try to choose any datasource for databound control like "gridView" of "ObjectDataSource". The connection can be tested as OK but when I click on OK the it gives following error and database could not be added: "Object Reference not set set to an instance of an object." it was working perfectly fine in Visual Studio 2005, so kindly help if there is some settings that are to be adjusted for 2008 version.
I was working on a asp.net project earlier but due to some OS problem I had to re-install the OS..so before re-installing the OS I detached my sql database and then attached it back after installation..but I am having a login problem now..the previous servername was XYZ-DB840C74SQLEXPRESS..so this user i.e. XYZ-DB840C74ASPNET is added to the database's permissions..now my new server name is XYZ-8D50FD73SQLEXPRESS..but I am unable to add this user through the permissions wizard..I am getting the following error: Cannot open database "finance" requested by the login. The login failed. Login failed for user 'XYZ-8D50FD73ASPNET'.
I have no trouble connecting to a SQL server with code in my web config file for user registeration. But I am having trouble telling it to go to a particular table.
I have two PCs with Windows Server 2003 standard adition installed on them, each are in a saperte room, and having SQL Server 2005 Express. Now I want to let Myserver to connect to server1 with a readonly access to a database on it. I figured to create a user acount on server1, and make it as a login account in SQL Server and grant the appropreate privilage. Now I'm wandering are there any security risks regarding this approch.
While working with LINQ to ENTITIES I see that there is only a way to use stored procedure that is returning one entity only, or a view that is a join of two entities.
But what if I need in ASPX page to get two tables that there is NO connection between them, no join can be done between them at all.
I have one Stored Procedure that return the two tables, but entities don't support this right now.
I can split them to two Stored Procedure and call each of them separately.
I have a website I'm trying to catch up to speed on. It is throwing a null exception when the code tries to assign a variable pulled from a SqlDataSource query. The query is below:
[code]....
I want to know if there is a way to test the connection to the remote IP Address perhaps through some debugging tools and as a general question how would the web app authenticate against the remote database? I just see the connection string but no user name etc.
I am trying to make connection to a remote database server and I am getting the following message. I think i have to grant access to the client maching from my database server.. How do i grant access to an ip addess?
ERROR [HY000] [MySQL][ODBC 5.1 Driver]Access denied for user 'thelp'@'123.29.14.30' (using password: YES) ERROR [HY000] [MySQL][ODBC 5.1 Driver]Access denied for user 'thelp'@'123.29.14.30'(using password: YES)
the following will clearly show the steps i have taken to achieve a connectivity to database "123" such that the remote user who is using sql login verification can do whatever he wants with the "123" database, and thee remote user cannot change anything of any other database.
?the permission u see granted in the pictures is just guest work, IT WORKS! but i would like to know the required correct permission to grant and not more permissions (to the point permission- DO ANYTHING WITH DATABASE "123" AND THATS IT- DONT EVEN SEE THE OTHER DATABASES)
?how shall i stop this remote user or deny this remote user from even viewing the other databases. a you can see the remote user cannot change anything in other databases but he can see them! I DOT WANT Him to VIEW THEM.
please give your comments and guidence "to achieve the above goals LIKE A PROFESSIONAL WOULD"
and a site link explaining these many permissions in sql server 2005 management studio express would be helpful.
How do I connect to a remote site in IIS 7.5 using vwd 2010? vwd 2010 appears to be looking for deprecated software instead of the IIS 7.5 supported protocol using webdav. My application uses a cookie authentication from a central corporate authority and nothing but a legitimate URL is going to work during debugging. There is almost no information in a google search and the only forums.asp.net post from last year says it isn't possible. If MS is no longer supporting FPSE in the new versions of IIS, then what is vwd 2010 doing looking for it--is there a patch or module of some kind that is available to enable webdav access?
I have an asp.net website that needs to connect to a dBase file on a remote server. The remote server has a ODBC System DSN connection configured but I have no idea how to connect to it.
i am using my sql database. what type of data connection improve the performance.oledb connection or odbc connection ? what is the theory of these architectures?
This is the code i am used for fetching data from DB2 server (windows based server)In the same server tables created by me is working fine...eg:
oCommand.CommandText = "SELECT * from DEB.TESTUSER";
below is a table created by another application but the data reader is not working with this query ( table in the same server with same DB as above)
oCommand.CommandText = "SELECT * FROM DEB.RULE_GROUP";
If any permission or any other things i want to check .....i mean security related.....odbcadapter is also working fine....pls help regarding the datareader.....below is the complete code......
I am new to the asp.net, I am going to create a website which needs to talk to oracle database(i only need get the data only) which is in client place.
I want to know what do i need to do this (what are the requirements)
What i have is Client IP, DB name, Username and Password.
I have created web pages using VS Web Developer that use a local Developer Edition of SQL server database on my PC with LINQ to SQL. When I deploy my website to a remote web host SQL server, I need for my web pages to be able to use the remote database instead of the local database. So, how do I get the Server Explorer to connect with a remote SQL Server database?
Iam using the DBconnection object through out my applicationI use the same as a singleton objectWhen more operations are performed on the single objectit throws an error ERROR [HY001] [Microsoft][ODBC Microsoft Access Driver] Cannot open any more tables.But it occurs only some timesHow to solve this?Can any property can be set to avoid this type of error.Or can i overload and write any method to avoid thisTo Identify the same i wrote some Poc and tried alsoLike opening the connection object and looping through 1000 times and creating a command object for the connection and running a query.Some times iam getting the exception and some times its running