|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
December 14th, 2003, 02:37 PM
|
|||
|
|||
|
MyOLEDB connection problem
Heres some information about my setup:
- .net framework 1.1 sdk installed - Microsoft MDAC 2.7 installed - Microsoft odbc.net provider installed - Mysql Servers and Clients install (this is the acctual server) installed - MySQL Connector/ODBC driver installed - setup odbc DSN for my database called "mysql_praxis" - MyOLEDB provider (myoledb3.exe) installed ok, i have been able to successfully connect to the database using ODBC by copying the ODBC.NET dll into the bin directory and using the microsoft.data.odbc namespace. What i cannot do is connec to the database using OLEDB. I installed the OLEDB provider and copied the Myprov.dll into the bin directory of my application. My code looks as follows: <%@ Page Language="C#" Debug="true" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OleDb" %> <html> <head> <title>Praxis OLEDB test</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <link href="main.css" rel="stylesheet" type="text/css"> <Script language="C#" runat="server"> void Page_Load() { String strConnection, strSQL, strPath; OleDbDataReader objDataReader = null; strConnection = @"Provider=MySqlProv;SERVER=127.0.0.1;DB=praxis;UID= praxisadmin;PWD=1118"; strSQL = "select * from user"; OleDbConnection objConnection = new OleDbConnection(strConnection); // Connect OleDbCommand objCommand = new OleDbCommand(strSQL, objConnection); // Prepare command objConnection.Open(); objDataReader = objCommand.ExecuteReader(); if (objDataReader.Read() == true){ welcomeLabel.Text = "Username = " + objDataReader["username"] + ", Password = " + objDataReader["password"] + ", firstName = " + objDataReader["firstName"] + ", lastName = " + objDataReader["lastName"] + "!"; } objDataReader.Close(); objConnection.Close(); } </Script> </head> <body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> <div align="center"> <asp:Label ID="welcomeLabel" ToolTip="Enter Your Password" runat="server" ForeColor="#0000CC" f/> </div> </body> </html> When i attept to load this page nothing happens, no errors, it just never loads. It says "waiting for localhost" and nothing ever loads. Somebody help! -Thanks in advance Cooler
|
|
| Viewing: ASP Free Forums > Database > SQL Development > MyOLEDB connection problem |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
