OleDbConnection问题（VB.NET） [英] OleDbConnection problem (VB.NET)

问题描述

您好，

展开 | 选择 | < span class =codeLinkonclick =WordWrap（this）;> Wrap | 行号

解决方案

尝试下面的连接字符串而不是你拥有的那个......我真的不确定你有没有格式正确...


Driver = {MySQL ODBC 3.51 Driver}; Server = [SERVER ADDRESS]; Port = [PORT NUMBER]; Database = [DATABASE NAME]; User = [用户名];密码= [密码];选项= 3;


在连接调用上设置断点，然后在应用程序爆发时使用F8逐行执行。当你跳过连接调用时，将鼠标悬停在连接对象上，如果连接，你应该看到你的连接字符串。如果它没有连接，你会看到它说没什么。

尝试下面的连接字符串而不是你有一个......我真的不确定你的格式是否正确......


Driver = {MySQL ODBC 3.51 Driver}; Server = [SERVER ADDRESS ]; Port = [PORT NUMBER]; Database = [DATABASE NAME]; User = [USERNAME];密码= [密码];选项= 3;


在连接调用上设置断点，然后在应用程序爆发时使用F8逐行执行。当你跳过连接调用时，将鼠标悬停在连接对象上，如果连接，你应该看到你的连接字符串。如果它没有连接，你会看到它说没什么。

嗨巴拉巴斯特，



我已经尝试过你的连接字符串取代我的。我按照你的说法插入了断点，不幸的是，当我把鼠标放在连接对象上时，我得到了无的响应....

展开 | 选择 | Wrap | 行号

嗨巴拉巴斯特，



我已经尝试过你的连接字符串替换我的。我按照你的说法插入了断点，不幸的是，当我把鼠标放在连接对象上时，我得到了无的响应....

展开 | 选择 | Wrap | 行号

Hello,

Im trying to connect to a MySQL DB on my home network (testing purposes) using the following VB.NET code;

Expand|Select|Wrap|Line Numbers

解决方案

Try the connectionstring below instead of the one you have...I''m really not sure you''ve got the format right...

Driver={MySQL ODBC 3.51 Driver};Server=[SERVER ADDRESS];Port=[PORT NUMBER];Database=[DATABASE NAME];User=[USERNAME]; Password=[PASSWORD];Option=3;

Put a breakpoint right on the connect call, then when your application breaks out use F8 to step line by line. When you''ve stepped past the connect call hold your mouse over the connection object and you should see your connectionstring if it connected. If it didn''t connect, you''ll see it says "Nothing".

Try the connectionstring below instead of the one you have...I''m really not sure you''ve got the format right...

Driver={MySQL ODBC 3.51 Driver};Server=[SERVER ADDRESS];Port=[PORT NUMBER];Database=[DATABASE NAME];User=[USERNAME]; Password=[PASSWORD];Option=3;

Put a breakpoint right on the connect call, then when your application breaks out use F8 to step line by line. When you''ve stepped past the connect call hold your mouse over the connection object and you should see your connectionstring if it connected. If it didn''t connect, you''ll see it says "Nothing".

Hi balabaster,

thanks for getting back to me.

Ive tried your Connection string replacing mine. I inserted the breakpoint as you said and unfortunatley i get the "nothing"response when holding my mouse over the connection object....

Expand|Select|Wrap|Line Numbers

Hi balabaster,

thanks for getting back to me.

Ive tried your Connection string replacing mine. I inserted the breakpoint as you said and unfortunatley i get the "nothing"response when holding my mouse over the connection object....

Expand|Select|Wrap|Line Numbers

这篇关于OleDbConnection问题（VB.NET）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！