Mysql On Different Servers
Jul 20, 2005Is it possible to connect to different databases on different servers
so i can merge them as one.
I heard there is a tool that does this but still to come accross it
any help appreciated.
ADVERTISEMENT
Determining A MySQL Servers Status.
Jul 20, 2005I am using vb.net and the myoledb provider.I've run into a problem where what I need to do is open a databaseconnection to a mysql server, easy. The problem arrises in that I wantto, if the server cannot be found, open from a locally storedencrypted XML file.Works fine when the sever is present, but when I go to open theconnection and the database cannot be found, a dialog box pops up as tofill in the connection string information. I do not want this, is thereany way I can intercept this dialog or skip past it so my try/catchhandles it?Thanks.--Posted via http://dbforums.com
View 2 Replies View RelatedMS SQL Linked Servers(Linking MySQL To MS SQL) Collation Problem.
Jun 21, 2007Hello,I have a problem. I've linked MySql server to MsSql, in MySql I have atable with Latvian data(character set is ucs2, ucs2_general_ci) andthe problem is that when I use openquery to read data from MySQLserver, some characters are not translated correctly! I receivequestion symbols instead of Latvian special characters.Maybe someone had this kind of problem with collation?
View 2 Replies View RelatedCatastrophic Failure, MSDASQL, Linked Servers And MySQL
Jun 21, 2007When executing a query which joins against a large resultset from a linked server, SQL Server reports the following error:
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "foo" reported an error. The provider reported an unexpected catastrophic failure.
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "foo".
This is using SQL Server 2005 with SP2, and MyODBC version 3.51.16 (although previous versions also seem to have the same behavior).
Once the error occurs any subsequent query against the linked server (even something as simple as select top 3 * From foo...users) fails with the same error message. Queries using the OpenQuery syntax also fail with this error.
I've tried to determine if there are some error logs that might give me more insight into what's going on, but the above events don't seem to log to the ODBC trace logs. And I can't seem to figure out a way to trace the MSDASQL (i.e., oledb) events.
I initially thought there might be a problem with the MySQL myODBC driver, but the ODBC layer itself does not seem to have a problem. But the following steps indicate otherwise:
1. Create a new Linked Server to MySQL. Same error as above
2. Execute a query against the ODBC DSN directly, using a shell program. This works fine
I'm trying to clearly identify if the problem is with the MySQL driver or with the MSDASQL provider. It would appear that the latter is at fault, given the error message, and the lack of any ODBC logging.
Would anyone have any insights about what might be going on here, and if there is any possible resolution?
Linked Server To MYSQL Using OLEDB Provider For MYSQL Cherry
Feb 12, 2007Good Morning
Has anyone successfully used cherry's oledb provider for MYSQL to create a linked server from MS SQLserver 2005 to a Linux red hat platform running MYSQL.
I can not get it to work.
I've created a UDL which tests fine. it looks like this
[oledb]
; Everything after this line is an OLE DB initstring
Provider=OleMySql.MySqlSource.1;Persist Security Info=False;User ID=testuser;
Data Source=databridge;Location="";Mode=Read;Trace="""""""""""""""""""""""""""""";
Initial Catalog=riverford_rhdx_20060822
Can any on help me convert this to corrrect syntax for sql stored procedure
sp_addlinkedserver
I've tried this below but it does not work I just get an error saying it can not create an instance of OleMySql.MySqlSource.
I used SQL server management studio to create the linked server then just scripted this out below.
I seem to be missing the user ID, but don't know where to put it in.
EXEC master.dbo.sp_addlinkedserver @server = N'DATABRIDGE_OLEDB', @srvproduct=N'mysql', @provider=N'OleMySql.MySqlSource', @datasrc=N'databridge', @catalog=N'riverford_rhdx_20060822'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'collation compatible', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'data access', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'dist', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'pub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'rpc', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'rpc out', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'sub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'connect timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'collation name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'lazy schema validation', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'query timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'use remote collation', @optvalue=N'false'
Many Thanks
David Hills
Equivalent To MySQL's Password() Function? (was MySQL To SQL Server And Password())
Mar 3, 2005I have an internal Project Management and Scheduling app that I wrote internally for my company. It was written to use MySQL running on a Debian server, but I am going to move it to SQL Server 2000 and integrate it with our Accounting software. The part I am having trouble with is the user login portion. I previously used this:
PHP Code:
$sql = "SELECT * FROM users WHERE username = "$username" AND user_password = password("$password")";
Apparently the password() function is not available when accessing SQL Server via ODBC. Is there an equivalent function I could use isntead so the passwords arent plaintext in the database? I only have 15 people using the system so a blank pwd reset wouldn't be too much trouble.
Sql Report Works Fine On Internal Servers - Hosed On External Servers - Need Some Help
Nov 21, 2007I have a report that was designed using SQL Reporting Services that sits on a SQL reporting server. It's nothing too exciting, it is essentially a three page application with legal jumbo on pages 2 and 3 and applicant data in fields on page 1.
We use rectangles to force page breaks to page 2 and to page 3.
When running the report on the report server, it shows and prints fine.
When running the report from the QA website internally, it shows and prints just fine.
When running the report from the production website from a machine internally, it shows and prints just fine.
When running the report from outside of the company network, the report is jacked. It obliterates large chunks of text, crams text together, and creates blank pages.
I need help in determining where I even begin with trouble shooting this!
Development Servers, Auto-update Live Servers
Aug 21, 2001can anyone tell me if they know of a way to automate the update process from development servers to live server, with little interference from an administrator
I have a development team that are constantly updating their databases along with their ASP code, and want to publish changes an a weekly basis. They have asked me for a way to take their new structures, tables, procedures etc, and copy them to the live servers, but NOT to interfere with existing customer data.
Funny I know – and I hate the idea btw :(
Any references, contacts, 3rd party tool recommendations welcome,
Thanx,
Darren
Linking SQL 2005 Servers To SQL 2000 Servers Problems
Sep 27, 2007I am in the middle of a major migraton project, moving from x86 SQL 2000 to IA64 SQL 2005. I have a business need to link to several legacy servers. I have a number of problems I am trying to solve.
1) Linking a Kerberos server to a non-Kerberos server.
2) Linking x64 or IA64 servers to x86 servers.
3) Linking SQL 2005 to SQL 2000.
Two of the errors I am encountering are:
------------------------------
TCP Provider: An existing connection was forcibly closed by the remote host.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
OLE DB provider "SQLNCLI" for linked server "SCDC250DB" returned message "Communication link failure".
(Microsoft SQL Server, Error: 10054)
------------------------------
And
------------------------------
The OLE DB provider "SQLNCLI" for the linked server "SCDC250DB" reported an error. Authentication failed.
Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "SCDC250DB".
OLE DB provider "SQLCLI" for linked server "SCDC250DB" returned message "Invalid authorization specification".
(Microsoft SQL Server, Error: 7399)
If someone has worked through these problems before, I would appreciate it if you could direct me to the relevant documentation to resolve these issues.
Thanks!
Brandon Forest
Database Administrator
Data & Web Services Team
Sutter Connect Information Technologyforesb@sutterhealth.org
Sql And Mysql
May 14, 2007Hello,I'd noticed when looking at the prices of hosting ASP websites that it was much cheaper if you useda mysql database instead of mssql so this is the way that I coded everything. I've been using the logincontrol too though so does this mean... 1) that I *need* a mssql database?2) that this database will take up my 1 allocated mssql database with the webhost?3) can I use mysql in the same website; it seems to be working ok with the developer server... Many thanks folks,Adam
View 5 Replies View RelatedMySQL DB
Nov 29, 2001Has anyone ever connected to a MySQL DB? If so, did you encounter difficulties? Did you do it through DTS? Can you give me some specifics?
DenverDBA
MySQL
Apr 27, 2004puuuuuuuuuuuuuuuleeeeeeeeeeze
Sorry....
MySQL -&> SQL
Feb 19, 2007Can anybody see what is wrong with this?
create table transaction
(txn_id int not null IDENTITY(1,1),
txn_date datetime not null,
account_id int not null,
/*txn_type_cd enum('DBT','CDT')*/check(txn_type_cd('DBT','CDT')),
amount double(10,2) not null,
teller_emp_id smallint ,
execution_branch_id smallint ,
funds_avail_date datetime,
constraint fk_t_account_id foreign key (account_id)
references account (account_id),
constraint fk_teller_emp_id foreign key (teller_emp_id)
references employee (emp_id),
constraint fk_exec_branch_id foreign key (execution_branch_id)
references branch (branch_id),
constraint pk_transaction primary key (txn_id)
I'm getting an error when I try and run in, but I can't see what it is!
Incorrect syntax near the keyword 'transaction'.
The code has been generated as mysql, and I am attempting to change it to SQL.
Thank you!
Vs MySQL
Jan 9, 2006HiHow is SQL Server 2000 better than MySQL? I need to convince my boss as weare contemplating doing a website with either SQL Server 2000 or MySQL asbackend.ThanksRegards
View 4 Replies View RelatedMysql And ASP
Jul 20, 2005Hi all, i've just set up an mysql server on my computer and now i want toconnect to a mysql database with an ASP page but i can't find the correctconnection string. I always get an error that the datasource can not befound.ConnString ="Driver={MySQL};SERVER=mysqlhost;DATABASE=myDB;UID= userID;PASSWORD=pasword"What's wrong with it?
View 1 Replies View RelatedMysql And C++
Jul 20, 2005hellosomeone could tell me how could I insert SQL statement in a C++ code ?If you know online documents easy to read about this subject, it will bevery welcome(in english or in french)..Thanks
View 1 Replies View RelatedUso Del Top En El Mysql
Jul 20, 2005hola! alguno sabe como uso el top en el mysql??? debo hacer lasiguiente consulta y no le gusta al mysqlSELECT TOP 10 * From ControlDeCaja WHERE CodUsuario = "xxx"alguien sabe? Gracias de todas maneras!!
View 1 Replies View RelatedMySQL
Jan 31, 2006Is SQL Server Express the same as MySQL?
MySQL To Sql Server 05
Oct 5, 2006im trying to convert this table for a friend 1 CREATE TABLE adminmessage (
2 adminmessageid INT UNSIGNED NOT NULL AUTO_INCREMENT,
3 varname varchar(250) NOT NULL DEFAULT '',
4 dismissable SMALLINT UNSIGNED NOT NULL DEFAULT '0',
5 script varchar(50) NOT NULL DEFAULT '',
6 action varchar(20) NOT NULL DEFAULT '',
7 execurl mediumtext NOT NULL,
8 method enum('get','post') NOT NULL DEFAULT 'post',
9 dateline INT UNSIGNED NOT NULL DEFAULT '0',
10 status enum('undone','done','dismissed') NOT NULL default 'undone',
11 statususerid INT UNSIGNED NOT NULL DEFAULT '0',
12 PRIMARY KEY (adminmessageid),
13 KEY script_action (script, action),
14 KEY varname (varname)
15 )
and was wondering how to do it when mssql doesn't have enums :(
MySQL -&> MsSQL
Jan 16, 2007Hello all,
I spent the last two days trying to find an application that can export a mySQL database into msSQL syntax so that I can then use that to just create my msSQL database. I have had no such luck, though I could find a bunch to do msSQL to mySQL.
Please let me know if anyone has one or knows of one that works because I really do not want to hand port my 70 table database from mySQL to msSQL
Thanks in advance,
Anthony F Greco
Mysql To Mssql
Mar 25, 2007i have dumped a mysql database to my my documents folder on my server, how can i convert this to a mssql database.
the database came from a site that was in php and of course using mysql, the database has all the users logon information and other information in there personal profile.
i would like to convert this to a mssql database and connect it to the new site i am doing in .net/C#
MySQL Vs MSSQL
Oct 21, 2007Hi, I've been coding in C#/ASP.NET for a little while now, but I've only ever used MS SQL.I'm starting a new project at work soon, and our host provides free MySQL databases but charges for MS SQL databases.
What are the pros/cons for each of these databases, and how much conversion would be required in an existing C#/ASP.NET application if I wanted to change from MS SQL to MySQL? I assume the syntax/commands to operate a C# app with MS SQL are different to the ones required to communicate with a MySQL database?
I'll probably stick with MS SQL because it's what I know, but I'd like to get familiar with MySQL as it might come in handy one day.Thanks, any information is greatly appreciated.
Converting From MySQL To SQL
Mar 26, 2004hi..
may i know how to convert from mysql to microsoft sql server ??
is it very troublesome ??
coz its quite a big project..
i need to convert frm mysql to sql..
is there any example or reference?
thanks
SQL Server To MySQL
Jul 5, 2004I just started developing my site locally using SQL Server and am planning to move it to our work's MySQL server. Is there anything that I should be aware of before I continue any furthur? Will I lose any data or is it even an option to move from SQL Server to My SQL???
View 1 Replies View RelatedPerformance Vs Mysql
Mar 7, 2000Does anyone know of a page that compares the performance of SQL Server 7 to mysql?
View 2 Replies View RelatedMysql To SQL Server 7.00
Nov 16, 2000Hi Guys,
I am working for a client who needs to move database from MySQL application to MS SQL SERVER 7.0.
Is there anybody who has done it before?
I need some help about how to load data from one system to another system.
THanks in advance.
Text Til MySQL
Mar 31, 2003Hi
I am a newbee to both php and MySQL.
I was wondering if I could get some assiatance on a matter:
I have a userdatabase in flatfile format. The user info is divided into many files:
First the main file where all the usernames are listed in one column. Then one separeate file for each user, named [username].dat containing their userinfo with encrypted password.
Is there a way I can import all these files (almost 300 of them) into a single MySQL table? If so, could someone please explain this to me in easy terms? Thanks.
Charlotte
Convert MS Sql To MySql.....???
Mar 23, 2004Hello there...
Well i want to ask that.... is it posible to Convert MS Sql server Tables/Views + Database to MySql server.....? or is there any software which can automatically convert MS Sql Server database into MySql database.
I'll be REALLY GLAD if someone can please help me asap...
take care...
Regards
Nabeel Qaisar
Different Between MYSQL And MSSQL
Jun 14, 2005i'm a newbie here. :D
as the topic stated, what is the diferent between the 2 database in term of, reliability, speed, price for licensing and etc. :confused:
any reply will be appreciated
thanks :)
Link To MySQL
Jan 24, 2006Can anyone tell me how to link to a MySQL database please?
i want to DTS some data from one and i cant see how to link....
TIA
FatherJack
Apache, PHP, MySQL, And MS SQL
Mar 10, 2006I have been running Apache 2.2 and PHP 5.0 with MySQL 5.0 on my XP system. I installed MS SQL today, an I'm unable to connect to the MS SQL server through PHP. When I installed MS SQL I:
added extension=php_mssql.dll to php.ini, and I copied ntwdblib.dll into the windows/system32 directory. I still can't access the server.
The server is running, when I start Windows. I can open the SQL Server Service Manager, and it shows Server: XP-LINUX, Services: SQL Server. I can also open the Web Data Administrator tool at: http://localhost:8080/webadmin/default.aspx, and work with databases. I can open it on port 80, because Apache is using that port.
Anyone know what's up whit PHP?
Thanks in adavance...
Darin
Is MySQL Right For This Task?
Feb 4, 2005My friend has a business website http://www.autonetworkinc.com he is concerned about his hosting. He's wonder if it would be a smart move to have his databases converted from FoxPro to something else. I'm wondering if it would be best to have that foxpro converted to mysql (or any other database program i.e. Cache, or something else) or is foxpro where he should stay?
View 1 Replies View RelatedMigration From MySQL
May 3, 2005Hi all, via ODBC, how to convert the command 'SHOW COLUMNS FROM ...' from MySQL to SQL Server?
Is there any document explaining the differences between those DBs?
Thanks
Stefano