I'm missing something here. I've installed odbc.net. I've installed the
latest dotnet SDK. I'm following the walkthrough in the msdn to create an
asp.net c# app. I get to the point where I put the sqlDataAdapter on the
component1.cs, but I'm not sure how to configure it. Selecting the MS OLE DB
Provider for ODBC Drivers, and selecting my MySQL DSN passes the "Test
Connection" test, but if I try to save it I get "The connection you have
created does not work with the current adapter". The same DSN works fine,
it's not the DSN, it's what I'm trying to do in C# that isn't working.
What am I missing? I'm not quite sure how to use odbc.net to connect to the
MySQL DSN.
4  4932 
I'm not sure but beter try with:
-> odbcDataAdapter
NOT sqlDataAdapter
MP
"Ook" <usenet@no****@emberts.com> wrote in message
news:O$**************@TK2MSFTNGP10.phx.gbl... I'm missing something here. I've installed odbc.net. I've installed the
latest dotnet SDK. I'm following the walkthrough in the msdn to create an
asp.net c# app. I get to the point where I put the sqlDataAdapter on the
component1.cs, but I'm not sure how to configure it. Selecting the MS OLE
DB Provider for ODBC Drivers, and selecting my MySQL DSN passes the "Test
Connection" test, but if I try to save it I get "The connection you have
created does not work with the current adapter". The same DSN works fine,
it's not the DSN, it's what I'm trying to do in C# that isn't working.
What am I missing? I'm not quite sure how to use odbc.net to connect to
the MySQL DSN.
There are no odbcDataAdapters - either that, or I don't know where to find
it. My choices seem to be limited to OleDb... or sqlDat.... How do I use an
odbcDataAdapter?
"MP" <m.******@codetel.net.do> wrote in message
news:O4**************@tk2msftngp13.phx.gbl... I'm not sure but beter try with:
-> odbcDataAdapter
NOT sqlDataAdapter
MP
"Ook" <usenet@no****@emberts.com> wrote in message
news:O$**************@TK2MSFTNGP10.phx.gbl... I'm missing something here. I've installed odbc.net. I've installed the
latest dotnet SDK. I'm following the walkthrough in the msdn to create
an asp.net c# app. I get to the point where I put the sqlDataAdapter on the
component1.cs, but I'm not sure how to configure it. Selecting the MS
OLE DB Provider for ODBC Drivers, and selecting my MySQL DSN passes the "Test
Connection" test, but if I try to save it I get "The connection you have
created does not work with the current adapter". The same DSN works
fine, it's not the DSN, it's what I'm trying to do in C# that isn't working.
What am I missing? I'm not quite sure how to use odbc.net to connect to
the MySQL DSN.
>>>>> "Ook" == Ook <usenet@no****@emberts.com> writes:
Ook> I'm missing something here. I've installed odbc.net. I've installed the
Ook> latest dotnet SDK. I'm following the walkthrough in the msdn to create an
Ook> asp.net c# app. I get to the point where I put the sqlDataAdapter on the
^^^^^^^^^^^^^^
This is for
MSSQL Only.
Ook> component1.cs, but I'm not sure how to configure it. Selecting the MS OLE DB
Ook> Provider for ODBC Drivers, and selecting my MySQL DSN passes the "Test
Ook> Connection" test, but if I try to save it I get "The connection you have
Ook> created does not work with the current adapter". The same DSN works fine,
Ook> it's not the DSN, it's what I'm trying to do in C# that isn't working.
Ook> What am I missing? I'm not quite sure how to use odbc.net to connect to the
Ook> MySQL DSN.
Use OleDbConnection and OleDbDataAdapter.
--
Peter Wu
Powered by Microsoft Windows XP [Version 5.1.2600]
Time to take a setp backwards - are there any beginner guides for the dotnet
absolutely clueless? Not only am I not able to make this work, I'm not even
sure what to try.
"Ook" <usenet@no****@emberts.com> wrote in message
news:ud**************@TK2MSFTNGP09.phx.gbl... There are no odbcDataAdapters - either that, or I don't know where to find
it. My choices seem to be limited to OleDb... or sqlDat.... How do I use
an odbcDataAdapter?
"MP" <m.******@codetel.net.do> wrote in message
news:O4**************@tk2msftngp13.phx.gbl... I'm not sure but beter try with:
-> odbcDataAdapter
NOT sqlDataAdapter
MP
"Ook" <usenet@no****@emberts.com> wrote in message
news:O$**************@TK2MSFTNGP10.phx.gbl... I'm missing something here. I've installed odbc.net. I've installed
the latest dotnet SDK. I'm following the walkthrough in the msdn to create an asp.net c# app. I get to the point where I put the sqlDataAdapter on
the component1.cs, but I'm not sure how to configure it. Selecting the MS OLE DB Provider for ODBC Drivers, and selecting my MySQL DSN passes the "Test
Connection" test, but if I try to save it I get "The connection you
have created does not work with the current adapter". The same DSN works fine, it's not the DSN, it's what I'm trying to do in C# that isn't working.
What am I missing? I'm not quite sure how to use odbc.net to connect
to the MySQL DSN.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Marek Kotowski |
last post by:
Hi,
I am new to MySQL and PHP programming.
What is the practical difference between MySQL
ODBC functions (3.51 Driver) and native mysql
support in PHP (I mean "mysql_" functions available in...
|
by: callmebill |
last post by:
I'm getting my feet wet with making Python talk to MySQL via ODBC. I
started on Windows, and it went smoothly enough due to the ODBC stuff
that apparently is native to Python at least on windows...
|
by: DJJ |
last post by:
I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL
tables to a Microsoft Access 2003 database. I am finding that the data from
the MySQL tables takes a hell of a long time...
|
by: uli2003wien |
last post by:
Dear group,
we are dealing with some very specific problems with ODBC, where a
connection from SQL-Server to Mysql works with ODBC-driver 3.51.10.00
and does NOT work with ODBC-driver...
|
by: Eric E |
last post by:
Two questions regarding ODBC.
1) I am connecting to a MySQL database using the following code:
Function LoginToMySQL(sUsername As String, sPW As String) As Boolean
Dim dbMySQL As Database
Dim...
|
by: Beda Christoph Hammerschmidt |
last post by:
MySQL, Access, ODBC, Replication
Hello,
i have a central mysql database that is accesed by multiple clients
running MS Access with ODBC.
This works fine if Access has a permanent connection...
|
by: Bob Sanderson |
last post by:
I am trying to set up an ODBC DSN to our company MySQL database so that I
can use a MS Access front end. I am using the MySQL ODBC 3.51 driver. The
database is running off of Apache on our Windows...
|
by: Jacques Lebastard |
last post by:
I have a problem writing PHP ODBC scripts that suit both MySQL and
PostgreSQL. So far, the following syntaxes seem to apply to each
database (this is an 'insert' example; the same differences apply...
|
by: 111mike |
last post by:
Hello,
Here's my problem. I cannot connect to mysql database using odbc string
connections or dns. I keep getting a "cannot connect to mysql server localhost." I'm running windows XP Pro and...
|
by: BillCo |
last post by:
I need to Connect to an online mySQL database from Access using JET
ODBC with no saved DSN.
Anyone out there who as made this work and can give example of how
it's done? I've seen lots of posts...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |
